One ledger tab per account
Line-numbered transaction schedule. Each tab is an independent ledger with its own opening and ending bookends.
Hopkins Forensic
Forensic accounting workpapers for probate, trust, fiduciary, and litigation matters.
StatementProof turns bank and brokerage statement PDFs into reviewable Excel workpapers. Transactions extracted. Balances reconciled. Source pages cited. Discrepancies flagged — never hidden.
Flagship deliverable
StatementProof
Not just PDF‑to‑Excel. Statement workpapers built for review.
StatementProof
Bank statements in. Forensic workpaper out.
StatementProof converts bank and brokerage statement PDFs into structured forensic Excel workpapers. The deliverable is not just extracted transactions — it is a reviewable workpaper package that supports reconciliation, litigation analysis, fiduciary accounting, divorce financial review, estate and trust administration, bookkeeping cleanup, and investigative use.
Every workpaper is built around one test.
opening balance + visible credits − visible debits = calculated ending balance
If the calculated ending balance does not match the statement, the difference is flagged. StatementProof does not hide mismatches or force false ties.
What you receive
Extracted debits and credits
Every dated transaction row, separated into debit and credit columns with the original description preserved verbatim.
Running-balance validation
Each row’s balance is computed from the visible cells above it. Drop a row and the workbook tells you, by exactly how much.
Source-page traceability
Every transaction carries its source page number. Reviewers can trace any figure back to the statement PDF.
Control Summary
Per-account balance walk and section tie-outs reported as PASS or MISMATCH with the diff amount.
Raw Source Data
The audit trail behind every row: source page, account, raw text, parser confidence, and any review flags.
Exception flags
OCR uncertainty, missing rows, sign-repaired amounts, and non-reconciling activity are surfaced inline on each affected row.
How it works
A service engagement, not a self-serve upload.
Every matter starts with a short scoping conversation. We do not run unredacted statements through a black-box tool. A reviewer is in the loop on every workpaper.
-
01
Scope & sample
Send a brief description of the matter and, if available, one redacted statement page. We confirm the institution, the format, and the scope by email.
-
02
Written quote
We return a written quote with a price range, a turnaround estimate, and a list of the expected workpaper deliverables for your matter.
-
03
Secure transfer & production
On engagement, we provide secure file transfer instructions. Production proceeds against the agreed scope; any reconciliation issues are surfaced as they arise.
-
04
Workpaper delivery
You receive the Excel workpaper with all tabs (ledgers, Control Summary, Raw Source Data) plus a short cover note summarizing reconciliation status and any items flagged for reviewer attention.
Why StatementProof
PDF converters extract rows. StatementProof proves the rows tie.
Generic PDF-to-Excel tools produce spreadsheets. StatementProof produces forensic workpapers designed to be reviewed, challenged, and traced back to source statements.
Never show a false tie.
That is the core law of the product. If a calculated ending balance does not reconcile, the workbook surfaces the discrepancy with the exact dollar difference. It will not paper over a gap by relying on summary totals or hidden parser state.
Who we help
Built for matters where the numbers may be challenged.
- Probate and trust disputes
- Fiduciary accounting reviews
- Estate administration support
- Divorce and litigation matters
- Fraud and elder exploitation reviews
- Forensic accounting engagements
- Multi-account bank statement reconstruction
- Investigative and analytical support
Method
AI-assisted review, forensic discipline.
StatementProof may use AI-assisted extraction, pattern detection, payee normalization, and transfer matching. AI does not replace reconciliation.
The core rule
- AI can suggest and flag.
- The reconciliation must prove.
- The reviewer decides.
Where AI can assist
- Payee normalization across spelling variants
- Matched and unmatched transfer detection across accounts
- Large or unusual transaction flags for reviewer attention
- Recurring payment identification (utilities, subscriptions, rent, fees)
- Missing statement-period and continuity checks
- Fiduciary, probate, and trust review tags
- Check and deposit image review support
StatementProof flags transactions for review. It does not adjudicate. Final determinations on whether activity is appropriate, authorized, or actionable rest with counsel, the fiduciary, or the forensic accountant of record.
Founder
Built by a forensic accountant, not a generic converter.
Oscar T. Hopkins brings 16 years of federal forensic accounting, auditing, and financial investigation experience, including FBI Forensic Accounting Academy training at Quantico, expert testimony and analytical reporting, national forensic accounting leadership, and real-world business ownership experience.
His work has focused on forensic accounting, fraud detection, financial audits, data analytics, financial investigations, and litigation-support analysis. Tools used in prior practice include BankScan, Power BI, i2 Analyst’s Notebook, and CFIS.
Certified Fraud Examiner FBI Forensic Accounting Academy training B.S. Accounting & Finance, Boston College
Professional background is provided for context only. Hopkins Forensic is independent and is not affiliated with or endorsed by any government agency.
Template library
A growing library for financial statement formats.
Every supported statement format becomes a reusable StatementProof template with extraction rules, control checks, known OCR traps, and accepted workbook behavior.
BOFA_TRUST_V1
Bank of America / Merrill trust-brokerage statements
Cash flow control spine, per-section detail tabs, money-fund carry-forward.
CHASE_CONSUMER_V1
Chase consumer checking and savings
Per-account ledger tabs, printed-balance per-row cross-check, checks-paid dedupe.
BOFA_DEPOSIT_V1
Bank of America consumer checking and savings
Section-grouped layout, per-section tie-outs, Keep-the-Change transfer-pair handling.
Template coverage expands through reviewed service work and redacted sample submissions. Statement formats not yet templated can be added during a pilot engagement.
Services & pricing
Starting ranges, written quotes after scoping.
Final pricing depends on volume, PDF quality, account complexity, and the required forensic review level. The ranges below are starting points to help you frame budget; written quotes are returned after a short scoping email.
Single-account sample workpaper
$150 – $250
A focused proof-of-concept on one account. Useful for evaluating fit on a small matter or before committing to a larger engagement.
- 1 account
- 1–3 statement periods
- Ledger tab + Control Summary
- Native PDF preferred
Standard statement conversion package
$500 – $1,500
The everyday deliverable for fiduciary, probate, trust administration, and bookkeeping cleanup. One or more accounts across multiple months with full workpaper output.
- One or more accounts
- Multi-month periods
- Ledgers, Control Summary, Raw Source Data
- Exception flags inline on review notes
Forensic tie-out / litigation support
$2,500+
Multi-account reconstruction, tracing, transfer matching, and forensic review notes prepared for counsel. Includes documentation of methodology and assumptions.
- Multi-account reconstructions
- Tracing and transfer matching
- Forensic review notes
- Documentation suitable for litigation use
Large matters, scanned/image-only statements, brokerage accounts, trust and estate accounts, and multi-account tracing projects are quoted after review of a redacted sample. Engagements typically begin with a short scoping email; written quotes are returned within one business day.
FAQ
Questions that come up before engagement.
- What formats do you accept?
- Native digital PDFs (downloaded directly from the institution’s online banking) are preferred and produce the cleanest workpapers. Scanned or image-only PDFs are accepted but require OCR, which can introduce extraction uncertainty — we surface that uncertainty inline rather than hiding it. Brokerage statements, trust statements, and consumer bank statements are all in scope.
- What does “the workpaper ties out” mean?
- For every account, the workbook calculates ending balance from the visible Credit and Debit cells, then compares to the statement’s printed ending balance. If they match within one cent, the Control Summary marks the account PASS. If they do not match, it marks MISMATCH with the exact dollar difference. No false ties.
- What is your typical turnaround?
- Turnaround depends on scope and PDF quality. A single-account sample workpaper is typically two to three business days from secure file receipt. Standard packages are typically five to ten business days. Litigation-support matters are scoped on a per-engagement basis. We confirm a turnaround estimate in the written quote before work begins.
- Do you handle missing statement periods?
- Yes — missing periods are flagged in the Control Summary, with the date range gap identified. Where adjacent periods are available, we note whether the closing balance of one period matches the opening balance of the next. We do not fabricate the contents of missing periods.
- Are workpapers attorney work product?
- Engagement structure is a matter for your firm and your client. We are a forensic accounting service provider and can be engaged directly or through counsel. We do not provide legal advice and we do not issue audit opinions. Confidentiality and NDA terms are available on request.
- How is file transfer handled?
- Do not email unredacted statements. After scoping, we provide secure transfer instructions appropriate to the sensitivity of the records. Redacted samples for scoping purposes are welcome by email.
Intake
Request a StatementProof quote.
Send a brief description of the matter to contact@hopkinsforensic.com covering the items below. Written quote returned within one business day. Redacted samples for scoping are welcome by email; full file transfer instructions follow on engagement.
- Institution name (e.g., Bank of America, Chase, Merrill, Vanguard)
- Account type (checking, savings, brokerage, trust, IOLTA, other)
- Number of accounts
- Number of statement months covered
- Whether the PDFs are native digital statements or scanned/image PDFs
- Purpose of the review (probate, trust, divorce, fiduciary, fraud review, bookkeeping cleanup, litigation, other)
- Deadline or target turnaround
- Known issues, if any: missing statements, unexplained transfers, suspected duplicates, balance discrepancies, messy OCR, etc.
Please do not send unredacted PDFs over email. We provide secure transfer instructions during scoping. A short scoping email is enough to start a quote.