Softwiro
Free Excel template

HOA Budget Template for Excel

A free HOA budget spreadsheet for a volunteer treasurer or a small board. You list the budget lines for the year, log each bill as it is paid, and the workbook shows for every line what has been spent, what is left, whether spending is on pace for the point in the year, and a status. It also tracks monthly dues and other income, the operating balance and the reserve fund. It opens in Excel, LibreOffice and Google Sheets, and it works in any currency.

Excel file (.xlsx) · 144 KB · 8 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

Example from the sheet

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.
Budget year2026As of46340Change the year, the as-of date and the opening balances on the Settings sheet.
Expense budget (year)137,600.00Income so far126,435.00
Budget to date126,133.33Income budget to date126,500.00
Spent so far123,190.00Operating balance21,745.00
Under (+) or over (-) budget to date2,943.33Reserve fund balance64,000.00
Share of yearly budget used89.5%Lines over annual budget1
Largest line by spendReserve fund contributionLines near annual limit2
Expense rows to review0
GroupAnnual budgetBudget to dateSpent so farLeft for the yearMonthIncomeExpensesNetOperating balance
Administrative25,800.0023,650.0021,795.004,005.00Jan11,200.009,040.002,160.0020,660.00
Insurance14,400.0013,200.0013,200.001,200.00Feb11,600.0010,225.001,375.0022,035.00
Utilities22,800.0020,900.0021,380.001,420.00Mar11,500.0011,570.00-70.0021,965.00
Grounds26,600.0024,383.3324,345.002,255.00Apr11,380.0010,360.001,020.0022,985.00
Maintenance24,000.0022,000.0020,470.003,530.00May11,800.0012,065.00-265.0022,720.00
Reserve contributions24,000.0022,000.0022,000.002,000.00Jun11,500.0010,800.00700.0023,420.00
Jul11,335.0010,655.00680.0024,100.00
Aug11,500.0012,115.00-615.0023,485.00
Sep11,500.0011,250.00250.0023,735.00
Oct11,620.0014,905.00-3,285.0020,450.00
Nov11,500.0010,205.001,295.0021,745.00
Dec0.000.000.0021,745.00

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.

What is inside

  • Dashboard: The board summary: yearly budget, budget to date, spent, and the difference, the biggest expense line, income so far against the dues budget, the operating balance, the reserve fund and how many lines are over or near their limit. Below it, each budget group with its budget and spending, and charts for budget vs actual and monthly income vs expenses.
  • Budget: Your budget lines, each with a group and a budget for the whole year. It works out the monthly budget, the budget to date, spent, left for the year, how spending compares with the budget to date, the percent used and a status (On track, Over pace, Near annual limit or Over annual budget). Room for 40 lines.
  • Expenses: The log you type into: date, budget line from a dropdown, vendor, description, invoice number, amount and payment method. A Check column flags a row that cannot be counted because its budget line is not on the Budget sheet. Room for 2,000 expenses.
  • Monthly: Every budget line across the twelve months of the year, with a total for each line and each month.
  • Income: Dues collected and other income (late fees, clubhouse rental) for each month, with the dues budget per month and the difference.
  • Settings: The association name, currency symbol, budget year, the as-of date, opening operating cash and reserve balances, yearly dues budget, the warning level and the list of budget groups, including the group that holds reserve contributions.

The file opens on a start tab (“Start here”) that explains how to use it.

What makes it different

Most HOA budget templates are a list of lines with a yearly total. This one is built for the second half of the job: comparing the budget with what you have actually paid. It compares against the budget to date, not only the full year, so it tells you a line is running ahead of pace in October rather than after it has gone over in December. The sample is a 15-line association budget with spending to mid-November 2026.

What should an HOA budget include?

Start with income: the regular dues you expect, then late fees and other income. Then the operating expenses by group: management and administration, insurance, utilities, grounds, maintenance and repairs. Last, the contribution to the reserve fund for big future repairs such as roofs and paving.

The sample budget has 15 lines in six groups and adds up to 137,600 for the year. The yearly dues budget on Settings is 138,000. Put each line in a group and the Dashboard totals each group for the board. Rules on how a budget is approved and what reserves you must hold differ from place to place, so check your governing documents and local law.

How do I compare HOA budget vs actual?

Type each bill on the Expenses sheet and pick the budget line. The Budget sheet then shows, for each line, the amount spent so far, the amount left for the year and a comparison with the budget to date, which is the yearly budget divided by 12 times the months passed. In the sample, as of 14 November 2026 (11 months), 123,190 has been spent. That is 89.5% of the yearly budget, 14,410 left for the year and 2,943.33 below the budget to date of 126,133.33.

The status column points at the lines that need a conversation. In the sample, Tree trimming is Over annual budget (3,500 against 3,000, after a 2,100 storm cleanup). Common-area electricity (6,930 of 7,200) and Building repairs (8,670 of 9,000) are Near annual limit. Water and sewer is Over pace: 8,950 spent against 8,800 budgeted to date. Lines paid in lumps, such as an annual premium, will show Over pace until the year catches up.

How do I track the HOA reserve fund?

Give your reserve contribution its own group on Settings and budget it like any other line. Each transfer you log to that line adds to the reserve fund on the Dashboard. In the sample the opening reserve is 42,000, 22,000 has been contributed so far and the reserve fund shows 64,000.

The operating balance is the opening cash plus income entered minus all expenses entered. With opening cash of 18,500, income of 126,435 (125,710 dues and 725 other) and 123,190 of expenses, it comes to 21,745. This sheet does not track money taken out of the reserve. For dues owed by each owner, see HOA dues collection and for the reserve itself HOA reserve fund.

How to use it

  1. On the Settings sheet type the association name, currency symbol, budget year, the "as of" date, the opening operating cash and reserve balances, the budgeted yearly dues income, the warning level (for example 95%) and the name of the group that holds reserve contributions. Edit the budget groups in the list on the right.
  2. On the Budget sheet list every budget line (Landscaping, Insurance, Management fee...), pick its group and type its budget for the whole year. The monthly budget and the budget to date are worked out for you.
  3. On the Expenses sheet add one row per bill paid: date, budget line (pick from the list), vendor, description, invoice number, amount and payment method. The Check column tells you if a row cannot be counted.
  4. On the Income sheet type, month by month, the dues collected and any other income (late fees, clubhouse rental).
  5. Open Budget to read, for each line, what has been spent, what is left for the year, how it compares with the budget to date, and its status. Monthly shows the same expenses month by month.
  6. Open Dashboard for the totals, the operating balance, the reserve fund and the charts.

Before you start:

  • Capacity: 40 budget lines, 8 groups, 2,000 expense rows.
  • The sheet does not use TODAY(): type the as-of date on Settings. Budget to date = yearly budget / 12 x the number of months passed in the budget year.
  • Only expenses dated in the budget year are counted. An expense whose budget line is not on the Budget sheet is flagged in the Check column and left out.
  • Status: Over annual budget = spent more than the whole year. Near annual limit = spent at least the warning level. Over pace = spent more than the budget to date. Otherwise On track. Lines paid in lumps (an annual premium) will show Over pace until the year catches up.
  • Operating balance = opening cash + income entered - all expenses entered, including reserve contributions. Reserve fund = opening reserve + reserve contributions spent. Money taken out of the reserve is not tracked here.
  • Use one currency in one workbook. The currency symbol on Settings is only a label.

Excel file (.xlsx) · 144 KB · 8 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Still running this on Excel?

This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.

In this sheetIn Custom Software from Softwiro
One file that one person edits at a time, and copies reach you on WhatsApp.A program with a login for each user and permissions you define, and everyone sees the same data.
You type everything and check the numbers by hand.We design the screens around your work steps, so each person records only what concerns them.
Columns and formulas are fixed as the sheet was designed.We build what you need: reports, alerts and screens your way.
Backups and security are your own responsibility.The program runs on a secured server with regular backups.

See Custom Software from Softwiro · Ask for a demo

Frequently asked questions

Is this HOA budget template free?

Yes. Download it, use it for your association and change anything you like. There is nothing to sign up for to open the file.

Does it work in Google Sheets and LibreOffice?

Yes. It uses ordinary formulas such as SUMIFS, INDEX and MATCH, so it works in Excel 2016 and later, LibreOffice and Google Sheets. In Google Sheets, upload the file to Drive and open it with Sheets.

How many budget lines and expenses can it hold?

40 budget lines in 8 groups and 2,000 expense rows. Only expenses dated in the budget year are counted, so you can keep last year's rows or start a new file.

Why does a line show Over pace when the year is not over?

Over pace means you have spent more than the yearly budget divided by 12 times the months passed. It is a warning, not an overspend. A line paid in one or two lumps, such as insurance, will show it until the year catches up.

Why is an expense not counted?

The Check column on Expenses says so when the budget line on that row is not on the Budget sheet, usually a spelling difference. Pick it from the dropdown or add the line to the Budget sheet.

Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html

All the templates in this group: Compound and owners' association sheets: dues, maintenance and property

More free templates for: Owners associations and compounds

More free templates

All templates · Free tools