Consolidated reporting for corporate groups on local ERPs: how to do it without Enterprise software
You have 3-10 companies in your group, each running on a local ERP like Saga. Monthly consolidation takes 5 days and is prone to errors. Here is how to reduce it to 30 minutes without changing your software.
Mihai Istrati — CTO Azuvio · 2026-05-21 · 9 min · ERP & Integrations
The real problem for corporate groups
If you manage a group of 3-10 companies (typically: holding + operational branches, or distributor + transporter + retail, or sister companies in different verticals), and accounting is kept in separate local instances, the monthly workflow usually looks like this:
Days 1-15: each company closes the month in the local ERP (current operations)
Days 15-20: data exports from each instance (trial balance, sales journal, purchase journal)
Days 20-25: the Chief Accountant / Controller consolidates in Excel using manual copy-paste
Days 25-28: identifying differences in intra-group receivables / payables (usually Company A says B owes 47k EUR, Company B says it owes 52k EUR — welcome to reconciliation hell)
Days 28-30: final board-pack → presented to shareholders with data that is already 30 days old
The real cost: 30-60 hours/month of a Controller's time + constant risk of material errors + decisions made with a 4-week data lag.
Why consolidation is difficult on local software
Most local accounting software is built as a single-company application, not as a multi-entity ERP with native consolidation. Concrete limitations:
There is no "group view" across multiple databases
Intra-group accounts are not automatically eliminated upon consolidation
Differences in the Chart of Accounts between companies (Company A uses specific analytical codes, Company B uses generic ones) do not align automatically
Multi-currency support for foreign branches is often limited
The usual "manual Excel" solution works for up to 3 companies. At 5+ companies, it becomes unsustainable.
The correct solution: data warehouse + automated ETL
A modern, affordable, and robust architecture:
1. Each local instance exports daily (or weekly) the trial balance + sales journal + purchase journal in XML/CSV format (most systems allow scheduled automated exports).
2. Automated ETL pickup (Azuvio or any integration tool — even a Python script + cron) retrieves the files, validates them, normalizes them (mapping different Charts of Accounts to a consolidated one), and loads them into a common database (PostgreSQL, BigQuery, or the Azuvio data module).
3. Consolidation elimination rules configured once: Company A receivables → Company B payables are cancelled out; intra-group sales are eliminated; profit from intra-group sales in remaining stock is adjusted.
4. Live consolidated dashboard (Power BI, Metabase, or Azuvio dashboard) featuring: consolidated P&L, consolidated balance sheet, cash-flow per company and consolidated, sales per segment / product / client, and real margins.
Result: consolidation that used to take 5 days becomes a 30-minute review at the end of the month. Copy-paste errors: zero. Data is live, not lagging by 4 weeks.
Comparative costs
Scenario: "Enterprise ERP with consolidation module" (SAP Business One Multi-Entity, Microsoft Dynamics 365 F&O, Sage X3):
Licenses per company: 8,000-15,000 EUR/year × N companies
Consolidation implementation: 40,000-80,000 EUR one-time
Accountant training on the new tool: 10,000-20,000 EUR
Risk of failure: 70% (Gartner on multi-entity ERP implementations)
Total Year 1 for a group of 5 companies: ~150,000-280,000 EUR. Duration: 8-18 months.
Scenario: "Keep local software + add Azuvio automated consolidation":
Local ERP on each company: 0 EUR additional (stays as is)
Azuvio Business plan with consolidation module: ~8,000-12,000 EUR/year for the group
Consolidation rules setup + dashboard: 4,000-8,000 EUR one-time
Accountant training: 0 EUR (they continue to work in their familiar environment)
Total Year 1: ~12,000-20,000 EUR. Duration: 4-8 weeks.
Savings: 130,000-260,000 EUR in Year 1 + 6-15 months gained + zero risk of failure.
What the Board / Investor receives
With the right architecture, the monthly board-pack includes:
Consolidated P&L with breakdown per company and per business segment
Real-time consolidated cash-flow + 30/60/90 day forecasts
Consolidated Top 20 clients (seeing that "Client X" actually buys from 3 of your companies)
Real margins per product / client / channel, after intra-group eliminations
Automated YoY and Budget vs. Actual comparisons
All available as of this morning, not from 25 days ago.
Conclusion
Consolidation for corporate groups using local software does not require changing the software. It requires a data layer above it that automates what your Controller currently does manually in Excel. The investment is 10-20x lower than an Enterprise ERP, the duration is 10x shorter, and the accountants remain experts in the tools they already know. See how we do it at Azuvio for CFOs or read "When your local ERP becomes too small" for broader context.