Free CSV template

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 template

Editable CSV · No email required

Bank reconciliation working paper
1line · description · amount
2A · Closing balance per bank statement ·
3B · Add: deposits in transit (recorded, not yet cleared) ·
4C · Less: outstanding payments (issued, not yet cleared) ·
5D · Adjusted bank balance (A + B - C) ·
6 · ·
Inside the template

Made for the actual work.

  • 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.

Make room for what's next

Clear books. A clearer head.

30-day trial. Card required. Cancel before the first charge.

Try comma