You’re on the United Kingdom site
  1. Home
  2. Ecommerce

Shopify integration by Xero

By Xero
1.3 out of 5 stars
Connect your Shopify store to your Xero account for easy management of your ecommerce business finances.

Overview

*Updated with improved sales tax functionality (November 2022)

This integration automatically syncs a daily summary of your Shopify sales transactions with Xero at the end of each day, giving you an accurate view of cash flow and business performance.

Benefits of connecting Xero and Shopify

  • Automate finance admin - daily summaries of Shopify sales orders for each payment gateway are sent to Xero for easy reconciliation
  • More accurate data - reduce manual data entry and get visibility over Shopify payments and PayPal transaction fees
  • Track cash flow in one place - get a complete picture of business performance with Xero’s cash flow and insights tools
Explore all features of Shopify integration by Xero

Shopify integration by Xero + Xero

Integrating Shopify with Xero significantly reduces time taken to manually move data between your business apps, and helps you reconcile payouts to give you visibility over fees and other costs or discounts.

Features

  • 30 day free trial, no billing details required
  • Automatically syncs daily Shopify sales transactions to Xero
  • Creates a daily summary invoice for preferred payment gateways
  • Shows sales, discounts, shipping costs, refunds, gift card payments, and fees across all invoices
  • Automatically groups Shopify transactions based on tax rate to help you manage your sales tax compliance (November 2022 update)
  • Tracks pending sales from Shopify payments and PayPal by adding a clearing account
  • Transfers processed sales from Shopify payments and PayPal into a nominated bank account for easier reconciliation
  • Imports the previous 90 days of Shopify sales transactions (only available with Xero Standard or Premium plans)

Pricing & packaging

There is a monthly charge to connect your Xero and Shopify accounts in the UK (£10 per month exc. VAT) in addition to Shopify and Xero monthly subscription charges.

Not supported in Shopify integration by Xero

There are some things this integration doesn’t do. Check with your accountant or bookkeeper if you're unsure whether this integration will meet your needs.

  • Invoices for each Shopify sales transaction
  • Inventory and Cost of Goods Sold management
  • Connection of multiple Shopify stores to a Xero account
  • Shopify stores and Xero accounts with different currencies
  • Automatic tax filing in multiple tax jurisdictions
  • Invoices showing customer (payment) details

Reviews & ratings

1.3 out of 5 stars
20 Reviews
5 star(5%)
4 star(0%)
3 star(0%)
2 star(10%)
1 star(85%)
LW
Leo Walton
Posted
1 out of 5 stars

No support for sales tax transactions

I do not understand why this doesn't support transactions that charge sales tax. There's not even a paid tier that provides support for this. Surely it's a simple thing to integrate. Can't even comment on its other functionality as it won't even let me connect the accounts.

Response from Shopify integration by Xero

Hey Leo, We are pleased to say we have made improvements to the integration to now support businesses like yours that charge sales tax. Should you wish to try the integration again, you can trial it free for 30 days: https://apps.xero.com/app/shopify. You can find our support content over at Xero Central if you need a hand getting setup: https://central.xero.com/s/article/Connect-to-Shopify. All the best, Xero App Store Team
DD
Dmitry Dorofeev
Posted
1 out of 5 stars

DOES NOT Itemise Sales Lines!!!

Manual Processing will be required by using this FREE App, only good if you have time to play around with each transaction!!!
3 people found this review helpful.

Response from Shopify integration by Xero

Hi Dmitry, The integration creates a daily summary of these sales amounts in Xero, to enable you to quickly and easily reconcile against the payouts in your bank feed through the use of a clearing account. This keeps your Xero data tidy as you don’t have an invoice for every Shopify order, removing the need to manually reconcile each individual Shopify order. We recently released improvements to the integration's sales tax functionality that should remove the need to manually adjust each transaction in Xero. If you wish to try the integration again, you can do so free for 30 days: https://apps.xero.com/app/shopify Thanks, Xero App Store Team
CH
Cameron Houston
Posted
1 out of 5 stars

Shows a complete lack of understanding

This app should be pulled. It is a scam. Because NZ is +12 GMT & Xero runs on GMT the payments are always out of sync so nothing will ever match. I spoke to Xero about this and they said they know about it, and basically suck it up and do it manually. When an app has 85% 1 star reviews you would think they would just pull it. MYOB has a way better intergration.
One person found this review helpful.

Response from Shopify integration by Xero

Hi Cameron, We’re sorry to hear about your challenges reconciling your Shopify payouts. The integration uses a clearing and bank account to manage differences in timing between when an invoice is created and your payouts occurring. This ensures that you are always able to reconcile your Shopify sales against the payments in your Xero bank feed. Guidance on how to setup a clearing and bank account for the integration can be found at: https://central.xero.com/s/article/Connect-to-Shopify#3Setuptheintegration If you wish to try the integration again, you can do so free for 30 days: https://apps.xero.com/app/shopify Thanks, Xero App Store Team

Additional info

App details

By Xero
Added in 2021

Countries

Australia, Canada, Global, Hong Kong, Indonesia, Ireland, Malaysia, New Zealand, Philippines, Singapore, South Africa, United Kingdom, United States

Languages

English

Support

Setup walkthroughContact support
Although Xero reviews each app in the Xero App Store, we can’t give any guarantees. It’s up to you to assess the performance, quality and suitability of any app before going ahead.