SHORT ANSWER · EXCEL
Is Excel enough for forensic accounting?
Excel is enough for the analysis in most forensic matters: the schedules, the pivots, the lookups and the final workpaper. The gap is getting PDF statements into it accurately. Excel’s Power Query PDF connector reads clean, text-based PDFs, but it has no proof built in, so every check against the printed balances is one you build yourself.
WHERE THE GAP IS
What does Excel handle, and what doesn’t it?
Excel is the right place for the analysis. Choosing software to feed it? See the best forensic accounting software.
| Job | Excel on its own | ZeraBooks first, then Excel |
|---|---|---|
| Schedules and analysis | Built for it | Same, on rows already proven |
| Reading PDF statements | Power Query reads clean, text-based PDFs | Bank, card, check and brokerage statements, scans saved as PDF too |
| Checking what was read | You build any check yourself | Every account and cardholder tied to the printed balances |
| Missing months and duplicates | Your own formulas, per matter | Flagged across the matter; duplicate rows counted once |
Power Query facts from Microsoft’s connector page, read 2026-11-10.
ZeraBooks builds the workflow around your matters and your template for free. No development charge, whether it’s a forensic department or one person.
IF YOU STAY IN EXCEL
How do you check a Power Query import by hand?
- 1
Total each statement
Sum money in and money out for one statement period.
- 2
Tie it out
Opening plus money in minus money out should equal the printed closing. For March in Matter 25-117: 14,902.35 + 8,120.00 − 4,781.80 = 18,240.55.
- 3
Chain the months
Each closing should equal the next opening. March closing at 18,240.55 against May opening at 21,905.10 means April is missing.
- 4
Look for repeats
Check for a period loaded twice. One duplicate statement doubles every row in it.
BEYOND EXCEL
When do you need more than Excel?
When the matter has more statements than you can tie by hand, or when testing whole populations matters more than building schedules. CaseWare IDEA vs Excel: when do you need IDEA covers the analytics side.
For the other tools in a matter, see what software do forensic accountants use. The hours spent on hand checks show up in how much does a forensic accountant cost.
Is Power Query free?
It’s included with Excel. It’s a free start on clean, text-based PDFs.
Can Power Query read scanned statements?
Its strength is text-based PDFs. ZeraBooks reads scans saved as PDF and flags any statement that doesn’t tie after reading.
Does ZeraBooks replace Excel?
No. It delivers proven rows into Excel or CSV, or into your own workpaper template, and the analysis stays in Excel.
Sources and further reading
FREE CUSTOM BUILD
Keep Excel for the analysis.
Prove the rows before they get there.
Send one past matter and get every statement back proven, in your own Excel workpaper, in 2 to 3 days.