A multi-entity medical practice needs more than a spreadsheet that adds every entity’s revenue and expenses together. Internal management fees, shared payroll reimbursements and balances between entities can distort that total. Meanwhile, a group-level profit figure can hide cash constraints or operating problems within an individual entity.
AI-assisted consolidated reporting should support a controlled accounting process—not replace it. Depending on the tools and data available, AI can suggest account mappings, flag unmatched balances and draft explanations of financial changes. The finance team must validate those suggestions, reconcile the underlying books and approve the reporting adjustments.
For practice owners, the objective is a reporting pack that answers three questions: How did the group perform with outside parties? Which entity or location drove the result? Where is cash available, and what obligations remain?
Decide What the Report Should Represent
Before combining financial data, ask your CPA to determine the appropriate reporting basis and which entities belong in the report. Common ownership, a management relationship or shared staff does not, by itself, settle how financial statements should be presented.
Your CPA should distinguish formal consolidated financial statements from combined financial statements or an internal management aggregation. A lender’s reporting requirements may also differ from the owner’s monthly management needs.
Location aggregation is a separate task. If one legal entity operates several offices, a location P&L divides that entity’s activity into operating segments. Consolidating several legal entities requires additional attention to reciprocal balances, internal transactions and the applicable reporting basis.
Keep both views when they are useful: group results for overall performance, entity statements for accountability and location schedules for operational decisions.
sbb-itb-17e8ec9
A Controlled Monthly Consolidation Workflow
1. Align the reporting period and accounting basis
Set a common month-end cutoff and identify the accounting basis used by each entity. Do not silently combine a cash-basis management company report with an accrual-basis operating practice report.
The close instructions should identify:
- Entities included and the responsible preparer for each.
- Reporting period, accounting basis and comparative periods.
- Required reconciliations and supporting schedules.
- Treatment of late entries and revised reports.
- Reviewer and final approval responsibilities.
Payer deposits received after month-end, outstanding patient balances and unpaid payroll can affect reports differently depending on the basis used. The CPA should determine any necessary adjustments before the statements are combined.
2. Map entity accounts to a common reporting structure
Each entity can retain its own chart of accounts while mapping to shared reporting categories. The mapping should preserve distinctions that matter to the owner, such as provider compensation versus administrative payroll and external service revenue versus internal management fees.
| Entity account | Group reporting category | Review consideration |
|---|---|---|
| Operating practice: payer and patient revenue | External practice revenue | Confirm recognition follows the approved basis |
| Operating practice: physician compensation | Provider payroll | Keep separate from administrative payroll |
| Management entity: office staff wages | Administrative payroll | Confirm which entity employs the staff |
| Management entity: fees from practice | Intercompany management revenue | Identify the corresponding practice expense |
| Operating practice: amount owed to management entity | Intercompany payable | Match to the other entity’s receivable |
AI can help propose mappings from account names and transaction descriptions. A reviewer should approve each new or changed mapping. Similar labels are not enough: an account called “collections” might represent revenue, a clearing account or a transfer.
Keep a dated mapping file so the team can explain changes between reporting periods.
3. Reconcile each entity before combining it
Consolidation cannot repair incomplete books. Each entity should have reconciled bank and credit card accounts, reviewed payroll balances and support for significant assets and liabilities.
The IRS guidance on business recordkeeping supports maintaining complete records, keeping business accounts separate and reconciling bank records. Those habits also provide a stronger foundation for group reporting.
For a staffed practice, the close review may include:
- Tying payer receipts and patient collections to the relevant accounting records without duplicating revenue.
- Reconciling provider and administrative payroll, including unpaid amounts where applicable.
- Reviewing receivables and adjustments under the selected reporting basis.
- Confirming loan balances and separating principal from interest.
- Resolving unexplained clearing-account balances.
If an entity is not ready, identify its status in the draft pack. Do not present an incomplete group report as a final close.
4. Match intercompany activity and resolve differences
Create a schedule of internal transactions and balances by counterparty. Common examples include management fees, shared-cost reimbursements, loans and cash transfers.
For each item, record the originating entity, receiving entity, period, amount, transaction type and supporting reference. Compare reciprocal balances before preparing eliminations.
An unpaid management fee should generally have corresponding records on both sides under the applicable accounting treatment. If one entity recorded it in a different period or under a different category, investigate the difference. Do not force the balances to agree with an unexplained adjustment.
AI-assisted exception checks can help identify unequal balances, missing counterparties or unexpected changes. They cannot establish that a transaction was authorized or determine its accounting treatment from a description alone.
5. Prepare and review elimination entries
Elimination entries remove internal activity from the group presentation. They do not erase the underlying obligations from the separate entity books.
For example, management fee revenue in one entity and the corresponding expense in another may need to be eliminated from the group results. The management entity’s actual external payroll and vendor expenses remain.
Record eliminations in a separate consolidation worksheet with an explanation, supporting reference, preparer and reviewer. Have the CPA determine other required adjustments, including any ownership-related eliminations. Do not assume that eliminating management fees and intercompany balances completes every consolidation.
Illustrative Example: Operating Practice and Management Entity
All amounts below are hypothetical, illustrative figures in thousands of dollars. Assume the CPA has approved including both entities in the reporting perimeter and using a consistent accrual basis for this management reporting example.
The operating entity receives payer and patient revenue and employs providers. The management entity employs administrative staff and incurs shared operating costs. It charges the operating entity a management fee.
This simplified example demonstrates reporting mechanics, not the legal, tax or contractual appropriateness of that arrangement. It excludes ownership-investment accounts and other complexities; the CPA must assess them in an actual reporting pack.
Income statement worksheet
| Monthly P&L line | Operating entity | Management entity | Before eliminations | Elimination adjustment | Group result |
|---|---|---|---|---|---|
| External practice revenue | 500 | 0 | 500 | 0 | 500 |
| Internal management fee revenue | 0 | 80 | 80 | -80 | 0 |
| Total revenue | 500 | 80 | 580 | -80 | 500 |
| Provider payroll | 260 | 0 | 260 | 0 | 260 |
| Administrative payroll | 0 | 50 | 50 | 0 | 50 |
| Occupancy | 60 | 0 | 60 | 0 | 60 |
| Internal management fee expense | 80 | 0 | 80 | -80 | 0 |
| Other external expenses | 40 | 20 | 60 | 0 | 60 |
| Total expenses | 440 | 70 | 510 | -80 | 430 |
| Net income | 60 | 10 | 70 | 0 | 70 |
Simply adding entity revenue would show $580,000. After eliminating internal fees, external group revenue is $500,000. Net income is unchanged because the matching internal revenue and expense offset, but the revenue and expense presentation changes substantially.
Elimination worksheet
Assume $20,000 of the illustrative management fee remains unpaid at month-end.
| Entry | Debit | Credit | Supporting review |
|---|---|---|---|
| Remove internal fee activity | Management fee revenue: 80 | Management fee expense: 80 | Match the fee schedule and both ledgers |
| Remove reciprocal unpaid balance | Intercompany payable: 20 | Intercompany receivable: 20 | Confirm both entities report the same outstanding amount |
The fee elimination covers the period’s internal activity. The balance-sheet elimination covers the amount still outstanding at month-end. These are related but different checks.
Simplified balance sheet worksheet
| Month-end balance | Operating entity | Management entity | Before eliminations | Elimination adjustment | Group result |
|---|---|---|---|---|---|
| Cash | 120 | 40 | 160 | 0 | 160 |
| External receivables | 180 | 0 | 180 | 0 | 180 |
| Intercompany receivable | 0 | 20 | 20 | -20 | 0 |
| Total assets | 300 | 60 | 360 | -20 | 340 |
| External liabilities | 90 | 10 | 100 | 0 | 100 |
| Intercompany payable | 20 | 0 | 20 | -20 | 0 |
| Equity | 190 | 50 | 240 | 0 | 240 |
| Total liabilities and equity | 300 | 60 | 360 | -20 | 340 |
The group has $160,000 of cash in this example, but the entity columns still matter. A group total does not establish that all cash is freely available to pay every entity’s obligations. Review entity-level payroll, debt and other commitments before making transfers or distributions.
Where AI Can Assist—and Where Review Must Remain
Use AI on bounded tasks with identifiable inputs and reviewable outputs. Do not treat a fluent explanation as evidence that the numbers are correct.
| Task | Potential AI assistance | Required human control |
|---|---|---|
| Account mapping | Suggest a reporting category for a new account | Approve classification and counterparty treatment |
| Intercompany matching | Identify possible reciprocal transactions | Verify amount, period and supporting records |
| Exception review | Flag unmatched balances or unusual movements | Investigate rather than automatically clear exceptions |
| Report narrative | Draft commentary from approved statements | Check every amount and distinguish facts from hypotheses |
| Statement preparation | Help assemble approved reporting schedules | Review formulas, adjustments and accounting presentation |
For example, a draft narrative might attribute lower profit to increased provider payroll. The reviewer should verify that payroll actually increased and determine whether the cause was staffing, timing or reclassification. AI should not invent a hiring explanation from the financial totals alone.
Use financial summaries without patient identifiers wherever possible. Do not place patient-identifiable information in ordinary Slack messages or general-purpose AI tools. The HHS minimum necessary guidance describes a standard with exceptions; the practice should confirm appropriate data handling for its circumstances rather than assuming every financial workflow has identical requirements.
Approve a Reporting Pack, Not Just a Dashboard
A useful monthly pack should include:
- Scope and basis: Included entities, reporting period, accounting basis and draft or final status.
- Group statements: P&L, balance sheet and an appropriately prepared cash flow statement or clearly labeled cash movement schedule.
- Entity statements: Separate results and balances, including intercompany accounts.
- Location schedules: Operational P&Ls where useful, with shared-cost allocation methods explained.
- Consolidation support: Account mappings, elimination worksheet and unresolved exceptions.
- Management commentary: Verified drivers of changes and decisions requiring owner attention.
Keep location cost allocations distinct from intercompany eliminations. Allocating shared administrative costs among offices supports location analysis; eliminating internal fees prevents internal activity from inflating group reporting.
Before release, the finance reviewer should confirm that entity statements tie to approved trial balances, mappings are complete, eliminations have support and the group balance sheet balances. The owner should review the business interpretation and action items. Owner approval does not replace accounting review.
If a correction arrives after approval, issue a clearly dated revision and explain what changed. A dashboard refreshed with new transactions is not automatically a newly approved reporting pack.
How Lucid Financials Fits
Lucid Financials provides CPA-led bookkeeping, tax and CFO services for staffed US private medical practices. Its approach combines AI-assisted financial work with a human finance and CPA team, including support for clean books, catch-up bookkeeping and location/entity financial visibility.
For a multi-entity owner, the starting conversation should cover the reporting perimeter, quality of each entity’s books, close responsibilities and required review. Slack support can help coordinate questions and follow-up without using ordinary messages to exchange patient-identifiable information.
The goal is not autonomous consolidation. It is a repeatable process that produces reviewed group results while preserving the entity detail needed to manage payroll, cash and operating performance.
FAQs
Is adding location P&Ls the same as consolidated reporting?
No. Location P&Ls describe operating segments and may belong to one legal entity. Multi-entity reporting also requires a defined reporting perimeter, consistent accounting treatment and review of internal transactions and balances. Your CPA should determine the appropriate presentation.
Can AI automatically approve intercompany eliminations?
AI may help identify possible matches or draft a worksheet, but that does not establish the correct accounting treatment. A qualified reviewer should verify the supporting records, resolve differences and approve elimination entries before the report is released.
Do elimination entries change the separate entity books?
Typically, consolidation worksheet entries affect the group presentation rather than removing transactions from entity ledgers. An actual error in an entity’s books should be corrected there through the normal review process. Keep those corrections separate from reporting-only eliminations.
Does AI-generated reporting establish GAAP compliance?
No. Automated calculations and generated narratives do not establish compliance with an accounting framework. The CPA must determine the appropriate basis and presentation, assess required adjustments and disclosures, and review the statements for their intended use.