Copyable cycle worksheet
Time one reporting cycle from request to decision.
| Stage | What to record | Example evidence |
|---|---|---|
| Collect | Sources and people needed | Two exports, one spreadsheet, one delayed reply |
| Repair | Cleanup and reconciliation time | Renamed values, missing dates, duplicate accounts |
| Verify | Questions needed before sharing | Manager checks a changed pipeline total |
| Explain | Follow-up after publication | Why two dashboards disagree or a number moved |
Cost model
Measure the whole reporting loop, not only the final build time.
A report can take thirty minutes to assemble after five hours of preparation. If you only measure the last step, the business case for fixing it looks weaker than it really is.
Collect
Time spent exporting, requesting, chasing, and gathering data from different places.
Clean
Time spent deduplicating, renaming fields, filling gaps, and correcting obvious errors.
Explain
Time spent defending numbers, answering source-of-truth questions, and clarifying what changed.
The unit that actually matters
The useful unit is a reporting cycle.
Count one weekly, monthly, or campaign reporting cycle from the first data request to the final decision. If the report does not support a decision, that is a separate signal.
Time
Hours per cycle
Add collection, cleanup, checking, formatting, and explanation. Do not only count dashboard assembly.
People
Who touches it
A report that looks cheap for one person may actually pull three people into small recurring interruptions.
Delay
How late decisions become
If a report is only trusted after a cleanup pass, the business pays in both labour and slower response.
Measurement steps
Use this lightweight measurement before rebuilding reporting.
The point is not to shame manual reporting. Manual reports are often the right first version. The problem starts when the same repair work repeats after the report is already important.
01
List the sources
Write down every tool, export, sheet, message, and person required before the report can be created.
02
Time each segment
Use ranges if exact time is unavailable. A rough but honest estimate is better than pretending the work is free.
03
Mark trust checks
Every "can someone verify this?" moment is part of the cost because it proves the report is not self-explanatory enough.
04
Tie it to a decision
If the report does not change staffing, prioritisation, client action, or workflow design, ask why it exists.
What the number reveals
Most teams are surprised by how much of their reporting cost is not data work. It is explanation work.
A small share is pulling and formatting the data. The large share is explaining why a number looks the way it does, why it changed since last month, and why two dashboards disagree.
Average annual cost
Gartner research found that poor data quality costs organisations an average of $12.9 million per year. For most teams, the reporting cycle is where that cost is most visible, not as a single line item, but as accumulated hours of cleanup, correction, and explanation before anyone acts on the numbers.
Source: Gartner, "How to Stop Data Quality Undermining Your Business" (2021)
Decision point
A report is expensive when the team has to rebuild trust every time it is opened.
The best reporting systems reduce recurring explanation. They make the source, state, and next decision clearer without adding another weekly cleanup ritual.
The explanation cost compounds once the numbers themselves lose trust.
Why teams stop trusting dashboards ->Measure one reporting cycle.
Bring the report, its sources, and the last time someone had to clean or explain it. That is enough to price the manual loop.
Bring the page, report, or workflow as it is now.
We reply with the clearest next step, or an honest no.
