Maaz Zindani

Loading the index…

↑↓ move↵ openesc close4072 pages

Help for owners

The sales tax in QuickBooks does not match my shop after syncing

Short answer

Tax differs after a sync because your shop and QuickBooks each calculate it with their own rules, and the sync has to map one onto the other. Rates, tax-inclusive prices, shipping tax, rounding and tax overrides are the usual gaps. Do not file from the synced numbers until your accountant has compared a sample.

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

Does this sound like your situation?

  • The tax on a synced invoice is different from the tax the customer paid.
  • Totals match but the tax line is split differently, or the sale lands under the wrong tax code.
  • The difference is a few cents on many orders and adds up at month-end.
  • Orders from one region, one product type or shipping are always wrong.
  • It started after tax rates, tax settings or product prices were changed.

Why does this happen?

  1. Two systems calculate tax themselves

    A shop applies its own tax rates, and the shop owner can usually override them. If QuickBooks recalculates tax on the incoming order using its own setup, the two figures can disagree even when each is correct by its own rules.

  2. The tax code in QuickBooks does not match the order

    The sync has to choose a QuickBooks tax code for every order. A region, a tax-exempt customer or a shipping line with no matching code is sent under a default one, so the amount can be right and the category wrong.

  3. Prices that already include tax

    If prices in the shop include tax, the sync must split each line into net and tax. A sync that treats a gross price as net adds tax on top, and every order is overstated.

  4. Rounding and where it is applied

    Tax rounded per line in one system and per order in the other leaves small differences that look random but follow a pattern when many orders are compared.

  5. Shipping, discounts and refunds

    Tax on shipping, on discounted lines and on partial refunds is where simple syncs most often diverge from the shop's own figure.

What can I do about it today?

  1. Pick three orders that disagreeNote the shop's tax figure and the QuickBooks one for each. Choose different kinds: a normal order, one with shipping, one with a discount or refund.
  2. Show them to your accountant firstWhich system is right is a tax question. I do not give tax advice, so ask the person who files your returns.
  3. Do not edit the synced entries by hand yetA later repair run can overwrite or duplicate manual changes. Keep a list of the corrections you think are needed instead.
  4. Check what changed in the shopNew tax rates, tax-inclusive prices, a new market, tax overrides or a new shipping method often explain the date it began.
  5. Hold the tax return from synced figuresUntil the sample is explained, use figures your accountant has verified.

When should I bring someone in?

  • A tax filing is due and the synced figures are not reconciled.
  • The difference follows a pattern by region, product or shipping.
  • Nobody can say which tax code each order should land under.

How do I handle it?

  1. Compare a sample line by lineI read the vendor's current documentation first, and every change is tried on test data before it touches your real books. I take real orders across regions and order types and compare each tax figure between the shop and QuickBooks, so the gap is described exactly.
  2. Write the mapping downEach shop tax rule is mapped to a QuickBooks tax code in a table that your accountant can read and approve.
  3. Decide who calculatesEither the shop's tax figure is sent as it is, or QuickBooks calculates it. Not both, because that is what causes drift.
  4. Re-run affected orders safelyCorrected orders are updated in place with a backup and a before-and-after total, so nothing is duplicated.

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 system is correct, the shop or QuickBooks?

That is for your accountant or local tax authority. I do not give tax advice.

Can the sync just copy the shop's tax figure?

Often yes, and it is usually the cleanest choice, but the tax code and the account it posts to still have to be mapped so reports come out right.

Why are the differences only a few cents?

Usually rounding. When one system rounds each line and the other rounds the whole order, small differences appear and add up across many orders.

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.

Next step

Want this off your desk?

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