Spreadsheets are the right tool for a lot of commercial real estate budgeting, and the wrong one for a specific set of jobs. The switch is not about size. It is about which of these nine things has started happening.
“When should we move off spreadsheets?” assumes there is a threshold, a number of properties or a portfolio size, past which the answer flips. There is not. A team with four buildings and complex retail recoveries can be past the point; a team with twenty triple-net industrial boxes can be comfortably inside it.
What actually happens is that one specific job stops fitting the tool. The rest of the budget is fine; that one job now takes a week, or produces a number nobody trusts, or depends on one person. Then a second job stops fitting. The signs below are those jobs, in roughly the order teams tend to hit them.
A mid-year reforecast should start from the budget, replace the elapsed months with actuals, and carry every assumption forward: the cap on each controllable expense, the exclusions, the tenant-level adjustments, the gross-up method. In a spreadsheet, the actuals come in and the assumptions have to be reapplied by hand, because they lived in cells that the actuals just overwrote.
The sign is not that the reforecast is slow. It is that it is rebuilt from the budget file every time, and that a decision made in August, say a cap treatment for one tenant, has to be remembered in March. When the reforecast is a roll-forward, the actuals land in the first column and the adjustments are already in place, so the work is reviewing, not reconstructing.
A CRE budget has three components in a fixed order: rental revenue, then expenses and capital, then recoveries, which depend on both. Kardin co-founder Karen Schwartz puts it this way:
“There are really three major components of the budget. The first is going to be that rental revenue. The second piece of it will be your expenses, your capital. And then the third piece is once the rent roll is in place and all of your expenses are in place, then you can set up all of the recoveries.”
Spreadsheet budgets usually get the first two right and treat the third as a separate exercise, often a separate file, often done later by a different person. That is how a budget ships with a recovery income line that was estimated as a percentage of last year rather than calculated from this year’s rent roll and this year’s pools. The reconciliation the following spring is where that shortcut surfaces.
This is the single highest-value gotcha in Kardin’s training archive, and it is a spreadsheet symptom before it is anything else. When a lease renews, the rent, tenant improvements and leasing commissions carry forward from the renewal assumption. The expense reimbursements do not, unless someone sets them up again. The tenant sits on the rent roll paying rent and is absent from every recovery pool.
In a spreadsheet, nothing flags this, because the recovery tab does not know the rent roll changed. The symptom appears at reconciliation, months later, as an unexplained under-recovery. If your team has ever found a renewed tenant missing from a pool after year end, that is this sign.
Budget_v7_FINAL_KS_revised.xlsx. Every team has the joke and the joke is the sign. The problem is not filenames. It is that a spreadsheet has no concept of a draft versus an approved version, no history of who changed a cell and when, and no way to revert one change without reverting everything after it.
The test: can you say, for one line in one property’s budget, who last changed it, what it was before, and whether the change was approved? If the answer involves opening three files and asking two people, the model has outgrown its container.
Property-level budgets are where the work happens. Portfolio-level reporting is where decisions get made: which assets are underperforming, what the consolidated cash flow looks like, where the debt service coverage is thin. In a spreadsheet operation those are two different deliverables, and the second one is a consolidation exercise that runs after every property is locked, breaks when any property changes, and is usually owned by one analyst.
The sign is that the roll-up lags the budgets by days or weeks, and that a late change to one property means redoing it. When budgets and portfolio reports come from the same data, the roll-up is a report, not a project, and reports like cash flow analysis with DSCR exist at portfolio level as a matter of course.
Occupancy drives gross-ups, pro rata shares, vacancy leakage and management fee assumptions. When a 20,000-square-foot tenant leaves in a spreadsheet model, the rent line changes and the rest of the workbook waits for someone to notice. Gross-ups run at the old occupancy. Pro rata denominators stay put. The recovery income line does not move.
This one is easy to test. Change an occupancy assumption in your current model and count how many other numbers move on their own. If the answer is one, the model is a ledger, not a budget.
Every budget starts from actuals in the accounting system, and every reforecast and reconciliation pulls them again. If that pull is an export from Yardi or MRI, a cleanup pass, and a paste into the right tab, with the row order checked by eye, then three times a year the most error-prone step in the whole process is a human moving columns.
The tell is a cleanup step that has a name and an owner. Vanderbilt Office Properties estimated that ready-made interface reports saved about 135 hours of data cleanup per budget season across roughly 90 buildings. That time was not analysis. It was moving data from one grid to another so it would line up.
Asset managers, owners, and lenders review budgets. In a spreadsheet operation they review a PDF export or a locked copy, because giving them the live file risks the model, and because the file only makes sense to the person who built it. Questions come back by email. Answers are re-exported. Approval is a reply.
The sign is a review cycle measured in round trips. When reviewers can open the property, drill from the portfolio total to the tenant, and see the assumption behind a number without being able to break anything, the review is a conversation instead of a correspondence. It also costs nothing extra in the right tool, since read-only and report-only access do not consume licenses.
Sometimes it is the controller. Sometimes it is an analyst who built the model four years ago and now maintains it as a side job. Either way, the budget process has a single point of failure, and everyone knows it, and the workaround is that nobody else touches the file.
This is the sign most teams name last and feel first. The model is not the problem; the fact that it cannot be shared safely is. A purpose-built tool separates the logic from the person: the pools, the caps, the gross-up methods and the report definitions are the system’s, not the workbook author’s.
Plenty of well-run operations should stay where they are. A single property, or a handful, on one accounting system. Recoveries simple enough that one person can do them by hand and explain them to a tenant. A budget owner who is also the reforecast owner and the reconciliation owner. No lender or owner review beyond a summary. If that describes your operation, a spreadsheet is cheaper, faster and more flexible than anything you would buy, and the honest advice is to keep it.
The signs above are not about scale. They are about dependency: the moment recoveries depend on the rent roll, the roll-up depends on the properties, and the reforecast depends on the budget, and the tool cannot enforce any of it.
One misconception keeps teams on spreadsheets longer than they should be: the belief that the alternative is a rip-and-replace of the accounting system. It is not. Purpose-built CRE budgeting software works alongside Yardi, MRI, RealPage and other accounting systems, not instead of them. Actuals come in from the accounting system; the budget, the reforecast and the recovery calculations go back out to it. The accounting system stays the system of record and does the billing.
What changes is that the budget gets a tool of its own, one that knows a rent roll from an expense pool and keeps the two connected. If four or more of the signs above describe your last budget season, that is the conversation worth having. See what Kardin Portal does, or ask us to look at your current process; if a spreadsheet is still the right answer for you, we will say so.
Budget with clarity.
Not because of portfolio size. Teams outgrow spreadsheets and general-purpose budgeting tools when specific CRE jobs stop fitting: rolling a reforecast forward with its assumptions intact, calculating recoveries from the rent roll rather than estimating them, carrying reimbursements through a renewal, consolidating a portfolio without a separate project, and letting reviewers see the model without being able to break it. General tools do not know what a recovery pool or a gross-up is, so those jobs stay manual.
There is no threshold. A four-building retail portfolio with denominator groups and admin fees can be well past the point where a spreadsheet is safe; a larger portfolio of simple triple-net industrial may be fine. The better test is dependency: whether the reforecast, the recoveries and the roll-up depend on each other in ways the current tool cannot enforce.
No. Purpose-built budgeting tools sit alongside the accounting system. Actuals are imported from it and the budget, reforecast and recovery calculations are exported back for billing and posting. The accounting system remains the system of record.
General FP&A tools model revenue and expenses for any business. CRE budgeting software understands the objects specific to property: a rent roll with lease dates that drive recovery language, expense pools with caps and exclusions, gross-up methods, base years, and portfolio roll-ups by asset. The recovery calculation in particular has no equivalent in a general tool.