Lorixen.
EN

Shopify and Xero: syncing store orders into your accounts

Short answer: The big decision is whether each sale becomes its own transaction in Xero or whether sales are rolled up into a summary per day or per payout. Most growing stores are better off with summaries, because they match the deposits that actually land in the bank; per-sale detail suits low-volume stores that want customer and line-item data in Xero. Pick the integration that does the mode you need, map accounts carefully once, then reconcile payouts weekly.

Store owners connect Shopify to Xero hoping the books will look after themselves. They mostly can, but only after a few decisions made at setup: how much detail, which accounts, how fees and refunds are treated. Get those wrong and you spend every month matching a payout that never quite equals the sales.

Have your accountant or bookkeeper sign off on the account and tax mapping before you switch anything on; this article covers the mechanics, not the accounting treatment.

Decision 1: summary or per-sale?

Work through these questions.

How many orders do you take a day?

  • A handful → per-sale transactions are manageable and give you customer-level detail in Xero.
  • Dozens or more → summaries. Thousands of individual invoices make Xero slow to search and hard to reconcile.

Do you need customer or product detail inside Xero itself?

  • Yes (for example, wholesale customers on account, or sales reports by product in Xero) → per-sale.
  • No, Shopify's own reports are enough → summary.

Do you sell through more than one channel or payment method?

  • Yes → choose a tool that groups transactions per payout and per gateway, so each bank deposit has one matching entry.

Is someone confident in Xero doing the setup?

  • No → start with the simpler default setup and ask for help with the advanced mapping.

Decision 2: which integration?

Two common examples, each with a different approach. Check each provider's current listing before you choose.

Shopify integration by Xero. Its Xero App Store listing for NZ describes, as of November 2026:

  • A choice between a "Daily summary" for high-volume stores and "Per-sale transactions" for customer and line-item detail
  • Payout reconciliation for Shopify Payments and other methods, handling fees, refunds and taxes
  • Sales from both the online store and Shopify POS
  • Mapping Shopify taxes to Xero tax rates or liability accounts
  • Up to 90 days of historical data
  • Free on all Xero plans

Xero's connection guide notes it's built by integration partner Amaka, and walks through the setup steps: choosing a setup mode, selecting what syncs, transaction breakdown and account mapping (advanced setup only), tax mapping, payment type and bank account mapping, tracking categories (advanced only), and scheduling the sync plus historical import.

A2X. A2X's Shopify–Xero page describes summaries per payout period covering sales, fees and taxes, an entry each time Shopify pays you out, separate entries per payment gateway, POS data split by location, and historical data fetching. Its FAQ notes you still need to account for fees charged by gateways such as Stripe or PayPal.

Both approaches can work. The deciding factor is usually whether you want summaries by day or by payout, and how many channels and gateways you need to bring together.

Setup steps

  1. Clean up Xero first. Create or confirm accounts for sales, shipping income, discounts, refunds, merchant fees, gift card liability and a clearing account for each payment gateway if your tool uses them. Your accountant will have a view on names.
  2. Connect and choose the mode. Daily summary, per-payout summary or per-sale, as decided above.
  3. Map every transaction type. Sales, shipping, discounts, refunds, gift card sales and redemptions, tips, fees. Unmapped types are where reconciliation problems begin.
  4. Map payment types to the right accounts. Shopify Payments, PayPal, gift cards, manual payments (bank transfer, cash on POS) each need a destination.
  5. Map taxes as your accountant advises.
  6. Set tracking categories if you report by channel or location.
  7. Import a short historical period first, check it, then extend.
  8. Turn on the scheduled sync.

Gift cards and refunds: the two usual trouble spots

Gift cards. Selling a gift card isn't a sale of goods yet; redeeming it later is. If gift card sales are mapped straight to sales income, revenue gets counted twice: once when the card is bought and again when it's spent. Map gift card sales to a liability account and redemptions out of it, or follow whatever treatment your accountant sets.

Refunds. A refund can land in a different payout from the original sale, and sometimes the payout goes negative. Make sure refunds are mapped to their own account, and check how your integration handles a payout that's smaller than expected because refunds outweighed sales that day.

The weekly reconciliation routine

Fifteen minutes a week keeps it tidy:

  1. In Xero's bank reconciliation, find each Shopify Payments deposit.
  2. Match it to the corresponding summary or clearing-account entry from the integration.
  3. Check that the fees on the entry agree with Shopify's payout details for the same payout.
  4. Repeat for PayPal and any other gateway.
  5. Look for anything left unreconciled in clearing accounts. A balance that keeps growing usually means a payment type or transaction type isn't mapped.
  6. Spot-check one day's sales total against Shopify's own finance reports.

Once a month, check the gift card liability balance against Shopify's outstanding gift card total.

Multi-channel sellers

If you sell through Shopify plus a marketplace or a second store, keep each channel's settlements separate in Xero, using tracking categories or separate clearing accounts, so each deposit still matches one entry. Some integrations support several channels; others are Shopify-only, so check before you commit.

FAQ

Can I switch from per-sale to summary later?

Usually yes, but switching mid-year can make reports messy. Decide early, and if you switch, do it at the start of a month and tell your accountant.

Why doesn't my payout match my sales for the day?

Payouts cover a payout period, not a calendar day, and they're net of fees and refunds. Summaries built per payout make this much easier to see.

Do I still need a bookkeeper?

The integration does the data entry. Someone still needs to review mapping, reconcile, and handle the odd transaction that doesn't fit.

What about POS sales?

Both examples above describe syncing Shopify POS as well as online sales. Map POS cash and card payments to the right bank or clearing accounts.

Clean sales data in Xero starts with a careful mapping session, and we're happy to help you plan how your store and Xero fit together.

Sources

WhatsAppLet’s talk