Free download — no sign-up
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
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.
Fictional figures for learning only; this example is separate from the workbook's sample month.
Adjusted bank balance: $5,200
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.
A blank monthly report with a worked example, balance formulas and an approval checklist for your meeting.
Get the treasurer report template