“Our sales report says one thing and the books say another.” The sales team is celebrating a strong month. Then the accountant closes the books and the figure is lower, sometimes by a lot. Nobody is lying and nobody made an obvious mistake, yet the two numbers won’t line up, and someone spends days trying to explain the gap.

This is one of the most common versions of “we can’t trust our numbers”. This guide explains why the two systems disagree, why the connection between them stops working, and what it takes to get back to one set of figures.

When the sales report and the books tell two stories

Your sales system and your accounting system are built to answer different questions. The sales system, whether that’s an online store or a customer and sales tracker (often called a CRM), tracks orders and deals: what was sold, to whom, and when the customer said yes. The accounting system tracks money: what was invoiced, what was paid, and what belongs in which month.

Both are correct on their own terms. The trouble starts when someone puts the two reports side by side and expects them to match. Unless the two systems have been set up to count the same things the same way, they won’t.

Common reasons the numbers drift apart

Most gaps come from a short list of causes. Most businesses have several at once:

  • Timing. The store records a sale when the order is placed. Accounting may record it when it’s paid, shipped or invoiced. An order placed on the 31st can land in a different month in each system.
  • Refunds and returns. A refund may show up in the store straight away but reach the books weeks later, or the other way round. Partial refunds are especially easy to miss.
  • Tax and shipping. One report includes sales tax and delivery charges, the other doesn’t. That alone can explain a gap of several percent.
  • Discounts and fees. Discount codes, card processing fees and marketplace commissions are often handled differently in each system.
  • Currencies. If you sell in more than one currency, the two systems may convert at different rates on different days.
  • Edited or deleted records. An order is changed or cancelled in the sales system after it has already been sent to accounting, and the change never follows it.
  • Duplicate customers. The same customer exists twice, so sales are split across two records and totals by customer don’t agree.
  • Sync errors. Some records simply never made it across, and nobody was told.

None of these is unusual. Together, they explain almost every mismatch we see.

Why the CRM and accounting software stop syncing

Many businesses have a connection between the two systems already, often set up through a built-in option or an off-the-shelf connector tool. It worked when it was set up. Then, over time, it quietly stopped working properly. The usual reasons:

  • A login or permission expired. The connection loses access and stops sending records, often without telling anyone.
  • One of the systems changed. Software companies update their products, and a field the connection relied on is renamed or moved.
  • The business changed. You added a new product type, a new tax rate or a new sales channel, and the connection’s rules were never updated to handle it.
  • A record failed and blocked the rest. One order with a missing field stops the queue behind it.
  • Nobody owns it. The person who set it up has moved on, and nobody checks whether it’s still running.

The common thread is silence. A connection that fails quietly is worse than none at all, because everyone assumes the numbers are complete.

Working with the tools you already run, such as QuickBooks, Shopify and NetSuite

The answer is rarely to replace your software. QuickBooks, Shopify, NetSuite, HubSpot and Salesforce are all perfectly capable of agreeing with each other. What’s usually missing is clear rules and someone looking after them.

That means deciding, in writing, things like:

  • When a sale counts: when it’s ordered, paid or shipped
  • Whether reported sales include tax, shipping and discounts
  • How refunds, partial refunds and cancellations flow from one system to the other
  • Which system is the master copy for customer details
  • What happens when a record fails to send, and who gets told

Once those rules are agreed, the connection between the systems can follow them every time. If you want the wider picture of connecting systems, we cover it in how to get your business systems talking to each other.

Getting to one set of numbers you can trust

Fixing the mismatch usually happens in three steps:

  1. Reconcile the past. Take a recent month and match the two systems record by record. Every difference gets a reason: timing, a refund, tax, a duplicate, a missing order. This shows you which causes apply to your business, and how big each one is.
  2. Fix the causes, not just the totals. Correct the connection’s rules, merge duplicate customers, and send across anything that was missed. Some fixes are changes to how your team works, such as how refunds are recorded.
  3. Check it every day from now on. A simple automatic check compares the two systems each day and flags any difference while it’s still small and easy to explain.

People often ask what business intelligence includes. In plain English, it’s the whole chain that turns your records into answers: collecting information from your systems, cleaning it, agreeing what each number means, and showing it in reports or a dashboard. Matching sales to accounting is the foundation. If the underlying numbers disagree, no report built on top of them can be trusted. When you’re ready for that next step, see do you need a custom dashboard?

What a fix involves and how it’s scoped

With Agapi, the work usually runs like this:

  1. A free 30-minute call in plain English, with no obligation. You tell us which numbers don’t match and which systems are involved.
  2. A reconciliation of a recent month, so we can show you exactly where the gaps come from before anything is changed.
  3. A written plan covering the rules, the fixes and the daily check, with the price scoped and agreed in writing before any work starts.
  4. The fixes, tested against your real records, run alongside your current process until the numbers match, then a plain-English walkthrough for your team.

The cost depends on how many systems are involved, how many causes turn up, and how much history needs correcting, which is why we look before we quote. The work is done by Agapi’s own senior engineers, you have one consistent point of contact throughout, and you own everything we build. We also keep an eye on the connection afterwards and fix it when one of the systems changes.

Being honest about the limits

Some differences between sales and accounting are correct and will never go away. Accounting has rules about which month money belongs to, and those rules don’t always match when a deal felt “done”. The goal isn’t to force two reports to show the same figure. It’s to know exactly why they differ, and to trust that the difference is explained.

Some problems also start with people rather than software. If refunds are recorded in three different ways, the fix includes agreeing one way and sticking to it.

The short version

Sales and accounting disagree because they count different things at different times, and because the connection between them breaks quietly. Agree the rules, reconcile a recent month, fix the causes and check the two every day.

If your numbers tell two stories, book a free 30-minute call, or read more about what we do.