QuickBooks for Commercial Property Management: A Practical Setup Guide

1. Start with a chart of accounts built for CAM and percentage rent, not one "Rental Income" line

A single-family rental has one number: rent. A commercial lease usually has at least two — base rent and a reimbursement for shared operating costs — and sometimes a third, percentage rent tied to a tenant's sales. If your chart of accounts collapses all of it into one "Rental Income" account because that's what the QuickBooks quick-start wizard suggests, you're choosing to reconstruct the split later instead of capturing it now.

Take a realistic case: a 20,000-square-foot, 4-tenant strip center with a single CAM pool. Base rent ranges from $14 to $18 per square foot depending on the tenant, and the CAM pool — property tax, insurance, common-area maintenance and landscaping, common-area utilities, and a management fee — runs $90,000 a year, billed pro-rata by square footage. That's roughly $326,000 in annual base rent and $90,000 in annual CAM reimbursement moving through the same set of tenant invoices every month. If both post to one income account, the $90,000 is in there somewhere, but pulling it back out at year-end means re-opening every invoice line for twelve months across four tenants.

• Create "Base Rent" and "CAM Reimbursement" as two separate income accounts (or two Items that each post to their own account) from the day you open the file
• Add a "Percentage Rent" income account if any lease has a percentage-rent clause, even before a tenant crosses their sales breakpoint, so the account exists when the first overage payment arrives
• Mirror the split on the expense side: give CAM-eligible costs — property tax, insurance, common-area maintenance, common-area utilities — accounts that map cleanly to how the lease defines the CAM pool
• Keep tenant improvement allowances and security deposits in accounts of their own; neither is rental income, and both get miscoded as revenue in setups carried over from a residential template

2. Decide tracking mode — Class or Location — before you create a single account

Once income is split by type, the next decision is how you'll separate transactions by property. QuickBooks gives you two overlapping tools for this, Class and Location, and picking one deliberately up front matters more than either choice on its own — changing it after a year of transactions means re-tagging history, not flipping a setting. The short version worth acting on here: use Location for the property itself, since it's the one dimension that applies consistently across every transaction type, and reserve Class for whatever varies within a property, like expense category. For the full reasoning, including the QuickBooks transaction types where this actually matters, see the Classes vs. Locations guide — that decision isn't re-derived here.

This decision has a hard ceiling worth knowing before you commit to a scheme: QuickBooks Plus caps combined Class + Location tags at 40. A dozen properties, each with a small per-property Class breakdown, reaches that number faster than it sounds — plan the tagging scheme against your actual property count, not just today's portfolio.

• Use Location for the property; it's the one dimension that behaves consistently across invoices, payments, and expense transactions
• Reserve Class for something that varies within a property, like expense category or CAM-eligible vs. non-CAM
• QuickBooks Plus caps combined Class + Location tags at 40 — check this against your property count and any per-property Class breakdown before you finalize the scheme
• Treat this as a one-time structural decision, not a setting you'll casually revisit six months in

3. Set up Items, not just accounts, for anything that lands on a tenant invoice

An account is where a dollar amount ends up on the P&L. An Item is what actually appears on an invoice line — QuickBooks invoice lines reference an Item, never a bare account directly. If you're billing tenants by hand inside QuickBooks, that means a distinct Item for each charge type, pointed at the right account, before you can put it on a tenant invoice — one of the more common things a commercial setup gets wrong when it's built off a residential template, where "Rent" as a single item was enough. If you connect TenantPoint instead, you don't have to set this up yourself: TenantPoint creates the QuickBooks Item it needs from the income account you've already mapped, the first time it pushes an invoice that needs it.

• Create a distinct Item for every charge type that appears on a tenant invoice — Base Rent, CAM Reimbursement, Percentage Rent, Late Fee, Utility Reimbursement — not just an income account for each
• Point every Item at the income account it should post to; the Item is what the tenant sees on the invoice, the account is where it lands on your books
• Name items the way a tenant will read them on an invoice, not the internal shorthand you'd use in a spreadsheet
• Add a separate item for one-time charges — a tenant improvement buy-out, a lease termination fee — so they don't get folded into a recurring rent item and distort next year's base-rent trend

4. Build the vendor list around how commercial expenses actually flow

A commercial vendor list looks different from a residential one for two reasons: CAM-eligible costs need to be traceable straight back to the pool you're billing tenants against, and a meaningful share of your vendors are tied to a specific work order rather than a flat monthly bill.

• Tag CAM-eligible vendors — landscaping, snow removal, common-area utilities, the tax authority, the insurance carrier — clearly at setup, not while assembling the year-end reconciliation
• Separate vendors who invoice the property for common-area work from vendors who invoice an individual tenant directly for tenant-specific work
• Capture 1099 eligibility on the vendor record when you create it, not at tax time
• Create a vendor record even for a one-time contractor; an unmapped vendor is one of the most common things that stalls an automated bookkeeping sync once you connect one

5. Where TenantPoint's setup wizard picks up once you're ready to connect

TenantPoint connects to an existing QuickBooks Online account via OAuth — it doesn't create or replace your QuickBooks file. You don't have to pre-build everything from the sections above first, either: the mapping wizard lets you create a new Class, Location, income or expense account, tenant, or vendor inline as you map, and TenantPoint creates the QuickBooks Item it needs on its own. Setting up the chart of accounts in Section 1 ahead of time still gets your books organized the way you want rather than however the wizard's inline creation defaults them, which is why it's worth doing deliberately rather than skipping straight to the wizard. From there, a one-time setup wizard walks through six decisions in this order: tracking mode (Class, Location, or none — the same decision as Section 2, with the same 40-tag warning), property mapping, income and expense category mapping, tenant mapping, vendor mapping, and sync policy (deposit account and invoice cadence). Where a match is ambiguous — an unmapped vendor, a category you haven't mapped yet, a work order tied to more than one vendor — it's held for a person to resolve rather than guessed at.

What actually moves is one-directional and limited to three things: a generated rent/CAM invoice pushes to QuickBooks as an Invoice, a confirmed payment pushes as a Payment applied against that invoice, and a reconciled, work-order-linked bank expense pushes as a Purchase, not a Bill — because the only trigger for that push is a bank transaction someone has already manually reconciled and tagged to a work order, not an unpaid bill sitting in AP. If an accountant later edits one of these directly in QuickBooks, that edit is detected and flagged as a conflict for a person to accept or ignore — it's never silently overwritten. The Location-for-property, Class-for-category convention from Section 2 carries through here too, including on work-order expenses. Bank connectivity is a separate, already-live feature: an owner connects a real bank account once from the Banking screen, transactions sync in automatically, and TenantPoint matches them to tenants, vendors, work orders, and CAM eligibility — no invoice or payment sync required to use it.

• Wizard order: tracking mode → property mapping → income/expense category mapping → tenant mapping → vendor mapping → sync policy — and it only goes smoothly if the chart of accounts, items, and vendors above are already in place
• Every push is one-directional, TenantPoint to QuickBooks: generated invoices, confirmed payments, and reconciled work-order expenses only
• An ambiguous match — unmapped vendor, unmapped category, a work order billed to more than one vendor — is held for a human decision, never guessed
• An accountant's edit made directly in QuickBooks is flagged as a conflict, with only two resolutions available: accept QuickBooks' value or ignore it — nothing pushes TenantPoint's number back over it
• Bank connectivity via Plaid is separate from the QuickBooks sync, already live, and read-only

6. Close the loop: reconcile what you billed against what actually posted

The entire point of separating Base Rent from CAM Reimbursement, and tagging CAM-eligible vendors on the way in, is to make the year-end CAM true-up a report you can run, not a project you have to reconstruct. Back to the strip center: across the year, the CAM Reimbursement income account should show the full $90,000 billed. If actual CAM-eligible expenses — already isolated in their own accounts — came in at $84,200 instead, that's a $5,800 credit owed back to the four tenants, split the same pro-rata way the CAM pool was billed. If actual expenses had come in higher, it's an additional invoice instead. Either way, the number is a subtraction between two account totals, not a re-read of a year of invoices.

Keep percentage rent completely separate from this true-up. It's driven by a different lease clause — tenant sales crossing a breakpoint — and mixing its math into the CAM variance is a fast way to misstate both.

• Run a P&L filtered to the CAM Reimbursement income account and a second one filtered to your CAM-eligible expense accounts, same period, and compare the totals
• A variance becomes the true-up directly: a credit back to tenants if you billed more CAM than you spent, an additional invoice if you spent more than you billed
• Keep percentage rent calculations out of the CAM variance entirely — different clause, different math
• This is the exact reconciliation the CAM Reconciliation guide walks through in full — the chart of accounts and items built in this guide are what make that process a clean pull instead of a rebuild