Reports that last
Five hundred spreadsheets, two clicks: a report that outlives its builder
Why one clear report beats hundreds of spreadsheets, why the report is never the point, and how to make the savings last after the project ends.
Imagine about 500 spreadsheets. Each has its own layout, its own formulas, its own owner. Putting them in one place sounds impossible. It is hard. It is not impossible.
The report is never the point
A report that shows the same numbers faster is just a nicer spreadsheet. A useful one does something spreadsheets cannot: it makes every euro answer for itself. For each cost you can see what it bought, who approved it and what came back. That changes the talk in a budget meeting from "we spent €1.2M on this" to "we spent €1.2M and here is what we got".
That is the test for any finance report: does it only show the spending, or does it make the spending explain itself?
How to build one
- One person builds, the team feeds it. Someone brings all the files into one shape. Someone builds the report and checks it against the real accounts before anyone sees it, so people trust it.
- Start with the ugliest question. Not "how are sales?" but "where did the money go, by supplier, by month, compared with the plan?" That view finds money.
- Show what came back, not only what was spent. Spending with no result is a cost. Spending with a result is a decision.
- Launch before it is perfect. Start with a few budgets, then add more. Waiting for perfect means never.
The part most projects skip
Teach the people who will use it to run it without you. A saving that depends on the person who found it is not a saving. It is a delay.
A saving that depends on one person is not a saving. It is a delay.
That is why every job I do has a third step after finding and winning back: keeping it. The report stays with you, your team runs it, and every three months I check that nothing crept back.
If you are an owner thinking about this
You do not need a big programme. You need 12 to 24 months of accounts, supplier and shop-deal records, one person who knows where to look, and a simple report everyone in the room can read. The tool is the cheapest part.