Consolidation is not addition. It is standardization, then elimination, then addition, in that order. Skip the first two and the total you get is a number nobody can defend or drill into.
Every multi-location owner eventually asks for one P&L that shows the whole group. The naive version, summing whatever each location's books produce, generates a number that looks authoritative and survives about three questions before it falls apart: why is Shop 4's payroll in a different section, what happened to the management fee that shows up as income at the parent and expense at every shop, and why does the group total change depending on who assembled it?
The fix is a process. Here it is, in the order that matters. We have written separately about why the manual version of this breaks down after a handful of shops; this piece is about doing the job correctly, whoever or whatever does the labor.
Consolidation dies at the account level. If Shop 1 books shop supplies under "Supplies," Shop 2 under "Shop Expense," and Shop 3 splits them between parts cost and a miscellaneous line, then no report downstream can compare the locations, no matter how carefully it is assembled. Before anything else, define one chart of accounts for the group, with the parts and labor split a shop P&L needs (the structure we laid out in how to read an auto repair shop P&L), and map every location's books onto it. This is the highest-effort step and the highest-value one, and it is a one-time cost: once the mapping exists, every future month reuses it.
A consolidated statement is only meaningful if every column covers the same days. Set one monthly close deadline for all locations: all repair orders posted, parts invoices entered, payroll allocated, and adjustments booked by the same date. A group where Shop 2 closes crisply in five days and Shop 6 straggles in three weeks later does not have a consolidation problem, it has a close problem, and the consolidated view will always be as late as the slowest shop.
From each location's system of record, whether that is QuickBooks, Xero, or the reporting side of the shop management platform, produce the standard monthly P&L. Same period, same basis (accrual, ideally), every shop. Which system that data should come from, and why none of them hands you the cross-shop view on its own, is its own topic: QuickBooks or your shop management system.
Even with a shared chart of accounts, judgment calls drift: one bookkeeper capitalizes a compressor repair that another expenses, one shop books credit card fees against revenue while another shows them as an expense. Normalization is the pass where those differences get conformed to the group convention. Keep a short written list of the conventions; the document is what keeps the answers consistent when the person applying them changes.
This is the step that separates a real consolidation from a big addition problem. Any transaction between your own entities appears twice, once as revenue and once as expense, and must cancel at the group level:
Skip the eliminations and the group P&L overstates both revenue and expenses by the same amount. Net income survives, which is why the error goes unnoticed, but every ratio built on revenue, including gross margin and expense percentages, is quietly wrong.
Sum the normalized, eliminated statements into the group view, but keep each location as its own column. A single-column consolidated P&L answers exactly one question (how did the group do) and cannot answer the follow-up that always comes next (which shop drove it). The side-by-side layout is also where the management value lives: it is how you rank locations by what they keep, the exercise from which of your shops is actually most profitable.
Costs paid centrally, the owner's salary, group insurance, marketing, office staff, should be pushed down to locations on a simple, consistent basis such as revenue share. Otherwise every location looks more profitable than it is and the parent looks like a money pit. Keep the allocation as its own labeled line on each location's statement so a manager can see the split between costs they control and costs they carry. Consistency matters more than sophistication; a simple basis applied identically every month beats a clever one that gets renegotiated whenever a manager complains.
Steps 1 and 2 are one-time investments. Steps 3 through 7 recur every single month, forever, and each one is a place where a manual process can drop a number or apply a convention inconsistently. That recurring labor, not the concept, is what breaks by-hand consolidation as groups grow. The job belongs to software: a consolidation layer that holds the account mapping, applies the eliminations, and keeps the per-location columns current, sitting on top of whatever accounting and shop management systems each location already runs.
A group that has this working sees one consolidated P&L with a column per shop, on the same chart of accounts, for the same period, with intercompany noise removed and overhead visibly allocated, available days after month-end rather than weeks. That is the foundation everything else in this series stands on: per-location profitability ranking, budget vs actual by shop, and automated early-warning checks. It is also, specifically, what FinLoom's Multi-Shop tier stands up during onboarding: the mapping, the parent rollup, and the side-by-side view, built with you rather than left as homework.
FinLoom maintains one consolidated P&L across all your locations with per-shop drill-down, scoped manager logins, and weekly anomaly checks. Import from QuickBooks, Xero, or straight from Mitchell and Omnique. White-glove setup in 4 weeks.
Contact Sales