Condo reserve study spreadsheet: what it should include

What a condo reserve study spreadsheet tracks, what Florida law (Ch. 718) requires, real cost ranges, and how to build one your board can actually use.

BoardDeadline Editorial Team
16 min read
In This Article

Last updated 2026-07-25

TL;DR

A condo reserve study spreadsheet lists every reserve component (roof, paint, pavement, plumbing, SIRS items), its remaining useful life, replacement cost, and current funding level, then projects annual contributions needed. Florida condos must fund reserves for SIRS-covered items in full starting the 2025 fiscal year under Fla. Stat. 718.112(2)(f), so the spreadsheet is where boards prove the math.

What is a reserve study?

A reserve study is a physical inspection and financial forecast of every major common-element component in a building, roof, paint, elevators, plumbing risers, pavement, pool equipment, and (for condos 3 stories and up) the load-bearing and waterproofing items covered by the Structural Integrity Reserve Study, or SIRS. A qualified provider inspects the components, estimates remaining useful life and replacement cost, then builds a funding schedule showing what the association needs to save each year. Florida law splits this into two related but distinct things. A general reserve study (sometimes still called a reserve analysis) covers all the association's capital components. A SIRS is a narrower, statutorily defined study required for condos three stories or higher, covering specific structural and life-safety items: roof, load-bearing walls and other primary structural members, floor, foundation, fireproofing and fire protection systems, plumbing, electrical, waterproofing and exterior painting, windows and exterior doors, and any item with a deferred maintenance expense or replacement cost over $10,000 that would materially affect the safety of the building's habitability, per Fla. Stat. 718.112(2)(g) [1]. Either way, the output your board actually works from is a spreadsheet: components down the rows, years across the columns, dollars in the cells. If you want the statute language directly, see our reserve study explainer for the full breakdown of what's covered and who has to order one.

What is a reserve study for an HOA?

For homeowners associations (single-family and townhome HOAs, not condos), a reserve study works the same way conceptually but the legal requirement is lighter. Florida's HOA statute, Chapter 720, does not mandate a SIRS or milestone inspection the way the condo statute does for buildings 3 stories and up. HOAs commonly reserve for roofs, roads, drainage, clubhouse or amenity structures, and irrigation systems, but the funding decision is usually left to the board and the declaration, not a state formula. That said, more Florida HOAs are voluntarily adopting reserve studies because lenders (Fannie Mae, Freddie Mac condo/PUD questionnaires) and insurers increasingly ask for them, and because a poorly reserved HOA still faces the same roof-replacement bill a condo does, just without the statutory trigger forcing the conversation. See our HOA reserve study guide for how HOA boards typically structure one without a state mandate driving it. The spreadsheet itself doesn't change much between condo and HOA use. Same rows (components), same columns (years, cost, funding), same math. What changes is who's required to look at it and how often.

What is an HOA assessment?

An assessment is the fee an association charges owners to cover operating costs and reserves. There are two flavors, and the difference matters for your spreadsheet and for your wallet. A regular assessment is the recurring monthly or quarterly fee set in the annual budget. It funds day-to-day operations (insurance, landscaping, management, utilities) plus whatever reserve contribution the budget calls for. A special assessment is a one-time, unbudgeted charge the board levies when reserves fall short of an actual repair bill, or when a SIRS or milestone inspection turns up deferred maintenance nobody funded in advance. Florida condo boards can levy special assessments under Fla. Stat. 718.116 and 718.112, subject to notice requirements in the association's bylaws and the statute. If your reserve spreadsheet is honest and current, special assessments should be rare and modest. If the spreadsheet has been ignored, ballooning deferred items and a shrinking reserve balance eventually force a large special assessment, often right when a milestone inspection or SIRS deadline hits. For a deeper look at how these charges get triggered and structured, see HOA special assessment.

How much should an HOA (or condo) have in reserves?

There's no single dollar figure or percentage that's "correct" for every building, because it depends on the age, size, and condition of the components, not on unit count or budget size alone. The honest answer is: enough to cover the fully-funded reserve schedule your reserve study produces, which is why the spreadsheet matters more than any rule of thumb. For Florida condominiums 3 stories or higher, the law is now specific about the floor: starting with the fiscal year beginning January 1, 2025, associations must fund reserves for SIRS-covered components at a level that eliminates any funding deficiency, calculated using the current replacement cost and remaining useful life determined by the SIRS, per Fla. Stat. 718.112(2)(f)2 [1]. Boards can no longer waive or reduce SIRS reserves by member vote, a change enacted after the 2021 Champlain Towers South collapse prompted the legislature to close the waiver loophole that had let associations underfund for decades [1]. A commonly cited industry rule of thumb (not a legal standard) is that reserves should be funded to at least 70% of the fully-funded level to avoid special assessment risk, a benchmark used by reserve study firms and referenced in Community Associations Institute educational materials, though CAI does not set a binding percentage requirement [2]. Some lenders and insurers use similar informal thresholds when evaluating condo master policies and loan eligibility, but there's no single federal or Florida statutory percentage that applies across the board outside the SIRS full-funding mandate. Bottom line: for SIRS components, "how much" is now answered by statute, no deficiency allowed. For everything else, it's answered by your reserve study spreadsheet's funding plan, and a board that's tracking 70% or better funded is in reasonable shape.

What should a reserve study spreadsheet actually include?

Roof (SIRS)2010204$850,000$42,500
Pool resurfacing2018126$65,000$10,833
Elevator modernization2005254$220,000$11,000
Exterior painting (SIRS)201981$180,000$22,500
Pavement/parking lot2015154$95,000$5,938The annual contribution column is what your budget committee actually uses. It's simply replacement cost divided by remaining useful life, a straight-line method, though some studies use a component or cash-flow method that smooths contributions across all components together rather than funding each one separately. Both methods are legitimate; ask your provider which one they used and why, because it changes how lumpy your yearly contributions look. For Florida condos, add a column flagging which rows are SIRS-mandated items under 718.112(2)(g), since those can no longer be waived or underfunded starting with fiscal year 2025 budgets. A well-built spreadsheet also tracks current reserve cash balance against the cumulative funding target, so the board can see at a glance whether they're ahead, on pace, or behind.

At minimum, a usable reserve study spreadsheet needs these columns for every component: description, install/last-replacement year, estimated useful life, remaining useful life, current replacement cost, and required annual contribution. Miss any one of these and the board is guessing instead of planning. Here's a simplified example row structure: | Component | Install Year | Useful Life (yrs) | Remaining Life (yrs) | Replacement Cost | Annual Contribution Needed |

How much does a reserve study cost?

A full reserve study for a mid-size Florida condo typically runs somewhere between $3,000 and $15,000, depending on building size, number of components, and whether it includes a physical (Level I) inspection or a desktop update. Costs scale with unit count and structural complexity: a 20-unit low-rise with a straightforward roof and no elevators lands at the low end, while a 200-unit high-rise with structural, mechanical, and life-safety systems lands higher. A SIRS specifically, since it requires inspection by a licensed engineer or architect under Fla. Stat. 718.112(2)(g), often costs separately from (or is bundled with) the general reserve study, and DBPR maintains licensing information for the design professionals qualified to perform them. Get at least two quotes and ask exactly what's included, some quotes cover only SIRS components, others bundle the full reserve study for all common elements. Compare that cost to the alternative: a special assessment triggered by a milestone inspection finding deferred structural repairs can run into the hundreds of thousands or millions of dollars per building, spread across owners with far less notice and far less choice. A $5,000 to $15,000 reserve study is cheap insurance against that outcome. See reserve study for condo association for a fuller cost and vendor-selection breakdown. One practical note: a $199 one-time Building Compliance Kit (available at /board-kit-builder) won't replace the licensed engineer's inspection or the reserve study itself, nobody can shortcut that part, and the statute requires a qualified professional to do the actual assessment. What a kit like that does is organize the deadlines, track which components and years are due for updates, and generate the owner notices your board has to send, which is the paperwork half of this job that eats board volunteers' weekends.

Typical Florida condo reserve study cost by building size Estimated total cost range for a full reserve study, including SIRS components where applicable $4,000 Small (under 50… $8,500 Mid-size (50-15… $14k Large high-rise… Source: industry cost ranges cited in article body, DBPR licensing context, 2025

Are HOA and condo special assessments tax deductible?

Generally, no, not for the individual owner using the unit as a personal residence. Special assessments for capital improvements (a new roof, structural repairs, elevator replacement) are treated by the IRS as additions to the cost basis of your property, not as deductible expenses, similar to how a homeowner's own capital improvements work under IRS Publication 523 guidance on adjustments to basis [3]. There are two carve-outs worth knowing. If the unit is a rental or investment property, special assessments for repairs may be deductible as a business expense in the year paid, while assessments for capital improvements still get depreciated over time rather than deducted immediately, per general IRS rules on rental property expenses in Publication 527 [4]. And if the assessment is specifically for casualty-related repairs tied to a federally declared disaster, some owners may qualify for a casualty loss deduction, though the rules tightened significantly after the Tax Cuts and Jobs Act limited personal casualty loss deductions to federally declared disasters through 2025 [5]. This isn't tax advice for your specific situation, a CPA who handles rental or condo-owner returns can tell you exactly how your assessment gets treated. But the general rule board members should communicate to owners asking "can I deduct this" is: probably not immediately, it likely adjusts your basis instead. For special-assessment-related insurance questions specifically, see condo special assessment insurance.

How does the reserve study spreadsheet connect to the milestone inspection and SIRS deadline?

The milestone inspection (structural, Phase 1 and possibly Phase 2) and the SIRS are separate requirements that often land in the same window, and your reserve spreadsheet is the tool that ties their findings to your budget. Under Fla. Stat. 553.899, condo and cooperative buildings 3 stories or higher must complete a Phase 1 milestone inspection by December 31 of the year the building turns 30 years old (or 25 years old if within 3 miles of the coast), and every 10 years after, with local building officials able to require earlier inspections in some cases [6]. If Phase 1 finds substantial structural deterioration, a Phase 2 inspection follows, digging deeper into the specific issue. The SIRS deadline for existing buildings was December 31, 2024, for the first study, per Fla. Stat. 718.112(2)(g), with associations required to complete a new SIRS at least every 10 years after that [1]. If a milestone inspection turns up a structural problem the SIRS didn't already price out, that item and its cost estimate need to go straight into your reserve spreadsheet's next update, ideally the same week the engineer's report lands, not six months later during budget season. Boards juggling both deadlines on the same calendar, plus the annual budget cycle, are exactly where a scheduling tool earns its keep. Our florida condo reserve fund relief piece covers what limited relief options exist for associations that can't hit full funding right away, and what documentation the statute still requires even when relief applies.

Who actually has to fund the SIRS reserve line items, and can owners vote to waive it?

No. For condominiums with a SIRS completed on or after December 31, 2024, Florida law does not allow the membership to vote to waive or reduce reserve funding for the SIRS-designated components, per Fla. Stat. 718.112(2)(f)2 [1]. This closed the loophole that previously let associations vote annually to underfund or fully waive reserves, a practice legislators cited as a contributing factor in why so many Florida condos entered 2021 with reserve accounts far below what their buildings actually needed [1]. Non-SIRS reserve items (things like pool furniture, clubhouse carpet, non-structural amenities) can still be waived or reduced by a member vote under the general reserve waiver provisions in 718.112(2)(f), so your spreadsheet should clearly separate SIRS-locked rows from voluntary-reserve rows. Mixing them together is a common mistake that leads boards to think they have more flexibility than the statute actually allows. Confirm the current waiver rules and any transition provisions with your association's counsel, this is an area the legislature has amended multiple times since 2022 and may amend again.

Frequently asked questions

What is a reserve study?

A reserve study is a professional inspection and financial forecast of a building's major common-element components (roof, plumbing, structure, paint, elevators) that estimates remaining useful life and replacement cost, then projects the annual savings needed to pay for future replacements without a surprise special assessment.

What is a reserve study for an HOA?

For a homeowners association, a reserve study inspects shared components like roads, clubhouses, and drainage, then builds a savings schedule. Florida's HOA statute (Chapter 720) doesn't mandate one the way the condo statute mandates a SIRS, but many HOAs order one anyway for lender and insurance purposes.

What is an HOA assessment?

An HOA or condo assessment is a fee charged to owners. Regular assessments are the recurring monthly or quarterly charge in the budget; special assessments are one-time charges levied when reserves don't cover an actual repair cost, often after a deferred-maintenance finding from an inspection.

How much should an HOA have in reserves?

There's no single legal percentage for HOAs in Florida. The reasonable target is whatever your reserve study's fully-funded schedule calls for; many reserve specialists and CAI education materials treat 70% of full funding as a rough benchmark for avoiding special assessment risk, though it's not a binding legal standard.

How much should a condo have in reserves under Florida law?

For SIRS-covered components in condos 3 stories or higher, Florida law (Fla. Stat. 718.112(2)(f)2) requires full funding with no deficiency, starting with fiscal years beginning January 1, 2025. For non-SIRS items, the amount is whatever the association's reserve study and budget set, since no statutory percentage applies there.

How much does a reserve study cost in Florida?

Typical costs run $3,000 to $15,000 depending on building size and component complexity, with SIRS inspections by a licensed engineer or architect sometimes priced separately. Larger, more complex high-rises with structural and mechanical systems land toward the higher end of that range.

Are HOA or condo special assessments tax deductible?

Generally no for a personal residence; the IRS typically treats special assessments for capital improvements as additions to your cost basis rather than a deductible expense. Rental or investment properties may get different treatment, including possible expense deductions for repairs. Check with a CPA for your specific situation.

What's the difference between a reserve study and a SIRS?

A reserve study covers all of a building's capital components broadly. A Structural Integrity Reserve Study (SIRS) is a narrower, Florida-mandated study for condos 3+ stories covering specific structural and life-safety items listed in Fla. Stat. 718.112(2)(g), with stricter funding rules attached.

When was the first SIRS deadline in Florida?

December 31, 2024, was the deadline for existing Florida condominium and cooperative associations meeting the height threshold to complete their first Structural Integrity Reserve Study, per Fla. Stat. 718.112(2)(g). A new SIRS is required at least every 10 years afterward.

Can a condo association waive SIRS reserve funding by vote?

No. Under Fla. Stat. 718.112(2)(f)2, associations cannot vote to waive or reduce reserves for SIRS-designated components once a SIRS has been completed. Non-SIRS reserve line items can still be waived or reduced by member vote under separate provisions of the same statute.

What columns should a reserve study spreadsheet have?

At minimum: component name, install year, total useful life, remaining useful life, current replacement cost, and required annual contribution. Florida condo boards should add a column flagging which rows are SIRS-mandated, since those can't be waived or underfunded under current law.

Who is qualified to perform a Florida SIRS?

A licensed engineer or architect must perform the SIRS inspection under Fla. Stat. 718.112(2)(g). DBPR maintains licensing records for Florida design professionals; boards should verify credentials and ask for references from other condo SIRS engagements before hiring.

Sources

  1. Florida Senate, Fla. Stat. 718.112(2)(g): SIRS is required for condos 3+ stories and defines the specific components it must cover
  2. Community Associations Institute, reserve funding education materials: 70% of fully-funded reserve level is a commonly cited industry benchmark, not a binding legal requirement
  3. IRS Publication 523, Selling Your Home: special assessments for capital improvements generally add to cost basis rather than being deductible for personal residences
  4. IRS Publication 527, Residential Rental Property: rental property owners may deduct repair-related assessments as expenses while capital improvement assessments are depreciated
  5. IRS, Topic No. 515 Casualty, Disaster, and Theft Losses: personal casualty loss deductions are limited to federally declared disasters under current law
  6. Florida Senate, Fla. Stat. 553.899: milestone inspection deadlines at 30 years (or 25 years within 3 miles of coast) and every 10 years thereafter

Disclaimer: BoardDeadline is an independent information publisher. We are not engineers, architects, reserve specialists, community association managers, or a law firm, and nothing here is legal advice. Structural inspections and reserve studies must be performed by the licensed professionals your state requires; this kit helps your board organize, schedule, and communicate - it does not perform or replace any inspection or study. Statutes change; confirm current requirements with your association's counsel and your county. We make no promises about compliance outcomes.

BoardDeadline Editorial Team

BoardDeadline provides expert guidance and tools to help you succeed. Our content is reviewed for accuracy and kept up to date.

Related Guides

BoardDeadline
Start Free Assessment