Free HOA Reserve Study Template (CSV)

Download the HOA reserve study template and open it in Excel, Google Sheets, or any spreadsheet app. The file is a plain CSV, organized by component, with columns for install year, useful life, remaining life, replacement cost, and your current versus target reserve balance. Replace the placeholder zeros with your community’s real numbers and you have a working funding plan.

This is a different document than our HOA budget template, which covers the annual operating budget plus a single reserve-contribution line item. This template builds the detail behind that line: a component-by-component inventory that tells you what the contribution actually needs to be. For the full picture of what a reserve study covers, what it costs, and how often to update one, see our guide on HOA reserve studies.

What Is in the Template

The template groups components into four categories: structural and exterior, building systems, amenities, and other. Each line item has seven data columns plus a notes field. Below is the full CSV content so you can review it before downloading.

Category,Component,Install/Last Replaced Year,Useful Life (Years),Remaining Useful Life (Years),Current Replacement Cost,Current Reserve Balance for This Component,Target Reserve Balance (Full Funding),Notes
STRUCTURAL AND EXTERIOR,,,,,,,,
,Roof,0,0,0,0,0,0,
,Asphalt Paving and Sidewalks,0,0,0,0,0,0,
,Exterior Painting and Siding,0,0,0,0,0,0,
,Retaining Walls,0,0,0,0,0,0,
,Fencing and Gates,0,0,0,0,0,0,
,,,,,,,,
BUILDING SYSTEMS,,,,,,,,
,Common-Area Plumbing,0,0,0,0,0,0,
,HVAC (Common Areas),0,0,0,0,0,0,If applicable
,Elevator,0,0,0,0,0,0,If applicable
,,,,,,,,
AMENITIES,,,,,,,,
,Pool Resurfacing,0,0,0,0,0,0,
,Pool Equipment and Heater,0,0,0,0,0,0,
,Clubhouse or Amenity Building,0,0,0,0,0,0,If applicable
,Playground Equipment,0,0,0,0,0,0,If applicable
,,,,,,,,
OTHER,,,,,,,,
,Signage,0,0,0,0,0,0,
,Other Reserve Components,0,0,0,0,0,0,
,,,,,,,,
TOTAL (ALL COMPONENTS),,,,,0,0,0,
,,,,,,,,
FUNDING SUMMARY,,,,,,,,
,Percent Funded (Current Balance / Target Balance),,,,,,0%,Current divided by target
,Recommended Monthly Per-Unit Contribution,,,,,,0,From your reserve study or funding plan

Structural and Exterior Components

These are usually the biggest dollar amounts on the sheet. Roof replacement cost varies enormously by material and square footage, so pull a real quote or last-known price rather than guessing. Paving and sidewalks wear on a predictable schedule tied to climate and traffic. Exterior painting and siding depends heavily on your building material. Retaining walls and fencing are easy to forget because they fail slowly, right up until they don’t.

Building Systems

Common-area plumbing covers shared lines and fixtures outside individual units, not anything inside a homeowner’s walls. HVAC for common areas applies to shared mechanical rooms, clubhouses, or hallway systems, not unit-level equipment owners maintain themselves. Elevators belong on this sheet only if your community has one, and they’re typically the single most expensive line item when they do, so get a real vendor quote rather than a rough estimate.

Amenities

Pool resurfacing and pool equipment (pumps, heaters, filtration) run on different replacement cycles, so keep them as separate lines rather than one combined pool budget. Clubhouse or amenity buildings and playground equipment apply only where your community has them. Delete any row that doesn’t apply to your association rather than leaving it at zero, which can make the total look smaller than it should.

Other Components and the Totals Row

Signage and any other reserve components specific to your community, gates, entry monuments, irrigation systems, go in the final category. Add up every component’s current replacement cost, current reserve balance, and target reserve balance into the TOTAL row. That total feeds directly into the funding summary below it.

The Funding Summary

Two numbers in the funding summary matter most to your board. Percent funded is your total current reserve balance divided by your total target reserve balance. A board sitting above roughly 70 percent funded is in reasonably strong shape. Between 30 and 70 percent is fair but worth watching. Below 30 percent is a real warning sign, the kind of gap that turns into a special assessment the first time a big-ticket component fails early. Recommended monthly per-unit contribution should come from your most recent professional reserve study if you have one. If you don’t, this template gives you a rough number to start the conversation with your board, not a final figure to adopt without question.

Baseline, Threshold, and Full Funding

Every reserve plan targets one of three funding goals, and the label changes how conservative the target balance column above should be. Full funding aims to keep the reserve balance equal to each component’s depreciated value at all times. Threshold funding aims for a chosen minimum dollar balance instead of tracking depreciation exactly. Baseline funding aims to stay just above zero, the cheapest approach short term and the riskiest long term. Our reserve study guide’s section on inflation, baseline vs. threshold vs. full funding walks through each one in detail, including which lenders and states increasingly expect full funding rather than the cheaper alternatives.

Filling This Out Yourself Has Real Limits

Filling in this template is a reasonable starting point for a small community with simple components, and it works as a sanity check between professional studies once you have one on file. It isn’t a substitute for a credentialed reserve specialist, and treating it as one carries real risk. A volunteer filling in the replacement-cost column tends to underprice components against actual regional labor and material costs. A professional stands behind their numbers; a spreadsheet a board member built one evening does not. Some states and most lenders require a study performed by a credentialed specialist, RS or PRA designation, regardless of how thorough a DIY version looks. Our reserve study guide’s section on whether you can DIY a reserve study covers the full list of limitations, including the complexity ceiling where a DIY approach stops being realistic.

Who This Template Isn’t For

Skip the DIY approach and go straight to a professional if your community has 50 or more units, any structural components (load-bearing walls, elevators, parking structures), or sits in a state like Florida that requires a credentialed engineer’s Structural Integrity Reserve Study for qualifying condo buildings. A lender questionnaire pending on a unit sale is another reason to skip the DIY version: Fannie Mae and Freddie Mac generally want a professional study on file, not a board-built spreadsheet, before they’ll extend the reserve-funding exception described in our HOA reserve study guide.

What Would Change This

If your community is small today but is approaching 50 units, adding a pool, or planning a capital project large enough to need financing, the DIY approach stops being the right tool at that point, not before. The same is true the moment any lender, buyer’s mortgage application, or state statute asks for a reserve study specifically, rather than just a funding plan a board put together. At that point, a professional study replaces this template rather than supplementing it. Our best HOA reserve study companies roundup covers the national and regional firms boards hire most when that point arrives.

What We See Boards Get Wrong Filling This Out

In the guides we publish here, the recurring mistake isn’t skipping a component. It’s pricing the replacement-cost column against what the component originally cost instead of what replacing it would cost today. A roof installed eight years ago for $18,000 doesn’t necessarily replace for $18,000 now, and inflation in labor and materials moves faster than most boards assume between updates. That gap compounds every year the template goes unrevisited, quietly understating the target reserve balance and the monthly contribution the funding summary recommends. Revisit every replacement-cost figure against a current quote or a recent vendor estimate at least once a year instead of leaving it at whatever number went in when the sheet was first built.

How to Use This Template

1. Download the template and open it in your spreadsheet app.
2. Walk your property with a board member or manager and list every major shared component, adding or deleting rows so the sheet matches what your community actually owns.
3. Fill in the install year and a realistic useful life for each component, then calculate the remaining life.
4. Get a current replacement-cost estimate for each line, from a vendor quote where possible rather than a memory of what it cost originally.
5. Enter your current reserve balance for each component and calculate the percent funded in the summary section.
6. Bring the completed sheet to your board, and use the recommended contribution figure to check your budget’s reserve line against what this funding plan actually calls for.

For the budget side of this work, see our HOA budget template and our guide on how to create an HOA budget. For more free templates covering meeting minutes, violation letters, and other common board forms, visit our free HOA templates page.

Start by downloading the template and walking your property to list every component your association owns. Then compare the funding summary against your current budget’s reserve contribution line.

---

General information, not financial or legal advice. Reserve funding requirements vary by state and by lender, and this template is not a substitute for a study performed by a credentialed reserve specialist. Consult a reserve professional or your association’s attorney for your specific situation.