Why Your Dashboard Disagrees With Reality

The usual reason why dashboard numbers are wrong is not a calculation error. It is that the dashboard reads a copy of the data rather than the data itself.

How divergence creeps in

Each step between the operation and the report is a place where the two can drift.

  • Exports run nightly, so the panel is always a day behind
  • Settled entries included in totals meant to show what is open
  • A modelling layer applying rules nobody remembers
  • Archived records still feeding charts

Where to check first

  • Is the data live? A panel reading operational records cannot lag
  • What is being filtered? Paid and archived records usually should not count
  • Which period? A filter applied to one indicator and not another
  • Which records? Permissions may be scoping what a given viewer sees
  • Which calculation? A composite indicator crossing the wrong variables

How to fix it in Jestor

  1. Build indicators in Jestor directly on the operational table, with no export step.
  2. Filter payables and receivables to exclude settled entries.
  3. Exclude archived records from active charts.
  4. Apply the period filter at panel level so every indicator responds together.
  5. Use a composite indicator where the figure is a ratio, and check its variables.

Why choose Jestor for trustworthy reporting?

Because Jestor builds dashboards on the same records the team works in, there is no reconciliation between the system and the report — they are the same thing.

When a figure still looks wrong, the table history shows what changed, by whom, and from which source, which usually resolves the disagreement in minutes.

Frequently Asked Questions

Why is my total higher than expected?

Settled or archived records may still be counted. See jestor.com.

Do I need an export for reporting?

No, indicators read the operational records directly.

How do I investigate a specific number?

Through the table history, filtered by source and date.

Video Tutorial: Step by Step

Check out other practical tutorials on the Jestor YouTube channel.

Get to know Jestor

With Jestor, you can automate workflows, connect teams, and build internal systems your way — all without code and powered by AI. Discover Jestor at jestor.com and see how to take your company's operations to a new level of efficiency and control.

Read more