Shopify QuickBooks integration: orders, fees and refunds
Check a Shopify QuickBooks integration. Map orders, tax, fees, refunds and payouts, then verify duplicate imports, missing records and settlement totals.
- Published
- Last updated
Yes, Shopify integrates with QuickBooks Online through Intuit’s connector. A Shopify QuickBooks integration can import individual sales and connect them with settlement records. Choose the connection by your accounting edition and the records your bookkeeper needs. A bank payout alone doesn’t explain the sales behind it.
Verify the supported connection
For an Australian store using QuickBooks Online, start with Intuit’s current ecommerce connector instructions. The Australian documentation identifies a replacement for the legacy OneSaas connection. Its settings and transaction review live inside QuickBooks Online. Old screenshots can describe a different workflow.
Record your QuickBooks country and edition alongside your Shopify store, payment providers and installed connector name. Include online and in-person sales if both enter the same books. The following options handle different records.
Connection options
| Connection | Accounting destination | What decides its fit |
|---|---|---|
| Intuit’s Shopify connector | QuickBooks Online | Individual transactions and payout reconciliation, with optional product and customer tracking |
| A2X | QuickBooks Online | Categorised payout summaries for reconciling deposits, instead of a customer ledger for every retail order |
| QuickBooks Desktop Connector | QuickBooks Desktop accounting software | Shopify’s documented path for merchants migrating from QuickBooks Desktop Point of Sale |
A2X’s Shopify listing describes summaries of sales, refunds, taxes and fees. That suits a bookkeeper who wants settlement totals in the ledger while Shopify retains order detail. Decide whether your accountant needs individual customer balances before choosing a summary approach.
QuickBooks Desktop and QuickBooks Online need different connections. Shopify’s Desktop integration instructions apply to the Point of Sale migration programme. They describe daily scheduled or manual sync and a choice of detailed or summary data. The sync mode can’t be changed after setup. Pro and Premier files above 14,500 combined rows require summary mode under those instructions.
QuickBooks Desktop Point of Sale is a separate, discontinued product. Intuit’s discontinuation notice covers version 19.0 and its connected services. That migration route doesn’t establish Australian compatibility for an unrelated Desktop or Enterprise file. Treat its country, supported version and company file as separate selection criteria.
Map each record once
Give each accounting record one import owner before connecting historical sales. Shopify can remain the operational source while QuickBooks holds the ledger. Choose either individual transaction posting or settlement summaries for the same sales period. Running both as revenue imports counts the same trade twice.
Record ownership
| Record | Operational owner | Accounting treatment to agree |
|---|---|---|
| Product or variant | Shopify catalogue owner | Match the accounting item and income account, where item tracking is used |
| Customer | Store customer record | Choose named customers or the connector’s retail customer treatment |
| Order and payment | Shopify order and payment records | Record the sale once and retain its original identifier |
| Tax | Shopify transaction detail | Map the tax treatment to the bookkeeper’s approved accounts and codes |
| Processing fee | Payment provider transaction | Record the expense separately from sales |
| Refund | Shopify refund record | Link the refund to its original order and retain the tax adjustment |
| Payout | Provider settlement record | Clear the provider balance into the receiving bank account |
Keep the store identifier with the original order ID. Order numbers from different stores can overlap. Preserve refund and payout identifiers too. A product’s stock keeping unit (SKU) helps item matching, but a renamed product mustn’t create a second accounting item unnoticed.
Record the cutover boundary and the last imported transaction before a historical import. Compare the proposed start with existing entries, including manual journals and bank-feed additions. Keep an export of the old mapping. Test a mapping change on an unrecorded transaction before applying it to a wider period.
Intuit’s Australian migration guide describes imports every few hours and history up to 12 months. It also states that the replacement doesn’t support unpaid-order imports or two-way inventory sync. Use that specific connector’s limits when planning stock ownership. An inventory feature shown on an app listing doesn’t establish two-way support in every connector generation.
Trace the sale and refund
A captured customer payment, a provider payout and a reconciled bank entry are different events. Customer-service staff use the order’s payment status to answer whether payment succeeded. The bookkeeper uses settlement records to explain when the money reaches the bank.
Consider this fictional example. Assume one taxable sale of AUD $220, including AUD $20 tax, and a partial refund of AUD $55, including AUD $5 tax. Assume the provider deducts an AUD $6 processing fee from the same settlement. These are example amounts, not Shopify’s fee schedule.
Worked settlement example
| Component | Shopify or provider record | Expected accounting effect |
|---|---|---|
| Original payment | AUD $220 captured | AUD $200 sales and AUD $20 tax, with AUD $220 due from the provider |
| Partial refund | AUD $55 refunded | Reduce sales by AUD $50 and tax by AUD $5, reducing the provider balance |
| Processing fee | AUD $6 deducted | AUD $6 fee expense, reducing the provider balance |
| Payout | AUD $159 sent to the bank | Transfer AUD $159 from the provider balance to the bank |
The arithmetic is AUD $220 minus AUD $55 minus AUD $6, giving AUD $159. In an itemised workflow, inspect the linked sale, refund and fee. In a summary workflow, those components must appear in the settlement summary. The bank deposit matches the payout already recorded.
Incorrect: adding the AUD $159 bank deposit as a second sale after importing the original order. Correct: matching it to the settlement entry that clears the provider balance.
The example assumes the refund and fee fall into the same payout. A later refund can reduce a later settlement. Shopify’s payout records and reports separate transactions, fees and payouts. Use the payout’s actual membership when comparing totals, instead of grouping solely by order date.
Check failures and ongoing work
The bookkeeper owns reconciliation, while the store administrator owns connector access. Agree who can correct mappings and who approves changes to recorded entries. A successful connection screen doesn’t prove a period balances.
Run these checks on a controlled sample before importing the rest of your history.
- Follow a paid order through a complete sync cycle. If it’s delayed, inspect the last successful sync and the transaction queue before entering it manually.
- Inspect a transaction with an unmatched item or tax code. Correct its mapping, then confirm that the resulting entry uses the intended account.
- Compare the original IDs against an already imported order. Confirm that the overlap is recognised before repeating a historical import.
- Follow a partial refund and a subsequent correction. Compare the order total with the refund records and the eventual settlement adjustment.
- Match one complete payout to its bank deposit. Investigate every remaining difference, including currency conversion or reserves where they occur.
When a check fails, pause that import path and preserve the affected IDs. Fix the source record or mapping, then retry only the affected records through the connector’s supported recovery process. Reconcile the sample again before widening the import. Reinstalling an app can leave previously recorded transactions intact, so it isn’t a clean restart.
The QuickBooks Online app listing says it’s free to install, with additional charges possible. That doesn’t include every accounting subscription or implementation cost. A2X uses subscription pricing with order-volume limits. Its listing states US-dollar billing every 30 days. Tax treatment isn’t stated in that listing.
Budget separately for account mapping, cleaning historical imports and ongoing reconciliation. Start with one payout whose components you can explain. Let the bookkeeper approve that result before bringing in earlier periods.
Give your store its own shopping agent
Customers ask in their own words. Your agent finds, compares and checks out from your catalogue, right on your site.