Shopify and Xero Reconciliation: Complete Guide for 2026

Shopify and Xero are two of the most widely used platforms for ecommerce sellers. Connecting them sounds simple. In practice, it trips up store owners and bookkeepers every month — because what Shopify sends to your bank account almost never matches any individual sale, and the difference is rarely obvious without a structured reconciliation process.

This guide covers the full picture: why Shopify-Xero reconciliation is genuinely hard, what the native integration can and cannot do, how to set up your chart of accounts correctly, a step-by-step manual reconciliation process, and an honest comparison of the tools that automate it. The goal is to give you a process that works regardless of your store's volume, payment gateways, or tax jurisdiction.

Why Shopify-Xero Reconciliation Is Complex

Understanding the root causes of the complexity makes the solutions much clearer.

Shopify Pays Out in Net Bulk Amounts

Shopify Payments does not send you one bank transfer per order. It aggregates sales across a rolling settlement period — typically two business days — deducts processing fees, refunds, chargebacks, and adjustments, then deposits a single net figure into your bank account. A deposit of $4,312.17 might represent 47 transactions, 3 refunds, $189 in processing fees, and a chargeback reversal. None of those line items appear individually on your bank statement.

This is the fundamental mismatch. Your Xero books record gross revenue per order. Your bank receives net payouts. Reconciling between them requires accounting for everything in between.

Multiple Payment Gateways Create Separate Payout Streams

Most Shopify stores accept more than one payment method: Shopify Payments, PayPal, manual bank transfers, and sometimes buy-now-pay-later providers like Klarna or Afterpay. Each of these operates on its own settlement schedule with its own fee structure. A single day of sales can result in three separate deposits arriving on different days, from different processors, with different amounts deducted.

Shopify Payments (which is powered by Stripe) and an external Stripe gateway, for example, behave differently in payout reports and require different treatment in Xero. This is one of the most common sources of reconciliation confusion.

Tax Treatment Varies by Region

Shopify collects and remits sales tax in the US under its marketplace facilitator obligations for many states — but Xero's native Shopify integration does not account for US sales tax at all. Sales tax data must be downloaded directly from Shopify and handled separately. For UK and European merchants, VAT treatment is more straightforward with the native integration, but multi-country VAT for global sellers adds complexity.

For Australian and New Zealand merchants, GST recording in Xero needs to be correctly mapped — Shopify can collect GST on applicable sales, but whether A2X or another tool extracts and allocates it correctly depends on configuration.

Refunds, Chargebacks, and Gift Cards Each Have Specific Accounting Requirements

Refunds reduce your next payout rather than appearing as a separate outgoing payment. This means a single Shopify payout covers multiple sales periods and includes deductions from refunds that may have been processed days earlier. Chargebacks involve a dispute fee (typically $15) deducted whether you win or lose. Gift card purchases are liabilities at the point of sale, not revenue — they become revenue only when redeemed.

Each of these has a specific correct treatment in Xero. Getting any of them wrong creates cumulative errors that compound over time.

Does Xero Have a Native Shopify Integration?

Yes, but it comes with significant limitations that are worth understanding before you rely on it.

What the Native Integration Does

Xero's official Shopify integration — available from the Xero App Store — syncs a daily summary of Shopify sales into Xero at the end of each day. It creates a daily summary invoice covering sales, discounts, shipping, refunds, gift cards, and fees across your payment gateways. For AU, NZ, and UK merchants, it groups sales by tax rate to simplify GST and VAT reporting.

Pricing for the native Xero Shopify integration:

• US, Canada, Singapore, and rest of world: Free
• Australia and New Zealand: NZD/AUD $20 per month (excluding GST)
• United Kingdom: £10 per month (excluding VAT)

The Xero native app has a 1.8/5 rating on the Shopify App Store (as of late 2025), with 59% of reviews giving it one star. The most common complaints are reconciliation mismatches, incorrect fee handling, and inadequate support.

The Key Limitations

No US sales tax handling. The native integration explicitly does not account for US sales tax. Sales tax data must be downloaded from Shopify separately. This is a significant gap for US-based stores.

Daily summary only, not per-transaction. The integration posts a single aggregated invoice per day, not individual orders. You cannot match a specific Shopify order to a specific Xero entry. For audit purposes or order-level investigation, this is a real constraint.

Does not automatically match payouts to the bank feed. Shopify pays out net of fees, but the native integration records gross sales in a clearing account structure that does not automatically reconcile to the net payout in your bank. Manual matching is still required.

No COGS or multi-location support. The integration does not sync cost of goods sold data or support multi-location inventory, limiting its usefulness for retailers who track inventory margins in Xero.

What You Need to Reconcile Shopify in Xero

Before setting up any integration or manual process, you need the right account structure in Xero.

Recommended Chart of Accounts for Shopify Sellers

Revenue accounts

• Sales — Products (mapped to Shopify product sales)
• Sales — Shipping Revenue (if you charge for shipping)
• Discounts Given (contra-revenue; do not net against sales)
• Gift Card Liability (current liability; move to revenue on redemption)

Expense accounts

• Payment Processing Fees (Shopify Payments / Stripe / PayPal transaction fees)
• Shopify Subscription Fee (monthly platform cost)
• Shopify App Fees (third-party apps)
• Chargeback Fees (separate from processing fees for visibility)
• Returns and Allowances

Current asset accounts

• Shopify Clearing Account (the central staging account — see below)
• Shopify Payments in Transit (for amounts settled but not yet deposited)

Tax accounts

• Sales Tax / VAT Payable (jurisdiction-specific)
• GST Collected (AU/NZ)
• Input Tax Credits (AU/NZ)

Why the Shopify Clearing Account Is Non-Negotiable

A clearing account is a staging account that sits between your Shopify sales entries and your bank account in Xero. When a sale occurs, gross revenue posts to the clearing account. When fees are deducted, the clearing account decreases. When a refund reduces the payout, the clearing account decreases. When the net payout arrives in your bank, you match it against the clearing account balance — which should now equal the payout amount exactly.

Without a clearing account, you are trying to match a net bank deposit against multiple gross sales figures while manually accounting for fees and refunds. It creates an arithmetic puzzle that is easy to get wrong and hard to audit.

To create the clearing account in Xero:

1. Go to Accounting > Chart of Accounts
2. Click Add Account
3. Account type: Current Asset
4. Name: "Shopify Clearing" or "Shopify Payments Clearing"
5. Code: assign a code near your other current asset accounts (e.g., 1250)
6. Save

Step-by-Step: Manual Shopify-Xero Reconciliation

If you are not using an automation tool, this is the correct process to follow for each payout cycle.

Step 1: Download the Shopify payout report

In Shopify admin, go to Analytics > Reports > Finances > Payouts. Click the specific payout and download the full breakdown. This shows gross sales, refunds deducted, processing fees deducted, adjustments, and the net payout amount.

Step 2: Verify or record gross sales in Xero

If the native Xero integration has already imported daily summaries, verify the total gross sales for the payout period match the Shopify report. If you are working manually, create journal entries or sales invoices for the gross amount, crediting your Sales revenue account and debiting the Shopify Clearing account.

Step 3: Record processing fees as expenses

From the payout breakdown, create a bill or journal entry for total processing fees. Debit your Payment Processing Fees expense account, credit Shopify Clearing. This reduces the clearing balance by the fee amount.

Step 4: Record refunds as credit notes

For each refund in the payout period, create a credit note in Xero against the original invoice. The credit note reduces Sales revenue and reduces the Shopify Clearing balance.

Step 5: Verify the clearing account balance

Before touching the bank reconciliation, confirm the clearing account balance equals the net payout. The formula:

Gross Sales − Processing Fees − Refunds − Chargeback Fees − Adjustments = Net Payout

If the numbers do not match, something is unrecorded. Do not proceed until they balance.

Step 6: Match the payout in the bank feed

In Xero's bank reconciliation screen, find the incoming payout deposit. Match it to the Shopify Clearing account — not to a sales account directly. This closes the clearing account for that payout cycle and completes the reconciliation.

Repeat this process for every payout, and separately for each payment gateway (PayPal, Stripe, Afterpay) that settles to your bank independently.

How to Handle Shopify Refunds in Xero

Refunds deserve specific attention because they are the most common source of reconciliation errors.

The accounting treatment for a refund:

• The original sale should have been recorded as: Debit Shopify Clearing, Credit Sales Revenue
• The refund reverses this: Debit Sales Revenue (or create a credit note), Credit Shopify Clearing
• The payout is reduced by the refund amount, so the bank deposit is lower by the refund amount

What goes wrong: Many store owners record refunds as a new expense entry (Debit Refunds Expense, Credit Bank). This is incorrect. It overstates costs, understates gross revenue, and leaves the clearing account out of balance. A refund is a reversal of a previous sale, not a new cost.

Gift card edge case: If the original purchase was made with a gift card, the refund goes back to the gift card balance (a liability), not to the clearing account. This requires a separate entry to restore the gift card liability. If Shopify reloads the gift card rather than refunding to a payment method, no cash moves at all — only the liability balance changes.

Chargebacks: A chargeback is different from a refund. Shopify deducts both the sale amount and a dispute fee from your next payout. If you win the dispute, Shopify reverses the deduction. If you lose, you absorb both. Record the chargeback fee to your Chargeback Fees expense account separately from general processing fees — it gives you visibility into dispute costs over time.

The Better Way: Integration Tools

For any store processing more than a few hundred orders per month, manual reconciliation is a significant time cost. The tools below automate the mapping of Shopify payouts to Xero accounts.

A2X

A2X is the longest-established Shopify-Xero integration tool and the one most frequently recommended by ecommerce accountants. It fetches each Shopify payout, maps every transaction type (sales, fees, refunds, gift cards, adjustments) to your Xero chart of accounts, and posts a clean summary that reconciles directly to the bank feed. It handles multi-currency transactions, per-region tax mapping (VAT, GST, US sales tax), and is particularly strong for high-volume stores.

Pricing starts at approximately $19/month for basic plans, scaling with order volume. Setup requires time to configure account mappings correctly, but once configured it runs automatically.

Link My Books

Link My Books posts a summarized journal entry to Xero for every Shopify payout, covering sales, fees, and taxes. The journal automatically matches to the bank feed, making reconciliation a one-step process. It is popular with UK merchants for its VAT handling. Pricing starts at approximately $17/month. One limitation: it does not offer per-order journal entries, only per-payout summaries.

Amaka

Amaka offers a free tier for stores with under 60 transactions per month, making it the lowest-cost entry point for small stores. It creates a daily summary invoice in Xero and uses clearing accounts to record sales before the payout arrives. Customer support includes live video sessions, which is uncommon in this category. Paid plans start at approximately $15/month.

Synder

Synder is designed for multi-channel sellers — stores that combine Shopify with Amazon, eBay, or multiple payment processors simultaneously. It syncs per-transaction rather than per-payout, which gives more granular records but can create high transaction volumes in Xero for large stores. Pricing starts at approximately $52/month.

Reconkept

Reconkept is purpose-built for Shopify-Xero reconciliation, with a review-before-post workflow that lets you see exactly what will be recorded before anything touches your Xero books. Sales, fees, taxes, and refunds are broken out correctly. For store owners who want the accuracy of a dedicated tool without committing to what gets posted automatically, this is the key differentiator.

Comparison: Xero Native Integration vs Third-Party Tools

Frequently Asked Questions {#faq}

Does Shopify integrate with Xero?

Xero does not directly integrate with Shopify out of the box. Xero offers an official Shopify integration app available in both the Xero App Store and Shopify App Store. It is free for US, Canadian, Singaporean, and most other international merchants. It posts daily sales summaries and handles basic refunds and tax for AU/NZ/UK. For more accurate reconciliation — especially with Shopify fees, multiple payment gateways, or US sales tax — a third-party tool is required.

How do I reconcile Shopify payments in Xero?

The correct process is: (1) set up a Shopify Clearing account in Xero as a current asset, (2) record gross sales to that clearing account, (3) record processing fees as an expense reducing the clearing account, (4) record refunds as credit notes reducing the clearing account, (5) verify the clearing account balance equals the net payout, and (6) match the payout deposit in the bank feed against the clearing account. This ensures every component of the payout is correctly categorised rather than posting a single net figure to a revenue account.

How do I record Shopify fees in Xero?

Shopify processing fees should be recorded as an expense — not netted against revenue. Create an expense account called "Payment Processing Fees" (or similar). For each payout, record the total fees shown in the Shopify payout breakdown as a debit to that expense account and a credit to the Shopify Clearing account. Shopify Payments charges approximately 2.9% + 30¢ per transaction on the Basic plan, with rates decreasing on higher Shopify plans. Keeping fees separate from revenue allows you to track your effective processing cost rate over time.

Why is my Shopify payout different from my Xero balance?

The four most common causes are: (1) processing fees that have not been recorded in Xero, (2) refunds processed during the payout period that reduced the net deposit, (3) timing differences where some orders in Xero fall into a different payout period than expected, or (4) chargeback fees that were silently deducted from the payout with no corresponding Xero entry. Download the full payout breakdown from Shopify and compare each line item against what is recorded in Xero to identify the gap.

What is the best Shopify Xero integration?

For most growing stores, A2X is the most established and accountant-preferred option due to its accurate payout mapping and multi-currency support. Link My Books is strong for UK merchants prioritising VAT compliance. Amaka is a good starting point for smaller stores on a budget, with a free tier. Reconkept is worth evaluating if you want a review step before anything posts to Xero. The right choice depends on your order volume, currencies, payment gateways, and how much manual control you want over what posts to your books.

Can I reconcile Shopify PayPal payments in Xero separately?

Yes, and you should. PayPal settles on its own schedule with its own fee structure, independent of Shopify Payments. Create a separate PayPal Clearing account in Xero. When a PayPal payout arrives, match it against the PayPal Clearing account using the same gross-in, fees-out, refunds-out method described above for Shopify Payments. The native Xero integration does list PayPal as a payment gateway but does not fully automate this matching.

Is Shopify Xero reconciliation different for international stores?

Yes, significantly. International stores face additional complexity from currency conversion. Shopify converts foreign currency sales to your payout currency at settlement, which may differ from the exchange rate at the time of sale. This creates unrealised foreign exchange gains and losses that need separate accounting treatment in Xero. Multi-currency Xero accounts are required, and a tool like A2X handles the FX variance automatically. Manual reconciliation of multi-currency payouts is feasible but time-intensive and error-prone.

Do I need a Shopify clearing account in Xero?

Yes, for any store where Shopify Payments or another gateway deducts fees before the payout. Without a clearing account, you are trying to reconcile net bank deposits against gross revenue entries while separately accounting for fees and refunds — and the maths will never balance cleanly. The clearing account is the structural fix that makes the reconciliation arithmetic work correctly.

Common Mistakes to Avoid

Recording the net payout as revenue. This is the single most common error. The Shopify payout amount is not revenue — it is net of fees and refunds. If your gross sales were $4,501.17 and you received $4,312.17, recording the deposit as revenue understates gross income by $189 in fees and misses the expense deduction entirely.

Netting fees against revenue. Processing fees are an operating expense. When they are netted against revenue, your gross margin figures become meaningless. You cannot determine whether margin is changing due to pricing, product mix, volume, or payment costs.

Recording refunds as expenses. A refund is a reversal of a previous sale, not a new expense. It should reduce your revenue figure (via a credit note in Xero) and reduce the clearing account. Recording it as an expense overstates both gross revenue and total expenses simultaneously.

Ignoring gift card liability. Gift card sales are not revenue at the point of purchase. They are liabilities until the customer redeems them. Recording gift card sales as revenue inflates income in the sale period and creates an accounting error that compounds every month.

Not reconciling per payout. Attempting to reconcile Shopify monthly rather than per-payout means you are trying to match multiple bank deposits of varying amounts against a month of aggregated entries. The per-payout approach makes each reconciliation a discrete, traceable task.