PIMACCOUNTING · WORKING RESOURCES
Bank reconciliation worksheet
Use one account, date and currency per sheet. Enter statement and ledger balances, classify each difference and calculate reviewed adjusted totals independently. This sheet does not calculate or post entries; never force a difference into an unsupported journal.
Working aid only — not an official form. Entries stay on this page and are not sent to Pimaccounting. There is no automatic saving. Print or save a completed copy before refreshing or closing.
Click or tab into a blank cell to add your notes. On small screens, scroll the table sideways.
| Item / reference | Statement adjustment (+/−) | Ledger adjustment (+/−) | Evidence / action |
|---|---|---|---|
| Opening comparison: statement and ledger balances | |||
| Timing difference: describe and date | |||
| Unrecorded transaction: review before posting | |||
| Bank charge / interest: supporting evidence | |||
| Error requiring investigation | |||
| Reviewed adjusted statement balance | |||
| Reviewed adjusted ledger balance / remaining difference |