Guides › Export BigCommerce Orders to QuickBooks Online
How do I export BigCommerce orders to QuickBooks Online?
In Export Stash, create an order export profile, choose QuickBooks as the export method, save it and click Connect QuickBooks to link your QuickBooks Online company. Each order is sent once: paid orders become sales receipts, and orders awaiting payment become invoices.
What you need
- A BigCommerce store with Export Stash installed
- A QuickBooks Online company that uses one currency, the same as your store's
Steps
- Open Orders and create an export profile.
- Select order filters: choose which orders to send, for example by status or date.
- Set export method: choose QuickBooks and save the profile.
- Click Connect QuickBooks on the profile's row and approve access to your QuickBooks Online company.
- Click Preview to see what would be sent: each order's document type, date, customer, lines and total. Nothing is written to QuickBooks.
- Click Run to send the orders, or Set Schedule to send new orders automatically.
Good to know
- Paid orders (Shipped, Partially Shipped, Completed, Awaiting Fulfillment, Awaiting Shipment, Awaiting Pickup, Partially Refunded) become sales receipts. Pending and Awaiting Payment orders become invoices.
- Cancelled, Declined, Refunded, Disputed and Incomplete orders aren't sales, so they are skipped.
- Each order is sent once. Running the profile again skips orders Export Stash already sent, so nothing is posted twice.
- The document number is the BigCommerce order number, and the date is the order date in your store's time zone.
- Using Xero instead? See export BigCommerce orders to Xero.
What each order looks like in QuickBooks
- Customer: matched by the billing email, or created from the billing name, company, email and address.
- Product lines: one line per item with its SKU, name, quantity and price, posted to an ExportStash Sales item.
- Shipping, handling and gift wrapping: their own lines on an ExportStash Shipping item.
- Discounts and coupons: a discount line on an ExportStash Discounts item, when needed for the total to match.
- Sales tax: one line on an ExportStash Sales Tax item.
- The four ExportStash items are created as service items on the first run, using your first income account. Change their income account in QuickBooks if you post sales elsewhere.
- An order is only sent if its lines add up to the BigCommerce order total, so a wrong amount never reaches your books.
Orders that are skipped
- The order is in a different currency from your QuickBooks company.
- The order has no line items, or its lines don't add up to the order total.
- Skipped orders are listed with the reason on the run, and failed orders mark the run as failed.
FAQ
Does BigCommerce connect to QuickBooks Online by itself?
Not directly. Export Stash sends each order to QuickBooks Online as a sales receipt or an invoice, on demand or on a schedule.
Are products synced to QuickBooks as items?
No. Orders post to four generic ExportStash items for sales, shipping, discounts and tax. Each line still shows the product's SKU and name.
Does it work with multi-currency QuickBooks companies?
Not yet. The QuickBooks company must use one currency, and orders in other currencies are skipped.
Will an order be sent twice?
No. Every sent order is recorded, so later runs skip it, even when the schedule overlaps.
Install Export Stash from the BigCommerce App Marketplace — free for 7 days.
More guides
- Export BigCommerce Orders to Google Sheets Automatically
- Export BigCommerce Orders to Xero Automatically
- BigCommerce Shipment Tracking: Bulk Upload Tracking Numbers
- BigCommerce CSV Import: Bulk Import Products from CSV
- BigCommerce Inventory Sync to eBay, Matched by SKU
- Update BigCommerce Stock & Prices from a Supplier File
- BigCommerce Google Shopping Feed Setup for Merchant Center
- Google Shopping Profit Margin Labels for BigCommerce
- How to Create a BigCommerce Facebook & Instagram Feed
- How to Schedule a BigCommerce Product Export to CSV
- BigCommerce to SFTP: Scheduled Product & Order Exports
- How to Export WooCommerce Products to CSV Automatically
- Auto-Export WooCommerce Orders to CSV or Google Sheets
- WooCommerce Google Shopping Feed Without a Plugin
Updated 2026-11-22 · FAQ · Compare · Help Centre