Trial-balance and transaction-level consolidation are two approaches to preparing consolidated reports for a corporate group. The main difference is what sits behind the reported figures. Trial-balance imports provide account totals; transaction-level imports retain the individual entries, enabling detailed analysis, greater transparency, and rules-based automation.
Trial-balance consolidation uses account totals from each company. Additional information is often needed to calculate intra-group eliminations and currency translation, such as intercompany transactions and balances, equity and investment movements, and relevant transaction dates and exchange rates. Finance teams may need to collect and process this detail separately in spreadsheets.
Transaction-level financial consolidation for multi-entity groups uses detailed general ledger data to automate validation, currency translation, and intra-group eliminations through configured rules. Finance teams can drill down from consolidated figures to the underlying transactions and consolidation entries, making the results easier to understand and verify.
What is a Trial Balance?
In a corporate group, each individual company or accounting entity can produce a trial balance: an accounting report, rather than a set of financial statements. It contains a list of the balances in an individual company’s general ledger at a specific point in time. It can feature balances for accounts such as revenue, cost of sales, salaries, rent, cash, accounts receivable, accounts payable, inventory, fixed assets, and so on.
Each entity in a corporate group produces its trial balance using its own reporting practices and software. Often in multi-entity organisations, the accounting system, chart of accounts, and currency differ from one company to another. This is especially true for international corporate groups whose entities are spread all over the world. This can make consolidation particularly difficult and highlights the importance of using consolidation software that supports the group’s reporting requirements.
In trial-balance-only consolidation, the imported totals contain no underlying transaction detail. When an intercompany balance does not match or a figure needs explaining, finance teams often request additional schedules and reconcile the detail in spreadsheets. Some elimination and currency-translation calculations may also require supporting data and spreadsheet work, depending on the software and data available. TB-based tools can automate these processes, but account totals alone cannot explain individual transactions.
What is Transaction-Level Consolidation?
Transaction-level consolidation uses detailed general ledger entries imported from different ERP and accounting systems across the group. In transaction-level consolidation software, finance teams can drill down from consolidated figures to transactions, legal entities, partners, dimensions, and original and reporting-currency amounts. This makes it easier to identify what caused a fluctuation or mismatch and review the source data alongside consolidation entries within the same system.
To consolidate accurately, all information must be standardised. This means that local accounts and reporting dimensions are mapped to the group structure, accounting policies are aligned, and financial information is translated into the group’s reporting currency where required. Once the data is prepared, consolidation rules automatically eliminate intra-group transactions and balances and apply other configured consolidation adjustments. Both the source transactions and consolidation entries remain visible through drill-downs, providing transparency behind the consolidated results. Finance teams can investigate exceptions directly in the system, reducing repeated data requests and manual spreadsheet work.
Trial-Balance vs. Transaction-Level Consolidation
Both approaches report the group as one economic entity. The practical difference is how much work finance teams must do to explain, reconcile, and analyse the results after the totals have been produced.
Transaction-level consolidation combines automation with visibility: finance teams can examine the transactions and eliminations behind consolidated figures and analyse results by available dimensions, such as projects, products, or cost centres. Instead of repeatedly collecting supporting detail, they can use the data already in the system. This supports faster explanations, less manual work, and clearer oversight of group reporting.

Leave a Reply