A financial report looks simple from the outside: a PDF in an inbox, a set of charts in a board pack. What’s less visible is the process that produced it — the data collection, the adjustments, the review cycles, the back-and-forth between finance and the entities before a number is confirmed. For multi-entity businesses especially, that process is where most of the time, effort, and risk actually live.
This is the full journey of a financial report, from the moment data collection begins to the decisions it eventually drives — and what can go wrong at each stage.
Stage 1 Data Collection and Period Close
Every financial report starts with the same prerequisite: the books need to be closed. For a single entity, this means confirming that all transactions for the period are posted, accruals and prepayments are journaled, and the trial balance is reconciled to the underlying ledgers.
For a multi-entity group, the same process needs to happen in every subsidiary — often across different time zones, different accounting software, and different finance teams with different close disciplines. The consolidated report can only be as timely as the slowest entity.
🚩 Where this breaks down: One entity submits a trial balance with an unresolved suspense balance. Another posts a large journal entry after the agreed cutoff. A third uses a slightly different period-end date. Each of these pushes the consolidated close — and any decisions depending on it — further out.
✅ What good looks like: A group-wide close calendar with hard deadlines by entity, a single agreed set of exchange rates circulated before close, and a clear rule on what constitutes a post-cutoff entry. The close process is only as fast as its most constrained step — removing that constraint at each entity is the lever.
Stage 2 Consolidation Adjustments
Once entity data is in, the consolidation adjustments begin. This is the most technically demanding stage — and where the most errors accumulate in manual processes.
The main adjustments for a group with foreign subsidiaries:
- Intercompany eliminations: Sales, loans, interest, and dividends between entities need to be matched and eliminated. Both sides of each transaction need to agree in amount — intercompany mismatches (one entity recorded $50,000, the counterparty recorded $49,800 due to FX timing) need to be resolved before the consolidated balance sheet will close cleanly.
- Currency translation: Each foreign entity’s trial balance is translated at the correct rates — closing rate for balance sheet items, average rate for P&L items. The resulting currency translation adjustment goes to equity.
- NCI calculations: For partially-owned subsidiaries, the minority shareholders’ share of net assets and profit is calculated and separated from the parent’s share.
- Group-level journals: Provisions, eliminations of unrealised profit in inventory, and any other group policy adjustments that don’t sit in any individual entity’s books.
🚩 Where this breaks down: In a spreadsheet consolidation, each of these adjustments is a manual step. A rate applied to the wrong column, an elimination posted to the wrong entity, or an NCI calculation that doesn’t update when the subsidiary’s profit changes — any of these produces a balance sheet that doesn’t balance, or worse, one that balances but with the wrong numbers in the wrong places.
Stage 3 Report Build
With the adjusted trial balance in place, the report is built: consolidated P&L, balance sheet, cash flow statement, and any management reporting layers — budget vs actuals, entity comparisons, prior period analysis.
This stage involves two things that are often underestimated: chart of accounts mapping and report structure decisions.
Chart of accounts mapping is the process of linking each entity’s account codes to a common group structure. Entity A uses account 4100 for domestic revenue; Entity B uses 40001; Entity C uses REV-DOM. In the consolidated report, all three need to flow into the same group revenue line. Maintaining this mapping as entities add new accounts — which they do constantly — is an ongoing task that breaks silently when it’s missed.
Report structure determines what the reader sees: which subtotals appear, how operating expenses are grouped, whether EBITDA is shown as a line or derived from the P&L, which comparative columns are included. In a manual process, this structure gets rebuilt or reformatted every period — one of the most time-consuming parts of report production for no analytical value.
💡 The report build stage is where most of the presentation work happens — but it should be the easiest stage if the data and adjustments in stages 1 and 2 are clean. When report build is slow, it’s usually because something upstream wasn’t resolved.
Stage 4 Review and Sign-Off
Before a report reaches any decision-maker, it needs to be reviewed — and that review is rarely a single pass. A finance controller checks the mechanics: does the P&L reconcile to prior period plus movements? Does the balance sheet balance? Does the movement in cash reconcile to the opening and closing cash balance on the balance sheet?
Then comes the analytical review: are there numbers that look unusual compared to prior periods or budget? Each anomaly generates a query — sent to the relevant entity finance contact, who needs to respond before the report can be signed off.
This is where close timelines stretch. Each query that comes back with “I’ll check and get back to you” adds a day. Each revised trial balance submitted after queries reopen the consolidation adjustments. In a complex group, three or four rounds of queries between consolidation and sign-off is not unusual.
✅ What good looks like: A structured review checklist that covers the same reconciliation points every period, reducing the time spent deciding what to check. Commentary templates where entity finance teams explain significant movements before submission — so queries are answered before they’re asked.
Stage 5 Distribution
A report that’s complete but not distributed is worthless. Distribution sounds simple — send the PDF — but in practice it involves deciding who gets what, in what format, and at what level of detail.
A board gets the consolidated pack with group-level P&L, balance sheet, cash flow, and KPI commentary. A subsidiary controller gets the entity-level report. A department head gets the relevant segment of the P&L. The same underlying data, presented differently for different audiences.
Scheduled delivery — reports that go out automatically at a set time each month — removes the manual step and ensures no stakeholder is waiting on someone to remember to send the file. It also means the report arrives when it’s expected, which builds trust in the process over time.
Stage 6 Decision and Action
This is the only stage that actually matters — everything before it exists to make this stage possible. A financial report that produces no decision or action has consumed resources without generating value.
The decisions a well-produced report drives are specific: a budget is reallocated, a cost is investigated, a subsidiary’s pricing is reviewed, a hiring plan is approved or deferred, a financing decision is made with full visibility of group leverage. These are not abstract strategic moves — they are concrete operational choices made by people who trust the numbers in front of them.
That trust is earned at every prior stage. A report that arrives late, contains a known error, or requires significant interpretation before it can be read rarely drives confident decisions. Finance teams that invest in making stages 1 through 5 clean and repeatable are investing in the quality of decisions made from stage 6 — which is where the actual return on that investment appears.
BrizoConsol is built to compress stages 1 through 5 — connecting directly to entity accounting systems, automating consolidation adjustments, maintaining chart of accounts mappings, and delivering reports on schedule — so stage 6 happens faster and with more confidence. Learn more or see it in action →