Deeper Financial Drill-Down: From Consolidated Balance to Transaction in Seconds
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.
Automate NCI calculations across all your entities.
BrizoConsol handles non-controlling interest automatically — no manual adjustments required.
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.
| Feature | What it does | Why it matters |
|---|---|---|
| Summary totals and percentage breakdowns | Shows each entity or account’s share of the consolidated total as a percentage alongside the raw figure | Immediately surfaces which entities are driving a movement — no mental arithmetic required |
| Formula-driven report cells | Report cells compute derived metrics (margins, ratios, variances) directly inside the platform | Gross margin %, operating leverage, and period-on-period variances update automatically with each consolidation run |
| Historical balance fallback | Drill-down into prior periods uses the structure that was in place at that time, not today’s chart of accounts | Prior-period comparisons reflect what was actually reported — essential for audit reviews and year-on-year analysis |
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 requires no training. From any report — P&L, balance sheet, or custom — the path works as follows:
- Click any consolidated figure — expands to show each entity’s contribution to that balance, with percentage breakdowns alongside the raw amounts
- Click an entity’s contribution — expands to account-level detail, showing which accounts within that entity are driving the figure
- Click any account balance — shows individual journal lines, with dates, descriptions, and amounts from the source accounting system
At every level, formula-derived metrics and percentage breakdowns are present, giving you analytical context alongside the raw data. Because the entire drill-down happens within the platform, there is no export step, no version control problem, and no risk of the analysis becoming disconnected from the source data.
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.