Bank and Ledger Unmatched
Pair every bank movement in the ledger with the bank statement, both ways, for the whole year.
- Ledger + bank statements
- Key analysis in Cash & financing
How the result is read
The bank statement is third-party evidence of every movement of cash. Pairing it with the ledger line by line, all year rather than at year end only, finds what a year-end reconciliation can hide: a payment the ledger never recorded, and a movement recorded that never went through the bank. Lines recorded in the last days of the year and not yet on the statement are timing, listed to check they clear.
In the application
Bank and Ledger Unmatched is filed under Cash & financing, index letter G. "Run all analyses" runs it with every other analysis the ledger and the documents loaded can answer. The worksheet states the population it tested on its face — or "Not applicable" with the reason when a column it depends on is empty — and the Excel workbook the engagement exports files it under G, beside an index of the source files with their SHA-256 fingerprints.
Read it with
Run your next audit file test without the Excel crash.
One free engagement to evaluate, valid 60 days. The ledger never leaves the machine.
- 20 minutes
- Runs on a fictional engagement
- No client data required