Skip to content
Sudbury Consulting Group
← All posts
2 min read

Reports built by hand: getting to one set of numbers everyone trusts

When reports take days to assemble and two people bring two different figures, the problem usually isn't the data. It's agreement. Here is how to fix it.

In a lot of growing businesses, Monday's management report is built on Friday. Someone exports data from three systems, pastes it into a spreadsheet, fixes what doesn't line up, and sends it round. By the time anyone reads it, it's days old, and if two people built it, they'd probably get two different answers.

Most companies in that position think they have a data problem. Usually they have an agreement problem.

Three systems, three versions of the truth

Revenue in the accounting system doesn't match revenue in the CRM. Job counts in the scheduling tool don't match the timesheets. None of the systems is wrong exactly: they're measuring slightly different things, at slightly different times, under slightly different definitions.

Until the business decides which number is authoritative and what it means, no amount of reporting software will help. It will just show the disagreement faster and in nicer charts.

How to get to one set of numbers

1. Agree what the key numbers mean

Pick the handful of figures that actually drive decisions: revenue, margin by job or customer, cash collected, work in progress, utilisation, whatever matters in your business. For each one, write down exactly how it's calculated and which system it comes from. This is a management conversation before it's a technical one, and it's the step most often skipped.

2. Decide which system is the source for each

Every number should have one home. If customer details live in the CRM, the CRM is the source and everything else reads from it. Two systems that can both edit the same information will drift apart.

3. Connect the systems instead of exporting from them

Once the sources are agreed, the data can flow automatically into one place built for reporting. No more manual exports, no more paste-and-fix, and no more versions that depend on who built the report.

4. Validate automatically

Checks that run on their own (totals that must reconcile, records that must not be missing fields, values that fall outside normal ranges) catch problems before they reach a report, instead of after someone makes a decision on them.

5. Then build the reports

Only now do dashboards make sense. With agreed definitions and clean sources underneath, reports become a view of numbers everyone already trusts, available whenever they're needed rather than once a week.

What changes

The obvious gain is time: the hours spent assembling reports by hand come back. The bigger gain is that decisions get made on current facts instead of last week's estimate, and meetings stop opening with an argument about whose figure is right.

This is the core of our data and reporting work, and it often turns out to be the foundation the other improvements depend on. You can't show a process got faster if you can't measure it reliably.

If your reporting runs on exports and goodwill, tell us about it. The first conversation is free.