OWNER WORKFLOW GUIDE
How to Record CAM Charges in QuickBooks (and Set Yourself Up for Reconciliation Season)
How QuickBooks' Class and Location fields map to CAM tracking, where the 40-item cap bites, and what to record now so reconciliation season isn't a scramble.
QuickBooks records that $3,180 left the bank for a vendor. It has no field for whether that $3,180 belongs in this year's CAM pool, which of a property's tenants share it, or which lease year's true-up it falls under. Getting CAM charges recorded correctly means building that context around QuickBooks' Class and Location fields before reconciliation season forces the question.
1. Decide what belongs in the CAM pool before it becomes a QuickBooks entry
QuickBooks doesn't ask whether an expense is CAM-eligible when you enter it, so if you don't decide before you code the transaction, nobody decides at all — it just sits in Repairs & Maintenance indistinguishable from everything else. Check the expense against the lease's CAM definition (and its exclusion list) first: capital replacements, management-fee caps, and admin surcharges are the categories most likely to differ tenant-by-tenant even within the same property.
This matters more for anything that's only partly reimbursable. A roof patch is usually straightforward CAM; a full unit replacement often isn't, or is capped and depreciated instead of passed through in the year it was paid. Make that call before the invoice becomes a QuickBooks transaction, because once ten similar entries are sitting in the same account, nothing in QuickBooks distinguishes which ones you already decided on from which ones you didn't.
- Confirm the lease's CAM definition and exclusion list (capital items, fee caps, admin surcharges) before coding the expense, not after
- Note which lease year or true-up period the expense belongs to — QuickBooks has no field for this, so it has to live in a memo, a Class name, or an outside tracker
- Flag partially reimbursable items explicitly (a repair that's part CAM, part capital) so the split isn't guessed at reconciliation
- Keep the original vendor invoice attached to the QuickBooks transaction; it's your backup when a tenant later disputes the eligibility call
2. Set up Locations for properties and Classes for CAM categories — and check the 40-item cap first
QuickBooks Online Plus and Advanced give you two tracking dimensions, and for CAM tracking they're not interchangeable. Location lives at the transaction header and QuickBooks allows exactly one per transaction — which matches how expenses actually happen, since a given invoice was paid for one property. Class can be applied per line, multiple times on a single transaction, which fits tagging expense category (Repairs & Maintenance, Utilities, Landscaping, Snow Removal, Insurance) rather than property.
So the structural choice is: Location = property, Class = CAM expense category. That combination lets a Profit & Loss by Location report, filtered or crossed with Class, approximate a per-property CAM breakdown without re-keying anything. The catch is QuickBooks Plus caps combined active Classes and Locations at 40 total. Eight properties and ten CAM categories is already 18 combined entries; a portfolio that grows to fourteen properties with a slightly longer category list can hit that ceiling without anyone noticing until QuickBooks refuses to let a new one be created.
- Location = property (QuickBooks allows exactly one per transaction, so a repair invoice that legitimately covers two buildings needs two separate transactions, not one split by Location)
- Class = CAM expense category, applied per line — a single vendor invoice covering Repairs & Maintenance and Utilities can be split across two lines with two Classes in one transaction
- Count combined active Classes plus Locations before building the list out; QuickBooks Online Plus caps this at 40 total — confirm the current figure for Advanced or any other plan directly in QuickBooks before assuming it's different
- Standardize the CAM category list once — 8 to 12 categories is typical — instead of adding a new Class every time an unfamiliar expense type shows up
3. Record the expense correctly, and know exactly what QuickBooks captures (and doesn't)
Take a real case: a strip center's HVAC unit fails in July, the vendor invoice comes to $3,180, and it's paid from the operating account the same week. In QuickBooks, that's an Expense (or Check, not Bill, since it was paid same-day rather than invoiced for later payment): payee is the HVAC vendor, Location is the strip center, the account is Repairs & Maintenance, and the Class is whichever CAM category you've standardized on for mechanical repairs.
Once that's entered, QuickBooks knows the property, the vendor, the date, the amount, and the expense category. It still doesn't know whether the $3,180 counts toward this year's CAM pool at all, which of the center's six tenants share it, what each tenant's pro-rata basis is, or which lease year's true-up it belongs to if the failure happened in June but the invoice cleared in July. None of that is a QuickBooks limitation you fix with a setting — there's simply no field for any of it, which is exactly why steps 1 and 2 have to happen before this one.
- Use Expense or Check for anything paid the same day from the operating account — it matches how the transaction actually happened and keeps Accounts Payable clean for genuine unpaid vendor bills
- Set Location once, at the header — this is the only place QuickBooks lets you set it, and it applies the same way on a Payment or an Invoice
- Set Class at the line level — this matches how QuickBooks' own Purchase-family transactions work, where Class has no header-level shortcut the way Location does
- Attach the vendor invoice as a source document; the memo field alone won't carry lease-specific context (CAM year, tenant share basis) forward to reconciliation
4. Separate reimbursable CAM expenses from non-reimbursable ones inside QuickBooks' limits
Since QuickBooks has no CAM-eligible toggle, most bookkeepers approximate one with the Class list itself: splitting "Repairs & Maintenance" into "Repairs & Maintenance – CAM" and "Repairs & Maintenance – Capital/Excluded" as two separate Classes, or using sub-accounts under the same parent account for the chart-of-accounts side. A lighter option that doesn't grow the Class list is a consistent memo prefix ("CAM:" at the start of every reimbursable line) that QuickBooks' own search and export can filter on later.
None of these are a substitute for the actual CAM allocation calculation — they only keep the raw expense data organized enough that pulling it at reconciliation time doesn't mean re-reading every invoice from January.
- Split ambiguous categories into CAM and non-CAM Classes up front rather than deciding after the fact, if you have Class headroom under the 40-item cap
- Use a memo convention instead if you're already near the cap — a filterable prefix works with QuickBooks' native search and export without adding entities
- Export by Location and Class to a spreadsheet, or a dedicated CAM tool, at least quarterly — waiting until year-end reconciliation to look at the totals is how six months of miscoded entries get discovered all at once
- Reconcile the bank feed against CAM-relevant transactions as they clear, not just against the GL balance; catching a miscoded expense in the month it happens is far cheaper than unwinding it during reconciliation
5. Get the numbers ready before reconciliation season starts
At close-out, pull the expense report by Location and Class for the full reconciliation period — not a trailing 12 months from today, but the actual lease year or calendar year each property is reconciled on. Then check that total against each tenant's lease individually: CAM caps, exclusions, and pro-rata share bases are set lease by lease, not portfolio-wide, so one property-level total almost never applies evenly across every tenant sharing it.
None of that comparison happens inside QuickBooks — it's a GL export that has to be checked against lease terms living somewhere else, tenant by tenant. That's the specific gap CAM-focused tools (TenantPoint's included) exist to close: TenantPoint pushes the finished result into QuickBooks once the allocation is done — the invoice with CAM already included as a line alongside rent, and the confirmed payment applied against it — as standard Invoice and Payment records, so QuickBooks still ends up holding the accounting record even though it isn't where the allocation math happens.
- Pull expenses by Location and Class for the full reconciliation period, matched to the property's actual lease or calendar year, not a rolling window
- Cross-check the total against each tenant's lease individually — caps, exclusions, and pro-rata basis are set per lease, not per property
- Reconcile prior-year true-up adjustments separately from current-year CAM; combining them silently changes what the comparison is actually measuring
- Keep source invoices linked to their QuickBooks transactions so a tenant dispute can be resolved by pointing at the original document, not a recreated spreadsheet row
Frequently asked questions
Should I use Class or Location for properties in QuickBooks?
Location, if you're on QuickBooks Plus or Advanced. QuickBooks allows exactly one Location per transaction, which matches how a real expense usually works — it was paid for one property. Class allows multiple per transaction, which fits tagging the CAM expense category per line instead. Using Class for properties works too, but it breaks down the moment one invoice covers two buildings, since a transaction can only have one Location.
What's the QuickBooks Class + Location limit, and does it actually matter?
QuickBooks Online Plus caps combined active Classes and Locations at 40 total. This is a QuickBooks plan limit, not a CAM accounting rule, so it's easy to ignore until a portfolio's property count and CAM category list add up past it — 8 properties and 10 categories is already 18; a few more buildings and a couple of new expense types can close that gap faster than most owners expect.
Can QuickBooks tell me whether an expense is CAM-eligible?
No. QuickBooks has no field for CAM eligibility, lease year, or true-up period. That call has to be made against the lease before the transaction is even entered, and Classes, sub-accounts, or a memo convention are just ways to record a decision you already made — not a system that makes it for you.
Does TenantPoint replace QuickBooks for CAM accounting?
No. TenantPoint pushes generated invoices, confirmed payments, and reconciled work-order expenses into QuickBooks one-directionally, as Invoices, Payments, and Purchases; QuickBooks stays the system of record for the books. This is a deliberate design choice, not a limitation waiting to be lifted.
USE THIS WITH ONE REAL PROPERTY
Stop rebuilding the operating record every month.
Start a 15-day trial, add one property, and bring the lease, rent, CAM, and tenant communication into the same workspace.