Can you run a CAM reconciliation in QuickBooks Online?

Partly, and the part it does is the part that matters most. A QuickBooks Online company file holds the actual operating expenses, and with classes or locations for the property and a chart of accounts laid out along the recoverable line, it produces the expense pool as a report. At the other end it can bill the result — an invoice per tenant for the true-up, a recurring invoice for next year’s estimates, a statement showing the balance. What it has no place for is everything between those two ends: there is no lease record, no field for a tenant’s share or base year or cap, no gross-up, no pro-rata engine and no memory of what last year’s cap ceiling was. As of October 2026, Intuit’s plan comparison and feature pages describe classes, locations, recurring transactions and customer statements, and say nothing about leases, CAM or property recovery, because the product is a general ledger and does not claim otherwise.

So the reconciliation itself — exclusions, gross-up, allocation, base year, cap, true-up — happens somewhere else: in a workbook, in a platform that replaces the ledger, or in a tool that reads the ledger and writes back to it. This post covers what the company file does well for a commercial owner, what people try to make it do that it strains at, and the division of labor between the books and the reconciliation that holds up over years and a change of staff. The setup post covers how to structure the file so that the pool is a report rather than a project.

What the platform does well for a commercial owner

Four things, each of which a reconciliation depends on and none of which a recovery tool should try to replace.

Profit and loss by class or by location. With a class or a location per property, the Profit and Loss by Class or by Location report, filtered to the operating expense range, is the gross pool. As of October 2026, Intuit’s plan comparison page states that tracked classes and locations are not available in Simple Start or Essentials, that Plus includes up to 40 combined tracked classes and locations, and that Advanced includes unlimited classes and locations; Intuit’s own help articles describe locations as a way to categorize data from different locations, offices, regions, outlets or departments, and classes as representing parts of the company such as departments or product lines. A property is a location in that sense, and a building or recovery group inside it is a class. Plans and limits change; check the current plan comparison on Intuit’s own site before building a structure that depends on the count.

Cash or accrual on the report. A base-year lease needs the base year and the comparison year on the same basis, and a report that can be run on either basis makes that a setting rather than a rebuild. A December utility bill paid in January is in the 2026 pool on accrual and in the 2027 pool on cash; the lease rarely says which, so the owner’s reporting basis usually decides, and consistency year to year is the whole requirement.

Bank feeds and the audit trail. Every transaction in the pool has a date, a vendor, a source document and a bank match. When a tenant’s auditor asks for the invoices behind 6300 Janitorial, they exist, and the amount on the statement ties to them.

Accountant access. Intuit’s plan page describes inviting accounting firms on every tier. The CPA who closes the year and prepares the return works in the same file the pool is pulled from, so the pool after close is the pool the return was built on.

What people try, and why each one strains

Every one of these appears in files that have been doing CAM for a few years, and each is an attempt to make the ledger hold a lease term it has no field for.

A sub-account per tenant under each expense account. 6300 Janitorial split into 6301 Brightleaf Yoga, 6302 Meridian Title and so on, with every janitorial invoice allocated at posting. This bakes a share into the books that the lease will compute differently once the gross-up, base year and cap apply — Brightleaf Yoga pays 8.00% of the grossed-up pool less its base year, not 8.00% of janitorial, and no sub-account can hold that. The books carry an allocation the reconciliation has to reverse.

Journal entries for estimates against the expense accounts. Monthly CAM estimates posted as a credit to expense, so the expense accounts show “net” recoverable cost. The pool is now understated by the estimates, which makes the true-up uncomputable from the report: $1,000,000 of expense less $10,800 of Brightleaf Yoga’s estimates, less the other five tenants’, is a number that means nothing to any lease. Estimates are income, in their own income account, and the pool is the gross expense.

Memorized reports as the allocation. A saved Profit and Loss by Class with a custom column per tenant, percentages typed into the column headers. It works for one year on one property with uniform leases and no caps. It cannot hold a base year, which is a prior year’s figure, or a cap, which depends on prior years’ ceilings; the first lease with either one moves the allocation into a workbook anyway.

Customers and sub-customers as properties. Harbor Point Plaza as a customer and the six tenants as sub-customers, so that a report by customer shows the property. The customer list is for who pays; a tenant’s invoice is then addressed to a building, and the receivable aging is by property rather than by tenant. Locations and classes exist for this and are the right tool.

Exporting the whole thing to a workbook. The honest one, and the usual one. The Profit and Loss Detail is exported, the exclusions are marked, the gross-up and shares are computed, and the true-ups are typed back into invoices. It works, and the spreadsheet template post sets out how to do it properly. The strain is in the two seams: the export is a snapshot, so a transaction reclassified after the export is in the books and not in the pool; and the invoices are typed, so the figure the tenant pays is traceable to the figure the workbook computed only by someone’s care.

Each workaround moves a reconciliation decision — which tenant, what share, what rule — into the bookkeeping, where it is made transaction by transaction under no rule the lease would recognize.

The division of labor that holds up

Books of record in the QuickBooks Online company file; lease terms and recovery rules in something built to hold them; results written back to the books as the tenant billings. The table is the whole argument.

The rows that say “company file” are the beginning and the end. Everything in between is the lease, and the lease has no home in a general ledger — which is no more a defect in the ledger than the absence of a bank feed is a defect in a lease abstract.

Harbor Point Plaza, split along that line

Run the dataset the rest of this site uses through the table. In the company file: the 2026 Profit and Loss Detail for the Harbor Point location, operating range 6100–6999, accrual basis, totals $1,240,000. That is the file’s whole contribution to the pool; had the roof been posted to 1540 Capital Improvements and the commissions and refinancing legal to the 7000 range, it would have been $1,000,000 with nothing to exclude.

In the reconciliation: $180,000 roof, $44,000 commissions and $16,000 refinancing legal marked excluded with reasons, pool $1,000,000; variable accounts $400,000 grossed up from 80% to 95% occupancy, $400,000 × (95 ÷ 80) = $475,000, fixed $600,000 unchanged, grossed-up pool $1,075,000.

On the lease record: Brightleaf Yoga, Suite 210, 8,000 RSF ÷ 100,000 RSF = 8.00%, base year 2023, base-year share $74,000, no cap, estimates $900 a month.

In the reconciliation again: $1,075,000 × 8.00% = $86,000; less $74,000 = $12,000; less $900 × 12 = $10,800; true-up $1,200.

Back in the company file: an invoice to Brightleaf Yoga for $1,200 to the CAM Recoveries income account, and, if the owner re-estimates on the actual, a recurring monthly invoice for 2027 at $12,000 ÷ 12 = $1,000, a scheduled template with no end date. The calculator runs the middle section on your own figures; the file supplies the first line and receives the last.

What writes back, and what should not

The results that belong in the books are the tenant billings: the true-up invoice or credit memo, and the next year’s estimate schedule, in the income account where the estimates already are, against the tenant as customer. Nothing else from the reconciliation belongs in the ledger. The pool, the exclusion reasons, the gross-up working, the shares and the cap history are the reconciliation’s records, and posting them as journal entries or memos puts lease decisions into the books where the next bookkeeper will take them for facts.

That is the shape of the integration Ledgerstone runs: it reads actual expenses from QuickBooks Online rather than re-keying them, scoped by class, location and account; holds the recovery rules — caps, base years, gross-ups, exclusions, recovery groups — on the lease; shows the derivation behind every figure and seals the period; and writes the CAM recovery results back to QuickBooks Online as the billings. The integration page lists exactly what is read and what is written, and the file stays a set of books.

FAQ

Can a QuickBooks Online company file track CAM charges?

A company file can hold the charges as invoices to tenants, in an income account for CAM recoveries, and can report what was billed and collected per tenant. It cannot compute the charges: there is no field for a tenant’s share, base year, cap or gross-up, so the amount on each invoice is calculated elsewhere and entered or written back.

Can I bill CAM estimates from QuickBooks Online?

Yes. Intuit’s help article on recurring transactions describes scheduled templates that create invoices at a set interval with an optional end date and can email them automatically, which is exactly a monthly estimate. Set one per tenant, to the CAM recoveries income account, and change the amount when the reconciliation re-estimates for the new year.

Can I send tenants a CAM statement from QuickBooks Online?

A customer statement — balance forward, open item or transaction statement, in Intuit’s terms — shows what was invoiced, paid and owed: the $1,200, not how it was reached. The derivation the tenant will ask for comes from the reconciliation, and the sample statement shows what that looks like.

Do I need to leave QuickBooks Online to do CAM reconciliation?

No. The pool comes from the file and the billings go back to it; the reconciliation in between can be a workbook or a tool that reads the file. Leaving the ledger is a choice some owners make for other reasons — a mixed residential portfolio, in-house accounting across many entities — and the comparison of AppFolio and Yardi Breeze is about that choice. CAM on its own does not require it.

What about QuickBooks Desktop?

As of October 2026, Intuit’s own pages state that after September 30, 2024 it stopped selling new U.S. subscriptions to QuickBooks Desktop Pro Plus, Premier Plus, Mac Plus and Enhanced Payroll, that existing subscribers can continue to renew, and that QuickBooks Desktop Enterprise continues to be sold. The class and customer:job patterns many commercial owners built on QuickBooks Desktop have location and class tracking as their counterpart in a QuickBooks Online company file. Check Intuit’s current notice on Desktop subscriptions for the present position before planning around either product.

Which QuickBooks Online plan do I need?

One with class or location tracking, which as of October 2026 Intuit’s plan comparison places at Plus and above, with a combined limit of 40 tracked classes and locations on Plus and no limit on Advanced. A single property is well inside the Plus limit; a portfolio with a class per building and per recovery group may not be.

What makes the next one easier

Draw the line once and keep to it. The file answers two questions — which property, and which account — and the chart of accounts puts every account on one side of the recoverable line, so the pool is a filtered report and not a judgement. The lease record holds everything the lease decides; the reconciliation applies it and keeps its own working; the billings go back. The annual reconciliation then starts from a report that already ties to the return and ends in invoices that already tie to the reconciliation, with nothing typed twice in between.

Related reading

• A QuickBooks Online setup for CAM recovery — entities, classes and locations, and the chart of accounts that makes the pool a report.
• The accounting integration — what is read from the file and what is written back.
• CAM reconciliation spreadsheet template: where it breaks — the middle section, done by hand.
• What a CAM reconciliation actually involves — the five steps, with the same worked example.