Why your reports disagree, and how to get one set of numbers

It is the first week of the month. Sales says revenue was one number. Finance says another. Operations has a third. Someone spends days building a spreadsheet to explain the difference, and by the time it is ready, the numbers are out of date.

This is very common. The good news is that it can be fixed.

Why reports disagree

There are usually four reasons:

• Different definitions. Does "a sale" mean when the order is placed, when it is paid or when it is delivered? Each team may count differently.
• Different systems. Your shop, your accounts package and your CRM each keep their own copy of the data.
• Copying by hand. Every time data is exported and pasted, mistakes can creep in.
• Different timing. One report was run on Monday, another on Wednesday.

Step 1: Start with the questions, not the data

Ask leaders which questions they need answered every week. For example: "How much did we sell, and where?" or "Which customers have not ordered in 60 days?" Then ask what they would do with each answer. Focus on the questions that lead to decisions.

Step 2: Agree the meaning of each number

Write down what each key number means, in one sentence. For example: "Revenue = paid orders, minus refunds, by payment date." Agree it once, with everyone who uses it. This step alone often ends most arguments.

Step 3: Collect the data automatically

Instead of people exporting and pasting, connect your systems so the data is copied automatically, every night or every hour, into one reporting database. Fewer manual steps means fewer mistakes.

Step 4: Build simple dashboards

A dashboard is a screen that shows your key numbers, always up to date. Build one for each team, showing only what they need. Keep it simple: a few clear numbers beat fifty charts.

Step 5: Check the data keeps being right

Add simple checks that warn you when something looks wrong, for example when a day has no orders or a figure suddenly doubles. Problems are caught in hours, not at the end of the month.

A bonus: your data is ready for AI

AI tools can answer questions about your business, such as "which products sold best in the North last quarter?". But they are only as good as the data they can read. The same clean, organised data that fixes your reports also gives AI correct facts to work from.

Where we help

Our data and analytics work brings your data together, agrees the definitions with your team, and builds dashboards that update themselves. When the data needs to move between systems first, our integration and automation work connects them.