Multi entity accounting is one of those things that looks manageable on a spreadsheet until the month you realise it isn’t, and by then the close is already three weeks late. We see this constantly across growing healthcare groups. A practice that started with one location builds a perfectly reasonable Excel model to roll up two entities, then a third, then a fourth. Nobody questions it because it still technically works. Then it doesn’t. The consolidated P&L is wrong, nobody can agree on the numbers, and the physician-owners are asking questions nobody can answer cleanly. The spreadsheet didn’t fail because someone made a mistake. It failed because it was never designed to do what a multi-location healthcare group actually needs.
If your consolidation runs on a spreadsheet someone built a few years ago, this is worth reading before that model breaks on you.
What You’ll Learn
• Why spreadsheet consolidation breaks structurally as healthcare groups scale, and it is not a people problem
• What intercompany eliminations are and why skipping them produces a consolidated P&L that is wrong every single month
• What a chart of accounts standardisation process actually involves across multiple healthcare entities with different EINs
• What a properly structured multi-entity close process produces and what timeline it should run on
• How long it realistically takes to move from a manual Excel consolidation to a system-driven setup
Table of Contents
1. What Multi-Entity Accounting Actually Involves for a Healthcare Group
2. Why Does Spreadsheet Consolidation Break Down?
3. What a Properly Structured Multi-Entity Close Process Looks Like
4. The Healthcare-Specific Wrinkles Most Accounting Guides Skip Over
5. How Long Does the Fix Actually Take?
6. Questions Practice Administrators Ask About Multi-Entity Accounting
7. The Decision That Changes Everything
What Multi-Entity Accounting Actually Involves for a Healthcare Group
Multi-entity accounting is the process of maintaining separate financial records for each legal entity in a business structure, then producing a consolidated view that eliminates intercompany transactions so the numbers reflect what the group actually earned. For a healthcare group with multiple practice entities, a management company, and different EINs per site, that means two distinct outputs every month: accurate entity-level financials for each practice, and a consolidated rollup the owners or PE sponsor can actually use.
Multi-entity accounting for a healthcare group requires two outputs every month: accurate entity-level financials for each practice, and a consolidated view that eliminates intercompany transactions so the numbers reflect what the business actually earned.
This is structurally different from single-entity accounting. A single QuickBooks file was never designed to produce both of those outputs, and neither was the Excel workbook sitting on your administrator’s desktop. The volume of data isn’t really the issue. It’s the structure underneath it. Many of our clients come to us with setups cobbled together across multiple tools, multiple people, and multiple workarounds. The structure is the problem.
For a typical multi-location healthcare group, the accounting structure involves:
• Separate legal entities per site (PC, LLC, PLLC) with different EINs and sometimes different ownership splits
• A management company or holding entity that charges management fees to the practice entities
• Shared costs (physician contracts, staff, equipment) that need to be allocated across entities
• Intercompany transactions that must be eliminated before producing a consolidated P&L
• Both per-entity and consolidated reporting required every single month
Why Does Spreadsheet Consolidation Break Down?
There are three structural failure modes we see every time, and they compound each other.
Failure Mode 1: Chart of Accounts Inconsistency
When every entity uses different account names or numbering, monthly consolidation becomes a time consuming, manual mapping exercise. One entity codes physician compensation to “Provider Salaries.” Another uses “Clinical Labor.” A third has it split across two separate accounts. There is no apples-to-apples comparison, and the person doing the roll-up has to make judgment calls every single month about how to match the accounts. Those judgment calls are rarely the same twice.
When every entity uses a different chart of accounts, monthly consolidation becomes a manual mapping exercise that produces a different answer depending on who runs the numbers that week.
Chart of accounts standardisation means defining one account structure that every entity uses, with consistent naming, numbering, and categorisation. That process has to happen before consolidation becomes reliable.
Failure Mode 2: Intercompany Eliminations That Never Get Done
Intercompany eliminations remove transactions between entities within the same group so they don’t inflate the consolidated financials. A management fee paid from a practice entity to the management company is revenue to the management company and an expense to the practice. If that transaction isn’t eliminated before consolidation, the combined P&L overstates both revenue and expenses. The consolidated financials are wrong every single month, and they’re wrong in a way that can look reasonable if nobody is checking for it.
Most Excel-based consolidations skip this step entirely, or do it inconsistently. Intercompany eliminations in healthcare groups are particularly complex because they often involve:
• Management fees structured as a percentage of practice revenue
• Shared physician and staff costs allocated across entities
• Equipment leases between entities
• Intercompany loans or cash transfers between sites
Doing this correctly in a spreadsheet requires someone who knows what they’re looking for, building a model that tracks every intercompany transaction, and running the eliminations the same way every month without error. That’s a high bar to clear manually.
Failure Mode 3: The Single Point of Failure
Most manual consolidation processes are built entirely around one person: the administrator who built the model, or the bookkeeper who runs it every month. When that person is out, on vacation, or leaves the firm, the close either doesn’t happen or happens incorrectly. At LBMC W Squared we operate on a model of no single point of failure. With our fully outsourced accounting services your practice has the support of a full team of people, not just one person.
What a Properly Structured Multi-Entity Close Process Looks Like
A properly structured multi-entity close process produces two things on a reliable schedule: entity-level P&L reporting for each practice and a consolidated P&L with intercompany transactions eliminated. Both are ready by the 10th of the following month. That’s the standard.
Getting there requires four structural elements that a spreadsheet cannot reliably provide:
| Element | Spreadsheet Approach | System-Driven Approach |
| Chart of accounts | Each entity uses its own; manual mapping required | Standardised across all entities; no mapping needed |
| Intercompany eliminations | Manual; inconsistent; often skipped | Automated at the system level; runs every close |
| Entity-level P&L | Manually extracted from separate files | Native output; available on demand |
| Consolidated P&L | Manually built; unreliable | System-generated; intercompany already eliminated |
| Close timeline | 3 to 4 weeks; dependent on one person | On schedule; team-based; not a single point of failure |
Moving to a fully outsourced accounting department means the infrastructure behind each of those elements is already built. The chart of accounts is standardized on implementation. The intercompany eliminations are configured in the system. The close calendar is a fixed process the team runs every month, not a personal project someone picks up when they find the time.
The Healthcare-Specific Wrinkles Most Accounting Guides Skip Over
Most content about multi entity accounting is written for a general business audience. It explains the concept accurately, but it doesn’t cover what makes healthcare groups specifically harder to consolidate than a typical multi-entity holding structure.
A few things that don’t appear in those guides:
Management company structures. Many healthcare groups operate through a management company that provides administrative services to the practice entities and charges a management fee in return. That structure exists for good reasons, but it creates intercompany transactions that have to be tracked and eliminated every month. The management fee is recorded inside each entity. But it shouldn’t be reflected again in the consolidated view.
Mixed ownership splits. A physician group with five locations doesn’t always have identical ownership across every site. A founding physician might own 60% of locations one through three and 40% of location four. When the ownership split differs by entity, the consolidation has to account for minority interests. That’s a level of complexity that multiple separate QuickBooks instances simply can’t handle.
System fragmentation. We see this constantly: multi-entity clients coming from QuickBooks are often running multiple separate QuickBooks instances and trying to consolidate everything manually in Excel for reporting, instead of using a system like Sage Intacct that can handle the lift automatically. Each QuickBooks instance has its own chart of accounts, its own close process, and its own data structure. Connecting them is a significant system problem.
This is also where per-location profitability reporting becomes a different challenge than it appears at first. You can’t produce a reliable per-location P&L if the chart of accounts isn’t standardised across entities. The two problems are connected, and they have to be solved together.
Provider compensation tracking. When physician compensation is tied to production, RVUs, or collections, those calculations have to be accurate by entity. Shared physicians working across locations create allocation questions that a general consolidation model doesn’t address. The numbers feeding the compensation calculation have to come from the right entity with the right cost allocation applied.
How Long Does the Fix Actually Take?
This is the question that keeps most practice administrators from making the call. The assumption is that migrating from a manual Excel consolidation to a properly structured system is a six-month disruption that creates more problems than it solves in the short term.
That assumption is usually wrong, and we say that with 20 years experience of doing exactly this. When we take on a new client, data is often all over the place and in different systems. We’re very fast at migrating that data and integrating everything into one clean system. All the data ties together, and it does it quickly.
For most healthcare groups moving from multiple QuickBooks instances and manual Excel consolidation to Sage Intacct, the realistic timeline looks like this:
1. Weeks 1 to 2: Chart of accounts standardisation across all entities; data mapping completed
2. Weeks 2 to 4: Historical data migration; system configuration for intercompany eliminations and entity dimensions
3. Weeks 4 to 6: First clean close run in the new system, in parallel with the old process to validate
4. Week 6 onward: Close runs on the new system only; entity-level and consolidated reporting available on schedule
The part most practices overestimate as a disruption is the migration itself. We’ve done this enough times across enough healthcare groups that we know exactly what ties and what doesn’t, and we know how to move fast without creating new problems in the process.
If your consolidation runs on a spreadsheet someone built years ago, it’s time to fix it. A 30-minute conversation is usually enough to tell you what the fix looks like and how long it takes. Book a discovery call here.
Key Takeaways
• Multi entity accounting requires two outputs every month: entity-level financials for each practice and a consolidated P&L with intercompany transactions eliminated. A spreadsheet was never designed to produce both reliably.
• The three structural failure modes in Excel-based consolidation are chart of accounts inconsistency, intercompany eliminations that get skipped, and a single point of failure when one person owns the model.
• Healthcare groups face additional complexity that generic accounting guides don’t address: management company structures, mixed ownership splits per site, and system fragmentation across multiple QuickBooks instances.
• A properly structured multi-entity close process produces clean, consolidated financials by the 10th of every month. Getting there typically takes 30 to 60 days, not the six-month disruption most practices fear.
• The spreadsheet didn’t fail because of your team. It failed because the structure underneath it was never built for what a multi-location healthcare group actually needs.
Questions Practice Administrators Ask About Multi-Entity Accounting
What is multi-entity accounting?
Multi-entity accounting is the process of maintaining separate financial records for each legal entity in a business structure, then consolidating those records into a single view that eliminates intercompany transactions. For a healthcare group with multiple practice entities and a management company, it means producing both per-entity and consolidated financials every month.
Why does Excel break down for multi-entity consolidation?
Excel consolidation depends on every entity using identical chart of accounts structures, on someone manually eliminating intercompany transactions each month, and on a single person maintaining the model without error. Any one of those three conditions failing will produce an unreliable consolidated P&L, and all three become harder to maintain as the entity count grows.
What are intercompany eliminations and why do they matter?
Intercompany eliminations remove transactions that occur between entities within the same group so they don’t inflate the consolidated financials. A management fee paid from a practice entity to its management company is revenue to one and an expense to the other. If it isn’t eliminated before consolidation, the combined P&L overstates both revenue and expenses every single month.
How do you standardise a chart of accounts across multiple healthcare entities?
Standardisation means defining a single account structure that every entity uses, with consistent account names, numbering, and categorisation. For healthcare groups, this includes aligning how provider compensation, payer revenue, and shared overhead are coded so that per-location P&L reports compare on the same basis every month.
What accounting system is best for multi-entity healthcare groups?
Systems like Sage Intacct are built for multi-entity consolidation and handle intercompany eliminations, multi-ownership reporting, and entity-level dimensions natively. Running multiple separate QuickBooks instances and consolidating in Excel is a workaround, not a solution, and it breaks predictably as the entity count increases.
How long does it take to migrate from Excel consolidation to a proper multi-entity accounting system?
For most healthcare groups moving to Sage Intacct, an experienced team can complete data migration and have the first clean close running within 30 to 60 days. The migration itself is the part most practices overestimate as a disruption. With a team that has done this across dozens of healthcare clients, the process is faster and more predictable than it looks from the outside.
The Decision That Changes Everything
At some point, the spreadsheet stops being a temporary solution and starts being the thing that’s actively limiting the practice. You can’t produce board-ready multi entity accounting output from a manual Excel model. You can’t give physician-owners a reliable per-location P&L when the chart of accounts doesn’t match across entities. You can’t close the books by the 10th when the entire consolidation depends on one person running a model they built themselves.
We deal with complex, but we’re really good at peeling the layers of the onion back and making it simple. That’s what this process looks like for most of our clients: it’s not a wholesale change, just fixing the structure underneath the numbers so the numbers actually mean something to you.
If you’re managing multi entity accounting across a healthcare group and the close is consistently running late, it’s solvable. Book a 30-minute conversation with our team now.