How to build an occupancy-cost bridge into the cash forecast
The 13-week cash forecast is one of the most useful tools a controller or fractional CFO produces for a small or midsize commercial-tenant client. It is also one of the most common places that occupancy cost is wrong. Rent shows up as a single recurring line. CAM is folded into rent or omitted. The annual reconciliation lands as a surprise. Real estate tax pass-throughs hit on a schedule the forecast does not anticipate. The forecast reads cleanly until an occupancy bill arrives and the client discovers a cash gap that should have been visible six weeks earlier. For more context, see why occupancy cost is more than just rent.
The fix is not a more sophisticated forecasting model. The fix is a working bridge that aggregates every cash flow associated with the lease into a single forecast line, separates the run-rate items from the periodic items, and updates as new information arrives during the year. I built CAMAudit to operate against the same document set this bridge uses, because the bridge and the reconciliation review share inputs: the lease, the abstract, the prior-year reconciliation, and the run-rate billing pattern.
13-week cash forecast: A rolling forecast of expected cash receipts and disbursements for the next thirteen weeks, updated weekly or biweekly. The 13-week horizon is short enough to be reliable from observable inputs (open AR, open AP, scheduled debt service, payroll calendar) and long enough to surface cash issues in time to act on them. The forecast is most useful when each major recurring expense category has a documented forecasting basis (run rate, contract amount, schedule of known periodic payments) and a method for updating when assumptions change. Occupancy cost benefits from a dedicated bridge because the cash pattern includes both monthly and periodic components.
Why a single rent line is not enough
The standard rent line in a cash forecast captures the monthly base-rent disbursement. For most commercial leases that line is also the monthly CAM estimate, the monthly real estate tax estimate, and the monthly insurance estimate, all bundled into the one ACH or check the client sends to the landlord. A controller looking at the rent line on the bank ledger sees a clean number and assumes occupancy cost is captured.
Three things break this view.
First, the annual reconciliation. After the year closes, the landlord computes actual operating expenses and reconciles them against the estimated payments collected. If actuals exceed estimates, the tenant owes a balance. That balance is not in the monthly rent line. It is a separate one-time disbursement, often three to ten percent of annual base rent, that arrives between sixty and one hundred eighty days after year end.
Second, semi-annual or annual pass-throughs. Some landlords pass real estate taxes through outside the monthly estimate, billing one or two payments per year aligned with the property tax due dates. These bills are large, predictable in timing, and invisible in the monthly rent line.
Third, direct-pay utilities and services. The client pays electric, gas, internet, and possibly janitorial directly to the vendor, not through the landlord. These are economically part of occupancy cost. They are usually in the forecast under utilities or facilities, but they are not connected to the rent line. When the controller talks to the client about occupancy, the rent line is the wrong number.
The bridge connects all of these so the forecast and the management conversation use the same number.
The bridge structure
The bridge is a small working schedule with one row per lease and a column for each of the next thirteen weeks. The rows for a typical commercial-tenant client are:
Base rent (contractual monthly amount). Monthly CAM estimate (the CAM portion of the monthly landlord billing). Monthly real estate tax estimate (if the landlord includes it in monthly billing). Monthly insurance estimate (same condition). Periodic real estate tax pass-throughs (if the landlord bills these separately). Periodic insurance pass-throughs (same condition). Annual CAM reconciliation balance (modeled estimate). Direct-pay utilities (run-rate average). Direct-pay services (janitorial, security, anything paid outside the landlord). Other landlord bills (one-time charges, amendments, special assessments).
For each row, the cell in each weekly column is the expected cash disbursement for that week. Run-rate items (base rent, monthly estimates, direct-pay utilities) populate the cells where the bill is due. Periodic items (annual reconciliation, semi-annual taxes) populate only the weeks where the bill is expected to land.
The total row for each week is the total occupancy cash for that week. The total row across thirteen weeks is the occupancy cash exposure for the forecast horizon. Both numbers are visible to the client.
How to model the periodic items
The annual reconciliation is the most common periodic item and the one that gets the bridge's biggest contribution. The starting estimate is last year's actual reconciliation balance, with adjustments for known changes.
If last year's reconciliation produced a balance due of $14,200 and nothing material has changed (occupancy stable, no major property tax change, no amendment), the bridge models a $14,200 balance for the current year, scheduled to land in the week the prior reconciliation arrived. If the property tax bill has gone up by twelve percent and taxes are roughly forty percent of the reconciliation base, the bridge adjusts the estimate upward by roughly five percent. The estimate is not precise. It is approximately right and refined as the year progresses.
Real estate tax pass-throughs that bill outside the monthly estimate are easier. The county tax bill due dates are public, the prior-year amount is known, and any estimated changes are folded in. The bridge schedules the disbursement for the week of the due date.
Insurance pass-throughs follow the same pattern as taxes. The renewal date is on the lease abstract or available from the landlord. The amount is the prior-year billing adjusted for known changes.
One-time landlord bills are the hardest because they are by definition unscheduled. The bridge handles them as a separate buffer line: a small reserve added to the forecast for unmodeled landlord items, sized at one to three percent of annual occupancy cost based on the client's history with the landlord.
"The single best change I made to the cash forecasts I worked with was breaking occupancy cost out of the rent line and forcing the periodic items to live as separate forecast rows. Once the annual reconciliation has its own row, the question is not whether it surprises the client. The question is just how accurately the row is sized." — Angel Campa, Founder of CAMAudit
Updating the bridge during the year
The bridge is not a static schedule. It updates when new information arrives, and the trigger events are predictable.
A new landlord bill arrives. The controller posts the bill, updates the year-to-date occupancy cost, and refines the estimate for any remaining periodic items. If the monthly CAM estimate just increased by eight percent, the bridge picks up the new run rate for the rest of the year.
The annual reconciliation arrives. This is the biggest update event. The actual reconciliation amount replaces the estimate, the disbursement timing is locked in, and the bridge resets the assumption baseline for the coming year.
A property tax bill arrives or changes. The bridge updates the periodic line.
An amendment is executed. The bridge updates base rent, escalation schedule, and any pro-rata or cap changes the amendment introduced.
The cadence is not heroic. It is a thirty-minute update each month for the controller, with longer updates at year end and at amendment time. The output is a forecast that does not surprise the client.
Where this connects to the close
The bridge is also a close-week artifact. When the controller is reviewing a landlord bill during the close, the bridge is the document that shows whether the bill is consistent with the year-to-date forecast. If the monthly CAM estimate just increased by twenty percent and the bridge had it at the prior run rate, the close has a flag the bookkeeper might not have caught. If the annual reconciliation arrives and is materially higher than the bridge estimate, the controller knows immediately and can run the rest of the review with that context.
The bridge and the close are two views of the same underlying lease activity. Maintaining the bridge feeds the close. Running the close updates the bridge. The two-way feed is what keeps both reliable.
A client who can see the next thirteen weeks of occupancy cash, including the annual reconciliation that used to land as a surprise, is a client who experiences the firm as proactive rather than reactive. That experience is the difference between a transactional engagement and an advisory one, and the bridge is the document that makes it possible.
Frequently Asked Questions
What is an occupancy-cost bridge?
An occupancy-cost bridge is a working schedule that aggregates all the cash flows associated with a commercial lease (base rent, CAM estimates, real estate tax pass-throughs, insurance pass-throughs, annual reconciliation balances, direct utility payments) into a single forecast line that ties to the cash forecast. The bridge separates run-rate occupancy cost from one-time or annual items so the forecast reflects both the steady payments and the periodic spikes.
Why does occupancy cost belong in the cash forecast separately from rent?
The rent line in most cash forecasts captures only the contractual base rent and possibly the monthly CAM estimate. It does not capture the annual reconciliation balance, real estate tax pass-throughs that bill once or twice per year, insurance pass-throughs, or direct utility costs that are economically part of occupancy. A forecast that shows only the rent line understates true occupancy cost and produces unpleasant surprises when the annual or semi-annual items hit cash.
Where do the annual reconciliation amounts come from in the forecast?
The estimated annual reconciliation amount comes from prior-year actual reconciliations adjusted for any known changes. If the prior year produced a balance due of $14,200, the controller can model a similar balance for the current year and refine the estimate as the year progresses. If a major change is known (an amendment, a property tax increase, a structural occupancy change), the estimate adjusts for that change. The forecast is not pretending to predict the exact reconciliation.
How often should the occupancy-cost bridge be updated?
At least monthly during the standard close, and sooner if a triggering event occurs (a new landlord bill, an amendment, a known property tax adjustment, an unexpected pass-through). The bridge is a working document, not a year-start projection that goes stale. The controller updates it when new information arrives.
Should the forecast show occupancy cost at the gross level or the net level?
Both, with the gross level as the primary view. The gross occupancy cost includes everything the client pays (base rent, CAM estimates, tax pass-throughs, insurance pass-throughs, direct utilities, reconciliation balances). The net level optionally shows occupancy cost net of any pass-through credits the client has received. Showing only net hides the cash exposure; showing only gross obscures any recoveries. Both views give the client a complete picture.