Top

Export Orders from Shopify to QuickBooks Online

You can use QuickBooks Online to export paid or fulfilled orders directly from your Shopify admin to your QuickBooks Online account.

To export orders from Shopify to QuickBooks Online, follow these steps:

  1. From "Shopify Admin", select Apps.
  2. Select Intuit QuickBooks Online.
  3. In the "Export Shopify data to QuickBooks Online" section, select the date range that you want to export orders for.
  4. Select Export.

    Note: After you've made multiple exports, you can review past orders in the "Previous exports" section, and select the date of a specific export to view its details.

  5. If your export fails, then you can select Review the export details to see which orders aren't exporting properly.

That's it!

Exported orders include the following information:

  • order numbers
  • order sources
  • products
  • taxes
  • dates
  • payment information
  • customer details
  • billing addresses
  • shipping addresses
  • shipping costs

Exports don't include partially refunded or partially paid orders.

Note: The QuickBooks Online app doesn't manage your product inventory using the data that you export from Shopify. There are separate third-party apps available in the Shopify App Store that sync inventory data between QuickBooks Online and your Shopify store.

You can configure how QuickBooks Online receives exported information using the QuickBooks Online Settings page in your Shopify admin.

By default, QuickBooks Online records exported orders as sales receipts in the Product sales account, purchased gift cards as liabilities in the Gift cards account, purchases made with PayPal as deposits in the PayPal account, and payments associated with your Shopify orders as assets in the Payment deposits account.

Next Steps:

Have more questions? Submit a request