Multi-Entity Consolidation for Sage Intacct Users: What Excel Can't Do

Sage Intacct will hold 100 entities cleanly. Excel breaks at three. The gap between the two is where most mid-market FP&A teams end up working — and where most of the monthly close pain comes from.

This piece is for controllers and FP&A leads at multi-location, multi-entity companies running Sage Intacct who are tired of the workaround.

‍

The 5-entity threshold: Where Excel stops working

Two or three entities, you can hold the consolidation in your head. Each subsidiary has a tab in the master workbook. Intercompany journals are obvious. Currency conversion is a single line item.

At entity number four, the formulas start to drift. At five, you hire someone whose half-time job is the consolidation. At seven or eight, that person becomes a full hire whose entire job is the consolidation. Then someone makes a typo on the consolidating entity's intercompany elimination and the board pack goes out wrong.

If you've crossed this threshold and your FP&A is still in spreadsheets, the FP&A platform pays for itself on FTE cost alone. Sage Intacct handles the actuals side; you need the budgeting and planning side to match.

What Sage Intacct already does for you

Sage Intacct Multi-Entity & Global Consolidations is a real strength. Out of the box, you get:

• Inter-entity transactions posted once, with automatic mirror entries in the other entities.
• Intercompany eliminations at consolidation time, with full drill-down.
• Multi-currency conversion at the transaction level, with historical and current-rate options per account.
• Multi-book accounting for GAAP, statutory, and management views.

That covers actuals beautifully. What it doesn't cover is the planning layer — budget consolidation across entities, scenario modelling per entity, top-down vs bottom-up reconciliation, and workforce planning at the entity level. That's the FP&A platform's job.

‍

What an FP&A platform has to add on top

Automated intercompany eliminations at the budget layer

When the parent entity budgets a management fee and the subsidiary budgets it as an expense, the consolidation should net them out automatically. If your FP&A platform requires a manual elimination journal every cycle, you've just rebuilt the spreadsheet problem in a different surface.

Multi-currency at the budget layer, not just the actuals layer

Sage Intacct converts actuals at the transaction date. Your budget needs the same flexibility — locking specific accounts to a historical rate, others to a forecast rate, and letting you sensitivity-test the impact of a 10% FX move across the consolidated P&L.

Top-down + bottom-up reconciliation in one model

Most multi-entity organizations budget both ways. Corporate sets a top-down growth target. Subsidiaries build a bottom-up plan from departmental detail. Then you have to reconcile. In a spreadsheet, that's a manual back-and-forth. In a good FP&A platform, both views live in the same model with side-by-side variance views and approval workflow.

Workforce planning that respects entity boundaries

Headcount belongs to an entity. Cost allocations may split a position across entities. New hires need to be approved at the right entity level. The FP&A platform's Personnel Module should understand the entity, not just the department.

‍

Common failure modes — and how to spot them in a demo

Any one of these and you're going to be doing the consolidation manually on top of the platform you just bought.

‍

Centage's approach

Centage consolidates unlimited entities natively. Intercompany eliminations run automatically at consolidation time, with drill-down from any line on the consolidated P&L into the per-entity entries. Multi-currency runs at the budget layer with per-account rate rules. Top-down and bottom-up live in the same model with a built-in reconciliation view. The Personnel Module ties positions to entities and supports cross-entity allocations.

Multi-entity is included in the Performance tier (Premium Integrations · Enterprise Enhanced Data Modeling) — no add-on module, no separate license. Implementation timelines stay at 4-6 weeks even for organizations with 10+ entities, because Centage's AI-Powered Automations handle the bulk of the ERP mapping work.

‍

Frequently Asked Questions

How many entities can Centage consolidate?

Unlimited. The Performance tier includes multi-entity consolidation with no entity cap. Customers running 50+ entities on Centage are not unusual.

Does Centage automate intercompany eliminations?

Yes. Intercompany eliminations are defined once at the consolidation rule level, then applied automatically every time you consolidate or reforecast. Drill-down from any consolidated line back to the per-entity contribution is one click.

How does Centage handle multi-currency conversion?

Multi-currency is supported at the budget layer with three rate-type options per account: historical (locked at the transaction date), current (latest FX), or forecast (sensitivity-testable). You can model FX scenarios without rebuilding the model.

Can we consolidate entities that live in different ERPs (Sage Intacct + QuickBooks)?

Yes. Centage supports up to 5 GL integrations on the Performance tier, with native API connections to Sage Intacct, QuickBooks, NetSuite, Microsoft Dynamics, Acumatica, SAP Business One, and Blackbaud. Mixed-ERP consolidation is one of the most common reasons customers move up from spreadsheets.

How long does multi-entity setup take?

Most multi-entity implementations go live in 4-6 weeks, the same as single-entity. Centage's AI maps each ERP integration in minutes rather than days, which is where the time savings come from.