SHORT ANSWER · DATASNIPPER EXCEL
How does DataSnipper work in Excel?
DataSnipper works as an add-in inside Excel: it matches source documents to the figures in your audit workpaper, so the support sits beside the number. Its site describes it at that level. When those figures first have to come out of PDF bank statements, ZeraBooks extracts and proves the rows, and the matching follows.
IN ORDER
What comes before the matching step in Excel?
The rows have to exist and add up before anything gets matched to them. Choosing a tool for that part? See the best DataSnipper alternatives.
- 1
Collect the statements
Bank, card, check and brokerage statements as produced, scans saved as PDF included.
- 2
Extract and prove the rows
ZeraBooks reads every row and checks that opening balance plus every row equals the printed closing balance, per account and per cardholder.
- 3
Open the workpaper in Excel
The rows arrive in your own template, with your headers and number formats.
- 4
Match the documents
DataSnipper, as an Excel add-in, matches source documents to the workpaper.
ZeraBooks builds the workflow around your matters and your template for free. No development charge, whether it’s a forensic department or one person.
WORKED NUMBER
What does a proven statement look like in the workpaper?
It looks like this: the extracted rows land exactly on the printed closing balance. This is Checking ••4417 for March 2025 from Matter 25-117.
| Line | Amount |
|---|---|
| Opening balance | 14,902.35 |
| Money in, every row | 8,120.00 |
| Money out, every row | −4,781.80 |
| Printed closing balance | 18,240.55 |
If one digit had been misread, the sum would miss the printed closing and the statement would be marked Needs a look. Can the add-in read the statements itself? See can DataSnipper read bank statements. New to the tool? Start with what is DataSnipper.
Is DataSnipper a separate program from Excel?
Its site describes it as an Excel add-in, so the work happens in Excel.
What does DataSnipper check on a bank statement?
Its site says its cash reconciliation workflow agrees the ledger ending balance to the bank statement.
Does ZeraBooks run inside Excel?
No. ZeraBooks isn’t an add-in. You upload statements and download Excel or CSV, or a file in your own workpaper template.
Sources and further reading
- DataSnipper
FREE CUSTOM BUILD
Get the rows into Excel proven.
Then match away.
Send one past matter and see it in your own template in 2 to 3 days, built free.