A rental income and expense spreadsheet is only useful if it answers one question: is this property doing what you expected? That means logging gross rent and each expense category separately, every month, and comparing it to your original projection. A single “total expenses” number tells you nothing actionable — if cash flow is down $4,000, you need to know whether it was vacancy, a one-off repair, or insurance creeping up 12%.
What to track each month
Income. Log gross rent received before any management deduction. Note any month with vacancy or partial rent — those are the data points that tell you whether your vacancy assumption held. For short-term lets, also track nights booked and number of bookings, because cleaning is per booking and levies are per night.
Expenses — by category, not as a lump sum:
| Category | What to log | Frequency |
|---|---|---|
| Property tax / rates | Amount paid | Monthly or annual |
| Insurance | Premium | Annual |
| Maintenance & repairs | Each job | As it happens |
| Management fees | Monthly fee | Monthly |
| Body corporate / HOA | Levy | Monthly or quarterly |
| Mortgage interest | From your statement | Monthly |
| Utilities (if owner-paid) | Actual bills | Monthly |
Tracking each category separately is what lets you act. A rising total is just anxiety; “maintenance is 50% over budget” is a decision.
The columns that matter
A good rental income and expense worksheet has three columns per line, not one:
- Estimated — what your analysis projected for that month (rent after vacancy, each expense with its escalation).
- Actual — what really happened, entered as it comes in.
- Used / variance — the actual where you’ve logged it, the estimate where you haven’t, so the sheet is always complete and the gap is visible.
Most free worksheets give you a single “amount” column. That records history but never tells you whether you’re on or off plan — which is the entire reason to keep the sheet.
Estimated vs actual
The point of the three-column layout is that the sheet stays complete even when you’ve only logged a few months. The Used column takes the actual where you entered one and falls back to the estimate everywhere else:
| Month | Income (Est) | Income (Actual) | Income (Used) |
|---|---|---|---|
| Jan | 2,500 | 2,500 | 2,500 |
| Feb | 2,500 | 0 (vacant) | 0 |
| Mar | 2,500 | (not logged yet) | 2,500 (est) |
Because of that fallback, your yearly totals and projection are always populated — you don’t have to fill in all twelve months for the numbers to make sense, and the gap between the Est and Used columns is exactly your variance. (For what to do with a persistent gap — vacancy vs rate vs one-off repair — see the routine in how to track rental property income and expenses.)
Get the free tracker
You can build this by hand, but a blank worksheet means an hour of formulas and researching your own tax rates. The faster route is to export one pre-filled:
- Open the spreadsheet generator — it detects your country.
- Enter the property’s price, rent, expenses and financing.
- Click Calculate, then Export to Excel.
The download is a multi-sheet workbook with monthly income and expense tracking already set up — estimated columns are formula-driven from your inputs, blue cells are where you log actuals, and the projection blends the two automatically. It includes per-category expense escalation and a full mortgage amortization schedule. (Here’s exactly what’s in each sheet.)
Comparing options first? See the best free rental property spreadsheet templates for 2026.
Keeping the habit
The tool matters less than the routine. A simple spreadsheet updated monthly beats sophisticated software you abandon:
- Monthly: five minutes to log actual rent and expenses in the blue cells.
- Annually: compare estimated vs actual; if a category is consistently off, update its escalation rate so future years self-correct.
For the full routine — what to review and when — read how to track rental property income and expenses. Not sure whether to analyse the deal in a spreadsheet or a calculator first? See calculator vs spreadsheet.