🎉 Black Friday: off every tracker · Or get all 8 for $49.99 → 🎉 Get all 8 spreadsheets for $49.99, save $109.93 vs buying separately →

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.

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

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.

⚠ Important: please readA planning tool for information only. It is not tax, legal, accounting, lending, investment or financial advice, and it doesn't replace a qualified professional. Results depend on the figures you enter; lenders, platforms and tax authorities apply their own rules. Check important decisions with a professional. Images show the real workbook with sample data.

You might also like