Overview
Azira is a multi-entity organisation with complex group reporting requirements — multiple legal entities, multiple currencies, intercompany transactions, and a leadership team that needs agile, comparative financial visibility across both company and regional lenses.
Consolidation was being done manually — a time-intensive, error-prone process that consumed the finance team every month-end and still produced reports that were days old by the time leadership received them. XLURSELF was brought in to build a comprehensive Excel-based financial consolidation engine that would automate the entire process, eliminate human error, and give the CFO real-time visibility into the group's financial position.
Challenge
The consolidation process had every hallmark of a manually-maintained financial workflow at breaking point. Trial balances from multiple entities were uploaded in no particular order, creating version control nightmares and reconciliation errors. Multi-currency positions required manual forex rate application — with no systematic distinction between closing rates, average rates, and historical rates for different P&L and Balance Sheet line items.
Intercompany eliminations were performed manually in spreadsheets with no validation logic — meaning errors could propagate undetected into the group financials. Budget and forecast data was maintained separately, with no unified tool for comparative analysis. Leadership had no way to toggle between a company view and a regional view of the same financial statements without asking the finance team to rebuild the report.
Solution
XLURSELF designed and built a robust, single-file Excel consolidation engine that handles the complete group reporting workflow from Trial Balance upload to final consolidated financial statements — with automated validation, multi-currency logic, intercompany eliminations, and dynamic comparative reporting built into its core.
The tool enforces sequential Trial Balance uploads with match validation at every step — making it structurally impossible to produce a consolidated report on top of an imbalanced or out-of-sequence input. Multi-currency forex rates (Closing, Average, and Historical) are managed in a dedicated rate table and applied automatically to each line item category. Intercompany eliminations and Adjustment JVs are handled through a structured input layer with full audit trail. The result is a single dashboard that leadership can interrogate — by company or by region, with any comparative period — without any manual intervention.
How We Approached It
Consolidation Architecture & Requirements Design
Mapped the full group structure — entities, intercompany relationships, currency exposures, and reporting dimensions. Designed the tool architecture: data input layers, validation logic, consolidation engine, and output structure — before writing a single formula.
Trial Balance Input & Sequential Validation
Built the TB upload module with validation logic ensuring Trial Balances balance before acceptance, entities are uploaded in the correct sequence, and any imbalance is flagged immediately with the specific variance highlighted for the user.
Multi-Currency Forex Engine
Developed a forex rate management module supporting Closing Rate, Average Rate, and Historical Rate application — mapped to the correct Balance Sheet and P&L line items per accounting standards. Rates are managed in a single table and flow automatically throughout the consolidation.
Intercompany Elimination & Adjustment JV Module
Built structured input templates for intercompany eliminations and Adjustment Journal Entries, with automated posting into the consolidation engine and full reconciliation of intercompany balances before group financials are produced.
Dynamic Dashboard & Upload/Download Utilities
Designed the executive dashboard with Company vs Regional toggle for DFS views, custom comparative period selection, and one-click Download utilities for producing board-ready consolidated financial statements. Upload utilities allow the finance team to manage Budgets, Forecasts, and GL mappings without technical support.
Impact
1 tool
Full group consolidation
The entire consolidation workflow — from TB upload to consolidated DFS — runs in a single Excel file. No external tools, no manual aggregation.
Zero errors
TB validation enforced
Sequential upload validation makes it structurally impossible to consolidate on top of an imbalanced or out-of-order Trial Balance.
3 Forex types
Closing / Avg / Historical
Multi-currency consolidation handled correctly per accounting standards — each rate type automatically applied to the right line items.
Same day
Consolidated reporting
Leadership can produce a complete consolidated view — by company or by region, with any comparative period — without waiting for the finance team to rebuild reports.
Key Outcomes
- Complete group consolidation engine delivering Company and Regional DFS views with dynamic comparative periods
- Sequential TB upload with balance validation — human error in the input process structurally eliminated
- Multi-currency forex management with Closing, Average, and Historical rate application per line item
- Intercompany elimination and Adjustment JV module with full reconciliation and audit trail
- Budget, Forecast, and GL mapping managed by the finance team through intuitive Upload/Download utilities
Facing a similar challenge?
Let's talk about what's broken in your finance operations. The first conversation is free, focused, and no-pitch.