ABOUT ADVANCEDRX
A multi-entity specialty pharmacy with fragmented financial visibility
AdvancedRx is a specialty pharmacy operation with a multi-entity corporate structure spanning a parent company and several affiliated operating entities. Specialty pharmacy operations of this structure carry significant financial complexity: revenue and costs must be tracked at the entity level for tax and legal purposes, intercompany transactions between affiliated entities must be eliminated for consolidated reporting, and the parent company needs a single consolidated view of financial performance across the group.
Before engaging Archer Insights, none of that was working. The parent company ran its financials in QuickBooks. Other entities used disconnected tools. Consolidated reporting was a manual exercise that took days and produced results that were reliably late and occasionally wrong.
Key Outcomes
- 1 – System of record
- Auto – Intercompany eliminations
- Days – Reduced from weeks to days
- Zero – Manual consolidation overhead
THE PROBLEM
Three systems, zero consolidated truth
The financial fragmentation at AdvancedRx was not the result of poor decision-making. It was the result of a company that grew faster than its systems did. As new entities were added, for operational, regulatory, or ownership reasons, each one was stood up on whatever tool was available and convenient at the time. By the time Archer engaged, the parent company and its affiliates were running on fundamentally incompatible platforms.
Operational pain points
- Intercompany transactions between affiliated entities had to be identified manually and eliminated by hand every period before consolidated financials could be produced
- Chart of accounts was different across entities, making cross-entity comparison unreliable without a manual normalization step
- Month-end close required the finance team to export data from each system, load it into a master Excel workbook, reconcile the intercompany items, and then produce the consolidated report, a process that consumed days and was prone to version control errors
- There was no mechanism to enforce consistent approval authority across entities, so each affiliate managed its own financial controls independently
Strategic consequences
- Consolidated financials were always late, meaning management decisions were made on information that was already weeks old by the time it was available
- Lenders and investors requesting consolidated financial statements required a manual preparation cycle that could not be accelerated, creating friction in every capital-related conversation
- Audit preparation required reconstructing activity from multiple systems, with no guarantee that the picture across systems was internally consistent
- The finance team was spending its highest-value hours on data assembly rather than on analysis, forecasting, or control management
THE IMPLEMENTATION
One system, one close, one version of the truth
Archer Insights migrated all AdvancedRx entities into a single NetSuite environment built around a unified chart of accounts and a consolidated reporting hierarchy. The implementation began with a systematic data migration: each entity's historical financial data was mapped to the unified account structure, opening balances were reconciled before go-live, and the legacy systems were replaced rather than connected.
The design principle throughout was consolidation by architecture rather than by process. Intercompany eliminations run automatically. The consolidated P&L and balance sheet are available the moment any period-end transaction is posted. The finance team does not assemble the consolidated view, the system produces it.
THE ADVANCEDRX CONSOLIDATION ARCHITECTURE
How automatic intercompany elimination works in NetSuite:
When Entity A sells a service to Entity B, both sides of the transaction are recorded simultaneously in their respective entity books. NetSuite identifies the intercompany pair, records the elimination entries automatically, and reflects them in the consolidated view without any action required from the finance team. What used to be a multi-hour manual reconciliation task is now a system behavior that runs continuously in the background.
Historical data migration: getting the foundation right
Multi-entity migrations fail most often not during go-live but in the prior periods that follow. If historical data is migrated incorrectly, the variances show up in comparatives and create audit questions that require manual investigation. Archer's migration methodology maps each legacy account to the unified chart, validates opening balances against the prior-system trial balances, and reconciles any differences before the system goes live. AdvancedRx went live with clean prior-period data and a unified account structure that made period-over-period comparison reliable from the first close.
Standardized record-to-report workflow
After migration, every entity operates within the same close checklist, the same account structure, and the same reporting hierarchy. Period-end is a sequential, controlled workflow rather than a distributed effort across multiple tools and multiple people reconciling independently. The finance leader runs a single close, reviews a single consolidated report, and issues financial statements without reassembling the picture from separate sources.
MODULES DEPLOYED
What Archer configured for AdvancedRx
| Module | Function | Impact |
|---|---|---|
| Multi-Entity NetSuite | Unified chart of accounts and entity structure across all affiliates | Single system of record replacing QuickBooks and disconnected tools across the group |
| Automated Intercompany Eliminations | System-generated elimination entries at period close | Manual intercompany reconciliation eliminated entirely, consolidation runs automatically |
| Consolidated Financial Reporting | On-demand consolidated P&L, balance sheet, and cash flow across all entities | Management, lenders, and auditors receive one consolidated view without manual preparation |
| Historical Data Migration | Full migration of prior-period financial data to the unified account structure | Clean comparative financials from day one with no legacy system still needed for prior-year lookups |
| Archer Approvals App | Consistent DOA-based approval routing applied across all affiliated entities | Control parity across the group, no affiliate operates under a weaker approval standard than another |
RESULTS
What AdvancedRx gained at go-live
| Before Archer Insights | After Archer Insights |
|---|---|
| Parent company in QuickBooks; affiliates in disconnected tools | Single NetSuite environment housing all entities with unified chart of accounts |
| Intercompany items identified and eliminated manually each period | Automatic intercompany eliminations; no manual reconciliation required |
| Month-end close required multi-day manual assembly across systems | Single sequential close workflow; consolidated view available at period end |
| Consolidated financials always late and difficult to produce on demand | On-demand consolidated reporting with real-time data |
| Each entity managed its own financial controls independently | Consistent DOA-enforced approvals across the entire group |
| Prior-period data locked in legacy systems; comparatives unreliable | Clean historical migration; reliable period-over-period comparison from day one |
THE ARCHER EDGE
Consolidation is an architecture problem, not a reporting problem
Many organizations try to solve multi-entity consolidation by adding a reporting layer on top of existing systems, a consolidation spreadsheet, a BI tool that pulls from multiple sources, or a third-party aggregator. These approaches can produce a consolidated view, but they do not address the underlying problem. The intercompany reconciliation is still manual. The chart of accounts is still inconsistent. The close is still a distributed exercise across multiple tools.
Archer Insights solves the consolidation problem at the architecture level. A single system, a unified account structure, and automatic elimination logic means the consolidated view is a product of the system's normal operation rather than a manual construction that has to be rebuilt every period.
Client Quote
"The Archer team continue to collaborate with my team to ensure that our NetSuite capabilities continue to grow as our company does."
— Finance Leader, AdvancedRX
Call to Action
If your specialty pharmacy or multi-entity healthcare operation is assembling consolidated financials by hand every month, Archer can show you what it looks like when the consolidation happens automatically.
archerinsights.com | Schedule a conversation with our team