Single-Unit Rental Property Spreadsheet
Track one rental unit month by month. Enter rent received, repairs, insurance, property tax, HOA or utilities, other operating costs and debt service.
Download Excel Workbook · CSV Version
Template Preview
Property / Unit: __________
| Month | Rent Received | Operating Costs | Debt Service | Cash After Debt |
|---|---|---|---|---|
| January | ________ | ________ | ________ | Rent − Costs − Debt |
| February | ________ | ________ | ________ | Rent − Costs − Debt |
| March | ________ | ________ | ________ | Rent − Costs − Debt |
The workbook has all 12 months, annual totals and formulas. Blank months stay blank. CSV supplies entry columns; it does not carry formulas or formatting.
Operating net subtracts operating costs from received rent. Cash after debt also subtracts financing payments. Appreciation, income tax, depreciation and purchase costs are excluded.
Put a Number on Your Rental Costs
- Property Management Fee Calculator — Annual manager and self-management costs.
- Rent Increase Calculator — New rent, annual change and dated HUD reference figures.
- Published Property Management Fees — Named plans, cities and dates.
- Property Management Software Prices — Monthly bills and extra charges.
- Rental Inspection Checklist · Single-Unit Rental Property Spreadsheet