Bank Reconciliation
Re-perform the year-end bank reconciliation from the bank statement itself.
- Ledger + bank statements
- Key analysis in Cash & financing
How the result is read
A client’s reconciliation can balance by construction. Re-performed from the statement, it starts from the balance the bank shows at year end and adds back only what the pairing with the ledger proves: movements recorded before year end and cleared after (timing), movements recorded and never cleared, and movements cleared and never recorded. The last two make the reconciliation work by naming an error, so they are flagged even when everything balances.
In the application
Bank Reconciliation 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