Should multi-location clients use a single rent expense account or separate accounts by location?

A single parent rent expense account split by class or location dimension. Separate accounts for each location bloat the chart of accounts and make consolidated reporting harder. Most modern accounting platforms support a location dimension that lets the firm filter the same account across locations. Use the dimension; keep the account count low.

How do you separate base rent from CAM, taxes, and insurance pass-throughs in coding?

Two parent accounts work for most clients: base rent and operating expense pass-through. Base rent holds the contractually fixed monthly amount. Operating expense pass-through holds CAM, taxes, insurance, and any other variable lease charges. This separation makes year-over-year analysis cleaner and isolates the variable charges that are most likely to need review.

What about percentage rent and reconciliation true-ups across multiple locations?

Percentage rent gets its own sub-account under base rent because it is contractually defined and tied to sales. CAM true-ups flow through the operating expense pass-through account in the period they relate to. Both should be coded by location dimension so the management report can show occupancy cost by location accurately.

How do you handle a CAM red flag when it appears on only one location's bill?

Same escalation as a single-location client. Code the bill by location, preserve the document, and flag the location where the issue appeared. The flag does not migrate across locations because each location has its own lease. The firm's consolidated review can compare patterns across locations and identify systematic landlord issues if one landlord controls multiple locations.

When does multi-location occupancy coding warrant a fractional CFO or controller engagement?

When the client operates from four or more locations, has more than $400,000 in annual occupancy expense, or has experienced two or more landlord billing disputes in the prior 24 months. At that point, the bookkeeping volume and the contract complexity exceed what a recurring monthly engagement typically covers, and a fractional controller engagement adds clean structure.

Multi-Location Clients: How to Keep Occupancy Coding Consistent

The client opens a fourth location, and the chart of accounts that used to fit on one screen now reads like a phone book. Three different landlords, three different lease structures, four different CAM reconciliation seasons. The bookkeeper opens the GL in March and tries to remember which CAM bill belongs to which location, and which one had the management fee question last year.

The fix is not memory. The fix is a coding structure that makes the location obvious from the entry, the lease type obvious from the account, and the variable charges obvious from the parent. Once the structure is right, the volume scales without the chaos.

Occupancy expense: The total cost of occupying a leased commercial space, including base rent, CAM (common area maintenance), real estate tax pass-throughs, insurance pass-throughs, percentage rent if applicable, and any other lease-defined charges. For multi-location tenants, occupancy expense is reported by location for management reporting and aggregated for financial reporting.

The chart-of-accounts structure that scales

Three principles drive a clean multi-location occupancy chart of accounts.

Use the location dimension, not the account. Modern platforms (QuickBooks Online, Xero, NetSuite, Sage Intacct) support a location or class dimension. Set the location dimension on every occupancy entry and use the same parent account across locations. A single rent expense account filtered by location produces cleaner reports than fifteen rent accounts named "Rent: Atlanta," "Rent: Dallas," and so on.

Separate base rent from variable pass-throughs. Base rent is a fixed contractual obligation. CAM, taxes, and insurance are variable and tied to landlord billing. The two behave differently and should code differently. Two parent accounts: rent expense and operating expense pass-through. Sub-account or class out from there if needed for management reporting.

Hold reconciliation true-ups in the period they relate to. When a CAM true-up arrives in March 2026 for the 2025 lease year, the location dimension is the 2025 location and the period treatment follows the prepaid rent vs. accrual decision tree. The location and period are independent; do not let the invoice month override the period the bill covers.

A working chart for a five-location retail client looks like this:

Account	Dimension	Use
Rent expense: base	Location	Monthly contractual base rent
Rent expense: percentage	Location	Sales-based percentage rent if applicable
Operating expense: CAM estimates	Location	Monthly CAM estimates as paid
Operating expense: CAM true-up	Location	Annual CAM reconciliation amounts
Operating expense: RE tax pass-through	Location	Property tax pass-throughs
Operating expense: insurance pass-through	Location	Insurance pass-throughs
Operating expense: other lease charges	Location	Anything else the lease authorizes

Seven accounts, five location dimensions, 35 effective coding combinations. Cleaner than fifty accounts, and the management report can pivot by location or by charge type without rebuilding the chart.

How the AP team handles a multi-location landlord bill

A landlord who manages three of the client''s five locations issues bills monthly. Some bills are combined invoices covering multiple locations; some are per-location invoices.

For combined invoices, the AP team enters one bill with multiple lines, each line tagged to the appropriate location dimension. This preserves the AP audit trail and produces clean per-location reporting. For per-location invoices, the entire bill goes to one location.

Three habits make this easy:

Standard invoice memo format. Every occupancy bill memo follows the same template: location, lease year if reconciliation, brief description. "Atlanta: 2025 CAM true-up" or "Dallas: May 2026 base rent." Six months later when someone is reviewing the GL, the memo tells the story.

Standard vendor naming. If the same property management company manages multiple locations, the AP vendor record is the property management company, not the location. The location dimension carries the location detail. This avoids vendor record bloat.

Reconciliation tracking by location. Maintain a simple workpaper with one row per location and one column per reconciliation year. Date received, amount, period covered, flags raised, status. This is a 10-row spreadsheet for a 10-location client and it eliminates the "did we ever review the 2024 reconciliation for the Phoenix location" question that always comes up at year-end.

"Multi-location coding is not harder than single-location coding once the structure is set. It is just more entries against the same structure. The mistake is letting each location''s coding evolve independently until five locations have five different ways of representing the same charge type." — Angel Campa, Founder, CAMAudit

When a CAM red flag shows up at one location

A multi-location client with five different leases will get five different CAM patterns. A red flag at the Houston location does not implicate the Boston location. The flag is location-specific because the lease is location-specific.

The escalation is the same as for a single-location client: code the bill, preserve the document, escalate the flag. The location dimension makes the escalation more legible because the controller or specialist sees exactly which lease and which location are at issue.

What multi-location clients add is the ability to spot patterns across locations. Two situations are worth watching.

Same landlord across multiple locations. If one property management company controls three of the client''s five locations and a methodology issue appears at one (for example, a management fee computed on gross rather than net), check the other two. The same property manager often applies the same methodology across the portfolio they manage. CAMAudit''s detection runs on each reconciliation independently; the firm''s aggregation step looks for the cross-location pattern.

Same property type across multiple locations. If two locations are in similar shopping centers and one shows a 14 percent year-over-year CAM increase while the other shows 4 percent, the variance is worth a question. The locations are independent, but the comparable benchmark is informative.

These cross-location reviews are firm-level work, not bookkeeping work. They sit with the controller or partner and benefit from a quarterly review cadence rather than every-month review.

Reporting that the client actually uses

Multi-location clients want to see occupancy cost three ways:

Per location, by month. For operations management. Which locations are running over budget on rent and CAM, by month.

Per location, year-over-year. For real estate strategy. Which locations are getting more expensive faster than the others.

Total, by charge type. For category management. Are CAM costs growing faster than base rent across the portfolio.

The chart structure above produces all three reports without custom mapping. The location dimension drives reports one and two; the parent account structure drives report three. A 15-minute dashboard build at the start of the engagement pays for itself across every monthly close.

For clients who want it, occupancy cost as a percentage of revenue is the higher-level metric. That requires linking the location dimension to revenue tracking, which most retail and service-business platforms support natively.

When the engagement scope expands

A few signs that a multi-location occupancy engagement has outgrown standard bookkeeping scope.

The client has four or more locations and routinely sees one or two CAM red flags per reconciliation cycle. The firm is doing 90 minutes per cycle of escalation work that does not bill cleanly.

The client is opening locations faster than the firm can onboard new leases into the coding structure. New leases land in the GL without abstracts, and the coding gets ad hoc.

Two or more landlord billing disputes have happened in the past 24 months and the client wants more proactive review.

At that point, three options open up:

Fractional controller engagement. The firm adds a controller-level layer that owns the occupancy review across all locations and serves as the escalation point for the bookkeeping team.

CAM-specific advisory engagement. A separate, scoped advisory engagement specifically for lease compliance review, billed quarterly or per-reconciliation, with CAMAudit running the systematic detection.

External CAM specialist referral. For high-volume or high-complexity disputes, refer the work to a specialist with deeper CRE expertise and let the firm focus on bookkeeping.

The right answer depends on the firm''s capabilities and the client''s appetite for fee. The structural answer is the same: multi-location occupancy coding deserves more attention than the chart of accounts default suggests, and the firm that builds the structure early scales the relationship without burning out the close team.

Multi-location clients are some of the highest-value engagements an accounting firm carries. The coding structure is what makes them sustainable.

Multi-Location Clients: How to Keep Occupancy Coding Consistent