Cash flow model audit and rebuild — 996 formula errors and a material omission

Reference · Model rebuild · Consolidated cash flow · Six entities · Formal audit report

The situation

A six-entity consolidated cash flow model had been inherited and was being used for reporting. It looked complete. Under the hood it was carrying nearly a thousand formula errors and at least one omission that materially misstated the result.

The work

A full audit of the model surfaced 996 pre-existing formula errors, a logic bug that omitted an owner's balance from the total net balance year-end sum across every cash-flow sheet, and a broken SUM range on the total financing row. The forecast integration was also disconnected from the underlying store-level files it was supposed to pull from.

The resolution

Every error was corrected, the omitted balance was restored to the consolidation, the SUM ranges were rebuilt, and forecast integration was reconnected to the source files. A formal written audit report documented every fix so the rebuild was reviewable rather than a black box.

Why it matters

A model that's used for ownership reporting and capital decisions has to be right, and "it returns a number" isn't the same as "it's correct." Material omissions in a consolidation don't announce themselves — they require someone willing to audit formula-by-formula and document what they found.

Relying on a model nobody has audited line by line? Get it reviewed →