Excel · SheetsWork orders with response checks, an asset register with replacement years, and per-unit reserve tracking.
What's included:
- Work orders: priority, vendor, cost, days open, late flag
- Asset register: replace-by year, years left, repair limit
- Per-unit annual reserve vs spend
- Summary: spend by category, open work, assets due
- Excel, Google Sheets and LibreOffice
Preview: what's inside
Settings Settings
| Setting | Value |
|---|---|
| Annual maintenance reserve (% of property value) | 1% |
| Replace when repair cost exceeds (% of replacement cost) | 50% |
| Current year | 2026 |
Summary Summary
- Total repair spend
- Total annual reserve target
- Open or scheduled work orders
- Work orders past response time
- Assets due for replacement within 2 years
- Replacement cost of those assets
- Plumbing
- Electrical
Sheet Units — One row per rental unit.
| Unit | Address | Property value | Annual reserve target | Spent this year | Reserve left |
|---|---|---|---|---|---|
| Unit A | 14 Elm St, lower | 210,000.00 | auto | auto | auto |
| Unit B | 14 Elm St, upper | 190,000.00 | auto | auto | auto |
Sheet Work orders — Every request, logged the day it comes in.
| WO # | Reported | Unit | Category | Priority | Description | Vendor | Status | Completed | Cost | Days open | Response check |
|---|---|---|---|---|---|---|---|---|---|---|---|
| WO-001 | 2026-10-02 | Unit A | Plumbing | Urgent (72h) | Kitchen sink leak under cabinet | Rivera Plumbing | Done | 2026-10-03 | 185.00 | auto | auto |
| WO-002 | 2026-10-19 | Unit B | Appliances | Routine | Dryer not heating | Scheduled | auto | auto |
Sheet Assets — Big-ticket items with an expected life.
| Unit | Asset | Install year | Expected life (yrs) | Replacement cost | Replace by | Years left | Repair limit | Notes |
|---|---|---|---|---|---|---|---|---|
| Unit A | Water heater 40 gal | 2015 | 12 | 1,400.00 | auto | auto | auto | |
| Unit B | Furnace | 2009 | 18 | 4,800.00 | auto | auto | auto | |
| Unit A | Roof (shared) | 2012 | 25 | 11,000.00 | auto | auto | auto |
Preview generated from the actual file: sample rows are example data you replace with your own; formulas fill the calculated columns.
Good to know
- Instant digital download. Nothing physical is shipped.
- Licensed for personal and single-business use.
- 30-day fix-or-refund if a file doesn't work as described (terms).
- Support: eclipsekingdom.support@gmail.com