The Free HOA Dues Tracking Spreadsheet

Last verified: September 23, 2026 · See updates

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)

Free and ungated. You may copy it, change it and give it to your board, members or clients; see the reuse terms.

Also included in the Board Starter Pack (.zip) along with nine other templates, a README and a disclaimer.

What’s inside the workbook

No screenshots here, a plain description of each of the five tabs, which is what you actually need to judge it:

• Settings: association name, tracking year, default monthly dues, a flat late fee per late account, a grace period in days, and Billing Periods Elapsed This Year. That last cell is the engine: set it to 6 once June dues have been billed and every balance in the workbook recalculates through June. Blue cells are the ones you edit; black cells are formulas.
• Units: one row per unit. Unit number, owner name, unit type, and that unit’s own monthly dues, so a one-bedroom and a three-bedroom can be charged different amounts. There is no contact column; keep owner contact details in your records inventory, not here.
• Payment_Ledger: the journal. Each payment is one row: date, unit number, amount, method, period applied. You never delete history, you add rows. There is room for 6,000 payment rows, so a monthly close will not run out of it.
• Dues_Status: calculated. Year-to-date billed, year-to-date paid, balance due, a Current or Late status, months behind, and a suggested late fee.
• Aging_Summary: calculated. Unit counts, totals, a collection rate, and four buckets by months behind: up to 1 month, 1 to 2, 2 to 3, and over 3. This is the report your collections ladder runs on.

The file arrives with fictional sample data (names like “A. Sample”) so you can see the formulas working before you trust them. The worked example below reads that sample end to end.

A worked example: reading the sample before you erase it

Open the downloaded file and go to Aging_Summary. It is already showing you a finished half-year for Sample Ridge Condominium Association, a fictional 30-unit community with Billing Periods Elapsed set to 6, so the workbook is reporting through June:

Now the part that matters. Switch to Dues_Status, sort or scan the Balance Due column, and the five late accounts are not five versions of the same problem:

Two lessons a blank grid cannot teach you. First, one unit is the problem. Unit 302 is 37% of the money outstanding and every other account is either recent or trivial, so a board that spends its meeting on “delinquencies” in general is spending it on the wrong thing. Second, the Late flag is not a verdict. Unit 308 is flagged Late over a $75 shortfall and a flat $25 late fee is suggested next to it; charging that fee mechanically is how self-managed boards make enemies. The Suggested Late Fee column is a calculation, not a decision, and whether you may charge it at all is a governing-documents and state-law question.

The whole thing compresses into the two sentences a treasurer should say out loud at the meeting: “Through June we billed $45,600 and collected $43,175, a 94.7 percent collection rate. Five units carry $2,425 between them, and one of those units is $900 of it and four months behind.” Minutes get the numbers; the unit numbers and owner names stay off the record. See the meeting agenda and minutes templates for how to phrase it.

Your first fifteen minutes with this file

Do these in order, once. Setting up takes about a quarter of an hour, and the file then runs on ten minutes a month.

1. Minutes 0 to 4, read the sample. Walk the worked example above with the file open. Change Settings!B9 (Billing Periods Elapsed) from 6 to 3 and watch every balance, bucket and the collection rate move. Put it back to 6. You now know what drives the workbook.
2. Minutes 4 to 6, save your own copy in the right place. Association-owned storage, a shared drive under an association account, not a personal laptop. This file is an association record and the next treasurer has to inherit it. Name it with the year.
3. Minutes 6 to 8, fill in Settings. Association name, tracking year, your dues, your late fee, your grace period. Set Billing Periods Elapsed to the number of dues periods you have actually billed this year so far, not the month number.
4. Minutes 8 to 12, replace the Units tab. Type over the sample rows with your real units and each unit’s dues. Rows 32 to 251 on Units are already wired into Dues_Status and Aging_Summary, so a 60-unit association just keeps typing.
5. Minutes 12 to 14, clear Payment_Ledger and enter this year to date. Delete the sample rows, then enter the payments you have actually received this year from the bank statements. If someone arrived owing money from last year, add an opening-balance row so the ledger starts true rather than forgiving an old debt by accident.
6. Minute 14 to 15, check the one number that proves it. Total YTD Collected on Aging_Summary should equal your dues deposits for the year on the bank statement, to the penny. If it does not, the ledger is wrong and nothing downstream of it can be trusted. Fix it now, while the file is small.

The monthly close routine (15–30 minutes)

1. Enter the month’s payments from the bank statement into Payment_Ledger, then raise Billing Periods Elapsed on Settings by one.
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 Reserve Fund Calculator, for the reserve line your dues have to carry.
• The full template hub and the complete self-managed HOA guide.

FAQ

Text on this page is licensed CC BY 4.0. Suggested citation: CommonKeel, "The Free HOA Dues Tracking Spreadsheet", https://commonkeel.com/templates/hoa-dues-spreadsheet/, verified September 22, 2026. Downloadable files are free to use and share within your association; ask michael@commonkeel.com about redistribution.