A QuickBooks Online setup for CAM recovery

A CAM reconciliation can be pulled from the books or rebuilt from them. Which one you get is decided months before year end, by three structural choices in the QuickBooks Online company file: how properties are separated from each other, how operating expense accounts are laid out against the recoverable and non-recoverable line, and where capital, leasing and ownership costs are posted so that they never enter the operating pool in the first place. Get those three right and the reconciliation starts from a report. Get them wrong and it starts from a spreadsheet of somebody’s corrections to a report.

The short version. Keep one company file per legal entity, not per property. Inside the file, separate properties with the location or class feature — which one depends on whether a single bill ever spans two properties — and note that, as of October 2026, Intuit’s own plan pages say class and location tracking are available only on the Plus and Advanced subscriptions. Lay out the operating expense accounts so each account is either recoverable or not, never a mixture. Post capital to a fixed-asset account, leasing commissions and the owner’s own legal and financing costs to accounts outside the operating range, and tenant estimate billings to income, never as a reduction of expense. Then the Profit and Loss Detail report for the property, filtered to the operating range and run on the basis the lease requires, is the expense pool — before exclusions, but with the exclusions already visible as whole accounts rather than hidden inside them.

One company file, or one per entity

The question is usually asked as “one file or one per property”, and that framing is what causes the trouble. The right boundary is the legal entity: each entity that files its own tax return, holds its own bank account and signs its own leases gets its own company file, because the balance sheet and the bank feed reconcile per entity. A property is not an entity; it is a segment of one.

So an owner with three buildings in one LLC runs one file with three segments inside it. An owner with three buildings in three LLCs runs three files, each with one segment, and accepts that a vendor who services all three buildings on one invoice has to be split across three files — a genuine cost of the structure, not a bookkeeping failure. An owner with a management company and several owning entities runs a file for each, and the management company bills the owning entities for its fee, which lands in each owning entity’s 6900 Management Fees and is recoverable there. Everything in one file for convenience shows up later as intercompany balances nobody can explain and a pool that includes another entity’s roof; one entity split across several files shows up as a balance sheet that only balances when the files are added together.

Properties as locations or classes

Within one company file, there are two built-in ways to tag a transaction with the property it belongs to, and they behave differently. Location tracking assigns one location to an entire transaction. Class tracking assigns a class to each line of a transaction, so a single bill can carry lines for several classes. Both produce a Profit and Loss report filtered to one value — Profit and Loss by Class and Profit and Loss by Location — which is what the reconciliation needs.

The practical rule follows from the difference. If every bill in the file belongs wholly to one property, locations are the simpler choice: one field per transaction, and the report by location is clean. If bills routinely span properties — one landscaping contract for a campus of three buildings, one insurance policy across a portfolio, one management fee invoice — then the split has to happen at the line level, and that means classes. Many owners use both: location for the property, class for a finer segment inside it such as a building or a recovery group. There is no industry convention here; the invoice pattern decides, and the only real mistake is using neither and relying on the memo field.

Which subscription you need is not a detail. As of October 2026, Intuit’s plan comparison page states that tracked classes and locations are not available in Simple Start or Essentials, that the Plus subscription includes up to 40 combined tracked classes and locations, and that the Advanced subscription includes unlimited classes and locations. Intuit’s usage-limits article says the same and adds that the chart of accounts is capped at 250 accounts on every tier below Advanced. For a single property with a handful of segments the Plus limit is not a constraint; for a portfolio with a class per building and per recovery group it can be, and the ceiling is the combined count. Plans and limits change; check the current plan comparison and the usage-limits article on Intuit’s own site before committing to a structure that depends on the count.

Whatever you choose, review the “Not Specified” column on the property report monthly, because every dollar in it is a dollar the reconciliation will have to chase.

The chart of accounts

The operating expense accounts are where the recoverable line is drawn, and the principle is that each account falls wholly on one side of it. If an account can hold both recoverable and non-recoverable spending, the reconciliation has to open every transaction in it to sort them, and that sorting is redone — and re-argued — every year. The fix is to split the account, not to annotate the transactions.

The Harbor Point Plaza chart of accounts, which the rest of the site uses, is laid out this way.

Three things about this layout are doing the work. The recoverable operating accounts sit in one contiguous range, 6100 to 6999, so the pool can be pulled by filtering the report to that range, and the non-recoverable costs that are still operating in nature — leasing commissions, the owner’s professional fees — sit in a separate 7000 range, on the same Profit and Loss report but outside the filter.

Capital is not an expense account at all. A roof replacement posted to 1540 Capital Improvements sits on the balance sheet and never reaches the operating pool unless the lease allows capital items to be amortized in, in which case the amortization is a calculated line, not a posted one. In the Harbor Point example the roof replacement for Building A was posted to 6800 Repairs & Maintenance, which is why the reconciliation had to find it and exclude $180,000 as the first step. Posted to 1540, that step disappears, and the gross pool on the report is $1,060,000 rather than $1,240,000 before anyone opens a transaction.

The accounts that most need splitting are the ones with mixed use. 7200 Professional Fees holds the owner’s refinancing legal, $16,000, which is not recoverable, but many leases allow the legal cost of contesting the property tax assessment to be recovered. If both kinds land in one account, it is a mixed account; give the recoverable kind its own number in the 6000s. The same applies to repairs versus capital in 6800: the test is the lease’s definition of capital, often a useful-life or dollar threshold, and the bookkeeper needs that definition in writing before posting, not the controller at year end.

The report that is the pool

Once properties are segmented and accounts are laid out, the expense pool is a report: the Profit and Loss Detail for the period, filtered to the property’s location or class and to the recoverable account range. Every transaction in it is a line in the pool; every account subtotal is a line on the statement.

The accounting basis has to match what the lease says, and most leases say nothing, so the usual answer is the basis the owner reports on. Reports in QuickBooks Online software can be switched between cash and accrual on the report itself, independently of the company default. The choice matters at the edges of the year: a December utility bill received in January is in the 2026 pool on accrual basis and in the 2027 pool on cash basis. Either is defensible if it is consistent from year to year and the base year was built the same way; switching basis between a base year and a comparison year is the same error as grossing up one and not the other, with the same compounding effect.

What not to do

Three structures appear often enough to name, and each one makes the reconciliation harder than the file it replaced.

• A sub-account per tenant under each expense account. The expense is the property’s, not the tenant’s. Splitting 6300 Janitorial into six tenant sub-accounts means allocating every invoice at posting time, by a share that the lease will calculate differently anyway once caps and base years apply. The books end up carrying an allocation that the reconciliation has to undo.
• Tenant estimates booked against expense accounts. Monthly CAM estimates are income — a separate income account, such as CAM Recoveries, kept apart from base rent. Netting them against expense understates the pool and makes the true-up uncomputable from the books, because the amount billed is no longer visible anywhere.
• Customers and sub-customers as properties. The customer list is for tenants, which is who pays. Using a customer or sub-customer, or a project, to represent a property breaks the receivable: the tenant’s invoices are then addressed to a building. The QuickBooks Desktop customer:job pattern that this imitates has location and class tracking as its proper replacement.

The common thread is that each of these pushes a reconciliation decision into the bookkeeping, where it is made transaction by transaction under no particular rule. The structure that works keeps the bookkeeping to the question of which property and which account, and leaves tenant shares to the reconciliation.

Harbor Point Plaza, worked through the file

Take the dataset the rest of this site uses: 100,000 rentable square feet, six tenants, 80% occupied through 2026. The 2026 Profit and Loss Detail for the Harbor Point location, filtered to the 6000 range and run on accrual basis, totals $1,240,000 in the file as it was originally kept, because the roof was in 6800 and the 7000 range did not yet exist — commissions and the owner’s legal were sitting in a single 6950 Legal & Professional account inside the operating range. The reconciliation then applies the exclusions from the leases.

In the corrected file the same pull is $1,000,000 before anyone does anything, because the roof is on the balance sheet and the 7000 range is outside the filter. From there the gross-up follows: the variable accounts, 6100 Utilities and 6300 Janitorial, total $400,000, and at 80% actual occupancy grossed up to 95% that is $400,000 × (95 ÷ 80) = $475,000; the fixed accounts, $600,000, are unchanged; grossed-up pool $1,075,000. Brightleaf Yoga in Suite 210, 8,000 RSF, 8.00%: $86,000 gross share, less the 2023 base-year share of $74,000, recoverable $12,000, less estimates billed at $900 × 12 = $10,800, true-up owed $1,200. The whole chain is laid out in what a CAM reconciliation actually involves, and the calculator runs it on your own figures.

The point of the example is which parts of that chain are bookkeeping and which are reconciliation. The $1,000,000 falls out of the file if the file is structured correctly. Everything after it — the variable and fixed split, the gross-up, the share, the base year, the true-up — is a rule on a lease applied to the pool, and none of it belongs in the chart of accounts.

What a tool reads from this, and what it leaves alone

A reconciliation tool built on this structure needs nothing the file does not already contain. Ledgerstone reads actual expenses from QuickBooks Online rather than re-keying them, and scopes recoverable expenses by class, location and account — exactly the choices above: the location or class that identifies the property, and the account range that identifies the pool. The recovery rules — caps, base years, gross-ups, exclusions, recovery groups — live on the lease, not in the chart of accounts, so the file stays a set of books rather than becoming a set of lease terms.

What it leaves alone is the bookkeeping. It does not post, reclassify or split transactions; a roof in 6800 is still a roof in 6800, flagged for exclusion, until the bookkeeper moves it. At the end it writes the CAM recovery results back to QuickBooks Online as the tenant billings, in the income account where the estimates already are.

What makes the next one easier

The three structural choices are made once. A property added next year gets a location or class; a new expense type gets an account on the correct side of the recoverable line; a capital project goes to 1540 on the day the invoice arrives. The one habit worth keeping is the month-end look at the “Not Specified” column and the 6800 account, which are the two places the pool goes wrong quietly; thirty minutes a month there is cheaper than a day of sorting in March.

Related reading

• What a CAM reconciliation actually involves — the sequence this file structure feeds, with the same worked example.
• The CAM reconciliation checklist — the dated steps from year-end close to statements sent.
• Gross-up clauses, explained with the arithmetic — why the variable and fixed split in the chart of accounts matters.
• The accounting integration — what is read from the file and what is written back.