Free download — no sign-up
A spreadsheet built for lodge, church, nonprofit and association treasurers. Record the month's receipts and payments, calculate the book closing balance, and attach a bank reconciliation explaining any difference from the statement.
The file
The Budget Auditor carries report balances forward and offers AI bank-statement readings for human review. Budget and minutes comparison tools depend on the plan. Preparing or reviewing a report does not automatically verify every figure or authorize spending.
A book balance does not have to equal the unadjusted bank statement balance. Attach a list of deposits in transit, outstanding checks and other reconciling items, showing each date, reference, amount and follow-up needed. Show the raw bank balance, the adjustments and the adjusted bank and book balances.
Fictional example: a $5,000 statement balance plus a $500 deposit in transit minus a $300 outstanding check gives an adjusted bank balance of $5,200. If corrected books also show $5,200, the reconciliation agrees even though the raw statement differs by $200. Do not post the deposit or check twice.
Use C31 for the adjusted bank balance and keep the original statement amount on the attached reconciliation. C32 is only the arithmetic comparison; zero alone does not prove that the records are complete or correct. See the bank reconciliation example and template.
The workbook is a simple account receipts-and-payments report. Its fictional $500 building-fund transfer appears in the payment column and total; identify it as a transfer, not an operating expense, and avoid counting it again as income when combining accounts.
A check register with a running balance, journal entries for adjustments, and a match-to-statement tab that shows what's still outstanding.
Get the reconciliation template