You are in a meeting and someone shares the dashboard. Revenue for the month is one figure. The export you pulled this morning shows another. The ledger, which is the one that counts, shows a third. Everyone looks at the person who built the report, and that person starts to apologise.

Nobody made an arithmetic mistake. Each number is right for the question its system was asked. The hours that follow go on finding out which question that was, line by line, in two or three spreadsheets, usually the night before something is due.

Where the difference comes from.

Five causes account for most of it. You have probably met all of them in the last quarter.

  • The cut-off is different.One system closes the period at midnight in its own time zone. Another closes it when the last batch posts. An invoice dated the 31st but entered on the 2nd lands in one month in one report and the next month in the other.
  • One word, two definitions.“Revenue” in the dashboard may mean invoiced. In the ledger it may mean recognised. “Active customer” can mean logged in this month, or paid this quarter. “Hours” can mean worked, or billable. Both reports are correct and they do not measure the same thing.
  • Records changed after the report ran.A credit was issued, an entry was reversed, a date was corrected. The export you saved on Monday is a picture of Monday. The system on Thursday is not that picture.
  • Adjustments live in a spreadsheet.Someone fixed a figure in a working file to get the close done, and the fix never went back into the system. The spreadsheet is right. The system is also right, about a different version of the facts.
  • One system counts what was ordered and another what was paid or delivered.An order is not a shipment and a shipment is not a payment. The gap between them is real money, and it shows up as a disagreement.

One month end, one difference.

Take a 40-person firm that sells and delivers services to about sixty clients. At month end the operations lead, Dana, sees the dashboard show a revenue figure that is higher than the ledger by a round-looking amount. Here is how the difference gets worked through.

  1. Dana writes down the two questions.She asks what the dashboard counts and what the ledger counts. The dashboard counts every invoice raised in the billing tool. The ledger counts what the finance lead has posted. Dana decides which definition the meeting is meant to use, and checks it with the finance lead.
  2. She lines the two lists up.Each invoice in the dashboard export is matched to a ledger entry by number and client. Most match. Some do not, and she marks each of those as it stands.
  3. She finds a cause for each gap, or says she cannot.Four invoices are dated the 31st and posted on the 2nd: a cut-off difference. One was reissued after a pricing correction, so the export is older than the ledger. Two were adjusted in the finance lead’s own spreadsheet and never changed in the billing tool. One has no explanation yet, and it stays marked as unexplained.
  4. The owners decide.The finance lead decides which figure stands for the close and which entries are corrected in the ledger. The person who runs the billing tool decides what is corrected there. Dana records both decisions and who made them.

The finding takes most of the time. The decisions take a few minutes once the differences are laid out.

Illustrative example.

What changes when the comparison is prepared first.

The matching, the dating and the tracing are the part that is mechanical. A workflow can do that part before a person sits down. You give it the exports your team already pulls: the dashboard report, the ledger detail, the adjustment file. It lines them up, shows each difference line by line and traces each to a cause from the list above. Where it cannot trace one, it says so and leaves the line marked unexplained.

It changes nothing in any system. The person who owns each number still decides which figure stands and what is corrected in the system. The workflow prepares the comparison. Your people make the calls.

These free workflow templates are samples and a starting point. Each one is meant to be adapted to your records and your rules.

The Connectors Directory lists business systems by kind, such as accounting systems and payroll systems.

All of it runs on the AI you already pay for, whether that is ChatGPT, Claude, Copilot or Gemini. That is how we 10X the ROI of your existing AI.

Where to start.

If the same disagreement comes back every month end, start with the finance work it lands in: account reconciliations. Pick the next one on your calendar, or book a call and we will look at it with you.