If you run a holding company with multiple subsidiaries, you know the headache of consolidation. Different legal entities, different currencies, different fiscal years. The CFO of a group with eight operating companies told me it took her team 20 days every quarter to roll up the numbers. And even then, they weren’t fully confident in the results. They turned to ERPNext Consulting to streamline the process.
The Complexity That Was Buried in Spreadsheets
Each subsidiary used its own set of account codes. Intercompany transactions were tracked in Excel, with manual reconciliations that often took a full week. Currency conversion was done with a spreadsheet macro that had a known bug but nobody had time to fix it. On top of that, the parent company needed to report in US GAAP while two subsidiaries used local accounting standards.
With ERPNext Consulting, we implemented a multi-company setup where each subsidiary maintains its own books but all data flows into a single consolidation engine. The system automatically handles intercompany eliminations, currency revaluation, and adjustments for different reporting standards. The CFO can now run a consolidated P&L at the click of a button.
The Practical Steps That Made It Work
- Created a master chart of accounts that maps each subsidiary’s local accounts to a group-level standard
- Set up automatic intercompany matching – when one subsidiary raises an invoice to another, the system flags it for elimination
- Implemented a consolidation report that shows the group’s financials in both local currency and reporting currency
- Built a reconciliation dashboard that highlights any unmatched intercompany transactions older than 5 days
What They Achieved in Numbers
- Quarterly close time reduced from 20 days to 5 days
- Intercompany reconciliation errors dropped by 90%
- Audit adjustments decreased from an average of 25 per quarter to just 2
One critical insight: standardize the chart of accounts before you even think about software. We spent two weeks with all eight subsidiary CFOs in a room, hashing out the mapping. It was painful, but it made the entire implementation smooth. If you’re looking at ERPNext Consulting for multi-entity consolidation, start with the chart of accounts mapping – everything else follows.