A consolidated financial report is only as useful as your ability to understand what is behind it. When a balance is higher than expected, or when a variance appears that management wants explained, the question is always the same: what is actually driving this number? In a multi-entity context, that question is harder to answer than it sounds. The consolidated figure is a composite of contributions from multiple entities, multiple account groupings, and potentially multiple currencies — and unpicking it, in most finance teams, means exporting to Excel and building your own analysis from scratch.
BrizoConsol’s enhanced drill-down is designed to make that exploration happen inside the platform, in seconds, without any exports required.
Why Drill-Down Matters More in Multi-Entity Reporting
In a single-entity business, a balance on the P&L or balance sheet can usually be traced to its source relatively quickly. The chart of accounts is familiar, the volume of transactions is manageable, and the finance team has direct visibility into what has been posted. In a group environment, none of that is true. A consolidated revenue figure might aggregate contributions from six entities across three currencies, some of which have been translated at average rates and some at spot rates. A balance sheet movement might reflect a combination of operating activity, intercompany transactions, and currency translation effects.
When management asks why a number looks the way it does, the finance team needs to be able to answer that question quickly and with confidence. The longer it takes to trace a consolidated figure back to its underlying components, the slower the reporting cycle becomes — and the more likely it is that the explanation gets assembled under pressure, with the risk of errors that undermine credibility.
Better drill-down does not just make reporting faster. It makes it more defensible.
What Is New in BrizoConsol’s Drill-Down
The latest update to BrizoConsol’s reporting engine brings three meaningful improvements to how finance teams can explore consolidated data.
Summary Totals and Percentage Breakdowns
When you drill into a consolidated balance, the updated view now shows not just the raw figures from each entity or account, but also their share of the total as a percentage. This is a small change that has a significant practical impact. Instead of mentally calculating what proportion of a revenue figure comes from the Singapore entity versus the Hong Kong entity, you can see it immediately. Percentage breakdowns are particularly useful when you are explaining movement to management — the story of “Singapore grew its contribution from 38% to 47% of group revenue” is clearer and more communicable than two absolute figures sitting side by side.
Formula-Driven Report Cells
Report cells in BrizoConsol can now be formula-driven, meaning they compute derived metrics directly rather than simply pulling a raw balance. This is particularly valuable for profitability analysis — gross margin percentages, operating leverage ratios, or period-over-period variance calculations can now live inside the report itself, updating automatically each time the consolidation runs. Finance teams that previously built these calculations in a separate Excel model can now have them embedded in the platform, reducing the risk of the model getting out of sync with the underlying data and eliminating one more manual step from the reporting workflow.
Historical Balance Fallback
One of the practical challenges of multi-entity reporting over time is that the structure of the group changes. Entities are added or reorganised, charts of accounts are updated, and account mappings evolve. Without specific handling for this, drilling into a prior period can produce misleading results — the current structure is applied to historical data, and the figures do not match what was reported at the time.
BrizoConsol’s historical balance fallback solves this by ensuring that when you drill into a prior period, the correct structure for that period is used. The figures you see reflect what was actually in the system at the time, not how the current chart of accounts would classify those balances today. This matters enormously for year-over-year comparisons, audit reviews, and any situation where management wants to understand how the group has evolved over time.
How to Use It
The drill-down experience in BrizoConsol is designed to require no training. From any report — P&L, balance sheet, or custom — you click on any figure to expand it. The first level typically shows entity contributions. Clicking further reveals account-level detail. Clicking again shows individual journal lines. At every level, the percentage breakdowns and formula-derived metrics are present, giving you the analytical context alongside the raw data.
Because the entire drill-down happens within the platform, there is no export step, no risk of the analysis becoming disconnected from the source data, and no version control problem when multiple people need to review the same figures. The analysis is live, shared, and always current.
Less Time Explaining, More Time Deciding
The value of faster variance analysis is not just efficiency — it changes how finance teams engage with management. When it takes three hours to explain a balance sheet movement, the conversation is about the process of finding the answer. When it takes three minutes, the conversation can be about what the answer means and what to do about it. That is a different and more valuable role for a finance team to play.
BrizoConsol’s enhanced drill-down, formula support, and historical balance fallback are all available now across all reports. If you have been doing your variance analysis in Excel, log in and try clicking through a consolidated balance — the difference is immediate.