- Home
- QuickBooks integration
- Shopify and QuickBooks
Shopify to QuickBooks works when each payout matches the bank
A Shopify QuickBooks integration copies each paid order into QuickBooks Online, then matches each Shopify Payments payout, with its fees, to the deposit in your bank. Tax and refunds need their own rules. By default, Shopify's API shows an app only the last 60 days of orders, so plan the first import early.
Each Shopify record has its own home in QuickBooks
Five kinds of Shopify records move, and each lands in a different place in QuickBooks Online. Two rules come from Intuit. A sale paid at the time is a sales receipt, and a sale paid later is an invoice. Records a sale points to, such as the customer or the item, must exist first. QuickBooks can’t create them inside the sale.
Scroll the table sideways to see every column.
| Shopify record | Where it lands in QuickBooks Online | What to watch |
|---|---|---|
| Order paid at checkout | Sales receipt | Intuit uses a sales receipt when the customer pays at the time of sale |
| Order on payment terms | Invoice | Shopify orders can carry terms such as net due dates or early payment discounts |
| Product and variant | Item (inventory, non-inventory, service or bundle) | Intuit lists four item types, and the item must exist before a sale uses it |
| Refund | Refund (Intuit lists Refund among its transaction entities) | Book it when the refund transaction succeeds, not when the refund record appears |
| Shopify Payments payout | The deposit, with fees booked apart | A payout is net of fees, so gross sales alone never match the bank |
Why the first import stops at 60 days
Shopify’s order scopes cover only orders made in the last 60 days. An app reads orders with read_orders, or reads and writes them with write_orders. To reach older orders, it must also ask for read_all_orders and meet Shopify’s approval rules for that scope.
This matters on day one. If your books need last year’s orders, ask for the extra scope before the build starts. Or pick a cut-over date inside the 60 days and leave older history as it is. Your accountant should pick that date.
How payouts and fees should land
Shopify pays you a net amount, so the books need the gross sale and the fee as two lines. Each Shopify Payments balance transaction records three figures: the gross amount, the processing fee and the net. Each payout then carries a summary of fees and gross amounts for charges, refunds and adjustments.
Three details trip up a sync:
- Timing. A payout holds only the balance transactions that were ready when it was issued. So an order can land in a later payout than you expect.
- Fees. Fee data on an order transaction exists only for Shopify Payments. Orders paid through another gateway need that gateway’s own fee report.
- Direction. A payout is a transfer from your Shopify Payments balance to your bank account. Match it to the bank deposit in QuickBooks, not to a single order.
Your accountant decides which accounts the fees and sales post to. The sync follows that map.
Who calculates the sales tax
Shopify already charged the tax, so QuickBooks should record it, not work it out again. Intuit’s docs say US QuickBooks Online companies made after November 10, 2017 use the automated sales tax engine, called AST. AST sets tax from your company’s legal address and the shipping address on the sale. If an app assigns its own tax code, AST overrides it.
There is a way to keep Shopify’s figure. Intuit says an AST company honors a tax amount sent in TxnTaxDetail.TotalTax. QuickBooks then spreads that amount across the tax rates in the code. Two more limits apply:
- Sales tax must be turned on in the QuickBooks Online Sales Tax center. Intuit says the API can’t turn it on.
- A taxable transaction can hold at most 750 lines. A store that posts one daily summary of all orders can hit that.
On the Shopify side, check each order’s taxesIncluded flag. When it is true, line prices already include tax, so the sync must split the tax out before it sends the lines.
Shopify counts stock per location, and QuickBooks API adjustments post to one site
Shopify ties each inventory level to one location, with counts such as available, on hand, incoming and committed. Intuit’s Inventory Adjustment API supports only the primary site. So a sync can’t post stock adjustments per warehouse through it.
Here is what Intuit’s docs say about stock:
- Selling or buying an inventory item changes the quantity on hand by itself.
- QuickBooks Online costs stock first in, first out (FIFO): the first units bought count as the first units sold.
- A sale that draws on two purchase costs shows as two lines on a transaction report. That is expected.
- The Inventory Adjustment API works on QuickBooks Online Plus and Advanced, in the US only.
- An adjustment changes quantities only. It can’t change the value of stock.
- After the books are closed, no adjustment can be made, in the screen or through the API.
- Some QuickBooks Online versions don’t support inventory at all, so check your plan first.
How to stop double posting
Give every QuickBooks record a number that comes from Shopify. Intuit calls the visible form number the DocNumber, and it holds up to 21 characters. Intuit warns that DocNumber is not a guard against duplicates. Resend a create and QuickBooks does not hand back the first record. So Intuit’s advice is to set a stable DocNumber, such as your own order number, and to query for it before any retry. Intuit also strongly recommends a request ID on every write, so a retried request does the job once.
Shopify’s side needs care too. Shopify says the same webhook can arrive more than once, and gives each delivery an ID so you can drop repeats. The orders/paid event fires whenever an order is paid. That is a better trigger for a sales receipt than order creation, because an unpaid order has no money to book yet.
Orders that need their own rule
A few kinds of Shopify order should not post the normal way:
- Test orders. Shopify marks orders made with its Bogus Gateway or a payment provider in test mode. A test order can never become a real one, so the sync should skip them.
- Other currencies. The customer’s currency can differ from your shop’s base currency. Decide which amount QuickBooks gets, and where the exchange gain or loss goes.
- Point of sale. Shopify names each order’s source, such as web, mobile_app or pos. Shop counter sales may post to a different deposit account.
- Trade orders on terms. These become invoices, and the payment arrives later.
An AI agent can chase the payouts that don’t match
The sync itself is rules. An agent earns its keep on the exceptions. Intuit’s help center, in our capture of 15 November 2026, says Accounting AI groups the transactions it is confident can be posted. An agent can take the next step: read a payout that does not match, find the late refund or the missing fee, and leave a draft fix for a person to approve.
See QuickBooks AI agents for the agent side and AI integration services for how we build the links.
When Shopify and QuickBooks stop being enough
Stock across several warehouses is one breaking point the docs show. Intuit’s Inventory Adjustment API posts at the primary site only, while Shopify counts stock per location. Our team has run bookkeeping, inventory sync, order sync and invoicing in QuickBooks. Our team has also moved companies off QuickBooks, Xero or Sage into a full ERP. Our ERP implementation services page shows how that move runs, and QuickBooks integration compares the other ways to connect QuickBooks.
Questions
Does Shopify have a QuickBooks integration?
Yes, through an app or a custom build on both APIs. We tried to count the QuickBooks apps in the Shopify App Store on 18 November 2026, but the search page returned no app list to our tool. It said it was having trouble loading results, so we give no count. Any app works within the same rules. It needs Shopify's order scopes, and QuickBooks needs the customer and item to exist before a sale can point to them.
How do I enter Shopify sales into QuickBooks?
Match the QuickBooks form to how the customer paid. Intuit says a sale paid at the time gets a sales receipt, and a sale paid later gets an invoice. An order paid at checkout fits a sales receipt. Orders on payment terms, such as a trade buyer's net due date, fit an invoice. Give each one the Shopify order number as its DocNumber, and check for that number before any retry.
Why don't my Shopify payouts match QuickBooks?
Check the fees first, because the payout is a net figure. Shopify records each charge with its gross amount, its processing fee and the net that reaches your balance. A payout then holds only the transactions that were ready when it was issued. If QuickBooks shows gross sales but no fees, the bank deposit will look short. Book the fees apart and match by payout, and the deposit can line up.
Will QuickBooks recalculate the sales tax Shopify charged?
It can. US QuickBooks Online companies made after November 10, 2017 use Intuit's automated sales tax engine. It works out tax from your company address and the shipping address on the sale. Intuit says an app can send the tax it already charged in a field called TotalTax, and QuickBooks honors that amount. That keeps the books equal to what the customer paid.
Can the sync handle Shopify refunds?
Yes, with one check. Shopify fires a refunds/create event when a refund is made on an order. Shopify also says a refund record alone does not prove the money went back. The order's transactions show that. So a good sync books the refund once the refund transaction succeeds, not when the refund record first appears.
Why are people leaving QuickBooks?
For a store, the stock rules are where Intuit's docs show limits. Intuit's Inventory Adjustment API posts adjustments at the primary site only, and it changes quantities, not values. QuickBooks Online costs stock first in, first out, and some versions don't support inventory at all. We have no count of why stores leave. Our team has moved companies off QuickBooks, Xero or Sage into a full ERP.
Do you need our live store and books to build this?
Not to start. Intuit gives developers up to 10 sandbox companies, each valid for two years. Shopify marks test orders, made with its Bogus Gateway or a payment provider in test mode, and a test order can never turn into a real one. So a build can run end to end on test data first. We sign your NDA before you share any data, if you ask.
Sources
Every source behind a figure or a vendor fact on this page, with the day we read it.
- Shopify, API access scopesRead 18 Nov 2026
- Shopify, ShopifyPaymentsPayout objectRead 18 Nov 2026
- Shopify, ShopifyPaymentsBalanceTransaction objectRead 18 Nov 2026
- Shopify, OrderTransaction objectRead 18 Nov 2026
- Shopify, Refund objectRead 18 Nov 2026
- Shopify, Order objectRead 18 Nov 2026
- Shopify, WebhookSubscriptionTopicRead 18 Nov 2026
- Shopify, InventoryLevel objectRead 18 Nov 2026
- Shopify, webhooks guideRead 18 Nov 2026
- Intuit Developer, automated sales tax (US locales)Read 18 Nov 2026
- Intuit Developer, inventory adjustmentRead 18 Nov 2026
- Intuit Developer, basic inventory implementationRead 18 Nov 2026
- Intuit Developer, basic ID and field definitionsRead 18 Nov 2026
- Intuit Developer, inventory cost accounting (FIFO)Read 18 Nov 2026
- Shopify App Store, search for quickbooksRead 18 Nov 2026
- Intuit Developer, what you can do with the QuickBooks Online Accounting APIRead 18 Nov 2026
- Intuit Developer, invoicing basicsRead 18 Nov 2026
- Intuit Developer, manage inventoryRead 18 Nov 2026
- Intuit Developer, basic bookkeeping: inventoryRead 18 Nov 2026
- Intuit Developer, sandbox FAQsRead 18 Nov 2026
- Intuit, Accounting AI features (help article)Read 15 Nov 2026
Map your Shopify orders into QuickBooks
Tell us your QuickBooks edition, how many orders a week you take and how many places you hold stock. The first call is free.