A component inventory is the list of everything an association must eventually repair or replace, with each item's quantity, cost and life. This free CSV template has the columns a reserve study needs and 25 example rows to start from. No sign-up needed.
CSV file. Opens in Excel, Google Sheets and Numbers.
| Column | What to enter |
|---|---|
| Name | What the component is, as you would say it at a board meeting. Required. |
| Category | The group it belongs to, such as Roofing or Paving and Parking. Required for new components. |
| Property Area | The building or area it sits in. Leave blank if you do not track areas. |
| Quantity | How many, or how much, in the unit named in the next column. |
| Unit of Measurement | The unit the quantity is counted in: each, sq ft, sq yd, squares, linear ft, system. |
| Unit Cost | Today's cost to replace one unit, from a bid, an invoice or a local cost guide. |
| Total Cost | Quantity times unit cost. Fill this in directly if you only have a lump sum. |
| Year Installed | The year it was installed or last replaced. |
| Useful Life (Years) | How many years it should last in total. |
| Remaining Life (Years) | How many years it has left, judged from its age and condition. |
| Condition | One of: excellent, good, fair, poor, failed. |
| Location | Where to find it on site. |
| Description | Material, model or anything that identifies it. |
| Notes | Where the cost or life estimate came from, or anything to check. |
The template names common components across roofing, paving, painting, pool, elevators and mechanical systems. Quantity, cost and life cells are blank. Fill them in with figures for your own property.
| Component | Category | Unit |
|---|---|---|
| Asphalt shingle roof | Roofing | squares |
| Low-slope roof membrane | Roofing | sq ft |
| Gutters and downspouts | Roofing | linear ft |
| Exterior siding | Building Exterior | sq ft |
| Balcony and deck surfaces | Building Exterior | sq ft |
| Exterior paint, buildings | Painting and Coatings | sq ft |
| Wood trim and fence stain | Painting and Coatings | linear ft |
| Asphalt paving, overlay | Paving and Parking | sq yd |
| Asphalt seal coat and striping | Paving and Parking | sq yd |
| Concrete sidewalks and curbs | Paving and Parking | sq ft |
| Pool resurfacing | Pool and Spa | sq ft |
| Pool pump and filter | Pool and Spa | each |
| Pool heater | Pool and Spa | each |
| Pool deck | Pool and Spa | sq ft |
| Elevator modernization | Elevator Systems | system |
| Elevator cab interior | Elevator Systems | each |
| Boiler | Mechanical, Electrical, and Plumbing | each |
| Rooftop HVAC unit | Mechanical, Electrical, and Plumbing | each |
| Domestic water heater | Mechanical, Electrical, and Plumbing | each |
| Fire alarm system | Safety and Security | system |
| Entry gate operator | Safety and Security | each |
| Perimeter fencing | Site and Grounds | linear ft |
| Irrigation controllers | Site and Grounds | each |
| Clubhouse flooring | Common Area Interior | sq ft |
| Playground equipment | Recreation and Amenities | set |
The column headings are the same ones ReservePath writes when it exports an inventory, so a filled-in template imports without any mapping. In an association, open Components, choose Import/Export and upload the file. You can also paste rows straight from Excel into a study.
The Category column must match a category in your account, such as Roofing or Paving and Parking. Condition accepts excellent, good, fair, poor or failed.
It is the list of shared items an association must repair or replace, such as roofs, paving and pool equipment, with the quantity, cost, useful life and remaining life of each. It is the physical half of a reserve study.
Because they depend on your property and your local market. A roof in one region costs and lasts differently from the same roof in another. We do not publish made-up figures. Use bids, invoices, a local cost guide or your reserve preparer's estimates.
Yes. It is a standard CSV file. Open it in Excel, Google Sheets or Numbers, fill it in, and save it as CSV again if you want to import it.
Items that are the association's responsibility, have a limited useful life, have a remaining life you can reasonably predict, and cost more than a threshold the association sets. Routine upkeep belongs in the operating budget instead.
Open an association, go to Components, choose Import/Export, and upload the CSV. The column headings already match, so nothing needs mapping. Rename the example rows, delete the ones you do not have, and add your own.
Import the list into ReservePath and get the funding plan, percent funded and the report from the same data. Start a 30-day free trial, no card needed.
Start Your Free Trial