What is a CAM reconciliation?

A CAM reconciliation is the annual reckoning between what commercial tenants paid in monthly estimated operating charges and what the building actually cost to maintain. In commercial leases, common area maintenance (CAM) covers shared operating expenses such as landscaping, snow removal, parking lot lighting, lobby cleaning, and trash hauling. In a triple net (NNN) lease, the tenant also pays its share of property taxes and building insurance, and those are usually trued up the same way.

Because maintenance bills vary each month, landlords budget operating costs before the year begins and bill tenants monthly estimated CAM charges. At year-end, once actual expenses are finalized, the landlord calculates the variance. Tenants who underpaid are billed for the shortfall; tenants who overpaid receive a credit or refund.

This guide walks through a three-tenant worked example, covers lease clauses that modify the calculation, and shows how to record CAM estimates and true-ups in QuickBooks Online.

Worked example: a three-tenant commercial building

Consider a 10,000-square-foot commercial building with three tenants:

• Suite A (Anchor Retail): 5,000 sq ft (50.00% share)
• Suite B (Tech Office): 3,000 sq ft (30.00% share)
• Suite C (Design Studio): 2,000 sq ft (20.00% share)

During the year, actual allowable CAM operating expenses totaled $60,000.00:

Expense category	Description	Annual actual cost
Landscaping & snow removal	Groundskeeping and snow clearing	14,000.00
Trash, water & sewer utilities	Trash hauling and water service	11,000.00
Common area janitorial	Lobby and hallway cleaning	9,000.00
Parking lot & exterior lighting	Fixture upkeep and lot patching	6,000.00
Common area repairs	Routine repairs to shared areas	12,000.00
Property management fees	Third-party property management	8,000.00
Total actual CAM expenses	Annual operating expenses	60,000.00

Calculating pro rata shares and true-ups

Under standard commercial leases, each tenant’s share reflects their portion of total building area:

Pro rata share = Tenant rentable area ÷ Building rentable area

Multiplying the actual CAM pool by each tenant’s pro rata share establishes their annual share:

Tenant actual CAM share = Total actual CAM expenses × Tenant pro rata share

Comparing that share to monthly estimates paid determines the year-end true-up:

Tenant true-up = Tenant actual CAM share − Estimated CAM paid

Here is the reconciliation schedule across all three suites:

Suite	Tenant	Leased area	Pro rata share	Actual CAM share	Estimated CAM paid	Net true-up	Result
Suite A	Anchor Retail	5,000 sq ft	50.00%	30,000.00	27,600.00	2,400.00	Tenant owes landlord
Suite B	Tech Office	3,000 sq ft	30.00%	18,000.00	19,200.00	(1,200.00)	Landlord credits tenant
Suite C	Design Studio	2,000 sq ft	20.00%	12,000.00	11,400.00	600.00	Tenant owes landlord
Total	All tenants	10,000 sq ft	100.00%	60,000.00	58,200.00	1,800.00	Net owed to landlord

Suite A underpaid by $2,400.00 ($30,000.00 share minus $27,600.00 paid), and Suite C underpaid by $600.00 ($12,000.00 share minus $11,400.00 paid). The landlord bills both shortfalls. Suite B overpaid by $1,200.00 ($18,000.00 share minus $19,200.00 paid), receiving a credit or refund. Across the building, actual costs exceeded collections by $1,800.00 ($60,000.00 − $58,200.00).

Lease terms that modify the CAM reconciliation

While the pro rata formula is standard, lease clauses often adjust which expenses qualify and how they are allocated.

Controllable versus uncontrollable cost caps

Commercial leases often cap annual increases on controllable operating expenses. Controllable costs are expenses the manager directly controls, such as janitorial contracts, landscaping, and routine repairs. Uncontrollable costs are dictated by outside markets or government entities, such as property taxes, utility rates, and casualty insurance.

With a 5% cap, the tenant’s share of controllable costs can rise no more than 5% over the prior year. Caps may be cumulative, carrying unused room forward to later years, or non-cumulative. If controllable costs rise 15% in a hard winter under a non-cumulative 5% cap, the landlord absorbs the other 10 points for that tenant.

Gross-up provisions for partially occupied buildings

When a building has vacant space, variable operating expenses decrease while fixed costs remain constant. A gross-up clause lets the landlord restate variable expenses, such as janitorial and shared water, at the level they would reach at the occupancy the lease names, for example 95% or 100%.

Without a gross-up, the landlord absorbs the vacant suites’ share of costs that fell only because those suites were empty, and each tenant’s bill swings with occupancy. Grossing up before applying the pro rata share keeps each tenant’s charge close to what it would be in a full building.

Common CAM exclusions and capital expenditure limits

Exclusion lists differ by lease. Items that often appear on them:

• Capital expenditures: Structural replacements like a new roof or repaving, which are capitalized rather than expensed. Some leases let the landlord recover them over their useful life instead of excluding them outright.
• Leasing commissions and marketing: Broker fees and advertising to find new tenants.
• Tenant improvements: Build-out costs specific to another tenant’s premises.
• Executive overhead: Corporate salaries unrelated to day-to-day property operations.

Treating capital improvements as routine maintenance triggers tenant disputes. Capital improvements belong on the balance sheet, as detailed in our guide to the real estate chart of accounts.

Bookkeeping entries for CAM estimates and the year-end true-up

A reliable CAM reconciliation requires keeping estimated billings separate from actual operating expenses throughout the year. The entries below use four accounts: Property Operating Checking, Tenant Accounts Receivable, Commercial Lease Revenue, and CAM Reimbursement Income.

Monthly estimated CAM billing and payment

On January 1, the landlord bills Suite A for $8,000.00 base rent plus $2,300.00 in estimated CAM:

Date	Account	Account type	Debit	Credit
Jan 1	Tenant Accounts Receivable	Accounts Receivable	10,300.00
Jan 1	Commercial Lease Revenue	Income		8,000.00
Jan 1	CAM Reimbursement Income	Income		2,300.00

On January 5, Suite A pays the invoice in full:

Date	Account	Account type	Debit	Credit
Jan 5	Property Operating Checking	Bank	10,300.00
Jan 5	Tenant Accounts Receivable	Accounts Receivable		10,300.00

The $10,300.00 deposit matches one line on the bank statement, and CAM Reimbursement Income records the estimated payments toward operating costs.

True-up invoice for an underpaying tenant

On February 15, after year-end expenses are reconciled, the landlord bills Suite A for the $2,400.00 underpayment. If the prior year is still open in the books, date the true-up December 31 instead, so the income lands in the year the costs did.

Date	Account	Account type	Debit	Credit
Feb 15	Tenant Accounts Receivable	Accounts Receivable	2,400.00
Feb 15	CAM Reimbursement Income	Income		2,400.00

On March 1, Suite A pays the true-up invoice:

Date	Account	Account type	Debit	Credit
Mar 1	Property Operating Checking	Bank	2,400.00
Mar 1	Tenant Accounts Receivable	Accounts Receivable		2,400.00

The $2,400.00 deposit matches the incoming line on the bank statement.

True-up settlement for an overpaying tenant

For Suite B, the reconciliation shows a $1,200.00 overpayment. If the landlord issues a refund check on March 1:

Date	Account	Account type	Debit	Credit
Mar 1	CAM Reimbursement Income	Income	1,200.00
Mar 1	Property Operating Checking	Bank		1,200.00

The check withdrawal appears as one line on the bank statement. If the lease applies the overpayment to future charges instead, issue a $1,200.00 credit memo using the CAM True-Up item. It debits CAM Reimbursement Income and credits Tenant Accounts Receivable, and QuickBooks applies it to the tenant’s next invoice.

How to set up CAM accounts in QuickBooks Online

Setting up CAM tracking in QuickBooks Online requires creating designated accounts, service items, and classes.

1. Create the CAM income account

1. Open the Chart of accounts and select New.
2. For Account type, choose Income, and for Detail type, choose Other Primary Income. Name it CAM Reimbursement Income and save.

2. Configure operating expense accounts

Create dedicated accounts under Account type: Expenses for each common area category, such as Landscaping & Snow Removal, Trash, Water & Sewer Utilities, Common Area Janitorial, Parking Lot & Exterior Lighting, Common Area Repairs, and Property Management Fees.

3. Set up Products and Services items

1. Open Products and services and select New > Service.
2. Name the item CAM Estimate and map the Income account to CAM Reimbursement Income.
3. Create a second service item named CAM True-Up, also mapped to CAM Reimbursement Income.

Use CAM Estimate for recurring monthly invoice charges, and CAM True-Up for year-end true-up invoices and credit memos.

4. Assign classes and customers

Set up each tenant as a Customer and, where the owner holds more than one building, each property as a Class (classes need QuickBooks Online Plus or Advanced). Tagging both on every transaction gives a Profit and Loss by Class for each building’s actual costs and a Sales by Product/Service Detail report for CAM billed to each tenant, as outlined in our guide on commercial bookkeeping for real estate.

Three CAM reconciliation mistakes in inherited files

1. Lumping CAM estimates into base rent. Categorizing tenant payments to Commercial Lease Revenue leaves no record of estimates collected, forcing manual review of past invoices.
2. Netting expenses against reimbursement income. Booking vendor bills to CAM Reimbursement Income leaves profit unchanged but removes both inputs to the reconciliation: the profit and loss no longer shows what the building cost or what tenants paid toward it.
3. Commingling capital improvements into operating expenses. Booking structural roof or lot replacements as routine maintenance inflates CAM pools and invites tenant disputes. Capital improvements belong on the balance sheet, while tenant deposits stay in escrow as detailed in our guide on security deposit accounting.

When CAM expenses are commingled with owner personal spending or unclassified repairs, sorting them out means auditing general ledger detail and rebuilding expense pools before billing tenants. That is cleanup work, priced on the months the file needs:

$99per month of backlog20% off 6+ months

When to hand this off: if CAM expenses were commingled with owner personal expenses or general repairs across multiple years without property and tenant tracking, recalculating tenant shares means rebuilding historical expense pools. A free file review identifies whether your property ledgers support an immediate reconciliation or need historical ledger cleanup first.

Once historical ledgers are resolved, our monthly bookkeeping service keeps property schedules reconciled so year-end true-ups run straight from general ledger reports. At tax time, CAM reimbursements are rental income and the costs are rental expenses: a partnership or S corporation landlord reports them on Form 8825, and an individual or a single-member LLC taxed as a disregarded entity on Schedule E (Form 1040).