Maaz Zindani

Loading the index…

↑↓ move↵ openesc close4072 pages

Help for owners

The numbers in my dashboard do not match my other reports

Short answer

Numbers differ for ordinary reasons, almost never a mystery. The common ones are different definitions, different date ranges or time zones, data loaded at different times, duplicate or missing rows, filters nobody remembers, and tax or refunds treated differently. Pick one figure and compare it line by line with the source.

  • Written for business owners
  • Updated
  • By Maaz Zindani, Senior Software Engineer

Does this sound like your situation?

  • A total on the dashboard is not the same as the accounting system.
  • Two reports give different totals for the same month.
  • Numbers change when I reopen the report.
  • A figure looks too high after I added a new data source.
  • Nobody can say which number is right.

Why does this happen?

  1. The definitions differ

    One report counts orders placed and another counts orders shipped or paid. Revenue may include tax, shipping or discounts in one place and not in another. Rounding per line versus per total and exchange rates on different dates add small differences.

  2. Date and time zone boundaries

    A sale at 11pm local time can fall on the next day in another time zone, and month totals shift. Fiscal and calendar months also differ.

  3. Data is loaded at different times

    One report shows data from this morning, another from last night. A refund or edit made in between changes one only.

  4. Duplicates and missing rows

    Joining tables can repeat rows, so totals inflate. A failed or partial load can leave rows out.

  5. Filters and permissions

    A hidden filter, a date range or a user who sees only part of the data gives a different total from someone who sees everything.

What can I do about it today?

  1. Pick one figure and one periodFor example, last month's sales. Only compare that.
  2. Write what each report says it countsCheck the label, the filters and the date range of both.
  3. Check the refresh time of eachNote when each report last loaded.
  4. Compare a handful of rowsPick five orders and see whether each appears in both reports with the same amount.
  5. Do not change formulas yetWrite down the difference, in numbers and in rows.

When should I bring someone in?

  • The difference is large or growing.
  • The report is used for tax, lenders or investors.
  • You cannot explain a difference after a line-by-line check.

How do I handle it?

  1. Reduce the difference to rowsI find which rows are in one report and not the other, and group them by cause.
  2. Write a definition for each figureOne sentence and one calculation, agreed with you.
  3. Fix the cause at the sourceTime zones, duplicate joins and incomplete loads are corrected where they start, not patched in the chart.
  4. Add a reconciliation checkEach load compares totals with the source and flags a mismatch.
  5. Document what is leftSome differences are legitimate, such as timing. They are written down so the question does not return.

The price depends on what I find, so I quote in writing after a short discovery call. Tell me what is happening and I reply within 24 hours.

What do owners ask about this?

Which number is right?

The one that matches its stated definition and ties back to the source rows. That is why definitions come first.

Why do numbers change after I reopen the report?

The data may have been refreshed or edited in between, or a filter changed.

Could the dashboard tool itself be wrong?

Rarely. More often the data or the definition differs. Comparing rows shows which.

Do tiny differences matter?

For some uses they do not. For tax or lenders they should still be explained.

How was this page made?

I drafted this page with AI assistance. It is general guidance for business owners, not advice for your own system. Found a mistake? Tell me.

For your developer: the technical fixes

Next step

Want this off your desk?

Send me a few lines on where things stand. I reply within 24 hours.