You can connect Shopify to Xero using a connector that separates sales, refunds, fees and VAT, then reconciles them to your payouts. The right setup depends on transaction volume, payment gateways, stores and VAT complexity. Test those requirements before choosing the app. A successful connection moves data; accurate accounts also need the right tax mapping, stock costs and regular checks.
Your Shopify dashboard shows a good month. More orders, more revenue, a healthy return on advertising. Yet you still cannot explain why the bank balance is tight.
Connecting Shopify to Xero should help you answer that. But if the connection records a bank payout as sales, or leaves stock costs out, it can make the numbers look tidy while telling you very little about profit.
Start with the result you need: sales you can reconcile, VAT you can account for and a margin you can trust. Then choose the software to support it.
A Shopify payout is not your sales figure
The money arriving in your bank is a settlement. It may already have refunds and payment fees deducted. It can also relate to orders from an earlier reporting period.
Here is a simplified illustration of one settlement, not a client case. All orders are taxable Irish sales at 23%, with no refunds, reserves or timing differences.
| Item | Amount |
|---|---|
| Customers pay, including VAT | €12,300 |
| Sales excluding VAT | €10,000 |
| VAT liability | €2,300 |
| Payment fees deducted | €300 |
| Payout to your bank | €12,000 |
Recording the €12,000 as revenue overstates sales by €2,000 and hides €300 of fees. It also leaves the €2,300 VAT liability unrecorded if you have not separated it elsewhere.
If your accountant can confirm that the apps are connected but cannot explain that difference, the reporting job is unfinished.
Your connector should explain the route from orders to settlement to bank. Amounts still held by the payment provider belong in that reconciliation, rather than being forced into sales to make the bank match.
Shopify explains how payouts work. PayPal and other providers can have their own settlements, so one Shopify Payments payout does not prove that every gateway is reconciled.
Choose a connector for your actual store
Do not choose solely because the app says it connects Shopify and Xero. Our Xero setup and migration service covers the connections and accounting process together. List what your business needs the app to handle:
- Monthly order volume and the size of the records posted into Xero.
- Shopify Payments, PayPal, Stripe or other gateways you actually use.
- Refunds, chargebacks, discounts, shipping income and gift cards.
- Each store, currency and sales channel.
- VAT registrations, customer destinations and fulfilment locations.
- The evidence you need to trace a summary back to the underlying transactions.
For more complex setups, assess specialist connectors such as A2X and Dext Commerce. VAT complexity, transaction volume, multiple stores and payment gateways should drive the choice. A simple Irish store and a business selling through several channels from several warehouses need different setups. Test the connector against your actual transactions before choosing it.
Summary postings can keep the accounting ledger manageable at volume. Keep the order-level evidence available, and confirm how the app deals with period ends and exceptions. A smaller number of entries is useful only if you can explain what is inside them.
Check multiple stores and currencies against the specific connector and version. Xero’s current app listing describes a new integration, so restrictions reported for the older version should not be assumed to apply unchanged. Ask Xero, A2X or Dext to demonstrate your stores, currencies and payment gateways before you commit.
Check the Irish VAT treatment before connecting
Xero’s current Irish app listing describes a new integration that syncs taxes and allows tax mapping. Its Irish Shopify marketing page still carries a warning that the integration does not account for Irish sales tax. The documentation is inconsistent. Confirm which version you will use and test its Irish VAT postings before relying on it.
That is a connector question. Having Irish VAT reporting available in your accounting system does not, by itself, prove that the Shopify data feeding it is correctly mapped.
For EU consumer sales, establish the VAT treatment before setting the store’s registrations and rates. Moving fulfilment to another country can change the position. The warehouse is a tax decision as well as a logistics decision.
Shopify’s EU tax guidance makes the merchant responsible for correct tax collection, filing and payment. Confirm who prepares your Irish and any overseas returns; do not infer that a checkout setting does that work. Our ecommerce VAT guide explains the main distinctions.
Check Northern Ireland orders separately against your VAT position and store settings; our ecommerce VAT guide distinguishes Northern Ireland from Great Britain.
How to set up the integration
1. Agree the accounting and VAT treatment
Decide which accounts will receive sales, shipping, discounts, fees and refunds. Confirm each VAT registration and the treatment of the transactions you make. Gift cards and unusual refunds need their own check, not the default sales code.
2. Choose a start date
Identify what is already recorded in Xero and what the connector will import. Agree the opening balances for each payment-provider account. This avoids recording the same sales through an old import and the new connection.
3. Connect the required stores and gateways
Use the app’s current instructions and the appropriate permissions. Confirm which stores, gateways and currencies are included. Someone should own the subscriptions and access so the setup remains manageable when staff or advisers change.
4. Test a representative period
Use a period containing ordinary orders and the exceptions your store actually has: refunds, discounts, different VAT treatments and more than one payment provider where relevant. Compare the source reports, connector summary, Xero entries and bank receipts.
5. Check the reporting cut-off
An order, a refund and a bank payout can land on different dates. Check how the integration allocates transactions across month-end. A bank match does not settle whether the income belongs in that month’s accounts.
6. Agree the ongoing checks
Name the person who reviews failed imports, unmapped transactions and unreconciled balances. Agree the reporting timetable. Automation still needs someone to investigate exceptions.
If you need help choosing and configuring the connection, our software setup service covers the practical implementation discussion.
The connection will not supply your margin on its own
Revenue growth and a good advertising return are useful signals. You also need to know what remains after product costs, fulfilment, payment fees, refunds and advertising.
Some connectors support cost-of-sales postings. That still requires dependable product costs and a stock process. Check which costs are included, how stock movements are recorded and how returns or damaged stock are treated. Our inventory accounting guide covers that side.
Separate gross margin from contribution after variable selling costs, then look at overheads and cash commitments. A campaign can generate attractive sales while leaving too little to fund the next stock order.
Continue the €10,000 sales example above. This is an illustration, not a client case. The figures exclude VAT, assuming any purchase VAT is recoverable. Product costs are for the goods sold, not all stock purchased. Fulfilment, fees and advertising are treated as variable costs in this example.
| Item | Amount |
|---|---|
| Sales excluding VAT | €10,000 |
| Product costs | −€4,500 |
| Gross profit | €5,500 |
| Fulfilment | −€1,200 |
| Payment fees | −€300 |
| Advertising | −€2,000 |
| Contribution before overheads | €2,000 |
Gross margin is 55%, but only €2,000 remains for overheads and profit: a 20% contribution margin. If all these sales were attributed to the €2,000 advertising spend, the return on ad spend would look like 5x using revenue excluding VAT. That does not tell you what remains after the other variable costs. Nor is the €2,000 spare cash: VAT, stock purchases and payment timing still need a cash plan.
This is the point of the integration: better decisions about price, advertising and stock, supported by accounts that explain the business.
What you should receive each month
Ask for a clear answer to five questions:
- Do sales and refunds agree with the store reports?
- Do each provider’s settlements and outstanding balances reconcile?
- Is VAT separated and supported by the records needed for the relevant returns?
- Are stock costs current enough to explain margin?
- What changed in contribution and cash, and what needs attention next?
If your accountant can confirm that the apps are connected but cannot answer those questions, the reporting job is unfinished.
We provide accounting for Irish ecommerce businesses. If your business turns over €250,000 or more and you need clearer numbers from your Shopify operation, Book a Finance Fit Call.
FAQs
Can Shopify connect to Xero?
Yes. There are connectors that transfer Shopify data into Xero. Choose one that supports your stores, gateways, currencies and VAT requirements, then test its postings and settlement reconciliation.
Is the bank payout the amount I should record as sales?
No. A payout can include VAT and have refunds or fees deducted. Sales, VAT, fees and amounts still held by the payment provider need to be identified separately.
Should I use A2X or Dext for Shopify?
Assess both against transaction volume, VAT complexity, multiple stores and the reporting you need. Ask for a demonstration using representative transactions. The app name alone does not establish suitability.
Does connecting Shopify to Xero handle all my VAT?
No. Xero’s current app listing advertises tax mapping, while its Irish marketing page still warns of an Irish sales-tax limitation. Confirm the version, test the VAT postings and agree who prepares and files each return. Other connectors need their own assessment too.
Can the integration tell me whether the store is profitable?
It supplies part of the information. Reliable profit reporting also needs stock costs, selling expenses, overheads and the correct reporting cut-off. Review contribution and cash alongside revenue.
