
What it does
Rental cash flow is lumpy. A vacancy, a furnace and a roof in the same year can drain an account that looked healthy in January. This planner puts the next 12 months on one page for each property and for the whole portfolio, so you can see the tight months coming. List each property's rent, normal vacancy, operating expenses, full debt payment, opening cash and opening reserve. Add your capital projects with the month and estimated cost, and say whether each is paid from the reserve or from operating cash. The planner then suggests a monthly reserve transfer for each property, with the formula spelled out, that keeps the reserve at or above the minimum you set and saves evenly for projects further out.
- Property register for up to 10 properties
- 12-month forecast: effective rent after vacancy, operating expenses, NOI, debt payments, operating cash and reserve balance
- Optional month-by-month vacancy plan (e.g. a turnover month)
- Up to 40 capital projects with category (Roof, HVAC, Appliances, Other, or your own), month, cost and funding source
- Suggested monthly reserve transfer per property, using a stated formula; or type your own
- Alerts for reserve shortfalls, low operating cash and major repair months
- Property View (one property, month by month) and Portfolio (all properties combined; property totals reconcile to the portfolio)
- Scenarios: Base, extra vacancy, higher repair costs, and both combined
What's inside
Workbook tabs: Start Here · Dashboard · Settings · Properties · Vacancy Plan · Projects · Reserve Plan · Property View · Portfolio · Scenarios · Calc. Download: one .zip with 2 Excel workbooks (.xlsx), a PDF user guide and a licence.
Who it's for
- Small landlords with 1–10 doors who want a forward-looking cash and reserve plan alongside their bookkeeping.
Frequently asked questions
Is a transfer to the reserve an expense?
No. It moves money from operating cash to your reserve. Total cash only falls when you pay a project, an expense or a debt payment.
How is the suggested transfer worked out?
It's the larger of what keeps the reserve above your minimum through month 12, plus an even set-aside for later projects and an optional allowance. The exact formula is on the Reserve Plan tab and in the guide.
Does mortgage principal count in NOI?
No. NOI is effective rent minus operating expenses. Debt payments come after NOI.
Does it work in Google Sheets?
It hasn't been tested there yet. It's built for Microsoft Excel.
You might also like

Rental Property Buy-or-Pass Analyzer
Enter a property's price, financing, rent and costs and see cash needed, NOI, cash flow after a capital reserve, cap rate, cash-on-cash, DSCR and break-even occupancy in three scenarios, checked against your own rules. Excel template with a worked example.
Rental Property Tracker (T776)
Rent, expenses and your T776 for up to 5 properties.

Mortgage Offer & Renewal Comparison Kit
Put up to 4 mortgage offers side by side over the same horizon and rank them by net cost: interest, fees and penalties minus cashback, counting the balance you still owe. Canadian and U.S. editions, with worked examples.