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?
I say use ChatGPT's Sol or Astra models. If you have all the receipts and if you have the estimated payment earlier, it can scan the receipts and add it up and do the recouncliation and produce a nice spreadsheet for you. We don't have NNN but we use it for our multifamily properties where it uses receipts and bank statements to reconcile. It's working pretty well. You can build a skill and once the skill is built you don't even need to tell it everything. You can simply say reconcile. The skill will know what folders to look at the receipts etc.
CPA, CFP®, PFS · FL · Member since 2017 · 5k+ posts · 3k+ votes
1w
Milivoje, I think the biggest improvement is to stop treating CAM reconciliation as a year-end project and make it part of the monthly property accounting.
Then at year-end, you’re really just reconciling the final numbers instead of rebuilding twelve months of activity from bank statements and tenant emails.
I’d also keep each lease’s CAM language summarized in the same file or system. Different leases may treat management fees, capital items, insurance, taxes, repairs, audit rights, caps, and gross-up provisions differently, so I wouldn’t assume one formula applies across every tenant.
From the tax/accounting side, I’d also keep the reimbursements and underlying expenses properly separated. CAM reimbursements generally shouldn’t just disappear against the expenses in the bookkeeping. Clean gross income and expense tracking gives you a much better audit trail and makes property-level reporting easier.
For a smaller portfolio, a well-designed spreadsheet can work. Once you’re spending hours chasing allocations and payments, that’s usually the point where software or outsourced bookkeeping starts paying for itself.
Feel free to DM me, I’d be happy to send over a portfolio-management resource that might help simplify the property-level tracking and reconciliation process.
Minsk, Belarus · Member since 2026 · 16 posts · 1 vote
1w
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.
Minsk, Belarus · Member since 2026 · 16 posts · 1 vote
1w
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.
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.
Real Estate Consultant · Norfolk, VA · Member since 2017 · 345 posts · 201 votes
1w
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.
Attorney · 10451 Mill Run Cir #755 Owings Mills, MD 21117 · Member since 2024 · 360 posts · 136 votes
1w
Quote from @Milivoje Simonovic:
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?
@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.
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.
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.
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.
Real Estate Consultant · Lehigh Valley PA & New York City · Member since 2013 · 1k+ posts · 660 votes
23h
For commercial clients, we treat CAM as part of monthly property accounting, not a December science fair. Each lease gets a one-page abstract: inclusions, exclusions, caps, gross-up rules, current share, and base year. Then estimates, tenant payments, and actual recoverable expenses live in separate buckets so reimbursements don't pretend to be NOI.
Monthly, we post activity and watch the estimate-versus-actual variance. Quarterly we do a soft true-up. Annually we finalize with the lease rules in front of us, not from memory. Spreadsheets are fine as the calc layer if the GL stays clean; software only helps if it respects those lease fields.
If you wait until year-end to figure out who owes what, the lease language always wins and your weekend loses.
