Reviewed by Reuben Bergola, CA, Managing Partner, New Wave Accounting. Last reviewed 27 October 2026.
The cleanest Xero Shopify integration for an Australian store doing real volume posts one summary entry per payout, so every entry in Xero matches a bank deposit to the cent. Xero’s free Shopify integration can suit a simple store, but once you add PayPal or Afterpay, refunds, gift cards or overseas customers, ecommerce accountants commonly set up a settlement summary tool such as A2X with clearing accounts. This guide explains why, how to map GST, and the setup checklist we follow.
Why your Shopify payout never matches your sales
A Shopify Payments payout is a net figure. Before the money reaches your bank, Shopify deducts processing fees, any refunds issued since the last payout, and the amount of any chargeback plus its dispute fee.
Timing makes it harder. In Australia, Shopify Payments has a minimum settlement time of two business days, and payments captured on Friday, Saturday and Sunday are grouped into one payout. So a single deposit often covers several days of orders, and a deposit in early July can include June sales.
Other gateways such as PayPal and Afterpay pay you separately, on their own schedules, after taking their own fees.
Code each deposit straight to “Sales” in Xero and your revenue is understated, your fees are buried and your GST is likely wrong.
The four ways to connect Shopify and Xero
| Method | What lands in Xero | Reconciliation | Best suited to |
|---|---|---|---|
| Manual entry from Shopify reports | Whatever you key in | Slow and error prone | Very new, very low volume stores |
| Order-by-order sync apps | One transaction per order | Many entries to match; residual balances common | Low order volumes needing order detail in Xero |
| Xero’s free Shopify integration | Daily summary or one transaction per order, via a Shopify Payment Balance account | Transfer created when Shopify pays out | Simpler stores, mostly Shopify Payments |
| Settlement summary app (A2X) | One summarised entry per payout, per gateway | Entry equals the deposit; one-click match | Growing stores, multiple gateways or channels |
Xero’s free Shopify integration: strengths and limits
Xero now offers its own Shopify integration, built by its integration partner Amaka and free on all Xero plans at the time of writing. Once connected, it syncs daily sales and fees from your online store and Shopify POS into a “Shopify Payment Balance” bank account in Xero. When Shopify sends a deposit, Xero creates a transfer from that account to your real bank account, ready to reconcile.
You choose Summarised (all sales over a 24-hour period combined into one transaction) or Per Order (each sale as its own transaction), and whether sales post as invoices or bank transactions. The mapping includes separate accounts for fees, chargebacks, tips and gift cards (the last two as liabilities).
Where it falls short for growing stores:
- Per Order mode creates clutter. Hundreds of orders a week means hundreds of Xero transactions to review.
- Summaries are daily, not per payout. The balance account bridges the gap, but someone needs to check it clears regularly.
- Other gateways sit in clearing accounts you manage. Payment types other than Shopify Payments are allocated to clearing accounts, which you still have to reconcile.
- Limited history. You can import sales from up to 90 days before connecting.
- One integration only. Xero warns against running it alongside Xero Inventory Plus because of double entry. The same logic applies to any second sync app.
For a single-channel store on Shopify Payments with modest volumes, set up carefully in Summarised mode, it can be enough.
The clearing account method (and why accountants prefer it)
A clearing account is a temporary holding account in Xero, set up as a current asset, where money sits between the sale and the deposit. Once everything has cleared, its balance should be zero or close to it (anything left is usually money in transit).
A2X works on this principle. For Shopify Payments, it creates one summarised entry for every payout, broken into sales, refunds, shipping, discounts, fees and tax, and posts it to Xero as an invoice. Because the total equals the deposit, you match it in one click.
For other gateways, A2X posts a separate entry per gateway with an offsetting line to that gateway’s clearing account. A2X recommends a dedicated clearing account for each gateway. When the gateway pays you, you code the deposit to the clearing account. Because gateways such as PayPal deduct fees outside Shopify, A2X cannot see them, so you record those fees (and any chargebacks raised directly with the gateway) by journal, usually monthly.
A2X also splits payouts that span two months, can post COGS (cost of goods sold, the cost of the stock you sold) against each payout when you load product costs, and can load up to a year of past payouts.
Why accountants prefer this approach:
- Every entry ties to a real deposit.
- Xero stays lean, with order numbers to trace back to Shopify.
- Revenue lands in the month it was earned.
- Each transaction type, and its GST, is mapped once.
- The same method works for Amazon and eBay (see our Amazon seller accounting guide).
Fees, refunds, gift cards and currencies
| Item | What happens | How to handle it in Xero |
|---|---|---|
| Shopify Payments processing fees | Deducted from each payout | Map to a dedicated fees expense account |
| Shopify plan and app charges | Billed on your Shopify bill every 30 days, not taken from payouts | Enter as bills from Shopify’s invoices |
| Refunds | Deducted from your next payout | Map to a refunds account at the same tax rate as the original sale |
| Gift cards | Selling one is not yet revenue | Hold in a gift card liability account until redeemed |
| Chargebacks | Amount plus dispute fee deducted | Map the chargeback and the fee separately |
| Overseas customers paying in their own currency | Converted to your payout currency; a currency conversion fee (2% for Australian stores at the time of writing) is deducted and not returned on refunds | Map conversion fees to their own expense account so overseas margins are visible |
| PayPal, Afterpay and other gateways | Paid separately, fees deducted by the gateway | One clearing account per gateway, plus a monthly fee journal |
GST mapping in Xero: Australian vs overseas sales
If you are registered for GST, your integration must separate taxable Australian sales from GST-free sales, or your BAS (business activity statement) will be wrong. Exported goods are generally GST-free if you export them within 60 days of receiving payment or issuing an invoice, whichever comes first, but the conditions matter. Our GST guide for online sellers covers the rules in detail.
In A2X, tax comes through as separate lines. A2X’s guidance for Australian sellers is to map each sales line and its matching tax line to the same GST rate, so Xero calculates GST itself and your GST reports are correct. Assisted setup asks your main country and whether you collect GST, then applies default mappings you should review. Watch for transactions marked “country unknown”, which need a decision before posting.
Two more checks: confirm the GST on Shopify and app fees from the actual tax invoices, and remember that for face value gift vouchers the ATO says GST is accounted for on redemption, not when the voucher is sold.
Step-by-step Shopify to Xero setup checklist
| Step | What to do | Why it matters |
|---|---|---|
| 1 | Pick a clean start date, ideally the start of a month or BAS period | Avoids half-recorded periods |
| 2 | Disconnect or pause any existing sync app | Prevents double counting |
| 3 | Review your chart of accounts: sales, shipping income, refunds, discounts, Shopify fees, gateway fees, conversion fees, gift card liability, a clearing account per gateway, COGS and inventory | The structure your reports rely on |
| 4 | Connect A2X (or your chosen tool) to Xero and Shopify, and enable every gateway you accept | Missing gateways mean missing sales |
| 5 | Map every transaction type to an account and tax rate, splitting domestic and GST-free sales | Correct BAS and profit and loss |
| 6 | Load product costs if posting COGS | Accurate gross margin (inventory and landed cost guide) |
| 7 | Review one payout against Shopify’s payout report and the bank deposit before posting | Catches mapping errors early |
| 8 | Post, then reconcile in Xero | Confirms the end-to-end flow |
| 9 | Monthly: post gateway fee journals and check every clearing account | Keeps balances near zero |
| 10 | Before each BAS: compare Xero’s GST figures to Shopify’s tax reports | Final safety net |
Common mistakes we see
- Coding Shopify deposits straight to sales.
- Running two integrations at once, such as Xero’s integration and A2X, on the same sales.
- Using one clearing account for every gateway, so nobody can tell which balance is wrong.
- Ignoring a clearing account that keeps growing (usually deposits coded to sales, or fees never journalled).
- Treating gift card sales as revenue.
- Charging or reporting GST incorrectly on overseas orders or shipping.
- Leaving Shopify app charges paid on a personal card and never entered in Xero.
When to get help
DIY setup works for some stores. It is worth bringing in a Xero accountant when you accept more than one gateway, sell overseas, sell on more than one channel, have clearing accounts that never clear, or have margins that do not make sense.
That last point is common. One online retailer we work with sells internationally and could not make its margins add up. We connected A2X to Xero, rebuilt the chart of accounts, set up monthly inventory tracking and corrected the GST treatment. The owner now gets reliable monthly figures and accurate margins.
New Wave Accounting is a firm of Chartered Accountants, a Xero Platinum Partner and A2X certified, and ecommerce is a core niche for us. A2X setup, clean-ups and ecommerce bookkeeping are quoted upfront in writing, so there are no surprise bills. For the bigger picture, see our complete guide to ecommerce accounting, the hidden profit leaks in ecommerce, the ecommerce accounting software stack and our ecommerce accountant hub.
FAQ
Does Xero integrate directly with Shopify?
Yes. Xero offers a Shopify integration, built by its partner Amaka, that is free on all Xero plans at the time of writing. It syncs Shopify sales and fees as daily summaries or per-order transactions and creates a transfer when Shopify pays out. Many growing stores use a settlement summary app such as A2X instead.
Can I use A2X and Xero’s Shopify integration together?
Not for the same sales. Both record your Shopify sales in Xero, so running both will double count revenue. Pick one and disconnect the other from your start date.
How do I reconcile Shopify payouts in Xero?
Use a tool that posts one entry per payout, broken into sales, refunds, fees and tax, so the entry equals the bank deposit. You then match the deposit to that entry in Xero’s bank reconciliation screen. Payments through other gateways go through a clearing account for each gateway.
How do I record PayPal sales from Shopify in Xero?
Record the sales to a PayPal clearing account, code each PayPal withdrawal to the same account, then journal PayPal’s fees from its monthly statement. Anything left at month end should be money in transit.
Should every Shopify order sync into Xero?
Usually not. Order-level syncing fills Xero with transactions nobody needs, while a payout summary keeps order numbers so you can trace any sale back to Shopify.
What does a Shopify accountant do differently?
They set up the integration, chart of accounts and GST mapping so Xero reconciles to Shopify, your bank and your BAS, and track inventory and COGS so your margins are real.
Talk to an ecommerce accountant
If your Shopify payouts and Xero never quite agree, see how we work with online sellers on our ecommerce accountant page, or book a free 20-minute call.
This is general information only and does not consider your circumstances. Talk to a registered tax agent before acting on it.
Sources
- Xero Central, “Connect to the Shopify integration by Xero”: https://central.xero.com/0/article/Connect-to-Shopify-US (US regional version; the AU version at https://central.xero.com/s/article/Connect-to-Shopify-AU sits behind a Xero login)
- Xero App Store (AU), Shopify by Xero: https://apps.xero.com/au/app/shopify
- Xero App Store, A2X listing: https://apps.xero.com/us/app/a2x
- Shopify Help Center, lower or missing payouts: https://help.shopify.com/en/manual/payments/shopify-payments/payouts/lower-or-missing-payouts
- Shopify Help Center, Shopify Payments refunds: https://help.shopify.com/en/manual/payments/shopify-payments/payouts/refunds
- Shopify Help Center, payout timing: https://help.shopify.com/en/manual/payments/shopify-payments/payouts/payout-timing
- Shopify Help Center, setting up currencies for markets (conversion fees): https://help.shopify.com/en/manual/markets/customizations/local-currencies
- Shopify Help Center, international fees and costs: https://help.shopify.com/en/manual/international/pricing/fees
- Shopify Help Center, types of charges on your Shopify bills: https://help.shopify.com/en/manual/your-account/manage-billing/billing-charges/types-of-charges
- Shopify Help Center, app charges on your Shopify bills: https://help.shopify.com/en/manual/your-account/manage-billing/billing-charges/types-of-charges/third-party-charges/app-charges
- A2X, Shopify Xero integration guide (updated 19 Aug 2026): https://www.a2xaccounting.com/ecommerce-accounting-hub/shopify-xero-integration
- A2X Support, using clearing accounts for other payment gateways (19 May 2026): https://support.a2xaccounting.com/en/articles/6041146-a2x-for-shopify-using-clearing-accounts-for-other-payment-gateways
- A2X Support, A2X for Shopify and Australian GST: https://support.a2xaccounting.com/en/articles/3401545-a2x-for-shopify-and-australian-gst
- A2X Support, assisted setup for Australia and New Zealand sellers: https://support.a2xaccounting.com/en/articles/6459446-a2x-accounts-and-tax-mapping-assisted-setup-australia-and-new-zealand-sellers
- A2X Support, Shopify transactions and how to account for them: https://support.a2xaccounting.com/en/articles/2966364-shopify-transactions-what-they-mean-and-how-to-account-for-them
- ATO, GST and vouchers: https://www.ato.gov.au/businesses-and-organisations/gst-excise-and-indirect-taxes/gst/in-detail/rules-for-specific-transactions/gst-and-vouchers
- ATO, Exports and GST: https://www.ato.gov.au/businesses-and-organisations/international-tax-for-business/australians-doing-business-overseas/exports-and-gst
