True-up season starts with a stack of invoices
Every property that bills common-area maintenance to tenants runs into the same annual moment: it's time to reconcile what was actually spent on landscaping, snow removal, common utilities, security and maintenance against what tenants were billed throughout the year — and the honest starting point is a stack of invoices from a dozen different vendors, not a clean number anyone can just look up.
One vendor invoices monthly. Another bills quarterly. A snow-removal contract only generates invoices when it actually snows, unevenly across the year. None of that is a failure of anyone's process — it's the normal shape of common-area vendor billing, and it's exactly what makes an accurate, current CAM actual-cost picture hard to assemble without going through every invoice by hand.
The result, most years, is that whoever handles true-up builds the actual-cost side by pulling invoices from a filing system or inbox category by category, adding them up by hand, and hoping nothing from a slower-billing vendor got missed before the reconciliation letter goes out to tenants.
Why CAM reconciliation is harder than it sounds
Vendors bill on different schedules
A landscaping contract might invoice monthly while a roof-repair invoice is a single one-off — reconciling a full CAM year means catching invoices that landed at very different points across twelve months.
Categories aren't always labeled consistently
One vendor's invoice says 'grounds maintenance,' another says 'landscaping services' for functionally the same category, and a manual tally has to recognize they belong together.
Some costs span multiple properties
A management company covering several properties with one security contract needs that invoice split by property before it can be reconciled against any single property's tenant billings.
The budget used to bill tenants was set months in advance
Tenant CAM billings during the year are based on an estimated budget, not actual cost — so the actual-cost side has to be assembled independently before it can be compared against that estimate at all.
None of these problems get solved by asking vendors to bill more predictably — that request rarely changes anything. What actually works is reading invoices as they arrive and rolling them up by category consistently, all year, rather than reconstructing everything in one push when true-up letters are due.
What this doesn't do, stated up front
Doesn't calculate tenant pro-rata shares
Pro-rata percentages come from each lease, usually based on leasable square footage. This totals the actual cost side; applying lease percentages to that total stays a lease-administration step your team performs.
Doesn't set or audit the CAM budget
It reports what invoices show was actually spent. Whether the original budget used to bill tenants was reasonable is a separate planning decision.
Doesn't explain why a category ran over
It surfaces a deviation from a category's expected pattern. Understanding the cause — a one-time repair, a rate increase, a heavier winter — requires someone with property context.
Doesn't apply lease-specific caps or exclusions
Some leases cap certain CAM categories or exclude specific cost types entirely. This reads and totals actual invoice cost; applying any lease-specific adjustment is a step your team applies afterward.
What gets read from each CAM invoice
| Field | Notes |
|---|---|
| Vendor and category | So every invoice rolls into the correct CAM category, even when vendor labeling varies |
| Invoice amount and date | For assigning cost to the correct reconciliation period |
| Property reference, if multi-property | So a shared vendor invoice can be split and matched correctly per property |
| Invoice number | So every category total traces back to specific, individually verifiable invoices |
How it works
Read every CAM invoice
Vendor, category, amount, date and property reference extracted from the invoice batch.
Group into categories
Invoices rolled up by category, recognizing common variations in vendor labeling.
Roll up actual cost per category
Every matched invoice summed into one running total per category for the period.
Export the reconciliation
One actual-cost total per category, ready to compare against budgeted tenant billings, with drill-down to every underlying invoice.
A shopping center, one CAM year
A mid-sized shopping center with six CAM categories and eleven vendors asked for a single actual-cost picture for the year, built consistently rather than reconstructed by hand at true-up.
| Finding | Categories |
|---|---|
| Rolled up cleanly, matched the prior year's pattern | 4 |
| Ran meaningfully over budget, flagged for review | 1 |
| A shared security invoice needed splitting across two properties | 1 |
The category that ran over budget was snow removal, following a heavier winter than the year the original budget was set against — a real, explainable variance rather than a billing error, but one worth flagging clearly in the true-up letter rather than burying inside a total. The shared security invoice split cleanly once its property reference was read, rather than being coded entirely to whichever property happened to be invoiced first.
Matching cost isn't calculating pro-rata shares
A CAM reconciliation built from matched invoice cost answers one specific question — what did the property actually spend on each CAM category this year — and stops there. Translating that actual-cost total into what each individual tenant owes or is owed back requires applying each lease's specific pro-rata share, which is usually a percentage of leasable square footage defined in the lease itself, sometimes adjusted by caps or exclusions unique to that tenant.
Keeping these distinct matters because conflating them produces a reconciliation that looks like it's making a tenant-billing decision it was never designed to make. The actual-cost side is mechanical and traceable to invoices; the pro-rata allocation depends on lease terms this tool never sees.
When a category doesn't fit the pattern
Once actual cost is rolled up consistently by category, deviations become visible in a way they weren't before — a category running well ahead of the same period last year, or a vendor whose invoice total jumped sharply without an obvious explanation.
None of that is proof of a problem on its own. It's a pointer toward a specific category worth a conversation with whoever manages that vendor relationship — which is a much shorter list to work through than reviewing every category equally, every year, whether or not anything actually changed.
Reconciling before true-up, not at true-up
A CAM reconciliation assembled entirely in the weeks before annual true-up letters go out means every anomaly — a missing invoice, a miscategorized vendor bill, a shared cost that needs splitting — gets discovered under deadline pressure, with tenants waiting on a number.
Reconciling quarterly instead means each quarter's invoices get matched and categorized while they're still fresh, so by the time true-up season arrives, the actual-cost picture is already mostly assembled and just needs a final quarter added and a last review pass — rather than a full year reconstructed from scratch.
It doesn't require vendors to invoice any differently than they already do; it just means reading whatever has arrived at each interval rather than waiting for the full year before looking at anything.
Handling categories with caps or exclusions
Many commercial leases cap certain CAM categories — controllable costs limited to a fixed percentage increase year over year, for instance — or exclude specific cost types from CAM entirely, like capital improvements or costs covered under a separate insurance claim.
Those caps and exclusions are lease-specific and applied after the actual-cost reconciliation, not during it. This tool's role stops at producing an accurate actual-spend total per category; whoever administers the leases applies each tenant's specific cap or exclusion against that total when calculating what's actually billable to that tenant.
Keeping the actual-cost total separate from any lease-specific adjustment also makes it easier to audit later — a clean, unadjusted total by category, with each tenant's specific caps and exclusions applied as a distinct, documented step on top of it.
Who this is for
Property managers preparing true-up letters
A current actual-cost picture across every CAM category instead of chasing vendor invoices one by one.
Owners reviewing whether CAM budgets are realistic
A real, up-to-date sense of what common-area costs actually run, not last year's estimate carried forward.
Accountants preparing the true-up entry
Matched actual-cost data by category as an input, rather than reconstructing it from a stack of vendor invoices.
Bookkeepers serving multiple commercial properties
One repeatable process across every property's vendor list and invoice format.
Feeding your true-up letter, not replacing it
A common worry when a property introduces a systematic CAM reconciliation is that it's a step toward automating away the judgment behind the actual true-up letter sent to tenants. Worth addressing directly, because it's a reasonable concern and it shapes how the reconciliation actually gets used.
This reconciliation doesn't send any letter, doesn't calculate a single tenant's bill, and doesn't apply any lease terms. It's a read-only rollup of actual CAM invoice cost per category — the input whoever prepares true-up letters would otherwise have to assemble by hand before applying lease-specific percentages, caps and exclusions to arrive at each tenant's actual number.
Being explicit about that boundary — a cost input, not a tenant bill — tends to matter more to a property team than any technical detail about how the matching works, and it's worth stating plainly when introducing this to a team that hasn't used automated matching before.
Framing it as time saved on the assembly step, with the lease-administration judgment unchanged, tends to land better than framing it as a replacement for that judgment — even though the underlying reconciliation is identical either way.
Starting with one category, not the whole budget
A property with a dozen CAM categories and a full year of vendor invoices can find the idea of reconciling everything at once daunting enough to never start. A more realistic path is beginning with one or two categories — the ones with the cleanest, most consistently invoiced vendors — and using that as a proof of concept before extending to the rest.
That first small category answers the practical questions that matter before scaling up: how cleanly do the invoices actually match, how much manual correction do the flagged lines need, and how does the resulting total compare to whatever partial actual-cost picture existed before. Answers from one category transfer reasonably well to the rest, whereas trying to reconcile a full year across every category simultaneously multiplies every early surprise across the whole budget.
A well-referenced category with few vendors — landscaping, say, with a single contract — is a natural first candidate, not because messier categories don't matter, but because starting with the straightforward case builds a working process before it has to handle a category with many small, irregular vendors.
What an owner actually wants from the reconciliation
A single grand total across all CAM categories answers one question and raises several more — it's rarely the actual deliverable an owner wants to see on its own.
A total across all CAM categories, for the headline actual-cost figure.
A per-category breakdown, so any single category's actual cost is visible on its own.
A comparison against the budget used to bill tenants that year, where one exists.
A flag on any category whose cost moved sharply since the prior year.
Four layers, not one flat number — because an owner asking “where does CAM stand this year” is really asking several distinct questions at once, and a reconciliation that only answers the first one leaves the rest to be reconstructed by hand whenever someone follows up.
The per-category breakdown in particular tends to get more use than expected once it exists — an owner who has never had a clean, current view into which categories are running heavy on cost often finds that comparison alone valuable, independent of anything the total says.
Privacy
Uploads go over TLS, encrypted end to end.
Processing runs on EU-hosted infrastructure.
Original documents are deleted immediately after extraction.
Invoice and property data are never used to train AI models.
Full details are on the security page.
A smaller worked example, in detail
Take three CAM categories at a mid-sized office building, reconciled at year end. Landscaping draws from a single vendor with clean, consistently coded monthly invoices. Snow removal invoices only when it snows, unevenly across the winter months. Common utilities are billed by the property's own utility provider, spanning both the CAM common areas and a small amount of vacant-suite usage that needs excluding.
Landscaping's cost rolls up cleanly — every invoice matched, no flags. Snow removal's total reflects a genuinely uneven year, running well above the budgeted estimate after a heavier winter — a real variance worth flagging in the true-up letter, not an error in how it was reconciled. Common utilities requires manual confirmation that the vacant-suite portion has been excluded correctly before the category total is treated as final.
The resulting reconciliation combines all three cleanly: landscaping needs no manual intervention, snow removal is flagged with its budget variance clearly visible, and utilities carries a documented note on the vacant-suite exclusion. None of the three categories required a change to how vendors invoice to get there.
Scaled up to a dozen categories instead of three, the proportions hold roughly steady: most categories reconcile cleanly, a handful carry a known variance worth flagging, and the total review time stays small relative to the alternative of manually assembling a dozen separate cost pictures by hand from a year of invoices.
That ratio — most categories clean, a few with a known variance — tends to hold regardless of how many CAM categories a property tracks, which is exactly what makes the approach scale rather than getting proportionally harder as the category count grows.