Development tracking spreadsheets: the limits

A real estate development tracking spreadsheet that works has two layers. The first is a portfolio tab with one row per project, showing phase, budget health, and the next consequential milestone. The second is a tab per project carrying the budget's five columns and the milestone list. Most firms have the second layer in some form. The failures come from skipping the first, and from three structural limits that no template fixes.

What structure should the spreadsheet have?

Start with the portfolio tab: one row per active project with its name, phase, a budget-health verdict pulled from the project tab, the next milestone with its date, and an attention flag. This is the pipeline view in spreadsheet form, and it is the tab the principal actually reads. Each per-project tab then carries the five budget columns (original, changes, committed, actuals, forecast at completion) for every line item, split by hard and soft cost, plus the dated milestone list with each date's kind and lead time. Give contingency its own line with a drawdown log rather than burying it in a total. Add a change log recording who updated what and when, because a number with no provenance is just an assertion.

Where do development spreadsheets break?

The first break is stale actuals. The real numbers live in the contractor's construction software and the accounting books; the spreadsheet holds a copy, reconciled monthly at best, and every day after the last reconciliation the roll-up quietly diverges from reality. The divergence is worst during construction, which is exactly when it matters most.

Formula drift is subtler. Project tabs get cloned, then edited, and six months later no two tabs compute forecast-at-completion the same way. The portfolio tab ends up summing apples and oranges without anyone having decided to.

The third break is the single owner. One analyst maintains the workbook and the rest of the team emails in updates, so vacation weeks and deal crunches open gaps precisely when the portfolio is moving fastest.

Should you replace the spreadsheet?

Keep the discipline; the medium is the real question. The structure above (phase, the five budget columns, consequential milestones, a portfolio roll-up) is the right owner-side tracking practice in any tool, and a firm that runs it in a spreadsheet with a monthly reconciliation cadence is ahead of most. But the medium becomes the constraint as project count grows, because the three structural breaks scale with the portfolio while the discipline never gets easier. PlotSlate, part of Composed Studio's Property & Asset Operations suite, is a property development tracker being built around this structure. It is currently in development and not yet generally available.