Just adding up each practice's numbers gives you a total that looks authoritative and falls apart under the first three questions. Real consolidation lines up the categories first, strips out the double-counting that happens between your own entities, and only then adds. Here is the process, in the order that matters.
Every group that grows past a couple of practices eventually asks for one P&L that shows the whole operation. The naive version, summing whatever each practice's books produce, generates a number that looks authoritative and survives about three questions before it falls apart: why is one location's staff cost in a different section than another's, what happened to the management fee that shows up as income at the parent entity and expense at every practice, and why does the group total change depending on who assembled it?
This gets harder, not easier, as a group acquires. Every acquired practice arrives with its own chart of accounts, its own bookkeeper, and its own conventions for supplies, lab fees, and associate compensation. The fix is a process. Here it is, in the order that matters.
Consolidation dies at the account level. If one practice books clinical supplies under "Supplies," a second under "Dental Supplies," and a third splits them between a cost-of-services line and a miscellaneous expense line, then no report downstream can compare the locations, no matter how carefully it is assembled. The same goes for lab fees, associate pay, and hygiene staff cost: decide once where each belongs. Before anything else, define one chart of accounts for the group and map every practice's books onto it. This is the highest-effort step and the highest-value one, and it is a one-time cost per practice: once the mapping exists, every future month reuses it, and every future acquisition gets mapped once on the way in.
A consolidated statement is only meaningful if every column covers the same days. Set one monthly close deadline for all locations: revenue posted, supply and lab invoices entered, payroll allocated, and adjustments booked by the same date. A group where one practice closes crisply in five days and another 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 practice.
From each practice's accounting system of record, whether that is QuickBooks, Xero, or the file your accountant maintains, produce the standard monthly P&L. Same period, same basis (accrual, ideally), every location. Note what this step does not involve: patient data. The rollup runs on practice-level financial statements, aggregate general-ledger numbers, not on patient-level production reports or claims data. Those stay in the practice management system, where they belong.
Even with a shared chart of accounts, judgment calls drift: one bookkeeper capitalizes an equipment repair that another expenses, one practice nets merchant processing fees against revenue while another shows them as an expense, one books associate compensation in cost of services and another in operating expenses. 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. Dental groups are usually structured as multiple entities, and 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. That matters doubly for a group that ever plans to show its financials to a lender or an acquirer, because those are exactly the ratios they read first.
Sum the normalized, eliminated statements into the group view, but keep each practice 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 practice 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 in which of your practices is actually most profitable.
Costs paid centrally, the group's leadership compensation, billing and administrative staff, marketing, and group insurance, should be pushed down to practices on a simple, consistent basis such as revenue share. Otherwise every practice looks more profitable than it is and the parent entity looks like a money pit. Keep the allocation as its own labeled line on each practice's statement so a practice 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 objects.
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, and it compounds with every acquisition. The job belongs to software: a consolidation layer that holds the account mapping, applies the eliminations, and keeps the per-practice columns current, sitting on top of whatever accounting each practice already runs and alongside whatever practice management system runs the operational side.
A group that has this working sees one consolidated P&L with a column per practice, 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 for everything downstream: per-practice profitability ranking, budget vs actual by practice, and forecasting. It is also, specifically, what FinLoom's multi-location tier for dental groups stands up during onboarding: the mapping, the parent rollup, and the side-by-side view, built with you rather than left as homework. And because the whole process runs on practice-level financial statements, no patient data is involved at any step: FinLoom does not ingest, store, or process patient data of any kind.
FinLoom maintains one consolidated P&L across all your practices with per-practice drill-down, budget vs actual, forecasting, and scoped practice logins. Reads practice-level financial statements only, never patient data. White-glove setup in 4 weeks.
Contact Sales