
Multi-entity accounting software replaces the month-end ritual of exporting every company file, merging them in a spreadsheet, and reconciling intercompany balances by hand. Sage Intacct holds every entity in one shared dimensional chart of accounts, runs intercompany eliminations as a defined set, and produces a consolidated view on demand.
BCS ProSoft has implemented financial and ERP systems since 1985. We design the entity and dimension structure, build the elimination set, and migrate your history so the first consolidated close on the new system is one you can trust.
Starts with a discovery call. We review your entity structure, intercompany activity, currencies, and close calendar, then give you a realistic scope and pricing range.
THE CLOSE THAT NEVER GETS SHORTER
Close takes two weeks because five company files have to be exported, merged, and reconciled before anyone can look at a group number. The intercompany eliminations are always off by something, and finding the difference is the job.
That is not a discipline problem. It is what happens when each entity keeps its own ledger and the group only exists in a spreadsheet.
THE BUYING DECISION
Every multi-entity finance team is on one side of this line. It determines how long close takes, whether eliminations reconcile, and how much of the month is spent rebuilding numbers that already exist.
| A separate company file per entity | Native multi-entity consolidation |
|---|---|
| Each entity keeps its own chart of accounts, so the same expense is coded differently in different files. | One shared dimensional chart of accounts. Entity is a dimension on the transaction, not a separate book. |
| Consolidation is a spreadsheet built after every entity closes, and it is rebuilt from scratch each period. | Consolidation is a view of the ledger. It is available as soon as the underlying entities have posted. |
| Intercompany eliminations are manual journals that have to be re-derived and re-checked every close. | Eliminations are defined once as a set and run automatically at each close under ASC 810. |
| Foreign entities are translated by hand, so FX revaluation is a calculation someone owns and can get wrong. | Local currency transacting with automatic translation and revaluation into the group reporting currency. |
| Drilling into a consolidated number means opening another file and searching for the transaction. | Drill from a consolidated figure straight through to the originating transaction in the owning entity. |
| Adding an entity means another file, another mapping, and another column in the consolidation workbook. | Adding an entity is a configuration change. The elimination set and reporting pack already apply. |
RUNNING A COMPANY FILE PER ENTITY?
Most groups reach us with a file per entity, a consolidation workbook someone maintains, and an intercompany reconciliation that has quietly become a two-day task. The entity list, the elimination logic, and the reporting pack in that workbook are not waste. They are the specification for the configuration.
A file per entity. A consolidation workbook rebuilt each period. Intercompany differences chased by hand.
One dimensional ledger with entity-level drill-down, a defined elimination set, and a consolidated view available on demand.
BCS ProSoft maps your entities, ownership percentages, intercompany relationships, and currencies into a Sage Intacct configuration, then migrates the history you need for comparative reporting. Related reading: multi-entity reporting best practices and financial close software.
WHAT MAKES CONSOLIDATION NATIVE
Native consolidation is not one feature. It is four things working together, and missing any one of them puts the spreadsheet back in the process.
SHARED DIMENSIONAL COA
Every entity posts to the same account structure, and entity, department, location, project, and customer ride along as dimensions on the transaction rather than as segment codes bolted onto the account number.
That is what makes a group report and a single-entity statutory report come out of the same data instead of two reporting packs maintained in parallel.
AUTOMATED ELIMINATIONS
Intercompany AR and AP matching, management fee allocations, loans and interest, unrealised FX on intercompany balances, and investment-in-subsidiary elimination are configured as a set and applied at each consolidation under ASC 810.
Minority interest is calculated from ownership percentages rather than plugged, so a partially owned entity consolidates at its actual share.
MULTI-CURRENCY
Entities operate in their own currency while the group reports in one. Translation at the appropriate rate and FX revaluation on open balances are posted by the system.
The month-end FX journal stops being a calculation one person understands and becomes part of the close routine.
DRILL-DOWN
A consolidated figure is not a typed-in total. Drilling into it reaches the entity, then the journal, then the source transaction, without leaving the system or opening another file.
For groups under investor or lender scrutiny, that audit path is often the point. See multi-entity reporting for private equity.
WHAT CHANGES FOR THE CONTROLLER
When entity is a dimension and eliminations are a defined set, the consolidated numbers exist as soon as the entities have posted. The controller’s month shifts from assembling the group position to reviewing it and explaining variances.
The visible change is a shorter close. The durable one is that the group number and the entity detail can no longer disagree, because they are the same data viewed at two levels.
BEFORE YOU EVALUATE
The questions that decide whether this is worth your time.
Consolidation runs on demand rather than as a month-end project, because entities already share one chart of accounts and eliminations are defined once. The gating factor becomes how quickly each entity closes its own books, not the merge.
Yes. Entities can transact in local currency and report in the group currency, with FX revaluation and translation posted by the system rather than calculated in a spreadsheet and journalled in by hand.
Ownership percentages drive consolidation, so partially owned entities consolidate at their share and minority interest is calculated rather than plugged. Equity-method holdings can be carried without pulling the full entity into the group.
Yes. Consolidation here is native to the ledger rather than a downstream tool fed by exports. There is no separate mapping layer to maintain, and drilling from a consolidated figure reaches the original transaction in the owning entity.
Entity is a dimension, so any report runs for one entity, a sub-group, or the whole group without a different reporting pack for each. Local statutory reporting and group reporting come from the same data.
It is less about count than about intercompany activity. Two entities that trade with each other can already be painful; five that do not may be tolerable. When eliminations stop reconciling, the file-per-entity model has run out. See Sage Intacct vs QuickBooks.
HOW THE PROCESS WORKS
A practical path, with pricing that reflects the actual scope.
We map your entities, ownership percentages, intercompany relationships, currencies, and the reporting each entity owes locally and to the group. That produces a realistic scope and pricing range, and an honest answer if the fit is not there.
BCS ProSoft builds the shared dimensional chart of accounts, configures the elimination set and currency handling, and migrates opening balances plus the comparative history your reporting needs.
Your team runs a consolidated close in parallel with the existing process so the group numbers are proven to agree before cutover, then has support through the first live close on the new system.
Start with a discovery call. We will review your entity structure, intercompany activity, currencies, and close calendar, then walk you through what the configuration would involve. You can also explore Sage Intacct first.
BCS ProSoft is a certified Sage Intacct implementation partner for multi-entity groups.