Skip to content
Reports & decisionsBy BI Forge · Business guide

Three departments. Three sales numbers. Which one is right?

Marketing says sales were strong. Operations reports a different total. Finance has a third answer. The meeting moves away from what to do next and turns into a debate about whose spreadsheet is correct.

THE SHORT ANSWER

Sales reports often disagree because they use different dates, returns, discounts or definitions. Agree on the business rule and trace the same transactions before deciding that a report is wrong.

A label like “sales” is not a complete definition

Does it mean orders placed, orders paid, goods shipped or revenue after refunds? Does it include tax or delivery charges? Which date decides the month? Two careful people can produce different totals if those choices are different.

Several totals can coexist

Here is one simplified example using the same measurement basis and a defined period.

Question being answeredIllustrative total
How much was ordered?$120,000
How much was paid?$108,000
How much paid sales remained after refunds?$100,000

Illustrative example, not a reconciliation of every possible accounting or payment event. Real systems may also differ in tax treatment, timing and other rules.

The totals alone do not prove someone made a mistake. They may describe different stages. The useful task is to name those stages and show the bridge between them.

Give the important number a short instruction sheet

You do not need a large technical document to start. For each disputed metric, record a few concrete rules.

  • What business question does the number answer?
  • What is included and excluded?
  • Which date and time zone determine the period?
  • Which source provides it, and how current is it?
  • Who is responsible for explaining a discrepancy?

Fix one disagreement before adding more charts

Choose a number that repeatedly delays a decision. Trace it to the source, compare the rules and agree on a definition. Keep alternative views where they serve a real purpose. A useful report makes the differences understandable and gives the team a stable basis for discussion.

Make it specific to your business

A useful first step with BI Forge.

BI Forge can help trace the important metrics to their sources, agree definitions and create a repeatable reporting view. A focused start is one disputed number and the decision it should support.

Discuss consistent reporting
Start with the question. Scope and implementation are agreed together.