The Free HOA Dues Tracking Spreadsheet

Updated July 3, 2026

Tracking who has paid dues is the single most important recurring task in a self-managed association — and the one that most often lives in a fragile, home-made spreadsheet that dies when the treasurer moves. This workbook is the sturdy version: a per-unit ledger that calculates balances, late flags, and aging buckets automatically, built so a rotating volunteer treasurer can inherit it and keep going.

Download HOA_Dues_Tracker.xlsx (free, no email)

Also included in the Board Starter Pack (.zip) with 10 other files.

What’s inside the workbook

No screenshots here — a plain description of each tab, which is what you actually need to judge it:

• Settings: your association name, dues amount and frequency, grace period, and late-fee settings. Blue cells are the ones you edit; black cells are formulas.
• Units: one row per unit — unit ID, owner name, contact, dues override if a unit pays a different amount.
• Payments: the journal. Each payment is one row: date, unit, amount, method, memo. You never delete history; you just keep adding rows.
• Dues_Status: calculated. Per-unit charges to date, payments to date, current balance, and a late flag based on your grace period.
• Aging_Summary: calculated. Balances bucketed by age (current / 30 / 60 / 90+), the report your collections ladder runs on.

Sample data (fictional names like “A. Sample”) shows how the formulas behave — delete it once your real units are in.

How to set it up (about 20 minutes)

1. Fill in the Settings tab: dues amount, billing frequency, grace period.
2. Replace the sample rows in Units with your real unit list. Copy an existing formula row if you need more rows — don’t retype formulas.
3. Enter opening balances: for any unit that owes money today, record a catch-up row in Payments (or an opening-balance charge) so the ledger starts true.
4. Save it in association-owned storage — a shared drive under an association account, not a personal laptop. This file is an association record.

The monthly close routine (15–30 minutes)

1. Enter the month’s payments from the bank statement into Payments.
2. Reconcile: the sum of payments entered should match dues deposits on the statement, to the penny.
3. Review Dues_Status for new late flags and Aging_Summary for accounts crossing 30/60/90 days.
4. Trigger your collections policy steps based on the aging report — statement, late letter, escalation — identically for everyone. Our delinquent dues collection workflow gives you the full policy, escalation ladder, and adaptable letters.
5. Report to the board: total collected vs. expected, and anonymized delinquency counts.

When this spreadsheet stops being enough

Honest answer: this workbook tracks money; it doesn’t collect it. Owners still pay by check, Zelle, or bank transfer, and you still type payments in. When owners start demanding autopay and cards, when chronic delinquency needs automated statements, or when treasurer turnover keeps breaking the file, purpose-built software earns its subscription — entry prices run $399/year to ~$59/month at small sizes (published prices, verified July 3, 2026). Start with the rubric-scored software comparison, and check the normalized pricing table against your unit count.

Pairs well with

• The Annual Budget Workbook — dues income flows from the same unit list logic.
• The full template hub and the complete self-managed HOA guide.

FAQ