How Shopify data syncs into QuickBooks Online


Sales sync

On a daily basis, the Shopify + QuickBooks Online integration will sync an invoice for each closed sales order or a summary of your previous day’s sales data.

To view the integrated sales transactions:

  1. Sign in to your QuickBooks Online account.

  2. Click on the Sales menu and then Invoices.

  3. Select the date range of the sales you wish to view.

  4. Click on the invoice to view the details.

The default contact name for a daily summary sync is “Shopify” or the sales channel (if specified). If you have modified this, you can find the details within the integration settings in the General section.

The default contact name if you are syncing each closed transaction individually is the first and last name of the contact created in Shopify. If the name is not available, the email address will be used as the contact name.

Payout sync

Payouts coming in or out of your business bank account are synced as bank transfers. You need to match and reconcile these transactions. Find our Shopify + QuickBooks Online reconciliation guide.

To view the payout transfers from Shopify in QuickBooks Online:

  1. In your QuickBooks Online account, click on the Transactions menu and then Chart of Accounts.

  2. Find the Shopify Payments Balance account and click on Account history.

  3. You will find a list of transactions and the payout transfers are tagged as Transfer type.

The integration also syncs other payout transactions such as fees into a Journal Entry.

To find other payout transactions:

  1. In your QuickBooks Online account, click on the Reports menu.

  2. Select the Journal report.

  3. Select the date range for which you want to view the journal entries.

  4. Include the Memo/description in the visible columns.

  5. Click the Journal Entry you want to view.

The preset accounts below are created and mapped by default when you initially set up your integration.

Payout Transaction QBO Account Account Type
Shopify Fees Shopify Fees Expenses
Was this article helpful?