The client is a multi-entity medical group structured around one clinical operating company and five related entities sharing payroll, real estate, and intercompany loans. Annual revenue exceeded $1.3M across the structure, with accounts receivable fluctuating between $800K and $980K each month. The group’s healthcare accounts receivable reconciliation process had never been formally designed, it simply evolved as the practice grew. 
The prior workflow followed the pattern most founder-led practices drift into over time. A team member would periodically download an aging report from the practice-management portal, compare it to QuickBooks manually, patch the obvious discrepancies, and send financials out. Intercompany loans across the six entities were reconciled once a month at best. Observations were noted but rarely tied back to whether the AR figures were actually clean.
KEY CHALLENGES
When GATP Solutions’ lead reviewer first audited the process, a single question exposed the deeper issue: “Why are COGS higher than revenue, isn’t something off here?” The answer turned out to be a healthcare accounts receivable reconciliation failure, not a cost problem. Specific breakdowns included:
- Invoices billed in the portal were missing from the books entirely.
- Voided portal invoices were still being carried as open AR in QuickBooks.
- Intercompany loans across all six entities had no consistent reconciliation schedule, creating persistent balance-sheet noise.
- Financials were built from whichever portal report was pulled last which could have changed between the pull date and the review date.
- There was no standardized format, so each healthcare accounts receivable reconciliation required starting from scratch.
IMPACT
Unreliable healthcare accounts receivable reconciliation did not just produce messy spreadsheets, it created genuine operational risk for the practice owner. Without a reliable AR tie-out, monthly financials were essentially estimates. Revenue figures that appeared healthy could mask significant collection gaps. Strategic decisions on staffing, expansion, and cash management were being made on numbers that were off by an unknown margin.
REQUIREMENTS & EXPECTATIONS
The engagement required more than a one-time clean-up. The client needed a durable healthcare accounts receivable reconciliation system any team member could operate consistently, without tribal knowledge or spreadsheet archaeology. Specific requirements included:
- A repeatable AR reconciliation process running on a regular cadence, not just at month-end or quarter-end.
- Full invoice-level visibility into the gap between what was in the books and what the portal showed.
- Consistent healthcare accounts receivable reconciliation of intercompany balances across all six related entities on the same schedule.
- Monthly financials out by the 10th, tied to a clean AR close, without heroic manual effort.
- A process transferable to any analyst from day one, same output, same format, every time.
STRATEGIC APPROACH
GATP Solutions did not add more hours to the existing broken process. The approach was to redesign the healthcare accounts receivable reconciliation workflow so it could run every week, in the same format, by any team member, without sacrificing accuracy. Standardization came first. AI augmented the process only after the underlying data was made uniform and trustworthy.
Core Principle
A consistent, standardized format is the foundation of any reliable healthcare accounts receivable reconciliation. The AI layer amplifies speed and accuracy only once the data structure is clean and uniform.
COMPREHENSIVE SOLUTION
The solution was built in four interconnected layers that together form a complete, repeatable system:
1. Standardize Both Sides of the Reconciliation
The Books AR aging and the Portal AR aging were locked into a common shape: Date, Customer Name, Amount, spaces stripped, dates normalized, amounts formatted consistently. A Unique ID was generated on every invoice in both reports, enabling exact matching regardless of minor portal formatting differences.
2. Build an AI-Driven Matching Engine
GATP Solutions wrote a healthcare accounts receivable reconciliation prompt the team runs inside Claude AI. The prompt ingests both reports, builds the Unique IDs, and produces a four-tab output: a summary, invoices missing in books, extras in books, and confirmed matches, with duplicates flagged separately for immediate review. The team runs the process; the AI runs the matching.
3. Move AR to a Twice-Monthly Plus Pre-Close Cadence
The healthcare accounts receivable reconciliation now runs mid-month and again before financials go out. This eliminates the scenario where the portal changes between the pull date and the review date, a silent source of errors in the previous process.
4. Extend the Same Discipline to Intercompany Entities
All six related entities now reconcile on one weekly cycle using a parallel AI prompt, so intercompany loans between the operating company and its sister entities tie every period, not once a quarter or whenever someone remembers.
“GATP Solutions gave the team one source of truth for AR; missing invoices, extras, duplicates; every week, on the same format. Financials never go out without a clean AR tie-out now.”
– Anjali Saluja, Accounting Lead · GATP Solutions
MEASURABLE RESULTS
Inside sixty days of GATP Solutions rebuilding the process, three measurable shifts occurred for the client:
- Financials stopped going out with blind spots. The monthly close package; covering revenue, COGS, operating expenses, AR, AP, and cash flow, now lands by the 10th of every month, tied to a fully reconciled AR.
- Intercompany noise across all six entities resolved. Loans between the operating company and its affiliates now reconcile on a single weekly cycle instead of three separate, out-of-sync processes.
- The AI layer freed the accounting team for higher-value work. Time previously spent eyeballing spreadsheets is now directed toward unusual adjustments, vendor flags, and cash-flow analysis.
| Weekly AR reconciliation cadence — up from ad-hoc | ~$800K A/R balance now reconciled invoice-by-invoice | 6+ Intercompany entities reconciled on one cycle |
CLIENT IMPACT
Most seven-figure healthcare practices hit this same wall. Billing scales. AR balloons. The team that worked fine at $500K in revenue cannot keep pace at $1.5M, and the owner ends up running a version of the healthcare accounts receivable reconciliation in their head at 10 PM.
For this client, the impact went well beyond cleaner spreadsheets. The practice now has:
- Confidence in every monthly financial package, no more uncertainty about what the AR actually reflects.
- A close process that scales with the practice rather than breaking as revenue grows.
- An accounting team focused on decisions, not data hygiene.
- Full intercompany transparency across six related entities, reconciled weekly rather than quarterly.
- A transferable process — any new analyst can produce the same healthcare accounts receivable reconciliation output from day one.
KEY TAKEAWAY
GATP Solutions is a growth-focused accounting partner for healthcare founders ready to stop absorbing work that belongs inside a formal close process. The firm builds the process, reconciles the AR, ties the intercompany, and surfaces the numbers that drive real decisions. Where AI makes the team faster, GATP Solutions integrates it into the workflow — not to replace the team, but to free the team for the work that actually needs human expertise.
For any practice where healthcare accounts receivable reconciliation is still running on gut instinct and manually downloaded portal reports, there is a better way. The numbers do not have to stay blurry.
You’re running a clinic, not a spreadsheet
If your AR is sitting north of six figures and nobody can tell you exactly what’s collected versus what’s in limbo, we should talk. We run the healthcare accounts receivable reconciliation. You run the practice.
Book a 30-minute call.
