How to use QuickBooks and Shopify together?

How to use QuickBooks and Shopify together?


With Paragon, you can choose how QuickBooks and Shopify add-ons interact and work with each other. 
In this article, we will show you how to set up Paragon, as well as the Shopify and QuickBooks add-ons to manage your sales under a master customer account instead of keeping track of each customer account separately.

Tax setup

First, make sure the tax settings in QuickBooks match the tax setting in Shopify. If you are using QuickBooks Online Canada, the tax in Paragon must match exactly the tax set up in QuickBooks.
For instance, if you have set up Quebec tax in QuickBooks, you must set up the Quebec tax in Paragon:

Tax setup in Paragon:

Import products from Shopify and QuickBooks into Paragon

Once you have connected Shopify and QuickBooks to Paragon, you may want to import your product catalog into Paragon. 
To do that, you must add the Common ID attribute to both add-ons.
To avoid the creation of duplicate products in Paragon, you must select the same common ID in the Shopify and QuickBooks settings.

Add the Shopify Common ID attribute in the Shopify settings page:

In the QuickBooks settings page,  add the same Common ID attribute, using the same one selected in the Shopify settings:

SKU = Shopify SKU
Description = Shopify Description
QuickBooks Name = Shopify Title

Now that you have set up the same common ID you can import products from both add-ons. The products will have both Shopify and QuickBooks attributes:

Manage master customer accounts for Shopify in QuickBooks Online

Now that you have all your products in Paragon, you can import transactions from Shopify to QuickBooks!
To do that, create a customer in QuickBooks Online to act as the master account for Shopify, then assign that customer to the QuickBooks Export Customer attribute in the Shopify settings screen. This customer will be used to export your Shopify invoices and Shopify payments.

When a paid Shopify order comes in and creates an invoice and payment, the invoice and payment get exported to QuickBooks under the customer you just set.

The invoice created in Paragon and sent to QuickBooks will have both QuickBooks and Shopify attributes in the more tab:

Transactions will only be exported to QuickBooks if the automatic export setting for that transaction type is turned on in the QuickBooks add-on screen.

Export Shopify transactions to QuickBooks under individual customer accounts

To be able to send your Shopify transactions to QuickBooks with individual customer accounts, the customer on the Shopify transaction must be a QuickBooks customer

Make sure you do not have a QuickBooks export customer configured on your Shopify setup page:

Transactions will only be exported to QuickBooks if the automatic export setting for that transaction type is turned on in the QuickBooks add-on screen.

What's next

Now that you know how to use Shopify and QuickBooks add-ons together, you can learn more about all the features we offer in the handy articles below!

    • Related Articles

    • How to export purchase orders from Paragon to QuickBooks Online

      Introduction Paragon offers a few ways to export data to QuickBooks Online (to make sure that the integration is working smoothly. To export your purchase orders, there are a few extra requirements you will need to set up in Paragon and QuickBooks ...
    • How to export invoices and credits from Paragon to QuickBooks

      Introduction So now that you've imported all the reference data that you need to get started (such as customers, vendors, and products), you are ready to start creating financial transactions in Paragon and have them be automatically exported to the ...
    • How to export references such as customers and products from Paragon to QuickBooks

      Introduction Paragon offers many ways to keep your data in sync with your QuickBooks Online accounts. Exporting your references from Paragon to QuickBooks is one more way to do this and here we will show you how to export them automatically in the ...
    • Importing Shopify orders into Paragon

      Introduction Paragon offers the ability to connect your organization to your e-Commerce site hosted on Shopify. This document will explain how Paragon and Shopify sync the data once an order is created in Shopify.  Importing orders into Paragon From ...
    • How to connect and disconnect Paragon from QuickBooks Online

      Introduction You already know and love QuickBooks, and you've decided to give Paragon a try - congratulations! You're now ready to connect Paragon to QuickBooks Online.  Connecting Paragon to QuickBooks Online To connect Paragon to QuickBooks online, ...