Xero and Shopify integration: how to stop retyping orders into your accounts

Shopify tells you what you sold. Xero tells you where the money went. Connecting the two properly means your accounts are always current and your bookkeeper stops retyping orders. Connecting them badly means a Xero file full of thousands of tiny invoices that never reconcile. Here is how to get it right.

What needs to flow

• Sales. Order values, split by product type or tax rate as your accounts require.
• VAT. The right amount at the right rate, including zero-rated and export orders.
• Payments. What was paid, by which method (Shopify Payments, PayPal, Klarna), because each pays out differently.
• Fees. Gateway and platform fees, recorded as expenses.
• Refunds and returns. Credit notes or negative entries, correctly dated.
• Payouts. The batches that actually hit your bank, so the bank feed matches.
• Customers. Only if you need them individually in Xero, which most B2C stores do not.

Per order or per day?

The biggest design decision. Per-order invoices give full detail but for a store doing hundreds of orders a day they clog Xero and make reconciliation slow. Daily summaries post one journal or invoice per day (or per payout) with sales, VAT, fees and refunds totalled. Reconciliation is then a matter of matching a payout to a summary. For most retail stores, summaries are the right choice. For B2B stores where customers pay on account, per-order invoices are needed.

The parts that go wrong

Payouts and fees. Shopify Payments deposits money in batches, net of fees, a few days after the sale. If Xero records gross sales and nothing else, the bank deposit never matches. The integration must record the fee, and ideally post a payout entry that Xero can match to the bank line.

Multiple gateways. PayPal pays out separately, on its own schedule, net of its own fees. Each gateway needs its own clearing account in Xero.

Refunds. Must reduce sales and VAT in the period they happen, and match the negative amount in the payout.

Tax mapping. Standard, zero and exempt rates, and destination-based tax for exports, all need to map correctly. This is the item your accountant should review first.

Gift cards and discounts. Selling a gift card is a liability, not a sale; redeeming it is when the sale happens. Discounts reduce sales. Both need explicit handling.

Your options

Connector apps. Several apps in the Shopify app store connect to Xero with daily summaries, fee handling and tax mapping built in. For most stores, one of these is the right answer. Set it up carefully, review the first month with your accountant, then leave it alone.

Odoo in the middle. If you run Odoo for operations and Xero for accounts, orders come into Odoo from Shopify and Odoo posts to Xero. Two integrations, but Odoo handles stock and fulfilment along the way. See Shopify to Odoo integration.

Custom integration. For high volumes, multiple stores, multi-currency, or accounting structures the apps do not support. Built to your accountant's specification.

Setting it up well

1. Agree the accounting structure with your accountant: accounts for sales, VAT, fees, refunds, and clearing accounts per gateway.
2. Map every Shopify tax setting to a Xero tax rate.
3. Run the integration on a test period and reconcile it by hand once.
4. Check the first payout matches to the penny.
5. Review monthly for the first quarter, then quarterly.

Beyond Shopify

The same principles apply to WooCommerce to Xero, and to QuickBooks or Sage instead of Xero. The store changes; the accounting logic does not. Our guide to what is system integration covers the general approach.

We set up connector apps and build custom integrations, and we work with your accountant on the mapping. Read about our integrations service or request a quote.

Frequently asked questions