Cookies on this site
This site uses cookies to improve browsing experience and analyse traffic. Choosing to accept allows all cookies to be stored on your device.
A holding company with five operating entities once produced seven different versions of its monthly management report — each prepared by a different person, from a different data source, using a different template. The CFO spent the first two hours of every board meeting explaining why the numbers on slide three did not match the numbers on slide seven. The explanation was always plausible. The underlying problem was never a data problem. It was a process problem — and a process problem with a specific, identifiable structure.
Financial reporting consolidation fails in predictable ways. The failure modes are not random — they follow from specific choices made about data sources, report ownership, and the sequence in which figures are assembled. Understanding those patterns is the starting point for building a consolidation process that produces consistent outputs.
Most consolidation problems originate not in the report itself but in the data sources feeding it. When the same figure — a revenue number, a cost allocation, an intercompany balance — is pulled from different sources by different people, the outputs will rarely agree. The reasons are mundane: different extraction dates, different treatment of pending transactions, different rounding conventions. None of these are errors in the conventional sense. They are the natural consequence of pulling data from multiple places without a defined single source of truth for each input. The first layer of a consolidation process review examines which data points are currently drawn from more than one source and establishes a primary source for each. That decision — often made in a single working session — removes a category of reconciliation work that might otherwise recur every reporting cycle.
Once data sources are standardised, the sequence in which figures are assembled into the report becomes the next point of risk. In many consolidation processes, figures are assembled in parallel — different team members building different sections of the report simultaneously, with a final step that combines them. The problem with parallel assembly is that the final combination step often reveals inconsistencies between sections that require reconciliation — reconciliation that happens under time pressure at the end of the process, when the report is already overdue. A sequential assembly process, where each section is completed and verified before the next begins, reduces the number of reconciliation surprises at the end. It also makes it easier to identify which step introduced a discrepancy if one is found.
Consolidation processes that are owned by a team rather than a named individual tend to produce reports of variable quality. When everyone is responsible, no one is specifically responsible — and the decisions that require judgment, such as how to treat an unusual transaction or how to present a significant variance, get made inconsistently from month to month. Assigning named ownership to the consolidation process — not to the entire report, but to the process by which it is assembled — creates a single point of accountability for consistency. The owner is not necessarily the most senior person on the team. They are the person with the clearest understanding of the assembly sequence and the authority to enforce it.
The final layer of a consolidation process is the review step — the point at which someone checks the assembled report before it is distributed. In many organisations, this step is either too light or too late. A light review catches obvious formatting errors but misses substantive inconsistencies between sections. A late review — conducted after the report has already been sent to some recipients — is effectively a correction process rather than a quality control step. A well-designed review layer defines what specifically is checked, in what order, by whom, and by what deadline relative to the distribution date. It is not a general instruction to review the report for errors. It is a structured checklist applied to the specific risk points that past experience has shown are most likely to produce inconsistencies in this organisation's reporting process.
This site uses cookies to improve browsing experience and analyse traffic. Choosing to accept allows all cookies to be stored on your device.