How do you handle CAM/NNN reconciliation for your properties

Question

CAM reconciliations are a major source of frustration for small time property owners. For me, it means spending a significant amount of time each year tracking down each of my tenants to verify what they have paid, and determining what amount I am still owed. I had no idea I would have to do this when I took on property ownership.

When talking about risks associated with NNN leasing, most people discuss credit risk associated with tenants. There is risk associated with landlord reconciliations as well. I own a small number of properties and have to do pro rata CAM calculations, and then there are fees and estimates and other things to consider. This gets very time consuming and tedious.

As a landlord, I have to make sure language in the lease around CAM charges is very clear. I am suspicious of language that is too broad. If there is no clear language in the lease, I am absolutely expecting to have to have this explained to me and possibly litigate.

Curious how others here handle CAM reconciliation - spreadsheet you built yourself, outsource to an accountant, software? What's worked for you?

Fulton Abraham Sanchez · Answer

@Milivoje Simonovic, hi. CAM works best when treated as an ongoing accounting process, not a year-end cleanup. Track each tenant’s share, estimates, actual expenses, exclusions, and adjustments throughout the year.

For a small portfolio, a good spreadsheet may be enough. As the number of tenants or properties grows, outsourcing or using accounting software can save time and create cleaner documentation.

And yes, the lease language is critical. Clear CAM provisions make the reconciliation much easier to defend and explain.

Milivoje Simonovic · Answer

Thanks, that matches what a few others here have said too. Spreadsheet works fine early on, but the lease language ends up being the real foundation either way.

Milivoje Simonovic · Answer

That list is really helpful, thank you. Included, excluded, share calculation, caps, fees, reconciliation timing, backup docs, that's exactly the kind of detail I'm trying to capture. Would be glad to stay in touch.

Diana Khan · Answer

@Milivoje Simonovic, this is exactly where I’ve seen commercial lease issues start. Most of the time, the math itself is not the problem. The problem is that the landlord and tenant read the CAM section differently once the bill shows up.

When I work with clients on leases, I like the CAM language to be clear enough that someone managing the property can actually use it without guessing. What is included, what is excluded, how the tenant’s share is calculated, whether there is a cap, what fees can be added, when the reconciliation happens, and what backup the tenant can ask to see. If those pieces are clear from the beginning, the year-end conversation usually goes a lot smoother.

I’d be glad to stay connected, @Milivoje Simonovic. This is one of those areas where good lease language can save more time than any spreadsheet or software later.

Dan V. · Answer

I used to handle CAM/TICAM charges and reconciliations for a company with several large warehouses. The first thing I would say is that everything has to start with what the lease actually says—what expenses (be specific) are recoverable, how the tenant's share is calculated, any caps/exclusions, and how/when reconciliation is done.

The process we used worked pretty well:

We prepared a TICAM budget every year for taxes, insurance, common area maintenance, etc. We then allocated the expenses based on each tenant's pro-rata share, usually based on square footage, and billed the estimated amount monthly along with rent.

Throughout the year, we tracked the actual expenses against the budget. Then, usually during the first quarter of the following year, we completed the CAM reconciliation and did a true-up. If the tenant overpaid, they received a credit/refund. If they underpaid, they were billed for the difference.

The key, in my opinion, is preparing a good annual budget. Once you have enough historical data, taxes and insurance are relatively easy to estimate and you can factor in expected increases. For maintenance, I would look at historical costs, vendor contracts/renewals and updated bids, plus any known common-area work planned for the upcoming year.

We also provided tenants with the breakdown supporting the CAM budget and then the actual reconciliation. I think transparency helps a lot because the tenant can see where the numbers came from instead of just receiving an additional bill at year-end.

For an unexpected large expense during the year, I would go back to the lease before changing what the tenant is paying. If the lease allows the landlord to revise estimated CAM/TICAM payments during the year, you may be able to adjust the monthly estimate and avoid a huge true-up later. If it doesn't, I wouldn't just increase the charge without reviewing the lease or getting legal guidance. You may have to carry the difference until the annual reconciliation. That's also something worth addressing clearly when drafting future leases.

For me, the actual reconciliation wasn't the hardest part once the system was established. The important part was having a good budget, properly coding the expenses throughout the year, tracking each tenant's pro-rata share and payments, and having the lease terms clearly documented in the system.

Milivoje Simonovic · Answer

That example nails it, same clause can mean different things to different people and that's where the real cost comes in. Appreciate you sharing that.

Nikita Loika · Answer

The lease language is the real problem, not the math. If the CAM clause just says "tenant's pro rata share of common area expenses" without spelling out whether the cap is cumulative or compounding, whether gross-up applies to fixed costs or only variable, and what's excluded — capital repairs, management fee, marketing — you're not reconciling anything, you're negotiating it fresh every year. Get an addendum in at renewal that nails down cap type and gross-up methodology. Saves you the argument later.

Milivoje Simonovic · Answer

That is the problem right there. The math is easy once you have numbers but the ambiguity, in the clause itself is what eats the time.

Milivoje Simonovic · Answer

That’s basically the paid version I’m working on. One-page lease abstract for each tenant, with the fields you mentioned and each one linked to the correct page. I’d love to show you when it’s ready if that would be helpful.

Nikita Loika · Answer

Yeah, and the annoying part is you can't go back and fix it after the fact, you're stuck interpreting whatever's already signed. what's worked for me: a one-page abstract per tenant, done once, upfront. cap type, gross-up scope, exclusions, all pulled straight from the lease with the page cited next to each item. doesn't fix the ambiguity baked into the document itself, but now you're only arguing with the lease once a year instead of re-reading the whole thing every time a number looks off.