Explain why revenue reports disagree
Store, ad, and payment reports show different totals.
For teams comparing revenue totals from storefront, payment, accounting, or advertising reports.
What good looks like.
A comparison explains known differences and leaves unresolved amounts visible without forcing unlike measures to match.
- Starts when
- Two reports show different revenue totals for an apparently similar period.
- Accountable owner
- Analytics lead
Where AI could help.
AI could draft an explanation from a completed comparison table. Analysts verify definitions and calculations; attributed revenue must not be relabeled as collected cash.
How the work could move.
A suggested process to adapt to your team. Each handoff needs a clear owner and a visible check.
Capture each definition
Analyst
Record what each source measures, date field, filters, currency, and treatment of discounts, tax, shipping, and refunds.
Ready when: Readers can tell whether the measures are meant to agree.
Align comparable scope
Analytics lead
Build a side-by-side table with original totals and separately calculated comparable subsets.
Ready when: The original reports remain intact and every adjustment has a stated basis.
Trace the residual
Finance or data analyst
List timing, status, attribution, and missing-record differences with source IDs and amounts.
Ready when: Explained adjustments plus the unresolved residual account for the observed difference.
Publish the interpretation
Analytics lead
Write a reconciliation note naming the metric to use for each business question and remaining investigations.
Ready when: The report owners accept the definitions and no unexplained balancing item is hidden.
Explore the setup, checks, and exceptions
Start with your tools.
Use source exports and a comparison workbook with unchanged raw tabs. Keep report filters, timezone, currency, and refresh timestamps beside each total.
When things go wrong.
- Different timezones require an explicit cutoff comparison.
- Settlement totals and order totals may legitimately differ in timing and content.
- If a source cannot provide detail, report the residual and evidence limit.
A useful first step.
Compare one day in two reports and write their definitions before calculating the gap.
What to measure
Track unexplained residuals, recurring definition questions, and time to an accepted explanation.
Want this working with your team and tools?
Build it yourself, adapt what you already have, or work with us. We can help you choose where to start and handle the technical build.