Shopify + Xero Integration

Only on low-volume stores, or where individual invoices genuinely matter, such as B2B customers who expect an invoice with payment terms. Past a modest daily volume, per-order push runs into Xero’s per-minute and daily API limits, bloats the contact list, and hands your accountant thousands of documents to review instead of one. The daily summary approach posts one invoice or journal per day, per currency and payment gateway, carries the same totals, and reconciles faster. Most stores should summarise; the exceptions know who they are.

Because the payout is net and the invoices are gross. Shopify Payments deducts its fees and any refunds before the money lands, and one payout can span several days of orders. The fix is a clearing account: sales post gross to it, fees post per payout to an expense account, refunds post as credit notes or negative lines, and a transfer for the exact net amount moves clearing to bank. Set up this way, the bank feed line matches in one click. Without it, someone reconciles by hand forever.

Not at retail volume, and we will not build it that way. Tracked inventory in Xero is designed for small, stable catalogues: it costs on a rolling average, and it will refuse to post an invoice that would take an item’s quantity negative, which means any drift between Shopify and Xero blocks your revenue from posting. Shopify or a dedicated inventory app should own quantities; Xero should own the values, with cost of goods handled by journal. If a vendor proposes running live stock levels through Xero, ask them what happens during a flash sale.

Xero enforces both per-minute and daily API limits per connected organisation, and the exact numbers matter less than the shape of the problem: a busy store pushing an invoice, a contact check, and a payment for every order multiplies calls quickly, and a flash sale can put the sync hours behind. Daily summary posting nearly eliminates the risk, because a full day of trading becomes a handful of API calls. If per-order invoicing is a hard requirement, the sync has to pace itself under the limits with a queue and backoff, and you accept some latency during spikes.

Shopify is treated as authoritative for the tax actually charged at checkout, and each Shopify tax line maps to an explicit Xero tax rate rather than letting Xero recalculate. What those rates are depends on where you file: US sales tax, Australian and New Zealand GST, and UK or EU VAT are configured differently in Xero, and the filing obligations differ too. We build the tax map with your accountant during the audit and reconcile rounding at line level, so the return prepared from Xero agrees with what the store charged.

Yes, with two conditions. Your Xero plan has to include multi-currency, which not all plans do, and you have to decide once whether sales post in the customer’s presentment currency or your settlement currency. Mixing the two, or letting Shopify rates and Xero’s daily rates disagree silently, is how revenue drifts a little further from the store’s reporting every month. Where possible we set the exchange rate on each transaction from actual settlement data, so the books reflect what the bank received.

Try a connector first. Established apps such as A2X and Link My Books handle payout-based summary accounting from Shopify to Xero well, and for a single store in a single currency they are usually the right answer at a fraction of the cost of a build. Custom work earns its keep when you run multiple stores or currencies into one Xero organisation, need B2B invoices with terms alongside B2C summaries, take payment through gateways a connector does not reconcile, or have an accountant with specific posting requirements. If a connector covers you, we will say so and set it up properly.