All Collections
New Feature Announcements
How to separate Shopify sales in Xero by channel
How to separate Shopify sales in Xero by channel

If you want to see a breakdown of your Shopify sales by channel then this article is for you

Daniel Little avatar
Written by Daniel Little
Updated over a week ago

This feature is currently in beta testing and if you have any feedback please contact [email protected]

Shopify channels help you to understand where your sales are coming from. Channels include the likes of:

  • Web Sale

  • Recharge Subscriptions

  • Shop App

  • One Click Upsell - Zipify OCU

These are just a handful of the possible channels you may have showing in your Shopify store.

Link My books now has built in functionality to be able to separate your Shopify sales by channel so that you can better understand where your sales revenues are coming from.

How does it work?

With this new feature enabled, Link My Books will automatically group your Shopify settlement summaries by channel.

We'll automatically create tracking codes in Xero for each of the different channels and then we'll apply those to the relevant lines of the settlement invoice we send to Xero.

Your current account mappings can remain the same, meaning you can still have all Shopify Sales assigned to your chosen sales account etc. as the tracking codes will be doing all the hard work for you.

Hers is what a settlement summary for Shopify would look like:

If we hone in on the detail here you can see that all transactions are being separated by channel on separate lines in the summary invoice:

The real magic happens when you send the settlement to Xero as then we add a tracking code to each of these lines with the name of the channel.

If we punch in we can see that the tracking codes are being applied to each of the different channels accordingly:

How does it look in your P&L report?

If you run a P&L in Xero, by default it will show all your data together (not split by tracking category).

To run a P&L split by tracking category, follow these steps:

  1. From the Accounting menu, select Profit & Loss in the Accounting Reports section

  2. Select Compare LMB Tracking Codes format from the Common formats menu on the left menu

  3. Choose a Date range for your report and click Update

You should end up with something that looks like this:

Now you can see your figures from each of the different Shopify channels shown in their own column.

How do I set up this feature?

For now, this feature is in beta testing, so you'll need to get in touch with our support team and ask them to "enableShopifyChannelSplit". Once we do this then no further action is required on your side.

Your Shopify sales will be automatically separated by marketplace source and the tracking codes will be automatically created in your Xero account.

With this feature being in beta testing we ask that you report any bugs to our support team should you see them.

If you have any questions about this article or feedback on how we could make it better please reach out to the support team via the blue chat icon on the bottom right of the page or via email to [email protected].

Did this answer your question?