Stork Delivery
Why three dashboards disagree about revenue
Before rebuilding a report, agree on what the number means, which records it includes, and when it becomes final.
The problem: matching labels conceal different business definitions
Sales has one revenue number. Finance has another. The operations dashboard shows a third. All three may be correctly calculating different things.
One report counts accepted orders. Another counts issued invoices. A third counts payments received. Calling each number “revenue” does not make them comparable.
Before fixing the dashboard, agree on the question it is supposed to answer.
A practical approach
Define the measure in ordinary language
Write a short definition that someone outside the reporting team can understand. Specify the event being counted, the date used, and the treatment of adjustments.
For an operational order measure, that might mean accepted orders during the period, excluding canceled orders and showing returns separately. Finance may need a different measure for its own purpose. Keep both if both are useful, with labels that explain the difference.
Do not turn an engineering choice about available fields into an accounting policy. The relevant business owner should approve the meaning.
Follow the record through its changes
An order can be entered in January, shipped in February, and adjusted in March. Decide which reports change when the adjustment arrives.
A historical report that silently restates prior periods can confuse users who saved an earlier version. A report that never updates can preserve errors. Choose the behavior deliberately and make it visible.
Time zones and cutoff times also matter. A late-night transaction may fall into different reporting dates if two systems use different conventions.
Build a small reconciliation
Take a manageable period and compare the underlying records, not just the headline totals. Identify missing IDs, duplicates, excluded statuses, and differences in amounts.
Group the differences by cause. A missing integration update needs a different fix from a disagreement over how returns should be counted.
Keep this reconciliation repeatable. If the only person who can explain the numbers needs an afternoon of manual work each month, the process remains fragile.
Show freshness and ownership
Tell readers when the report last refreshed and who owns its definition. Distinguish a complete period from one still receiving data.
A dashboard earns trust when people can trace a number back to its records and understand why another view differs. Better charts can help communication, but reliable data and definitions do the underlying work.
The result: numbers that users can reconcile
Take one disputed measure and publish its definition, source, cutoff, adjustment rules, and owner. Compare a small period record by record until every material difference is explained or assigned for correction. Success may mean keeping two distinctly labeled measures. Begin the next reporting review with that comparison so discussion can move from arguing over totals to deciding what the numbers mean.