Proof of Cash
Prove each month’s receipts and payments per the books against the bank.
- Ledger + bank statements
How the result is read
The four-column proof of cash compares, month by month, the receipts and payments the books recorded with those the bank processed. Month-end timing is the usual noise; here it is computed from the pairing of ledger and statement lines rather than estimated, so a month left unexplained holds a movement one side recorded and the other never will — the signature of an unrecorded payment, or a recorded one that did not happen.
In the application
Proof of Cash 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