Skip to content
  • There are no suggestions because the search field is empty.

QuickBooks Sales Receipt Total Is Higher Than Shopify Order for VAT-Inclusive Amounts

If your Shopify orders post to QuickBooks Online with a higher total than the Shopify order, or VAT appears to be calculated twice on the sales receipt, this article explains why it happens and how to correct the tax settings in Webgility Online.

Symptoms

You may notice one or more of the following after Webgility Online posts a Shopify order to QuickBooks Online:

  • The sales receipt total is higher than the Shopify order total
  • VAT appears to be added twice — once in the Shopify price and again in QuickBooks Online

Example: A Shopify order totals £100.00 including 20% VAT. In QuickBooks Online, the sales receipt shows £120.00, because an additional 20% was calculated on top of the already VAT-inclusive amount.

Cause

Shopify prices in the UK and EU usually already include VAT. So for example if your Webgility Online order posting settings also apply a 20% tax rate, QuickBooks Online calculates 20% tax on top of those amounts — so the tax is effectively charged twice and the receipt total goes up.

A second, related cause of "extra" amounts is how Shopify fees are posted. If Webgility Online is set to post fees as a line item, they'll appear on the sales receipt itself, which can make it look different from the Shopify order.

Solution

Step 1: Update your tax setting in Webgility Online

  1. Open Webgility Online and go to your Order Posting settings for your Shopify store.

  2. Find the Tax section.

  3. Change the tax rate from the required percentage to 0% or No VAT.

  4. Save your settings.

Tip: This tells QuickBooks Online not to calculate additional tax on amounts that already include VAT, so the sales receipt matches Shopify.

Step 2: Unpost and repost affected orders

Settings changes only apply to orders posted after the change. To correct orders already in QuickBooks Online:

  1. In Webgility Online, find the affected order(s).
  2. Select Unpost to remove the existing sales receipt from QuickBooks Online.
  3. Select Post again to recreate the sales receipt with your updated settings.