HOA & Nonprofit Treasurer’s Report Workbook: Budget vs Actual, Reserves, Delinquencies (Excel + Printable)

Volunteer treasurer? Log your bank transactions once a month and this workbook builds the treasurer's report for you.

SPREADSHEET (Excel / Google Sheets, 7 tabs, sample HOA included):

• Treasurer Report: a one-page summary that prints on a single sheet: cash balances by account, income and expenses vs. budget, reserve fund roll-forward, delinquency totals, your notes and a motion-to-accept line

• Setup: organization, fiscal year start, report month, up to 6 bank accounts (operating, reserve, other)

• Budget: annual budget by line; months fill evenly, or type over them for seasonal costs like snow removal and mowing

• Transactions: 600-row log with account and category dropdowns; flags unknown accounts or categories

• Budget vs Actual: budget YTD, actual this month, actual YTD, variance $ and %, budget left; over-budget lines turn red

• Delinquencies: aging by unit/lot (0-30, 31-60, 61-90, 90+), status dropdown, totals and % of annual assessments

• Built-in checks: reserve roll-forward must match reserve account balances; uncategorized amounts are shown, not hidden

PRINTABLE PDF (5 pages): treasurer's monthly checklist (12-month grid + annual tasks), fill-in treasurer's report, budget vs. actual worksheet, delinquency aging report, bank reconciliation and reserve account log.

For HOA, condo, nonprofit, PTA, church and club treasurers. Cash basis, no accounting software needed.

Not accounting, tax or legal advice. Follow your bylaws, governing documents and state law; have your accountant review year-end figures.

Template only, not legal advice. Your association's governing documents and state law control. Have your association's attorney review notices before you send them.