The Budget AuditorSign in

Free download — no sign-up

Bank reconciliation template for small organizations

Compare your checkbook to the bank statement line by line. The register carries a running balance, the journal tab records adjustments like bank fees, and the match tab totals deposits in transit and outstanding checks to show any difference from your books.

The file

What's inside

  • Register — a check register with a running balance after every line and a Y/N column to mark items once they appear on the statement.
  • Journal entries — debit and credit lines for adjustments such as bank fees, interest and recording errors.
  • Match to statement — adds recorded deposits in transit and subtracts outstanding checks from the bank balance, then compares it with the corrected register balance. Investigate any remaining difference.
  • Worked example — a completed month so you can check your method against one that balances.
Download template (.xlsx)

How to reconcile

  1. Compare the register and bank statement at the same closing date. Match each recorded receipt and payment; mark it Y only when it appears on the statement.
  2. Identify timing differences already recorded in the books: add deposits in transit to the bank balance and subtract outstanding checks or payments. Mark these items N in the register; do not record them again.
  3. Record bank fees, interest credited, returned deposits and other bank transactions missing from the books. Correct book errors with supporting records. The journal tab does not update the register automatically: enter each adjustment there once, without duplicating an existing entry.
  4. Compare the adjusted bank balance with the adjusted book balance. Investigate any difference; do not invent an adjustment merely to make the totals agree. Contact the bank about bank errors and keep a documented reconciling item until resolved.

In The Budget Auditor, uploaded bank statements can be read by AI, but a person must review the suggested entries before accepting them into reports. Available comparison tools depend on the plan; see pricing for details. Reconciliation supports review, not a certified audit or a guarantee that every error will be found.

Which differences need an entry in the books?

Deposits in transit
Money received and recorded in your books but not yet shown by the bank at the closing date. Add it to the bank side of the reconciliation. No second income entry is needed.
Outstanding checks and payments
Payments already recorded in your books that have not cleared the bank. Subtract them on the bank side. No second expense entry is needed; investigate old or unusual outstanding items before changing them.
Bank fees and interest credited
If not already recorded, bank fees reduce book cash and are recorded as an expense; interest credited increases book cash and is recorded as income. In double-entry records, debit bank-fee expense and credit cash for a fee; debit cash and credit interest income for interest.
Other reconciling items
Record missing direct debits or bank collections once, using the correct category. A returned deposit reduces cash; its other entry depends on the original transaction and your accounting method. Correct book errors in the records. A confirmed bank error belongs on the bank side until the bank corrects it—not as a fictitious expense or receipt.

A simple reconciliation example

Fictional figures for learning only; this example is separate from the workbook's sample month.

Bank side

  • Statement closing balance: $5,000
  • Add recorded deposit in transit: $500
  • Subtract outstanding check: $300

Adjusted bank balance: $5,200

Book side

  • Book balance before adjustments: $5,215
  • Subtract unrecorded bank fee: $20
  • Add unrecorded interest credited: $5

Adjusted book balance: $5,200

The adjusted balances agree: $5,200 − $5,200 = $0. Record the $20 fee and $5 interest in the books once. The $500 deposit and $300 check are already recorded; list them as outstanding, without posting them again.

The workbook example also reconciles: $5,611.60 bank balance + $120 deposit in transit − $250 outstanding payment = $5,481.60, matching the register after its $5 fee has already been recorded. Do not add that fee again.

Also free: treasurer's report template

A blank monthly report with a worked example, balance formulas and an approval checklist for your meeting.

Get the treasurer report template