Your Shopify payout hits the bank, you open Xero, and the deposit doesn’t match any sales number you recognize. Fees came out, sales tax went in, and last week’s refunds scrambled the math.
A Shopify Xero integration fixes that by automatically sending your sales, fees, refunds, and taxes into Xero. Xero’s own app covers the basics for free, and connectors like Link My Books add payout matching and COGS tracking.
In this article, we’ll give you a step-by-step process and advice on how to get the connection set up. We’ll also compare the main tools and show you how to map fees, sales tax, and COGS so every payout reconciles.
TL;DR: How to Connect Shopify to Xero and Keep Payouts Reconciled
Here’s the short version of the setup and the checks that keep your numbers right:
- ●Pick Your Tool: Use Xero’s free app for a simple store, or a connector like Link My Books for multiple channels and COGS.
- ●Map Accounts First: Give sales, refunds, fees, shipping, and sales tax payable their own Xero accounts before the first sync.
- ●Record Gross Sales: Split each payout into sales, refunds, fees, and sales tax.
- ●Track COGS as Items Sell: Expense inventory in the month it sells.
- ●Reconcile Every Payout: Match each payout to its bank deposit before you close the month.
How to Connect Shopify to Xero
If you’re looking to streamline your bookkeeping and connect Shopify to Xero, you’re in the right place.
The five steps below take you from picking a tool to reconciling your first payout:
1Choose a Xero to Shopify Integration Tool
To get started, you’ll need a reliable integration tool that connects Xero with your Shopify account.
Here are a few popular options to consider:
- ●Xero Shopify App: Xero has its own built-in Shopify app that allows you to integrate the two platforms easily. Start from the Shopify listing in the Xero App Store, select “Get this app,” and log in to Xero to connect your store.
- ●Other Integration Tools: If you prefer exploring different options, you can check out third-party apps like Link My Books, A2X, or Synder. These tools offer more advanced features and customization options. We go into more detail on each below.
Our team runs client books through Link My Books, so that’s the connector we know best.
2Connect Xero to Your Shopify Account
Once you’ve chosen your integration tool, it’s time to connect Xero to your Shopify account.
Here’s a general outline of the steps involved:
- ●Install the chosen integration tool from the Shopify App Store or the Xero App Store.
- ●Follow the prompts to authorize access between Xero and Shopify.
- ●Provide the necessary permissions for data synchronization between the two platforms.
- ●Confirm the integration by logging in to your Xero and Shopify accounts.
3Configure Settings in the Tool
After the initial setup, configure the settings in your integration tool to ensure it meets your bookkeeping needs.
Here are some key areas to focus on:
- ●Sales Data: Determine how you want your sales data to be synced. For example, you can choose to transfer individual orders or consolidate them into daily summaries.
- ●Chart of Accounts: Review and map your Shopify revenue accounts to the appropriate accounts in Xero. This step ensures accurate tracking of income and expenses.
- ●Tax Settings: Configure tax settings based on your business requirements and the tax regulations in your location.
- ●Payment Gateways: Set up integration with your payment gateways to ensure transactions are properly recorded in both Xero and Shopify.
Map the sales tax you collect to a liability account, such as Sales Tax Payable. Give refunds, discounts, shipping income, and processing fees their own accounts so they don’t disappear into one revenue line.
On sync style, Xero suggests daily summaries for high-volume stores and per-sale transactions when you need customer and line-item detail. For the full monthly routine beyond the integration, our Shopify bookkeeping guide walks through it.
4Watch New Data Come Into Xero
Now that everything is set up, your integration tool will automatically sync new data from Shopify to Xero, keeping your bookkeeping up to date. Here’s what you can expect:
- ●Sales Orders: Depending on your sync setting, each new order placed on your Shopify store will be recorded as an invoice in Xero, including customer details, product information, and payment details, or rolled into a daily summary.
- ●Inventory Management: If your integration tool supports inventory syncing, you can track stock-level changes between Shopify and Xero.
- ●Payment Reconciliation: Payouts from your chosen payment gateways will be ready to match against your bank deposits in Xero, ensuring accurate financial records.
Xero’s native app can sync up to 90 days of history when you first connect. Check that the first synced period picks up exactly where your existing books end.
Take the time to choose the right integration tool for your business needs and keep an eye on any updates or new features they may offer.
5Reconcile Each Payout in Xero
Syncing gets the data into Xero. Reconciling it proves the numbers are right.
Once a payout lands, work through it in this order:
- ●Match the Deposit: Find the Shopify payout in your Xero bank feed and match it to the entry your integration tool created.
- ●Check the Gaps: If the amounts differ, open that payout in Shopify, which shows the fees charged on each payout, then compare refunds, chargebacks, and adjustments.
- ●Review Each Gateway: Stores using a third-party payment provider pay a Shopify transaction fee plus that provider’s card fees, so PayPal and other gateways need their own reconciliation.
- ●Close the Month: Once every payout ties out, review your profit and loss statement (P&L) before you use it for decisions.
If reconciliation breaks month after month, the cause usually sits upstream in your account mapping. That’s the work our Shopify bookkeeping services handle every month.
Why Doesn’t Your Shopify Payout Match Your Sales in Xero?
Your Shopify payout is a net number. By the time it reaches your bank, fees and refunds have already come out, and the sales tax your customers paid is mixed in.
Here’s a simplified week for a store on Shopify Payments:
| Line Item | Amount | Where It Belongs in Xero |
|---|---|---|
| Product sales | $10,000 | Sales (revenue) |
| Sales tax collected | $600 | Sales Tax Payable (liability) |
| Refunds issued | -$400 | Refunds (contra revenue) |
| Processing fees | -$320 | Merchant fees (expense) |
| Bank deposit | $9,880 | Matched to the payout |
Book that $9,880 deposit as revenue, and your P&L shows $9,880 in sales. Your real gross sales were $10,000; you refunded $400 and paid $320 in fees, and $600 of the deposit belongs to the state.
That gap swings every week, so margins built on deposits never tell you what Shopify actually costs to run. A good integration splits each payout into these lines for you.
The Best Xero Shopify Integration Tools
Here’s how the four main options compare at a glance. Prices are the current starting rates on each app’s listing and change often, so confirm before you subscribe.
| Tool | Starting Price | How It Posts to Xero | COGS Tracking | Best Fit |
|---|---|---|---|---|
| A2X | $29/month (200 orders) | Payout summaries | From the $45/month plan | Shopify-focused stores that want payout-level summaries |
| Link My Books | $21/month (200 orders) | Bank-matched payout entries | Built-in feature | Multichannel sellers with inventory |
| Shopify Integration by Xero | Free on all Xero plans | Daily summary or per sale | Not listed among its features | Smaller, single-store sellers with simple catalogs |
| Synder | $65/month | Daily summary or per sale | Listed as tracked | Sellers who want transaction-level detail across many platforms |
If you sell only on Shopify with a simple catalog, Xero’s free app is a reasonable place to start. Once you add channels, carry meaningful inventory, or need COGS on your P&L every month, a dedicated connector usually earns its fee.
Below, we break down what each tool does, what it costs, and where to learn more:
1A2X
Overview:
A2X is a popular third-party integration tool that connects Shopify to Xero, streamlining your bookkeeping process. It automates the extraction of your Shopify data, such as sales, fees, and refunds, and accurately reconciles it within Xero.
A2X provides detailed transaction breakdowns, making it easier to understand your financials.
Pricing:
A2X currently prices its Shopify plans by monthly order volume, starting at $29 per month for up to 200 orders. COGS tracking starts on the $45 per month plan, which covers up to 500 orders, and higher-volume plans are available.
2Link My Books
Overview:
Link My Books is another popular integration tool that connects Shopify to Xero, simplifying your bookkeeping tasks. It automates the process of importing your Shopify transactions into Xero, ensuring accurate and timely data reconciliation.
Each Shopify payout lands in Xero as a bank-matched entry, with sales, refunds, fees, taxes, and gateways such as PayPal and Klarna broken out. It also connects Amazon, eBay, Etsy, Walmart, TikTok Shop, Square, and WooCommerce, which matters once Shopify is one channel among several.
It’s the connector our bookkeepers use on client books, and its COGS feature is a big reason why.
Pricing:
Link My Books currently lists Shopify plans from $21 per month for up to 200 orders. Tiers scale with order volume; for example, $60 per month for up to 5,000 orders.
3Shopify Integration by Xero
Overview:
Xero, the popular accounting software, offers its own built-in integration with Shopify. This native integration connects your Shopify store to Xero and streamlines your bookkeeping.
With Xero’s Shopify integration tool, you can automatically sync sales, customer information, and payment details from Shopify into Xero, eliminating manual data entry. It simplifies the process of reconciling your transactions and helps you maintain accurate financial records.
According to its Xero App Store listing, the current version syncs sales, payouts, fees, and taxes, covers Shopify POS alongside your online store, and pulls up to 90 days of history. Xero partners with Amaka to support setup.
Check two things before you rely on it. The listing doesn’t mention COGS tracking, so plan to handle cost of goods sold separately.
The listing also says you can map Shopify taxes to tax rates or liability accounts, yet Xero’s US Shopify page says the integration doesn’t account for US sales tax. Run one recent payout through it and confirm where the tax lands.
Pricing:
The Shopify integration tool is available for Xero users as part of their Xero subscription. Xero’s listing says it’s free on all Xero plans.
Xero offers different pricing plans tailored to businesses of various sizes and needs.
4Synder
Overview:
Synder syncs Shopify sales, fees, taxes, refunds, discounts, gift cards, shipping, and customers into Xero, and it supports more than 25 sales and payment platforms. You can post daily summaries or individual sales, and its listing says it tracks COGS and inventory.
Pricing:
Synder’s Shopify App Store listing currently starts at $65 per month, with a free trial.
Picking and installing a connector takes an afternoon. Keeping fees, refunds, sales tax, and COGS mapped correctly every month is the part that takes real ecommerce know-how.
At EcomBalance, we’re a bookkeeping and tax firm built only for ecommerce brands, offering monthly bookkeeping, catch-up and clean-up work, and income tax filing and planning. For monthly bookkeeping, we connect Shopify and your other channels to Xero or QuickBooks Online through Link My Books (the tool cost is included in our price), reconcile every payout, and deliver your P&L, balance sheet, and cash flow statement by the 15th of each month.
Two things set our team apart. We were built by ecommerce sellers who did about $25 million on Amazon, and two levels of ecommerce bookkeepers review your books every month before they reach you.
How Should COGS Flow From Shopify Into Xero?
Cost of goods sold (COGS) is the integration detail most setup guides skip, and it decides whether your monthly margins mean anything.
Nathan Hirsch, our CEO, explains it with a simple example. Say you buy $50,000 of inventory in January and expense it when you pay for it.
January shows a big loss. Then February through April look wildly profitable as you sell that stock, and none of those months tell you how the business is actually doing.
As Nathan puts it, “For most e-commerce businesses, it makes sense to use accrual.”
That’s why we record sales and COGS on an accrual basis and other expenses on a cash basis. Product cost hits your profit and loss statement in the month the item sells, keeping margins comparable month to month.
To get COGS flowing correctly in Xero:
- ●Keep Product Costs Current: Enter a cost for every SKU (stock keeping unit), either in Shopify’s “Cost per item” field or inside your connector.
- ●Turn On COGS in Your Connector: Link My Books, for example, lists the products sold in each payout and posts their cost from your inventory account to a COGS account in Xero.
- ●Check Inventory Against Real Stock: Compare your inventory account to an actual count periodically, and record shrinkage or write-offs when you find them.
Which Shopify Xero Integration Mistakes Distort Your Margins?
Most broken Shopify books trace back to a handful of setup choices. Three of these are the mistakes our bookkeepers fix most often across every marketplace.
Here are the five to watch for, starting with those three:
- 1Posting Net Payouts as Sales: Record gross sales and break out fees and refunds on their own lines. Booking the deposit as revenue understates your sales and buries your fees.
- 2Expensing Sales Tax: Book the sales tax you collect to a liability account and clear it when you pay the state. The IRS instructions for Schedule C leave sales taxes imposed on the buyer, which you collect and pay over, out of both gross receipts and deductible expenses.
- 3Expensing All Inventory at Purchase: Adjust COGS to what actually sold each month, or your margins will swing with your purchasing calendar.
- 4Running Two Connectors at Once: If Xero’s native app and a connector like Link My Books both post the same Shopify sales, you’ll double-count revenue. Choose one source per channel before you switch anything on.
- 5Assuming the First Sync Covers Your History: Xero’s native app pulls up to 90 days of past data. If your books are further behind, catch-up bookkeeping gets you current before ongoing syncing starts.
Each state sets its own sales tax rules, so check your state Department of Revenue for filing requirements. Treat this as general information and confirm your sales tax and income tax treatment with your CPA or tax professional.
Should You Connect Xero to Shopify Yourself?
Both routes work, and the right one depends on your order volume, your channels, and how much of your week you want to spend in Xero.
Here’s how the two options compare:
Option 1: Do It Yourself
Here’s what you gain by handling the setup yourself:
- ●Cost-Saving: Connecting Xero to Shopify yourself can save you money since you won’t incur additional expenses hiring a professional.
- ●Flexibility and Control: You have full control over the integration process and can customize it according to your specific needs.
- ●Learning Opportunity: Setting up the integration yourself helps you understand how the systems work together, which can be valuable for managing your business.
Here’s what it can cost you:
- ●Time-Consuming: Integrating Xero with Shopify can be complex, requiring time and effort to navigate the setup and configuration process.
- ●Technical Challenges: If you’re not familiar with the platforms or their integrations, you may encounter technical difficulties or face a learning curve.
- ●Risk of Errors: Without professional expertise, there’s a higher risk of making mistakes during the integration, which could lead to inaccuracies in your financial records.
Option 2: Hire an Ecommerce Bookkeeper
Here’s what a specialist brings to the setup:
- ●Expertise and Guidance: Hiring a professional ecommerce bookkeeper who specializes in Xero and Shopify integrations ensures someone with experience and expertise handles the process.
- ●Time-Saving: Outsourcing the task to a bookkeeper frees up your time to focus on other aspects of your business, allowing you to draw on their skills and knowledge.
- ●Accuracy and Compliance: A qualified bookkeeper can ensure that the integration is set up accurately, following best practices and compliance requirements.
Here are the trade-offs to weigh:
- ●Cost: Hiring an ecommerce bookkeeper will involve additional expenses, which may not be feasible for businesses with limited budgets.
- ●Communication and Coordination: Working with a bookkeeper requires effective communication and coordination to convey your business requirements and ensure a smooth integration process.
- ●Dependency on External Help: Relying on a bookkeeper means you may need to wait for their availability, potentially slowing down the integration timeline.
Whether you connect Xero to Shopify yourself or hire an ecommerce bookkeeper depends on your budget, time, technical skills, and business complexity. Assess your specific needs and resources to make an informed choice that best suits your circumstances.
Our take, as sellers first: setup is a one-time job. Keeping the books right every month is the part most owners are better off handing off.
Frequently Asked Questions
Here are the questions Shopify sellers ask us most about connecting their store to Xero:
Conclusion
A clean Shopify Xero integration comes down to three things: the right connector for your volume, accounts mapped before the first sync, and a monthly reconciliation that ties every payout to the bank.
Still need help with your Xero Shopify integration?
EcomBalance is the bookkeeping and tax firm we started after years of selling online ourselves and building FreeUp to 8 figures, and we work only with ecommerce brands. Shopify payouts, sales tax liabilities, and COGS adjustments are everyday work for our bookkeepers, across Shopify, Amazon, Walmart, eBay, and Etsy.
If your books are behind, our catch-up and clean-up service rebuilds and reconciles every missed month before ongoing bookkeeping starts. Spencer Carlson of Ballard Products put it this way: “They got us caught up on 6 months of bookkeeping exactly as promised.”
Once your books are clean, our in-house ecommerce CPA, with more than 30 years of experience, can file your business income tax return, so bookkeeping and taxes sit under one roof.
