Xero–Shopify reconciliation for NZ: five mismatches to catch

If you sell on Shopify and bookkeep in Xero, connectors move data; reconciliation means the money story matches across Shopify payouts, bank feeds, GST coding, and what customers were actually charged. When it does not, month-end turns into an investigation.

This guide is NZ-flavoured because GST, NZD settlements, and local payment providers create recurring mismatch patterns. No invented percentages: just five places to look every week or every payout cycle, then a way to fix the mapping for good.

Mismatch 1: payout total vs invoice/sales total

Shopify (or your payment provider) pays a net amount after fees, refunds, and chargebacks. Xero might show gross sales invoices from the connector while the bank feed shows a smaller deposit. Staff then "force" the bank line to clear against the wrong invoices.

Check: for each payout period, compare the Shopify Payments (or Stripe/Afterpay) payout summary → bank deposit → Xero clearing account. The three should tell one story. If the connector creates invoices at gross, you need a consistent fee and refund treatment, not ad-hoc journal patches.

Mismatch 2: GST on shipping, discounts, and mixed rates

NZ GST is usually 15%, but shipping tax settings, discount codes, and products marked non-taxable (rare but real) create line-level differences. A connector that rounds differently from Shopify's tax engine will drift over hundreds of orders.

Check: sample ten orders with discounts and shipping. Confirm tax on the Shopify order equals tax on the Xero invoice. If not, fix tax mapping before you "adjust" GST in Xero manually. Manual GST patches compound.

Mismatch 3: refunds timed across payout periods

Refunds issued after a payout still reduce a later deposit. Refunds may hit Shopify immediately and land in Xero under a different date or account: Xero may show the refund against the original invoice date while the bank impact lands next week. That is normal timing, but only if both sides are coded. Orphan refunds in Shopify with no Xero credit note are how receivables lie.

Weekly habit: list Shopify refunds from the last seven days and confirm each has a matching credit note or clearing entry. Approval-gate any refund that is not already in a playbook.

Mismatch 4: app fees, currency conversion, and AU sales

Selling into Australia from an NZ store introduces FX on some providers, marketplace fees, and apps that bill in USD on the card while sales sit in NZD. Those costs often land on the bank feed without a tidy Shopify "order" to match. Payment and payout fees also sit in Shopify's reports in a way that does not match how Xero expects bank clearance.

Check: maintain a short chart of accounts for platform fees, FX differences, and app subscriptions. Do not dump them into "Shopify sales" or COGS. If you expand AU channels, revisit the mapping with your accountant.

Mismatch 5: gift cards, store credit, and partial fulfilments

Gift cards and store credit move liability, not (yet) revenue the way a simple product sale does. If both the sale and the redemption of a gift card are mapped as sales, it can look like revenue twice. Partial fulfilments and restocks confuse connectors that expect one invoice per order. The result is revenue recognised too early or liability ignored.

Check: compare the outstanding gift card balance in Shopify with the liability account in Xero, and investigate any large gap before month-end. For partial fulfilments, confirm whether your connector invoices on order or on fulfilment, then stick to one rule.

Shopify and Xero not matching? Why connector defaults drift

Many stores install a connector app, accept the default settings, and hope. Hope is not a reconciliation process. Shopify records orders, refunds, gift card activity and payment fees in its own way; Xero needs those events in accounts that match how you report GST and cash. Default connector settings rarely match an NZ retail chart of accounts on the first try, and one wrong mapping multiplies across every order.

Other things muddy the same water:

• Currency display apps.
• Manual journal "fixes" from prior months.
• A second sales channel, such as POS or wholesale.

Note every channel in scope before you change connector settings. If something only happened once, label it as one-off; do not bend the default mapping around it. The good news: comparing a full month of Shopify orders against what arrived in Xero usually surfaces a short list of repeatable causes rather than hundreds of unique mysteries.

How to fix the mapping with your bookkeeper

1. Pick a closed month. Compare Shopify totals to Xero line by line for the mismatch types you already dread.
2. Name the repeatable causes. Refunds, gift cards, payout fees and similar, not one-off guesses.
3. Propose mapping in plain language. Send it as a short table: transaction type, current behaviour, proposed account or tracking, and how to reverse it.
4. Let the bookkeeper have the final word. Ask them to mark anything that would break GST reporting. Treatment is their call.
5. Change settings only after approval. Then month-end becomes a check (totals within expected tolerance, exceptions listed, no silent remaps) rather than an archaeology dig.

If payouts and Xero have not agreed for months, start with one payout week and work outward.

A lightweight NZ weekly recon checklist

1. Last payout: Shopify summary = bank deposit = Xero cleared items
2. Refunds list matched to credit notes
3. Spot-check GST on discounted and shipped orders
4. Fee and FX accounts not buried in sales
5. Gift card liability sanity check

Inventory errors also show up as COGS noise later, so keep stock sync honest with the inventory sync break-points guide.

What operators do vs what accountants own

Operators catch mismatches early, prepare the exception list, and keep Shopify data clean. Accountants and bookkeepers own tax treatment, the chart of accounts, and year-end positions. Do not ask a connector to replace either role.

Backroom Ops is not an accounting firm. We will not silently reclassify revenue or invent GST treatment. We facilitate the comparison and prepare the proposal; you and your bookkeeper approve the mapping. If something is unclear, it stays flagged until it is clear. If you are weighing who should do this work week to week, see AI Shopify operator vs VA vs agency.

Illustrative examples

Illustrative examples based on patterns we see with NZ small businesses. Details generalised; not specific client results.

FAQ

Next step

Want a structured exception list from a Shopify-literate operator in NZT? Book a free diagnostic and bring a sample month export plus your bookkeeper's questions. We find the mismatches and propose the mapping; every change is approved by you and your bookkeeper before it happens.