A Shopify and Quickbooks integration guide

Reading Time: 3 minutes

Shopify is a complete commerce platform that lets you start, grow and manage a business. You can create and customise an online store, sell in multiple places such as the internet, by mobile, via social media, brick and mortar locations or even pop up shops. Using this system, you can manage your products, inventory, payments and shipping.

As a cloud-based system, you access this software from anywhere.

For more information on Shopify if this is your first time hearing of it or if you just need to refresh your existing knowledge of the software, please visit the Shopify website at https://www.shopify.co.uk/

If you are reading this document, we’ll assume you have already using Shopify and are looking to connect it with your Quickbooks software.

How to integrate Shopify with Quickbooks

To integrate your Shopify account with Quickbooks, you just need to complete the following steps;

Step 1

Download and install the Quickbooks app in Shopify https://apps.shopify.com/search?q=quickbooks&st_source=.

Step 2

Click ‘Add App’ and then click ‘Install app’.

Install quickbooks

Step 3

You then choose the payment plan you wish to use.

Step 4

Accept the terms and conditions.

Step 5

Click ‘Connect with Quickbooks’.

Step 6

Quickbooks accounts

A new pop up screen will open asking you to authorise Intuit to securely share your data with Shopify or Quickbooks Online. Click ‘Connect’. This will take you back to Shopify where you will need to select the Quickbooks accounts you want Shopify to connect to. The following image shows an example we have picked for these accounts; however, these can be at the users’ discretion.

Step 7

Next up comes the payment fees settings.

payment fees settings

Step 8

Then the tax settings, Product Export Settings and Customer export settings.  A point to note is that if you have not set up taxes in the QuickBooks account, the tax settings will not have anything to link to so you will need to set up the VAT in Quickbooks before you can select the HM Revenue  & Customs (VAT) option.

tax settings

Step 9

Finally, come the Export settings and the pricing plan. Click ‘Complete Setup’ when finished

Export settings and the pricing plan

Step 10

Next, you should move over to your Quickbooks software and see if the app has been integrated correctly. You can see this from the overview tab under the company setup section. Congratulations, you have now integrated Shopify with Quickbooks.

company setup

How Quickbooks is affected by the integration and the double entries involved

Shopify lists the changes it will make as the following adjustments;

1. Orders paid in full will be created as Sales Receipts

  • DR – Bank
  • CR – Product/Service Account
  • CR – VAT Control – HMRC

2. Refunds will be created as Refund Receipts

  • DR – Product/Service Account
  • DR – Vat Control – HMRC
  • CR – Bank

3. Products will be created and/or updated

  • Not a double entry, a new product/service code will be created in the Products and Services section when the sales receipt is created.

4. Customers will be created and/or updated

  • This is the same as with the products being created. The customer section will be updated with the new customer information when the sales receipt is created.

5. Shopify Payment fees will be exported Payment fees will be exported

  • DR – Bank
  • DR – Uncategorised/Sundry Account
  • CR – Sales

We are specialist Quickbook Accountants helping businesses grow.