Chapter 4 — When aggregation destroys the analytical path

A situation I know well

There are scenes I've lived through more than once. The numbers are out. The reporting is ready. The close went well. The meeting starts, the indicators scroll by, and then, at some point, something doesn't add up. We were ahead last month. This month, we're behind YTD versus the forecast. And yet, the month that just went by isn't catastrophic in any way. The question comes. Sometimes from the CEO. Sometimes from an operational director under pressure on their targets.

"What's really driving this gap?"

It isn't an attack. It's a legitimate question. But at that precise moment, I already know what's at play.

Why aggregation is necessary

After these meetings, there is always a moment of stepping back. A moment when I remind myself why, despite everything, we do things this way. Raw financial data isn't usable.

It comes in the form of thousands of lines, of entries, of isolated movements. At that level, there is no reading and no steering possible. If I put this data on the table as it is, no one could draw anything from it. Not management. Not the operational teams. Not me.

So, like every finance team, we aggregate. We group entries by account. We consolidate by entity, by supplier, by type of expense. We turn an unmanageable volume into something readable. That is when the P&L starts to exist. When trends appear. When the discussion becomes possible.

I have never seen a finance team aggregate out of laziness. We aggregate because we need to step back. Because we have to put the numbers out under constrained deadlines. Because we have to give a vision that is understandable, shareable, defensible.

Without this aggregation, there is no common language. No basis for discussion. No steering.

What aggregation makes disappear

As you aggregate, you move away from the detail. It isn't a conscious choice. It's a side effect. You move from entries to accounts. From accounts to categories. From categories to broad totals. Each step makes the reading simpler. But each step also puts a little more distance between you and what really makes up the number.

In the moment, it isn't visible. The P&L is clear. The totals are consistent. Nothing seems to have been lost. And yet.

When the moment comes to finely understand a variance, I realize I can no longer simply drill back down into the number. The link still exists somewhere, but it is no longer direct. It is no longer carried by the system itself.

When the system works… until it stops working

As long as the questions stay within the expected framework, the system works. But as soon as a question strays slightly off the expected path, I know almost immediately: the system won't keep up. I can no longer start from the displayed number and naturally unfold the reasoning down to the data.

So I rebuild. I go back to the extractions. I redo the groupings. I reapply the adjustments. Each analysis becomes a special case. Each question follows its own path.

The system isn't wrong. It is simply optimized to answer the questions it already knows.

Why finance keeps recreating files

When the system no longer allows exploration, you have to create a space elsewhere.

So I open a file. I rebuild a view tailored to the question. This file works. It allows the question to be answered. But it is specific. It can't be reused as is.

Over time, these files accumulate. They carry valuable knowledge. But fragile knowledge.

It lives in the files. And above all in the people.

The real cost: rebuilding the analysis

The real cost doesn't show up right away. It is the time spent rebuilding. The mental fatigue. The analyses you postpone. The questions you stop asking. Gradually, autonomy recedes.

I depend more on people, less on the system. And the longer this situation lasts, the harder it becomes to question.

What is really at play

The problem isn't aggregation. It isn't the team. It isn't the tool. It is the chain of effects.

The data is aggregated to be readable. The analysis becomes hard to take apart. It moves outside the system. Then into the people. The numbers keep coming out. But the capacity to explore shrinks.

The question is no longer only how to produce the numbers, but what the system allows — or prevents — you from understanding.