Free HOA Annual Budget Template (With Reserve Contributions)
TLDR
Most HOA budget templates on the internet treat reserves as a single line item and do not distinguish operating from reserve fund income. This template is built around fund accounting principles: dues are split at collection between operating and reserve funds, reserve contributions are tracked as a percentage of total assessments, and the format satisfies Fannie Mae's reserve allocation disclosure requirement.
What This Template Covers
A well-structured HOA annual budget does two things a generic spreadsheet template cannot: it tracks operating and reserve funds separately from the first entry, and it produces the reserve allocation percentage figure that lenders ask for on condo questionnaires.
This template is structured around fund accounting principles. Every dollar of assessment income is allocated at collection — split between the operating fund and the reserve fund based on the board-approved allocation percentage. Operating expenses are posted against the operating fund. Capital expenditures are posted against the reserve fund. The two funds never mix.
What You Get
Section 1: Assessment Income Summary
Calculates total annual assessment income across all units, split by operating and reserve portions. Includes a reserve allocation percentage calculator that updates automatically as you adjust the reserve contribution line.
Section 2: Operating Fund Budget
Line-by-line operating expense categories with monthly and annual columns:
| Category | Monthly Budget | Annual Budget | YTD Actual | Variance |
|---|---|---|---|---|
| Landscaping & Grounds | ||||
| Utilities — Water/Sewer | ||||
| Utilities — Electric (common areas) | ||||
| Utilities — Trash/Recycling | ||||
| Insurance — Master Policy | ||||
| Insurance — D&O/Umbrella | ||||
| Management Fees | ||||
| Routine Maintenance | ||||
| Administrative (legal, accounting, printing) | ||||
| Operating Contingency (5% of total) | ||||
| Operating Fund Total |
Section 3: Reserve Fund Budget
Reserve contributions and projected expenditure schedule by component:
| Component | Annual Contribution | Projected Replacement Year | Replacement Cost |
|---|---|---|---|
| Roof — Building A | |||
| Roof — Building B | |||
| Parking Lot Resurfacing | |||
| Exterior Paint | |||
| Pool Resurfacing | |||
| Pool Equipment | |||
| HVAC — Clubhouse | |||
| Elevator Modernization | |||
| Fencing & Gates | |||
| Other (per reserve study) | |||
| Reserve Fund Total Contributions |
Section 4: Per-Unit Assessment Breakdown
Shows each homeowner how their monthly dues are split:
| Assessment Component | Monthly per Unit | Annual per Unit |
|---|---|---|
| Operating Fund Contribution | ||
| Reserve Fund Contribution | ||
| Total Monthly Assessment |
Section 5: Reserve Allocation Compliance Check
| Metric | Value | Fannie Mae Threshold |
|---|---|---|
| Total Annual Assessments | — | |
| Total Annual Reserve Contributions | — | |
| Reserve Allocation % | 10% (current) / 15% (Jan 2027) | |
| Status |
Free HOA Annual Budget Template (With Reserve Contributions)
Free HOA annual budget template covering operating expenses, reserve fund contributions, and Fannie Mae reserve allocation requirements. Download and customize for your community.
No spam, ever. Unsubscribe anytime.
Frequently asked
Frequently asked questions about this template
Do I need accounting software to use this template?
How do I calculate how much to budget for reserves?
What should the reserve allocation percentage be?
- Reserve Allocation Percentage
- The portion of total annual HOA assessments designated for the reserve fund, expressed as a percentage. Calculated as annual reserve contributions divided by total annual assessment income. Fannie Mae requires a minimum 10% currently and 15% effective January 4, 2027 for condo project Full Review eligibility.
DEFINITION
- Operating Fund
- The HOA fund that covers recurring day-to-day expenses: landscaping, utilities, insurance premiums, management fees, and routine maintenance. The operating portion of monthly assessments funds this account.
DEFINITION
- Reserve Fund
- The HOA fund that accumulates savings for major repairs and replacements of common area components. The reserve portion of monthly assessments funds this account, and money is drawn down when capital replacements come due.
DEFINITION
Q&A
What does the HOA Annual Budget Template include?
The template includes an operating fund budget with income and expense line items, a reserve fund budget showing annual contributions and projected expenditures by component, a reserve allocation percentage calculator that shows compliance with Fannie Mae's 10% current and 15% (from January 4, 2027) requirements, a per-unit monthly assessment breakdown showing how dues are split between operating and reserve portions, and a variance tracking section for comparing actual results to budget throughout the year.
Q&A
How is reserve allocation percentage calculated in this template?
The template calculates reserve allocation percentage as total annual reserve contributions divided by total annual assessment income, expressed as a percentage. For example, if 100 units each pay $250/month ($300,000/year total) and $45,000 per year is allocated to reserves, the reserve allocation percentage is 15%. This is the figure lenders ask for on condo questionnaires and the threshold Fannie Mae requires for Full Review eligibility.
Q&A
What is the difference between this template and a standard budget spreadsheet?
A standard budget spreadsheet tracks total income and total expenses in one column. This template uses fund accounting principles: operating income and reserve income are tracked in separate fund columns, expenses are coded to the correct fund, and the reserve fund balance is tracked separately from the operating fund balance. This structure prevents commingling and produces the fund-level financial statements that state HOA statutes require.
Sources and Review Notes
BoardStack cites the sources used for this page and records the last review date for each reference.