OWNER WORKFLOW GUIDE
How to Track Commercial Property Expenses in QuickBooks Beyond CAM
How to track non-reimbursable property expenses in QuickBooks — capital expenditures, vacancy costs, excluded management fees, and debt service — so they never inflate the CAM pool tenants are actually billed against.
CAM reconciliation gets most of the attention because tenants see that number directly, but a lot of the real expense risk on a commercial property sits in the costs that were never supposed to touch CAM in the first place. QuickBooks won't stop anyone from coding a five-figure capital project to the same account used for routine repairs — that boundary only exists if the chart of accounts is built to hold it.
1. Draw the CAM line in your chart of accounts before it gets crossed
Most commercial owners run a single "Repairs & Maintenance" account that happily accepts both a $150 sink-trap fix billed through CAM and a $38,000 capital project that should never enter the CAM pool at all. QuickBooks has no field anywhere for "capital" versus "repair" — it just posts whatever account you pick to the ledger and trusts you got it right. The fix has to live in account structure, not in a memo line someone writes to explain it later.
Class or Location tracking, if you're using either, adds a reporting slice on top of the account — it doesn't replace the need for separate accounts. A class can't retroactively sort which dollars were capital and which were CAM-eligible if both were posted to the same account to begin with.
- Create a distinct account (or sub-account) for capital improvements, separate from "Repairs & Maintenance — CAM"
- Give vacancy-period costs, CAM-excluded management fees, and ownership costs their own non-CAM accounts too — not just capital projects
- Decide the account at the moment of entry, not at year-end reconciliation — a $38,000 line sitting in the wrong account for eleven months skews every interim CAM estimate sent to tenants in between
- If a capital project runs through a TenantPoint work order, the category is set when someone reconciles the matching bank transaction and manually tags it — that human step, not the work order itself, decides whether the expense lands in capital or in CAM repairs
2. Capital expenditures: the repair-vs-replacement test, worked with real numbers
Whether something is "capital" for CAM purposes is a lease question, not a QuickBooks question or a GAAP question. Here's the math worked through on a realistic strip center: the parking lot needs a full asphalt repave, which runs $38,000. That same property also has routine pothole patches through the year, each running about $1,200. The lease covering the center specifically excludes capital improvements exceeding $5,000 from CAM — the repave clears that threshold by a wide margin; the patches don't come close.
If the $38,000 repave gets coded to the same "Repairs & Maintenance — CAM" account used for the $1,200 patches, it inflates that CAM category by nearly 32x what tenants should actually be billed for it. That's not a rounding error — it's the kind of number that gets flagged the moment a tenant's accountant asks for the backup invoices behind a reconciliation statement.
- $38,000 full repave vs. $1,200 routine patch — same parking lot, same general contractor category, completely different accounting treatment
- Lease-specific caps: this lease excludes capital items over $5,000 from CAM; the threshold comes from lease language, not from QuickBooks or from GAAP capitalization rules
- A capital project typically gets its own fixed-asset or capital-improvement account, sometimes depreciated over its useful life, never averaged into the CAM pool
- The practical test is scope: does the work restore what's already there, or replace the whole surface/system?
3. Vacancy-period costs: real money, no one to bill
While a suite sits empty, utilities, security coverage, and leasing/marketing costs keep running — but there's no tenant lease in force to allocate a share to. These are landlord costs by definition, not CAM, because CAM allocation depends on an occupied tenant with a lease share to begin with.
Track them in a dedicated vacancy or leasing-cost account rather than letting them sit in the same operating accounts used for occupied-suite CAM. If a suite is vacant for only part of a reconciliation period, prorate by actual vacant days — the period before lease-up is a landlord cost, the period after is CAM-eligible again.
- Utilities kept on for a vacant suite — HVAC standby, lighting — landlord cost, not CAM
- Security or patrol coverage across common areas plus the vacant unit
- Marketing, signage, and broker costs to re-lease the space
- A suite vacant for only part of the period: prorate landlord-absorbed vs. tenant-shared costs by actual vacant days, not the full CAM period
4. Management fees: check what this specific lease actually allows
A management fee is a genuine operating cost the owner pays every month, which makes it tempting to run straight into CAM alongside everything else. Many leases don't allow that — some cap the CAM-eligible portion at a fixed percentage of the pool, and some exclude the management fee from CAM outright, leaving the owner to absorb it. This is lease-by-lease, sometimes tenant-by-tenant within the same building, so the same fee dollar amount can be treated two different ways depending on which lease you're reconciling against.
The practical handling is to record the full fee in one account, so P&L and NOI reporting stay accurate, and apply the lease-specific CAM eligibility — capped, excluded, or fully allowed — only at the point of the tenant billback calculation. QuickBooks doesn't know the cap exists; the reconciliation has to apply it.
- Some leases allow the full market-rate management fee into CAM
- Others cap it — for example, at a fixed percentage of the property's gross CAM pool — and that cap has to be applied manually at reconciliation, not by underposting the expense itself
- Others exclude the management fee from CAM entirely, making it a pure ownership cost
- Post the full fee for accurate P&L reporting first, then apply lease-specific CAM eligibility as a separate step, not by changing what actually got posted
5. Owner draws and debt service: keep them off CAM and off the operating P&L
Mortgage principal, mortgage interest, and owner draws never belong in CAM — that part is close to universal. The part that's easy to miss is that they also don't belong on the operating P&L the way a CAM-eligible repair does, because they represent financing and ownership activity, not property operations.
The cleaner treatment: mortgage principal reduces a loan liability account rather than hitting an expense account at all; mortgage interest is a real expense, but typically sits below the operating-expense line (an "Other Expense" section) rather than inside the accounts that feed CAM or operating NOI; owner draws post to an equity account, not an expense account. Keeping these separate matters beyond bookkeeping neatness — NOI is a number both the CAM math and any lender covenants depend on, and mixing financing activity into operating expense accounts moves that number in ways that are hard to untangle later.
- Mortgage principal -> reduces a loan liability account, not an expense at all
- Mortgage interest -> a real expense, but typically posted below the operating-expense line, never inside CAM
- Owner draws and distributions -> an equity account, not an expense
- Mixing any of these into the operating-expense accounts used for CAM materially overstates or understates NOI
Frequently asked questions
Is there a standard dollar threshold that makes an expense "capital" instead of a repair?
No — there's no single number that applies everywhere. It's whatever the specific lease's CAM-exclusion clause says (a $5,000 threshold, like the parking lot example above, is common but not universal), and it doesn't even have to match the capitalization threshold your accountant uses for depreciation on that same asset. Read the lease clause, don't apply a rule of thumb across the whole portfolio.
Can QuickBooks flag a transaction as capital automatically?
No. Bare QuickBooks has no capital-versus-repair concept — it posts whatever account, sub-account, or class you assign at entry, and nothing more. The distinction only exists if your chart of accounts is built to hold it, and someone applies it consistently every time a bill or bank transaction gets coded.
If a suite sits vacant for six months and then gets leased, do those utility and security costs eventually get folded into the new tenant's CAM?
No. Costs incurred during the vacancy stay landlord costs for that period, full stop. A new tenant's CAM share starts from their occupancy date forward — folding six months of vacant-suite costs into their first bill would be charging them for a period they weren't even in the building.
Does a management-fee cap in the lease apply to the whole fee, or just the CAM-billed portion?
That depends entirely on the lease language, and it's worth reading closely rather than assuming. Some leases cap only what's charged to CAM while the owner still pays — and books — the full fee as a real operating cost; others exclude the management fee from CAM entirely. The two clauses look similar on the page but produce very different numbers on the reconciliation.
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.