Exporting orders from Shopify to QuickBooks
You can use Shopify's QuickBooks Online app to export paid or fulfilled orders directly from your Shopify admin to your QuickBooks Online account.
Exported orders include the following information:
- order numbers
- order sources
- payment information
- customer details
- billing addresses
- shipping addresses
- shipping costs
Partially-refunded orders aren't included in exports.
If an order is only partially paid, then it won't be included when you export data from Shopify to QuickBooks Online.
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.
Export orders to QuickBooks Online
To export orders from Shopify to QuickBooks Online:
From your Shopify admin, click Apps (or press
Click Intuit QuickBooks Online.
In the Export Shopify data to QuickBooks Online section, select the date range that you want to export orders for:Orders that you've exported previously won't be exported again in subsequent exports, even if they're included in the date range you choose.
Click Export to export your orders to QuickBooks Online. The Last Export section displays the date and details of the most recent export:After you've made multiple exports, you can review past orders in the Previous exports section, and click on the date of a specific export to view its details.
If your export fails, then you can click Review the export details to see which orders aren't exporting properly:
After you export orders from your Shopify admin, you can view them in QuickBooks Online.