How to connect Shopify to Xero: the options, and how to keep the books right
Connecting Shopify to Xero takes minutes. Getting payouts, fees, refunds and GST to land correctly takes a decision about detail, and a test before you trust it.
Every Shopify store owner on Xero runs into the same thing. Sales come in all day, but what lands in the bank is a payout: several days of sales, less Shopify’s fees and any refunds, paid as one lump sum. If the books record the payout as “sales”, revenue, fees and GST are all wrong. If someone types every order in, they spend hours on it and still struggle to match the bank.
Connecting Shopify to Xero fixes this, as long as you choose the right level of detail and test it before you trust it. This guide covers the options and the setup.
What needs to reach Xero
Whichever way you connect, these are what the books need:
- Sales, split by tax treatment (GST and GST-free).
- Shipping charged to customers, and discounts given.
- Refunds.
- Shopify and payment fees, as an expense, with the GST on them.
- Payouts to your bank account, so the bank reconciles.
- Gift cards: a liability when sold, and a sale only when redeemed.
- Optionally, cost of goods sold and stock, if you track inventory in Xero.
The three ways to connect Shopify to Xero
1. Xero’s own Shopify integration
Xero offers its own Shopify integration, listed in the Xero App Store as free on all Xero plans. You choose whether it posts a daily summary or separate transactions per sale. It maps Shopify’s taxes to Xero tax rates, handles fees and refunds, matches payouts from Shopify Payments to your bank account, covers Shopify POS sales as well as the online store, and can bring in up to 90 days of history.
For many single-store businesses on Shopify Payments, this is the place to start.
2. Payout summary apps
Apps such as A2X and Link My Books post one summary per payout, broken into sales, refunds, fees and other items, so each entry matches the deposit in your bank exactly. They suit higher volumes, several sales channels (for example Shopify plus Amazon or eBay) and accountants who want clean, payout-level books. They charge a monthly fee that rises with order volume.
3. Per-order sync apps
Other apps create an invoice for every order in Xero, with the customer and product lines. That detail is useful if you sell to trade customers or need customer-level history in Xero. At high volume, it fills Xero with thousands of small invoices and makes the books slower to work with.
| Approach | What lands in Xero | Suits | Watch out for |
|---|---|---|---|
| Xero’s own integration | A daily summary, or one transaction per sale | One store on Shopify Payments, wanting a free start | Check how it treats your gift cards, other payment gateways and multi-currency |
| Payout summary app | One entry per payout, split into sales, fees and refunds | Higher volume, several channels, accountant-led books | A monthly fee by volume; a setup that needs care |
| Per-order sync app | An invoice per order, with customer and items | Trade customers, or a need for customer detail in Xero | Thousands of invoices; slower books |
Whichever you choose, a payout summary or daily summary is usually enough for the books. Customer-level detail already lives in Shopify.
How payouts reconcile: the clearing account
The cleanest way to keep payouts straight is a Shopify clearing account: a balance-sheet account that holds the money Shopify owes you.
- Sales, refunds and fees are posted to the clearing account as they happen.
- When Shopify pays out, the deposit in your bank is matched as a transfer out of the clearing account.
- The clearing account’s balance is then exactly what Shopify still holds. If it drifts, something is being missed.
Payout summary apps work this way by design, and Xero’s own integration matches Shopify Payments payouts to the bank. If you also take payments through PayPal, Afterpay or another gateway, give each one its own clearing account, so each deposit matches its own source.
Getting GST right
- Set up tax in Shopify first. Products and shipping need the right tax settings in Shopify before any app can post them correctly.
- Map every Shopify tax to the right Xero tax rate, including GST-free products and any international sales.
- Remember the GST on fees. Shopify’s fees are a business expense, and the GST treatment of them should match your invoices from Shopify.
- Test a handful of orders of each kind (GST, GST-free, refunded, discounted, with shipping), and check the BAS figures they produce before you rely on the connection.
Setting it up, step by step
- Decide the level of detail: daily summary, payout summary or per order.
- Set up the accounts in Xero: a Shopify clearing account, a fees expense account, a gift card liability account and a shipping income account.
- Map taxes and accounts in the integration.
- Connect, and bring in a short test period, such as one week.
- Reconcile one payout end to end: sales less fees less refunds should equal the deposit, and the clearing account should return to the amount Shopify still holds.
- Check GST on the test period against a manual calculation.
- Name an owner, and check the clearing account at every month-end.
Common mistakes
- Recording payouts as sales. Fees vanish from the accounts, and revenue and GST are understated.
- Double counting. Connecting an app while someone still enters sales manually, or running two apps at once.
- Treating gift card sales as revenue when they are sold, rather than when they are redeemed.
- Ignoring other gateways. Shopify Payments matches, but PayPal or Afterpay deposits are left unexplained.
- Never checking the clearing account. A growing balance means something is not being posted.
Stock and cost of goods sold
Xero can track simple inventory, but most stock-heavy stores use a dedicated inventory app connected to both Shopify and Xero, so stock levels, purchase orders and cost of goods sold stay in step. If stock is outgrowing your setup, our guide to outgrowing Xero covers the options in order.
Frequently asked questions
Does Shopify integrate with Xero?
Yes. Xero offers its own Shopify integration, and several apps connect the two in different ways: payout summaries (such as A2X or Link My Books) or an invoice per order.
Is Xero’s Shopify integration free?
Xero’s App Store listing describes its Shopify integration as free on all Xero plans. Third-party apps charge a monthly fee, usually by order volume.
Should I sync every order, or a daily summary?
For most stores, a daily or payout summary. It keeps Xero fast and still reconciles to the bank, while customer and order detail stays in Shopify. Sync every order only if you need customer-level detail in Xero, such as for trade accounts.
How much does a Shopify to Xero integration cost?
The connection itself can be free (Xero’s own integration) or a monthly app fee that rises with volume. The bigger cost is getting the setup right: accounts, tax mapping and testing. A wrong setup costs more at the first BAS than a careful one does upfront.
How we help
This is where finance and systems meet, which is exactly our work. We set up the connection, the accounts and the tax mapping, test it against a real payout and your BAS, and hand over a month-end check your team can run. See our business systems and integration work and our work with e-commerce retailers, or contact us.
Sources
Share this