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.

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

ConnectionAccounting destinationWhat decides its fit
Intuit’s Shopify connectorQuickBooks OnlineIndividual transactions and payout reconciliation, with optional product and customer tracking
A2XQuickBooks OnlineCategorised payout summaries for reconciling deposits, instead of a customer ledger for every retail order
QuickBooks Desktop ConnectorQuickBooks Desktop accounting softwareShopify’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

RecordOperational ownerAccounting treatment to agree
Product or variantShopify catalogue ownerMatch the accounting item and income account, where item tracking is used
CustomerStore customer recordChoose named customers or the connector’s retail customer treatment
Order and paymentShopify order and payment recordsRecord the sale once and retain its original identifier
TaxShopify transaction detailMap the tax treatment to the bookkeeper’s approved accounts and codes
Processing feePayment provider transactionRecord the expense separately from sales
RefundShopify refund recordLink the refund to its original order and retain the tax adjustment
PayoutProvider settlement recordClear 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

ComponentShopify or provider recordExpected accounting effect
Original paymentAUD $220 capturedAUD $200 sales and AUD $20 tax, with AUD $220 due from the provider
Partial refundAUD $55 refundedReduce sales by AUD $50 and tax by AUD $5, reducing the provider balance
Processing feeAUD $6 deductedAUD $6 fee expense, reducing the provider balance
PayoutAUD $159 sent to the bankTransfer 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.

  1. 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.
  2. Inspect a transaction with an unmatched item or tax code. Correct its mapping, then confirm that the resulting entry uses the intended account.
  3. Compare the original IDs against an already imported order. Confirm that the overlap is recognised before repeating a historical import.
  4. Follow a partial refund and a subsequent correction. Compare the order total with the refund records and the eventual settlement adjustment.
  5. 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.

See it in actionFree trial · Simple setup