How Annual CAM True-Ups Hit Cash Flow (and How to Forecast Them)
One tidy cash flow model for a multi-location retail client broke during reconciliation season. CAM means common area maintenance, the shared costs a tenant pays. Most months, the model looked stable. Rent and CAM landed on time. The operating budget held. Then the landlord reconciliation statements came in. The true-up bills hit the bank soon after. A true-up is the yearly catch-up bill or credit. The model went red because nobody had reserved for the variance.
This is the built-in problem with CAM true-ups in cash flow work. Monthly CAM estimates are smooth and easy to model. The annual reconciliation is lumpy. It may arrive after year-end. The payment terms come from the lease and the statement. An accountant who skips a true-up reserve is not forecasting. They are doing accounting that happens to point forward.
I built CAMAudit because the reconciliation is often wrong. But even when it is right, the cash hit needs a forecasting habit. Monthly bookkeeping does not give you that.
CAM True-Up Bridge: The step that squares monthly CAM estimates billed during the lease year against the landlord's stated actual costs for that year. The bridge entry books the gap as one charge or credit when the reconciliation statement is final. The cash flow model treats the bridge as its own forecast line because its timing and size differ from the smooth monthly estimate.
Why the timing creates the pain
Three timing facts cause most of the pain. First, landlord reconciliation cycles run on the lease year. That may not match the tenant''s fiscal year. Second, the statement may arrive after the books are closed. Third, the payment window is set by the lease, invoice, or landlord process. So a big gap can land in a tight window with no monthly smoothing.
Take a retail tenant on a calendar lease year. The client pays steady monthly CAM estimates. When the landlord sends the annual reconciliation, the actual pool may be higher than the estimates. Insurance renewals, parking lot work, snow events, or tax changes can all move the number. For a client with thin margins, that is a real cash problem. It is not a paper one.
The gap can go the other way. Overcollections give a credit or refund. That is good for the client. You still have to model it. The credit often cuts future monthly estimates instead of arriving as cash.
The monthly reserve that stops the surprise
The fix is built into the model. Add a separate true-up reserve line that funds all year. The reserve covers the gap when the reconciliation lands.
Three steps.
Estimate the annual CAM well. The landlord''s monthly estimate is a start, not the answer. Pull the prior year reconciliation. Adjust for known cost drivers. Think insurance renewal hikes, property tax reassessment, and repair projects named in lease letters. You get the firm''s estimate of total annual CAM. It may differ from the landlord''s monthly number.
Compute the monthly reserve. Take the firm''s estimated annual CAM divided by twelve. Subtract the landlord''s monthly bill. If the firm expects the annual cost to run above the estimate, fund the gap as a separate occupancy line in the model.
Reconcile when the statement arrives. The reserve covers the bill. If the bill is smaller than the reserve, the extra releases to operating cash. If the bill is larger, flag the gap before payment.
Set the reserve band from the lease file and the client''s history. Stable properties can use a narrower planning band. Properties with known cost drivers need a wider one. The point is not to predict the exact bill. The point is to keep the cash plan ready for a bill or credit that does not follow the monthly rent pattern.
"A cash flow model with no CAM true-up reserve can look stable until the reconciliation lands. The firm can make that risk visible by building the reserve into the deliverable." - Angel Campa, Founder of CAMAudit
The bridge journal entry
The true-up entry should follow the firm''s accounting policy and the client file. A common workflow is to book each monthly CAM bill as billed, then book the reconciliation variance as one bridge entry when support is ready.
For an undercollection, where the tenant owes more CAM:
Debit CAM Expense for the true-up amount Credit Accounts Payable for the true-up amount
For an overcollection, where the landlord owes a refund or credit:
Debit Accounts Receivable for the credit amount Credit CAM Expense for the credit amount
The bridge entry usually stays tied to CAM expense rather than becoming a new operating category. That keeps variance analysis tied to the prior year reconciliation. Variance analysis means comparing this year to last year to spot odd swings.
There is one planning issue to flag. The reconciliation may cross the client''s fiscal year-end. If the amount is reasonably estimable and material, the firm should evaluate accrual treatment under its normal accounting policy before the bill arrives. The reversal entry can then handle the actual bill in the new year.
When to delay payment for review
The model assumes the landlord''s reconciliation is right. It often is not. Common errors show up in reconciliation samples. A management fee base may include excluded categories. A pro rata share may understate occupied square footage. Pro rata share is the tenant''s slice of shared costs. Capital expenses may get recovered through CAM where the lease does not allow it.
A true-up bigger than the firm''s estimated band should trigger a review. Do the review before payment when the lease and payment terms allow it. The audit, notice, payment, and dispute rules are lease-specific. The firm flags the gap, requests the backup, and documents the recommendation in the client file. Counsel should review legal notices or dispute language.
The review does not promise a refund. It helps the partner decide whether the statement matches the lease, the backup, and the payment history. That is where the firm earns its advisory value.
Modeling true-up uncertainty in the rolling forecast
For multi-location clients, the true-up forecast turns into a portfolio question. Some sites may run hot and owe more. Others may run cold and get a credit. The partner should model each site separately, then roll the view into one planning schedule for the client.
Here is a planning format:
| Location | Annual CAM Estimate | Planning Band | Review Action |
|---|---|---|---|
| Site A | Use prior statement and lease file | Narrow | Watch for routine variance |
| Site B | Use prior statement and known projects | Wider | Request backup before coding |
| Site C | Use current estimate and lease cap | Narrow | Confirm credit treatment |
| Portfolio | Roll up site-level plans | File-specific | Fund reserve and review outliers |
The portfolio view is a planning tool, not a promise. Some sites may owe more. Others may get a credit. The rolling forecast funds a reserve based on the client''s risk tolerance and the lease files the partner has reviewed.
What the firm delivers in advisory meetings
The true-up forecast becomes a regular item in quarterly advisory meetings. Three deliverables make the work visible.
The variance dashboard. It shows year-to-date CAM billed against the firm''s estimated annual CAM. It shows the gap so far. The client sees whether the year is running hot or cold.
The reserve balance. It shows the true-up reserve funded so far. It compares that to the reserve needed at year-end. The client sees whether the cash is there to cover the bill.
The review queue. These are sites with a gap that needs file review. They go to a CAM reconciliation audit before the true-up payment goes out when the lease and payment terms allow it.
Forecasting, reserving, and reviewing turn the annual true-up into a managed budget line. It stops being a reconciliation-season surprise. The client sees the work. The firm books advisory hours that would otherwise look like plain bookkeeping.
A client whose model survives reconciliation season has a clearer reason to value the advisory work. The true-up forecast shows the firm''s value beyond bookkeeping. It supports the advisory fee and sets up the broader occupancy advisory offer.