Free HOA ledger template
Two accounting spreadsheets for a volunteer treasurer. The first is a ledger for one bank account: every deposit and payment, a running balance, totals by category and a check against the bank statement. The second is an owner ledger for one home that doubles as a statement of account. Both open in Excel or Google Sheets. No signup and no email address.
The bank account ledger
One row for every deposit and every payment, in date order. Type the balance at the start of the month at the top and the sheet carries the balance down the page. It comes filled in with a made-up month for a 24-home community, so you can see how a finished ledger reads before you replace the rows with your own.
| Column | What goes in it |
|---|---|
| Date | The day the money moved, or the date on the check. |
| Description | What it was, in words the next treasurer will understand. |
| Category | The budget line it belongs to. Use the same names every time so the totals work. |
| Paid by / Paid to | The homeowner or vendor. |
| Money In ($) and Money Out ($) | One or the other on each row, never both. |
| Balance ($) | A formula: the row above, plus money in, minus money out. |
| Cleared the bank (Y/N) | Y once the row appears on the bank statement. This is what lets the sheet reconcile. |
The summary under the table
- Total money in, total money out and the ending ledger balance.
- A reconciliation: type the balance from the bank statement, and the sheet takes away the rows marked N (not yet cleared). The line “Difference to explain” should read 0. If it does not, a row is missing, doubled or mistyped.
- Totals by category, so you can put the month beside the budget. Add a category by typing its name in a new row of that block and copying the two formulas down.
Keep one copy for each bank account. Reserve money belongs in its own account and its own ledger. Our guide to operating and reserve funds explains which pays for what, and the HOA bank accounts guide covers how to set the accounts up.
The owner ledger and statement of account
The bank ledger shows cash. It cannot tell you who is behind. For that, keep one copy of the owner ledger for each home: what was charged, what was paid and what is owed today. When an owner or a title company asks what a home owes, save the sheet as a PDF and you have a statement of account.
| Column | What goes in it |
|---|---|
| Date | The date of the charge or the payment. |
| Description | January assessment, late fee, payment received. |
| Charge ($) and Payment ($) | A charge raises what the home owes. A payment lowers it. |
| Balance owed ($) | A formula: the row above, plus the charge, minus the payment. |
| How paid and Reference | Check, Zelle or bank transfer, and the check number if there is one. |
Enter any balance carried in from last year in the opening balance line. The summary shows total charged, total paid and the balance owed today.
Five habits that keep a ledger right
- Enter it the day it happens. A ledger written from memory at month end is where missing checks come from.
- Use the same category names every time. “Landscape” and “Landscaping” are two categories to a spreadsheet. Take the names from your budget or from the HOA chart of accounts.
- Reconcile to the bank statement every month. Mark each row that appears on the statement and get the difference to 0 before the board meeting.
- Have a second person look. Someone other than the treasurer should see the bank statement beside the ledger. It protects the treasurer as much as the association.
- Record a transfer to reserves as money out here and money in there. It appears once in each account's ledger and never as an expense.
When a spreadsheet stops being enough
A ledger per bank account plus a ledger per home is a lot of files by the time a community has 30 homes, and nothing ties them together: a payment has to be typed into the owner's sheet and the bank sheet, and the two can disagree. Signs it is time to move on: the treasurer is the only person who can find a number, year-end takes a weekend, or a new board member cannot tell what the reports mean.
Effortless HOA's Starter plan does this work in one place: dues, fine and assessment invoicing and tracking, recording payments made by check, Zelle or bank transfer, GL accounting and financial reports, and aging and delinquency reports. It is $3 per home per month and never more than $249 a month for one community, with a 30-day free trial that needs no credit card. See how the accounting works or the price. If your books are in QuickBooks today, read QuickBooks for an HOA first.
More free files for boards, including a budget template and a reserve study spreadsheet, are on the HOA templates page.