How Annual CAM True-Ups Hit Cash Flow (and How to Forecast Them)
One tidy cash flow model for a multi-location retail tenant broke every March. CAM means common area maintenance, the shared costs a tenant pays. Eleven months a year, the model was right to the dollar. Rent and CAM landed on time. The operating budget held. The founder slept fine. Then the landlord reconciliation statements came in February and March. The true-up bills hit the bank in April. A true-up is the yearly catch-up bill or credit. The model went red for sixty days. The client scrambled to cover a charge nobody had reserved for.
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 often arrives late. The payment window squeezes the cash hit into one quarter. 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 actual costs for that year. The bridge entry books the gap as one charge or credit when the reconciliation statement is final. That usually lands 60 to 180 days after year-end. The cash flow model treats the bridge as its own forecast line. Its timing and size differ a lot 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 often does not match the tenant''s fiscal year. Second, the statement usually arrives 60 to 180 days after the lease year ends. It does not come at year-end. Third, the payment window is usually 30 days, sometimes 60. So a big gap lands in a tight window with no monthly smoothing.
Take a retail tenant on a calendar lease year. They have $4,000 monthly CAM estimates. That accrues $48,000 of expected CAM. Say actual CAM lands at $60,000. That is a 25 percent gap. Such a gap is common with insurance renewals, parking lot repairs, or snow events. The true-up bill is $12,000 due in 30 days. That is three months of CAM in one window. 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. Say the landlord bills $4,000 monthly and the firm estimates $5,000. The reserve is $1,500 per month, or $12,000 over the year. Fund it 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.
After testing reconciliation samples through CAMAudit, one gap band catches most clients off guard. It runs 15 to 30 percent above the landlord''s monthly estimate. Below 15 percent, clients absorb it. Above 30 percent, the gap is usually big enough. The client looks before paying. The middle band is where the surprise lives. That is the band a reserve guards against.
"A cash flow model with no CAM true-up reserve works eleven months a year. We see clients hit by the same March surprise three years running. Then the firm finally builds the reserve into the deliverable." - Angel Campa, Founder of CAMAudit
The bridge journal entry
The true-up entry should not restate prior monthly entries. Book each monthly CAM bill as billed: debit CAM expense, credit accounts payable. When the reconciliation arrives, the gap is one bridge entry.
For an undercollection, where the tenant owes more CAM:
Debit CAM Expense $12,000 Credit Accounts Payable $12,000
For an overcollection, where the landlord owes a refund or credit:
Debit Accounts Receivable $3,000 Credit CAM Expense $3,000
The bridge entry posts to CAM expense, not a separate true-up account. The gap is part of the same year''s CAM, not a new category. One entry keeps the GL clean. It also lets variance analysis run against the prior year reconciliation. Variance analysis means comparing this year to last year to spot odd swings.
There is one exception. The reconciliation may cross the tenant''s fiscal year-end. Then book an accrual at year-end for the estimated true-up. Do it before the bill arrives. The reversal entry handles the actual bill in the new year. This matters most for clients on calendar years. Their landlords are on the same calendar lease year. There the reconciliation arrives in February or March.
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. Most leases give 30 to 90 days to audit or dispute. Whether the tenant pays during that window depends on the lease. The firm flags the gap. It requests the backup. It advises the client to pay, ask for detail, or dispute.
The review costs little next to the cash at stake. Say a $12,000 true-up is half driven by billing errors. That recovers $6,000 in cash. A $50,000 true-up on a larger site can recover much more. The reconciliation review is where the firm earns its highest hourly value.
Modeling true-up uncertainty in the rolling forecast
For multi-location clients, the true-up forecast turns into a portfolio question. Some sites run hot and owe more. Others run cold and get a credit. The portfolio gap is smaller than any single site''s gap. That lets the firm forecast the total true-up with fair confidence.
Here is the math:
| Location | Annual CAM Estimate | Variance Band | Expected True-Up Range |
|---|---|---|---|
| Site A | $48,000 | plus or minus 15 percent | -$7,200 to +$7,200 |
| Site B | $72,000 | plus or minus 20 percent | -$14,400 to +$14,400 |
| Site C | $36,000 | plus or minus 10 percent | -$3,600 to +$3,600 |
| Portfolio | $156,000 | plus or minus 13 percent | -$20,200 to +$20,200 |
The portfolio band is narrower than the simple sum of site bands. The gaps are partly independent, so they offset. The rolling forecast funds a reserve at the midpoint or a bit above. How far above depends on how safe the firm wants the cash position.
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 big prior-year gap. The gap is large enough to review in detail. They go to a CAM reconciliation audit before the true-up payment goes out.
Forecasting, reserving, and reviewing turn the annual true-up into a managed budget line. It stops being a March surprise. The client sees the work. The firm books advisory hours that would otherwise look like plain bookkeeping.
A tenant client whose model survives the March cycle every year renews. The true-up forecast proves the firm''s value beyond bookkeeping. It justifies the advisory fee. It also sets up the broader occupancy advisory offer.