Our Systems Give Different Numbers
Why your systems disagree about revenue, cost and stock, and how to get one set of numbers
- 20+ years connecting business systems
- Works with the accounting, job and CRM systems you already use
- Fixed quote after a free chat
Short answer: when your job system, stock system, CRM, payroll and Xero or MYOB each show a different figure, it is rarely because one of them is broken. They record things at different times, define them differently, and pass information to each other through retyping or connectors that only carry part of it. The fix is to agree what each figure means, decide which system owns it, connect the systems properly and check the key figures automatically.
You will know the feeling. The monthly meeting starts with three versions of revenue, and the first half hour goes on working out whose is right. Someone has already exported everything and rebuilt the report in Excel, and that spreadsheet is the one people quietly trust. It works, but it is slow, it depends on whoever builds it, and it still can't tell you why the systems disagree.
Signs You Have This Problem
- Your job system, CRM and Xero or MYOB each give a different revenue figure for the same month
- Stock on hand in the inventory app doesn’t match the stock value in the balance sheet
- Payroll hours and the hours costed to jobs never quite agree
- Management meetings start with working out whose number is right
- Someone exports from each system and rebuilds the real report in Excel
- People keep their own spreadsheet “just to be sure”, and those don’t match either
- You only trust the numbers after the accountant has adjusted them at year end
Why the Numbers Don't Match
The differences almost always sit between systems, not inside them.
Timing
Each system records the same event at a different moment. A sale is booked in the CRM when it is won, in the job system when the work is done and in the accounts when it is invoiced. On any given day, all three can be right and still disagree.
Mapping
When figures move between systems, items, jobs and customers have to be matched to accounts, tracking categories or cost codes. If the mapping is wrong or out of date, the money lands in the wrong place and the totals stop lining up.
Retyping
Where information is copied by hand, it gets copied slightly differently. A missed invoice, a changed quantity or a typo in an amount, and two systems now tell two stories.
Half-synced connectors
A connector carries invoices but not credit notes, or new records but not changes to old ones. Each gap is small. Over a month they add up to a figure nobody can explain.
Different definitions
Sales means revenue to finance and orders to the sales team. Cost might include labour on-costs in one report and not in another. Without an agreed definition, two honest people produce two different numbers.
Edits in more than one place
When the same record can be changed in two systems, it eventually is. Then neither system knows which version is current.
What Fixing It Involves
Work through these in order. The early steps cost little and often settle most of the arguments on their own.
- Agree the definitions. Write down what revenue, gross margin, job cost and stock value mean in your business, which costs are included and at what point something counts. Get finance, operations and sales to sign off on the same page.
- Give each figure one owner. Decide which system each figure is entered and changed in. Every other system receives it from there, and nobody edits it anywhere else. Information then flows in one direction. One set of numbers everyone trusts
- Connect the systems properly. Replace the retyping and the half-working exports with connections that carry everything the figure needs, including changes, credit notes and deletions, and that tell someone when a record fails. Systems integration or Xero and MYOB integration repair
- Reconcile automatically. Compare the key figures between systems every day or week and list only the differences, so the team looks at exceptions instead of rebuilding the whole report.
- Report from the source. Build the management report straight from the systems that own each figure, so the Excel rebuild is no longer needed. Xero and MYOB reporting dashboards
When a simple fix is enough
Sometimes the difference comes down to one thing: a mapping rule in a connector, a tracking category nobody set up, or two reports that use different date ranges. If the gap is the same kind every month, fixing that one cause may be all you need. A bigger piece of work only makes sense when the differences come from several places at once, or keep coming back after each fix.
If your connector is the part that keeps letting you down, see when the integration only half works. For the wider picture of connecting and reporting from Xero or MYOB, read our Xero and MYOB guide, or go back to other signs your systems are costing you time.
Different Numbers FAQs
Why do our job system and Xero (or MYOB) show different revenue?
Usually because they are counting different things at different times. The job system may count work when it is done or quoted, while the accounts count it when it is invoiced. Add credit notes that were raised in one system only, invoices edited after they synced, and jobs mapped to the wrong account, and the two totals drift apart. Neither is necessarily wrong; they are answering slightly different questions.
Which system should be the source of truth?
There isn’t one answer for the whole business. Each figure should have one system that owns it. Revenue and cost in the ledger usually belong to Xero or MYOB. Stock on hand usually belongs to the inventory or warehouse system. Hours worked belong to the timesheet or payroll system. The rule is that a figure is entered and changed in one place, and every other system receives it from there.
Can a dashboard fix this?
A dashboard shows the numbers; it doesn’t make them agree. If the dashboard pulls from systems that disagree, it will show the disagreement more clearly, which is useful but not a fix. The definitions and the connections need sorting first. Then a dashboard built from the source data becomes the report everyone uses instead of the Excel rebuild.
Do we need a data warehouse?
Many growing businesses don’t. Agreeing definitions, fixing the connections between systems and reconciling the key figures automatically solves most of it. A data warehouse earns its place when you are combining many systems or entities, need history the source systems don’t keep, or want reporting that would be too slow to run against the live systems.
Where should we start?
Pick the one figure that causes the most arguments, often revenue, gross margin or stock value, and trace it through each system. Write down where it is entered, how it moves and how each system defines it. If you want help, start with a free initial chat. If the picture needs mapping across the business, the Process & Systems Audit maps your processes and systems for a fixed $5,000.
Want to talk it through? Book a free initial chat.
Systems Telling You Different Things?
Tell us which numbers don't match and where they come from. We'll tell you honestly whether it's a quick fix or a bigger piece of work, and where to start.
Free initial chat. No sales pressure - if we're not the right fit, we'll say so.
Prefer to talk? Call 1300 470 091
Got a spec or files? Email [email protected]