For accountants and finance managers supporting multi-entity clients or complex business groups, group reporting is one of the most time-consuming and error-prone tasks on the monthly calendar. Pulling trial balances from multiple accounting systems, mapping each entity to a common structure, eliminating intercompany transactions, adjusting for currency differences, and then assembling everything into a single coherent set of financials can take days rather than hours. And the moment a client updates a figure or an entity switches accounting platforms, the process often has to start again from scratch. This guide is written specifically for accountants who are ready to replace that manual cycle with a structured, repeatable, and largely automated approach.
The challenge is not that accountants lack skill. It is that traditional tools were never designed for this job. General ledger software is built to manage a single entity. Spreadsheets are flexible but fragile. And while enterprise consolidation platforms exist, they are typically priced and configured for large listed companies with dedicated finance technology teams. Practices and finance functions supporting growing groups have historically fallen into a gap between tools that are too simple and tools that are too complex. BrizoConsol was built specifically to close that gap, offering accountants a structured consolidation and reporting environment that does not require a systems implementation or specialist training to operate effectively.
Understanding What Group Reporting Actually Requires
Group reporting is distinct from individual entity reporting in several important ways. When you consolidate a group, you are not simply adding numbers together. You are combining the financial results of legally separate entities into a single view that reflects the economic reality of the group as a whole. That means removing the effects of transactions between entities within the group, such as intercompany loans, intercompany sales, management charges, and dividend payments. It means translating foreign currency balances into a single presentation currency using the correct exchange rates. And it means applying consistent accounting policies across entities that may be using different methods locally.
Before any of that can happen, you need clean data from each entity in the group. In practice, this is often the hardest part. Entities may use different accounting platforms, different chart of accounts structures, different fiscal period definitions, and different levels of bookkeeping quality. The accountant responsible for the group consolidation must gather all of this data, map it into a consistent structure, identify and correct errors, and only then begin the consolidation process itself. Without a purpose-built tool, each of these steps requires manual effort, and each step introduces the risk of introducing errors that will need to be found and corrected downstream. BrizoConsol addresses this by providing a structured import and mapping layer that absorbs the inconsistencies between entities and presents a clean, consolidated foundation to work from.
Setting Up a Common Chart of Accounts
One of the most important decisions an accountant makes when setting up a group reporting structure is how to handle the chart of accounts. Each entity in the group may have its own local chart of accounts, shaped by its accounting platform, its industry, or the preferences of whoever set it up. For consolidation purposes, these need to be mapped to a single common structure that allows the group financials to be presented coherently. This common chart of accounts does not replace the local charts used by individual entities. It sits above them as a reporting layer, and each local account is mapped to the appropriate common account so that the consolidation can aggregate balances correctly.
BrizoConsol’s AI Auto-Map feature significantly reduces the time this step takes. When you import a trial balance from an entity, the system analyses the account names and structures and suggests mappings to the common chart of accounts automatically. An accountant reviews and confirms those suggestions rather than building the mapping manually from scratch. For groups where entities share similar accounting platforms or business models, the AI-suggested mappings are highly accurate, and the review process takes minutes rather than hours. For more complex or unusual account structures, the accountant retains full control to adjust mappings as needed, and those adjustments are remembered for future imports from the same entity.
Handling Intercompany Eliminations Correctly
Intercompany eliminations are at the heart of the consolidation process, and they are also the area where manual approaches most commonly break down. When one entity in a group sells goods or services to another, both the revenue in the selling entity and the corresponding expense in the buying entity must be removed from the consolidated financials. When one entity lends money to another, both the intercompany receivable and the corresponding payable must be eliminated. When one entity pays a management fee to a parent company, both the charge and the income must cancel out. If these eliminations are not performed, the group financials will overstate both revenue and costs, and the balance sheet will show assets and liabilities that do not exist at a group level.
In practice, intercompany eliminations require accurate data from both sides of each transaction, and the two sides are rarely in perfect agreement. Timing differences, currency translation differences, and simple bookkeeping errors mean that intercompany balances frequently do not match exactly. BrizoConsol provides an intercompany elimination module that brings both sides of each transaction together, highlights mismatches, and allows the accountant to investigate and resolve them before the elimination is posted. For groups with regular, predictable intercompany transactions, BrizoConsol also supports auto-elimination rules that identify and eliminate recurring transaction patterns without manual intervention each month. This transforms a process that might previously have taken an afternoon into one that takes minutes, with a clear audit trail showing exactly what was eliminated and why.
Managing Foreign Currency in a Multi-Currency Group
For groups with entities operating in different currencies, the consolidation process must also handle the translation of foreign currency balances into the group presentation currency. The rules for this are well established under both IFRS and local GAAP frameworks: assets and liabilities are translated at the closing rate at the balance sheet date, income and expenses are translated at an average rate for the period, and equity items are translated at historical rates. The difference that arises from applying these different rates is accumulated in a separate equity reserve known as the cumulative translation adjustment. Managing all of this correctly in a spreadsheet environment requires careful construction and maintenance of currency translation worksheets, and errors are easy to introduce and hard to detect.
BrizoConsol handles multi-currency translation automatically once the entity’s functional currency and the group’s presentation currency are defined. Exchange rates can be entered manually or pulled through for each reporting period, and the system applies the correct translation method to each balance type automatically. The cumulative translation adjustment is calculated and presented as part of the equity reconciliation without any manual workings. For accountants supporting international groups, this alone represents a substantial reduction in both the time required and the risk of error in the consolidation process. The result is a set of consolidated financials that correctly reflects the currency composition of the group and provides a clear and auditable record of how foreign currency movements have been handled.
Delivering Reports to Clients and Stakeholders
Producing the consolidated financials is only part of the job. The output needs to reach the right people in the right format at the right time. For accounting practices, this typically means delivering a set of management accounts or board pack to the client, often on a monthly or quarterly basis. For in-house finance functions, it means distributing reports to divisional managers, board members, investors, and other stakeholders who may need different levels of detail and different cuts of the data. In a manual environment, this distribution step is typically performed by exporting spreadsheets or PDFs and sending them by email, often with version control problems and no way to verify that recipients are looking at the most current figures.
BrizoConsol’s Insight Package feature addresses this directly. An Insight Package is a defined set of reports and dashboards that is assembled once and then delivered automatically on a scheduled basis. The accountant configures the package once, defining which reports it contains, which entities and periods it covers, and which recipients should receive it. After that, the package runs automatically at each reporting cycle, generating a fresh set of outputs from the latest consolidated data and delivering them to the defined recipients without any manual intervention. For practices managing multiple clients, this means the month-end report delivery process can run in parallel across all clients simultaneously rather than requiring the accountant to manually produce and send each client’s reports in sequence. The time saving across a portfolio of multi-entity clients can be substantial, and the consistency and reliability of the output improves at the same time.
Making Group Reporting a Repeatable Process
The most important shift that accountants can make in their approach to group reporting is to treat it as a process rather than a project. When consolidation is done manually, it tends to be approached fresh each month, with the accountant working through the same steps in roughly the same order but without a formal structure that ensures consistency and completeness. This means that the quality of the output depends heavily on the individual doing the work, and it is difficult to delegate or scale. When consolidation is built on a structured platform like BrizoConsol, the process becomes defined and repeatable. The entity setup, the chart of accounts mappings, the intercompany elimination rules, the currency settings, and the report templates are all configured once and then applied consistently each period.
This repeatability has several practical benefits. It makes the process easier to delegate, because a newer team member can follow a defined workflow rather than having to reconstruct the process from memory or from undocumented spreadsheets. It makes the output easier to audit, because there is a clear and transparent record of every step in the consolidation. And it makes the process scalable, because adding a new entity to the group or onboarding a new client does not require building a new consolidation model from scratch but simply extending an existing structured framework. For accountants who are serious about building a group reporting service that can grow with their clients, a purpose-built consolidation platform is not a luxury. It is the foundation that makes the service sustainable and reliable over time.