Automated financial consolidation means using a dedicated platform to collect entity financial data, apply group accounting rules (COA mapping, intercompany matching, FX translation, elimination logic, ownership structures), and produce consolidated financial statements — with the system handling the mechanical steps that otherwise require manual intervention at every close.
It doesn’t replace the accounting software that each entity uses — Xero, QuickBooks, MYOB, Zoho Books, or any other system — and it doesn’t replace the judgment that finance teams apply to complex accounting questions. What it replaces is the assembly work: the exports, the pastes, the formula maintenance, the cross-referencing, the version management, and the reconciliation of things that should have matched but didn’t.
This post explains how automated consolidation actually works at each step — what the system does, what changes compared to a manual process, and what remains the finance team’s responsibility regardless of the automation layer.
Where Automation Fits in the Reporting Cycle
Automation begins after entity books are closed — after each entity’s accounting team has reviewed its own trial balance and is satisfied the entity-level figures are complete. The consolidation system doesn’t touch the entity’s own records; it reads them.
The consolidation workflow that automation handles sits between two points: entity data ready (entity close complete) and group reports distributed. Everything in between — data collection, mapping, matching, translation, elimination, aggregation, reporting — is where automation replaces manual steps.
How Automated Consolidation Works — Step by Step
1
Data collection via API or structured import Cloud accounting systems (Xero, QuickBooks Online, MYOB AccountRight, Zoho Books) expose their data through APIs — programmatic interfaces that allow other systems to pull data on demand. An automated consolidation platform connects to each entity’s system via a secure OAuth authorisation and pulls the trial balance at a defined point in time. The pull is versioned: if an entity’s books are later adjusted, the system can be re-synced and the consolidation rerun against the updated data. For entities on desktop or legacy systems not accessible via API, trial balance data is imported via a structured Excel template.
What this replaces: logging into each entity’s system, generating a trial balance report, downloading a CSV or PDF, reformatting the data for the consolidation model, and pasting it into the right sheet in the right format.
2
Account mapping to the group chart of accounts Each entity’s accounts are mapped to the group COA — done once and stored persistently. The mapping defines which entity accounts roll into which group lines in every report. When new accounts are added to any entity’s system, the platform flags them as unmapped before the next consolidation run — preventing the silent disappearance of balances into a catch-all that manual models are prone to. AI-assisted mapping suggests classifications based on account names and prior mapping decisions, which the finance team reviews and confirms.
What this replaces: manually checking each entity’s trial balance for new accounts, deciding where they belong in the group structure, and updating the mapping formula or lookup table in the spreadsheet model.
3
Intercompany identification and matching Intercompany accounts — accounts used to record transactions between group entities — are tagged in the group COA. When trial balance data is pulled, any balance in a tagged intercompany account is automatically identified as an intercompany position. The system then matches the two sides of each intercompany balance using counterparty codes and transaction references: Entity A’s intercompany receivable from Entity B is matched against Entity B’s intercompany payable to Entity A. Matched pairs are ready for elimination. Unmatched balances — where the two sides don’t agree in amount, currency, or account — are presented as exceptions for the finance team to investigate before the consolidation runs.
What this replaces: manually cross-referencing each entity’s intercompany schedule against counterparts, identifying mismatches by amount comparison, and emailing entity controllers to investigate differences.
4
FX translation with centrally published rates Exchange rates are published centrally in the consolidation platform — one closing rate and one average rate per currency pair per period, sourced from a named rate provider and applied to all entities simultaneously. Balance sheet items are translated at the closing rate; P&L items at the average rate. The currency translation adjustment — the balancing difference between equity translated at historical rates and equity translated at the current closing rate — is calculated automatically and posted to group equity as a separate OCI component. No entity applies rates from its own bank feed; no entity applies a rate from a different date.
What this replaces: manually maintaining an exchange rate table, applying rates to individual cells in each entity’s trial balance tab, and investigating residuals caused by entities using slightly different rates for the same currency pair.
5
Elimination entry processing Elimination rules are stored in the platform and applied automatically each period: eliminate intercompany revenue against intercompany cost, eliminate intercompany receivables against intercompany payables, eliminate dividend income against subsidiary retained earnings, eliminate investment in subsidiary against subsidiary equity. Rules are configurable — group-level (where a single entry removes both sides) or entity-pair (where the elimination is attributed to specific entities, needed when NCI is present). Every elimination is documented with counterparty, amount, account, and period — forming the elimination schedule that auditors review.
What this replaces: manually posting elimination journals in a spreadsheet, maintaining an elimination schedule in a separate tab, and checking that each elimination entry hasn’t been accidentally overwritten or displaced by another formula.
6
Consolidation and report generation With entity data collected, accounts mapped, intercompany balances matched, rates applied, and eliminations processed, the platform aggregates the group result across the ownership structure — applying ownership percentages to NCI calculations, carrying goodwill and PPA amortisation as consolidation adjustments, and producing the consolidated P&L, balance sheet, and cash flow. Reports are generated from the consolidated dataset and are immediately available for review, with drill-down from any group line to the entity and account detail behind it.
What this replaces: summing entity results across multiple spreadsheet tabs, checking that the balance sheet still balances after eliminations (it often doesn’t, requiring investigation), and rebuilding pivot tables or charts that broke when the data was updated.
What Remains Human
What the system handles
- Pulling entity data on demand
- Applying COA mapping consistently
- Flagging unmapped accounts
- Identifying intercompany balances
- Matching transaction pairs
- Surfacing unmatched exceptions
- Applying exchange rates to all entities
- Calculating CTA
- Applying stored elimination rules
- Generating consolidated statements
- Maintaining the audit trail
What the finance team handles
- Reviewing entity data quality before sync
- Confirming COA mapping decisions
- Investigating and resolving intercompany exceptions
- Publishing the group exchange rate table
- Reviewing elimination entries for completeness
- Writing management commentary
- Making accounting judgments (provisions, estimates)
- Approving the consolidated result before distribution
- Answering management and audit questions
The automation layer eliminates the mechanical steps — data assembly, formula maintenance, reconciliation of predictable mismatches. The judgment steps — reviewing the numbers, investigating anomalies, explaining what drove the movements — remain with the finance team. The time that automation returns is time for these higher-value activities, not a reduction in the finance team’s role.
BrizoConsol automates the consolidation workflow for multi-entity groups — connecting directly to Xero, QuickBooks, MYOB, and Zoho Books, applying group COA mapping, matching intercompany balances, translating currencies, processing eliminations, and generating consolidated reports. Learn more or see it in action →