Tracking Multiple Off-Plan Units: Portfolio Cash Flow Without Spreadsheets

One off-plan unit is a schedule. Three units is a cash-flow problem. The failure modes that are merely annoying with a single property — a moved milestone, a notice in the wrong inbox — compound sharply when several plans run in parallel, because the schedules interact in ways none of the individual SPAs show.

The clustering problem

Developers launch with similar payment rhythms, and buyers tend to purchase in bursts. The result: installments from different projects landing in the same months. Each SPA looks manageable on its own; stacked, a single quarter can quietly demand three payments at once. The only way to see a cluster coming is a combined forecast — every unpaid installment from every unit, on one timeline.

That combined view answers the questions that actually matter for a portfolio: How much cash do I need in the next 90 days? Which months this year are heavy? Does the new launch I'm considering collide with my existing schedule?

Different projects, different clocks

Each project also moves independently. One tower is on time, another slips a year — which shifts its milestone-linked installments but not its neighbour's. Tracked in a static spreadsheet, the portfolio picture goes stale the first time any single project issues a revised handover notice. A working system re-baselines each unit against its own construction timeline and rebuilds the combined forecast automatically.

What the portfolio view should contain

1. Every installment across every unit, with amounts and triggers, in one forecast.
2. Per-unit progress — paid vs outstanding, next payment, handover countdown.
3. The value side — an estimated current value and paper gain per unit, so decisions (hold, exit, rebalance) are made against worth, not just cost.
4. Statements you can share — co-investors, spouses and accountants need the picture without needing your login.
5. Reminders that never depend on you checking anything.

The spreadsheet ceiling

A spreadsheet can hold all of this on day one. What it cannot do is stay current: it doesn't read the developer's revised handover notice, doesn't shift milestone dates, doesn't email you nine days before a payment, and doesn't notice that you never marked March as paid. Portfolio investors don't fail at building the tracker — they fail at maintaining it.

PlanGuard is the maintained version: upload each SPA and every unit's schedule builds itself, the portfolio dashboard rolls it all into one cash-flow forecast and equity view, reminders and overdue escalations run automatically, and each unit re-baselines when its developer moves the timeline. The Portfolio plan tracks up to 25 units — built for exactly this problem.

General information, not financial advice.