FORENSIC AND LITIGATION
Forensic bank statement analysis
from rows you can prove are complete.
Forensic and litigation teams turn months of bank statements into checked spreadsheets by converting each PDF, proving every account against its printed opening and closing balances, and confirming each month’s closing balance carries into the next. ZeraBooks Convert does the conversion and the proof, and writes the source file on every row so each figure traces back to its statement.
1,000 pages a month from $79 billed annually · 7-day trial, card at checkout
WORKED EXAMPLE
How do you prove a set of bank statements is complete?
Two checks. First, each statement must tie: opening balance plus its transactions equals its closing balance. Second, the statements must chain: each closing balance is the next opening balance. Here is a production of six months for one account, ending 4417, where the second check fails.
| Statement | Opening | Closing | Ties to itself | Chains to the prior month |
|---|---|---|---|---|
| January 2025 | 12,480.20 | 15,102.66 | Yes | First month |
| February 2025 | 15,102.66 | 14,388.09 | Yes | Yes |
| March 2025 | 14,388.09 | 18,240.55 | Yes | Yes |
| May 2025 | 21,905.10 | 19,770.43 | Yes | No: 3,664.55 gap |
| June 2025 | 19,770.43 | 23,016.88 | Yes | Yes |
Every statement produced is internally correct, yet the set is not complete. March closes at 18,240.55 and May opens at 21,905.10, so April is missing and $3,664.55 of net activity sits in it. That is the request to make before anyone starts tracing. Combining the months into one sheet with this check is covered in combine bank statements.
Try it on your own documents. One-week free trial, both apps included.
THE DELIVERABLE
What columns does a forensic bank statement spreadsheet need?
Download in the All details format and every row carries what a reviewer needs to trace it back. ZeraBooks never guesses a value; a cell the statement doesn’t print stays blank.
| Column | What reviewers use it for |
|---|---|
| Date, Description, Amount | The transaction itself, money out as a minus |
| Money In, Money Out, Balance | Totals by direction, and the running balance where the bank prints one |
| Account, Account Last 4 | Which account a row came from when many are combined |
| Cardholder | Who made a card charge, on statements with several cards |
| Type, Check Number | Checks, transfers and fees picked out for follow-up |
| Source File | The statement PDF the row was read from, so any figure can be shown on the original |
Check images convert separately with Payee, Memo and Written By on each row, through the check converter. Brokerage statements have their own holdings and activity layout.
WHAT GETS TRACED
What do forensic accountants look for once the rows are clean?
This part is the reviewer’s judgment, not the software’s. Clean rows just mean it starts on day one instead of week three.
Transfers between accounts
Money leaving one account should arrive in another. With every account in one sheet, unmatched transfers stand out, and so do accounts nobody disclosed.
Cash withdrawals and round amounts
Repeated ATM withdrawals, round-dollar transfers and deposits just under reporting thresholds are sorted and totalled in minutes.
Checks and their payees
The bank statement shows a check number and amount. The check image shows who it was written to, which is usually the point.
Card spending patterns
Merchants, dates and cardholders across years, for lifestyle analysis or to test a claimed expense.
Deposits by source
Payroll, transfers, refunds and unexplained credits separated, the same split lenders ask for in bank statement analysis.
STEP BY STEP
How do you turn a statement production into a checked spreadsheet?
- 1
Upload the production
Bank and card statement PDFs from every institution, scanned or digital, in one batch in the ZeraBooks bank statement converter.
- 2
Check the proof on each statement
Each account shows whether it ties to its printed balances to the cent. A statement that doesn’t tie shows the difference so you can look at that one, not all of them.
- 3
Download together
Select the statements and download them as one All details file, or one per account, as Excel or CSV.
- 4
Run the chain
Sort by account and date and compare each closing balance with the next opening balance, as in the example above. Request any missing month before analysis.
- 5
Keep the files
Convert shows documents from the last 30 days, so save the downloads with your workpapers the same day.
WHAT IT DOES NOT DO
Where does the software stop and the expert start?
ZeraBooks reads and proves statements. It does not give an opinion, flag fraud, testify or decide what a transaction means; that is the examiner’s work. It has no bank connection: statements are uploaded as produced. Family law teams can see the review columns we suggest in bank statements for divorce, and firms that handle many matters can have the converter tailored to the firm for free. This page is not legal advice.
Can ZeraBooks read scanned or poor-quality statements?
Yes, if the scan is readable. Each scanned statement still has to tie to its printed balances, which is how a misread digit shows up before it reaches your analysis.
How many years of statements can I convert at once?
As many as your page plan covers in a month: 1,000 pages for $149 a month, 2,500 pages for $249 a month, 5,000 pages for $599 a month. See ZeraBooks pricing. A document that can’t be read uses no pages. Productions larger than that are handled on a custom plan.
Does the converted spreadsheet replace the original statements?
No. The statements are the evidence; the spreadsheet is the working file that makes them searchable. Every row names its source file so you can point to the original page.
Can it handle several banks and account holders in one case?
Yes. Each statement is read on its own, split by account and by cardholder, then downloaded together with the account on every row.
Is the data kept after the case?
Convert shows the last 30 days of documents only. Download what you need and keep it with your file.
ONE-WEEK FREE TRIAL
Start the analysis from a complete set.
Proven statement by statement.
Upload a production, see which statements tie and which month is missing, and download one checked sheet. 1,000 pages a month from $79 billed annually, 7-day trial.
Last updated November 4, 2026 · Written by Damin Mutti, founder of ZeraBooks