A repeatable month-end close for primary care groups growing through acquisition
How primary care groups growing through acquisition can build a repeatable month-end close: consolidation boundaries, account mapping and reconciliations.
Acquiring a practice can add new accounting records, systems and reporting obligations. Start with the entities that belong in your financial statements and the reporting requirements in your financing agreements. If the close relies on manually combining practice-level files, each acquisition can add work unless mappings, reconciliations and responsibilities follow a repeatable process.
This post covers why spreadsheet consolidation takes hold in primary care finance, what breaks as a group grows, what system-based consolidation can change, and how to absorb the next acquisition.
Key takeaways
- Lender reporting follows each financing agreement, including its reporting entities, covenant definitions and permitted adjustments. A close that relies on manually combining practice-level files can make that reporting slower and harder to get right as acquisitions add entities.
- Spreadsheet consolidation often starts as a reasonable fix for one or two practices and can turn into a monthly project as acquisitions add entities.
- A common reporting structure, configured intercompany eliminations and repeatable consolidation runs can reduce spreadsheet aggregation while preserving separate entity records. Mappings still need maintaining, and intercompany differences still need investigation and reconciliation.
- We recommend keeping patient-level detail in clinical and billing systems, with summarized financial results in the general ledger.
- With a group reporting structure and intercompany rules already in place, onboarding a newly acquired practice can follow a repeatable pattern. Its mappings still need maintaining, and readiness for its first close depends on opening balances, acquisition accounting and source-system feeds.
What we’ll cover
Why spreadsheets often become the default in primary care finance
In many groups, spreadsheet consolidation arrives with growth rather than by design.
As an illustration, a single practice may manage with entry-level accounting software and a few spreadsheets. After a second acquisition, the controller opens a second company file and starts a consolidation tab in Excel. As more practices join, that tab can become a monthly project: days of reconciliation work and numbers that arrive after the questions have been asked.
What breaks as the group scales through acquisitions
As a primary care group adds entities, four pressure points can build on each other.
No single chart of accounts. Acquired practices may use different account structures. A reusable mapping can align them with group reporting, but new accounts, inconsistent coding and changing requirements need review. The recurring burden is maintaining those mappings and resolving exceptions, whether the process runs in spreadsheets or accounting software.
Consolidation boundary and intercompany eliminations. First establish which entities belong in the consolidated financial statements under the applicable accounting requirements. The relationship between a management services organization (MSO) and a practice does not by itself determine whether that practice is consolidated. Review ownership and contractual arrangements with your accounting advisers. Eliminate balances and transactions between entities within that boundary, while retaining the underlying entity records. Automated entries can reduce manual work, but differences still need investigation and reconciliation. This accounting does not establish whether an MSO arrangement is permissible under state corporate practice of medicine rules, a question for healthcare counsel.
Limited cross-entity visibility. Controllers absorbed in reconciliations have less time for portfolio analysis. Provisional management reports can help, but forecasting and profitability by location and payer are harder to answer with confidence when the final consolidated view arrives late. Lender reporting follows each financing agreement’s own definitions and adjustments, so plan it as its own step rather than a by-product of the consolidated P&L.
Key-person dependency. When the close depends on the few people who understand the spreadsheet mapping, a vacancy or resignation can put the close timetable at risk.
What can system-based consolidation change?
System-based consolidation can reduce spreadsheet aggregation while preserving separate entity records. The benefit depends on configuration, complete source data and a controlled close.
- A common reporting structure. Map acquired practices to group accounts and retain useful dimensions where source data supports them. Maintain those mappings as accounts and reporting needs change.
- Configured intercompany eliminations. Set up the relevant balance-sheet and income-statement accounts for elimination. Reconcile counterparties and investigate differences; automation does not replace that control.
- Repeatable consolidation runs. Confirm whether reports update directly from postings or require a consolidation run. Refresh the consolidation after relevant adjustments, and distinguish provisional reports from final closed-period results.
- Reconciled source-system feeds. Integrations can reduce rekeying of summarized billing data. Retain the attributes needed for reporting and reconcile imported totals to the source systems.
Sage Intacct supports this for healthcare organizations with multiple entities, locations and clinics, with a shared chart of accounts, multi-entity consolidation, centralized payables, and automated payments and intercompany accounting.
We recommend keeping patient-level detail in the clinical and billing systems, with summarized results in the ledger. Summarized data isn’t automatically de-identified, so review what reaches the ledger and apply HIPAA safeguards wherever protected health information is held.
Summarized billing data can support revenue reporting by payer and location when those attributes are retained and reconciled. Cost per encounter also needs consistent encounter counts and cost attribution. For groups with capitation, care-management payments or shared-savings arrangements, contract profitability requires the relevant payer reports, revenue estimates and costs as well as encounter billing.
What one multi-group physician organization’s close shows
In its customer story, Millennium Physicians describes a business that “had grown drastically in seven years”, with “5,000 accounts across 16 separate medical groups” and a monthly close that “dragged on for weeks”.
Since Millennium moved to Sage Intacct, “the month-end process and prep operation that previously took 14 business days, now takes just two to three days.” Every group starts from a different place, but that is what a better-structured close did for Millennium.
Making the next acquisition easier to absorb
In one common spreadsheet pattern, each acquisition adds a new file, a new mapping exercise and a new reconciliation column.
With system-based consolidation, onboarding a newly acquired practice can follow a repeatable pattern. The group’s reporting structure, intercompany rules and dimensions are already in place, and the new practice’s accounts are mapped to that structure at onboarding, then maintained as needs change.
That repeatability helps when the next deal is already in diligence. The finance team can reduce redesign of the consolidation for each new practice, although opening balances, acquisition accounting and the practice’s billing integration still need to be set up and reconciled before the practice is ready to consolidate from its first close.
Frequently asked questions
What should a primary care group scaling through acquisition look for in accounting software?
Look for a cloud platform with multi-entity consolidation, a common chart of accounts, configurable intercompany eliminations, and integrations that bring summarized billing and practice-management data into the ledger with totals you can reconcile to the source systems. Financial systems can hold some protected health information, so confirm with your compliance team whether a Business Associate Agreement is required and, if it is, have it and the related safeguards in place before protected health information reaches the system.
How do you replace spreadsheet consolidation without disrupting the current close?
It helps to configure the new platform with the group’s consolidation boundary, standard chart of accounts and intercompany rules before the first live close. Existing entities can migrate in sequence, and newly acquired practices can onboard directly. Before retiring the spreadsheet, agree acceptance criteria with your implementation partner and discuss them with your auditors, for example that entity trial balances, intercompany balances and consolidated results reconcile between the old and new processes, with any differences explained.
How does multi-entity accounting software handle intercompany eliminations?
In a system built for multi-entity consolidation, eliminations are configured for the relevant accounts, such as management fees, shared-service allocations and intercompany loans between entities inside the consolidation boundary. The system can then post elimination entries during consolidation, reducing a manual step that is easy to get wrong in a spreadsheet. Counterparty balances still need reconciling and differences investigating. Elimination is an accounting treatment only and does not establish whether an MSO arrangement is permissible.
Read the Millennium Physicians customer story to see how one provider with 16 separate medical groups reports cutting its month-end process and prep from 14 business days to two to three days.
Browse more topics from this article
Explore more wisdom
Deferred tax liability: A practical guide
A deferred tax liability is a bit like a corporate version of “buy now, pay later”: your company reports lower tax now but owes the difference later. Here’s what causes one, how to calculate it, and what it means for your balance sheet.
