Bank reconciliation working paper
Statement balance to ledger balance with every difference named, plus an aged section for the reconciling items that have stopped being timing differences.
Download CSVNo sign-up. Opens in Excel, Numbers or Google Sheets.
What is in it
- Two-sided reconciliation that must resolve to zero
- Separate lines for deposits in transit and outstanding payments
- An aged section: anything over 60 days is a question, not a timing difference
A note on using it
This is a starting point, not a standard. Every business has something in it that does not fit a generic template, and the version worth keeping is the one you have edited. If a line does not answer a question you actually ask, delete it.