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.
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.
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.
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.
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.
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.
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.
Good question, and I think the three options actually solve different parts of the problem. The spreadsheet handles the math. The accountant handles the coding. Neither handles input quality, which is where most of the tedious chasing comes from.
What has worked in my experience: monthly cadence instead of a year-end project (several people here already said this and they are right), one-page lease abstracts per tenant, and, on the utility side specifically, auditing the bills before they enter the reconciliation. Rate class errors, estimated meter reads, and duplicate charges are more common than people expect. If a bad number flows into your CAM pool, you end up reconciling wrong numbers with clean math, and the tenant dispute that follows is about trust, not arithmetic.
On utilities it also helps to book accruals monthly so estimated billings track actuals through the year. The year-end true-up stays small and explainable instead of becoming a January surprise.
Full disclosure: I work with Conduit, a utility intelligence platform for commercial real estate, and this input layer (bill capture, auditing, accruals, tenant cost recovery) is what we automate. Not pitching you - a small portfolio can run fine on a spreadsheet plus discipline. But even fully manual, audit the utility bills before they hit the pool. Cheapest dispute prevention there is.
Disclosure first: I run Vandtage, and I'm starting a service that prepares CAM reconciliations for small commercial owners. So I'm not a neutral party, and this is one person's view.
To your question: for a handful of properties a spreadsheet you built yourself is enough. The tool matters less than doing three things before the year ends, while you still have time to fix them.
1. Write one page per lease. For each tenant: pro rata share and what it is measured against (leased area or leasable area), what is included in CAM, what is excluded, any cap and how it is calculated (year over year, over a base year, cumulative or not), the admin or management fee and what it applies to, and the deadline the lease gives you to send the statement. This is the step most people skip, and it is where your worry about broad language gets settled. If the page is hard to fill in, the lease is the problem, and you want to know that now.
2. Code every expense once, when you pay it. Recoverable, not recoverable, or recoverable from some tenants only. Doing this in February from a year of bank statements is what makes it take days.
3. Reconcile tenant by tenant against that one page. Total recoverable cost, times the tenant's share, less what the lease excludes or caps, less the estimates they paid. Put the lease section next to each line of the statement. Tenants question far less when they can see where a charge comes from.
On chasing tenants for what they paid: you shouldn't need to. Your own ledger of estimate payments is the record. If it isn't reliable, that is the first thing to fix for next year.
An accountant is worth it once the leases stop looking alike: different caps, base years, or anchor tenants with their own exclusions. Software earns its cost later than most people expect.
One thing to check this month: some leases let the tenant refuse a true-up that arrives after a set date. Find that date in each lease before you plan your first quarter.