HOA Treasurer Spreadsheet, HOA Dues Tracker, Homeowners Association Budget, Reserve Fund Plan, Owner Ledger, Google Sheets Excel

Run a small self-managed HOA or condo association's books in one workbook. Regular assessments are charged automatically from your schedule; you log payments and bills, and the workbook keeps owner balances, budget vs actual, bank reconciliations and a 30-year reserve projection up to date.
WHO IT'S FOR
Volunteer treasurers and boards of self-managed homeowners and condo associations with up to 150 units.
WHAT IT DOES
• Assessments charged automatically (monthly, quarterly, semi-annual or annual) with share factors, due day, grace period and a flat or percentage late-fee rule
• Special assessments, fines and credits by unit
• Owner balances with approximate 30 / 60 / 90+ day aging, and a dues grid showing what each unit paid each month
• Operating and reserve bank register (1,500 rows) with cleared dates
• Bank reconciliation for two accounts: deposits in transit, outstanding payments, difference and status
• Budget vs actual for up to 40 categories, split by operating and reserve fund, plus the assessment per share the budget needs
• Reserve component list (up to 40) with percent funded and a 30-year projection showing the lowest projected balance
• One-page monthly treasurer's report for board meetings
• Dashboard with cash, owed by owners, collection rate, percent funded, alerts and charts
TABS
Start Here · Dashboard · Settings · Units & Owners (up to 150) · Owner Charges · Owner Payments (1,500 rows) · Dues Grid · Ledger (1,500 rows) · Budget · Bank Reconciliation · Reserve Plan · Treasurer Report
WHAT YOU GET
• Instant digital download — no physical item is shipped.
• Excel workbook (.xlsx) plus a Buyer Access PDF with your Google Sheets copy link.
• Works in Microsoft Excel 2010 or later (Windows and Mac), Excel for the web, and Google Sheets (free Google account). No macros, add-ins or subscriptions.
• Fictional sample data is included so you can see how it works. Clear it when you're ready to start.
GOOD TO KNOW
• Formula cells are protected so they can't be overwritten by accident (no password). Light-tinted cells are for your entries, and dropdowns keep entries consistent.
• The Reserve Plan is a planning aid built from your own component list. It is not a reserve study; many states and lenders require one from a qualified professional.
• Late fees and collection rules depend on your governing documents and state law. Enter your own rules in Settings.
• Because this is a digital download, returns aren't accepted. If something doesn't work, message the shop and we'll help.
AI disclosure: This listing was made with the help of AI tools. AI helped draft the spreadsheet formulas, the listing text and the layout of the preview images. Every formula was then recalculated and checked for errors before listing, and the preview images show the real workbook's sample numbers.
Please note: This is a record-keeping template. It is not financial, tax, accounting, legal or HR advice, and it does not guarantee compliance with any law, regulation or rule. Check important results with a qualified professional.
Original design by SystemSheets. For personal or internal business use; please don't resell or share the file.