Skip to main content

How to separate Shopify sales in Xero by source when imported via Mirakl

If you're using the Mirakl Marketplaces App to import orders into Shopify and you want to see the source breakdown, this article is for you.

Daniel Little avatar
Written by Daniel Little
Updated over 2 weeks ago

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

Mirakl allows you to sell your products across hundreds of marketplaces from one central dashboard. They also integrate with Shopify so that you can import those orders and fulfil them via your Shopify Admin.

Link My books now has built in functionality to be able to separate your Mirakl orders that are imported to Shopify and separate them by the marketplace source.

How does it work?

With this new feature enabled, Link My Books will automatically group your Mirakl settlement summaries by marketplace source.

We'll automatically create tracking codes in Xero for each of the different marketplace sources 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:

A screenshot of a Link My Books invoice summary for Shopify. The invoice date is February 1, 2023, covering the period from February 1 to February 28, 2023. The invoice status shows it was sent on March 7, 2023, with a total amount of £0.00. The breakdown includes six line items:  Sales to Sephora UK – £309.00, posted to "201: Sales from Shopify" with 20% VAT on income.  Sales to Debenhams – £269.00, posted to the same account and tax rate.  Sales to Superdrug – £76.00, same account and tax rate.  Discount for Superdrug – –£10.36, posted to "201a: Sales from Shopify - Discounts" with 20% VAT.  Refund for Debenhams – –£235.00, posted to "LMB31: Shopify Refunds" with 20% VAT.  Shopify Gateway Clearing (Mirakl) – –£408.64, posted to "LMB39-C: Shopify Gateway Clearing (Mirakl)" with no VAT.  A "Re-send Invoice to Xero" button is visible at the top right.

If we hone in on the detail here you can see that the sales to Sephora UK, Debenhams and Superdrug are all on separate lines in the summary invoice:

A screenshot of a Shopify invoice summary from Link My Books. The invoice is dated February 1, 2023, covering the period from February 1 to February 28, 2023. The invoice includes six line items:  Shopify Sales – Principal – Sales shipped to UK – Sephora UK, Invoice Amount: £309.00  Shopify Sales – Principal – Sales shipped to UK – Debenhams, Invoice Amount: £269.00  Shopify Sales – Principal – Sales shipped to UK – Superdrug, Invoice Amount: £76.00  Shopify Sales – Principal Discount – Sales shipped to UK – Superdrug, Invoice Amount: –£10.36  Shopify Refunds – Refunded Principal – Sales shipped to UK – Debenhams, Invoice Amount: –£235.00  Shopify Gateway Clearing (Mirakl), Invoice Amount: –£408.64  No total or VAT details are visible in this cropped version.

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 marketplace.

A screenshot of a Xero draft invoice entry screen for Shopify, dated 28 February 2023, with invoice number INV-0178. The invoice includes six line items:  Shopify Sales – Principal – Sales shipped to UK – Sephora UK Qty: 1.00 | Unit Price: £309.00 | Account: LMB30 – Shopify Sales | Tax: 20% VAT | Amount: £309.00  Shopify Sales – Principal – Sales shipped to UK – Debenhams Qty: 1.00 | Unit Price: £269.00 | Account: LMB30 – Shopify Sales | Tax: 20% VAT | Amount: £269.00  Shopify Sales – Principal – Sales shipped to UK – Superdrug Qty: 1.00 | Unit Price: £76.00 | Account: LMB30 – Shopify Sales | Tax: 20% VAT | Amount: £76.00  Shopify Sales – Principal Discount – Sales shipped to UK – Superdrug Qty: 1.00 | Unit Price: –£10.36 | Account: LMB30 – Shopify Sales | Tax: 20% VAT | Amount: –£10.36  Shopify Refunds – Refunded Principal – Sales shipped to UK – Debenhams Qty: 1.00 | Unit Price: –£235.00 | Account: LMB31 – Shopify Refunds | Tax: 20% VAT | Amount: –£235.00  Shopify Gateway Clearing (Mirakl) Qty: 1.00 | Unit Price: –£408.64 | Account: LMB39 – Shopify Gateway Clearing (PayPal) | Tax: No VAT | Amount: –£408.64  At the bottom, the subtotal is £0.00, VAT included is £68.10, and the invoice total is £0.00. Buttons for Save, Approve, and Cancel are shown at the bottom of the screen.

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

A cropped screenshot of a Xero invoice table showing five line items. The columns displayed are Description, Qty, Unit Price, Account, Tax Rate, and LMB Tracking. The "LMB Tracking" column is highlighted in red. The values in this column are:  Sephora UK  Debenhams  Superdrug  Superdrug  Debenhams  Each line item corresponds to Shopify sales, discounts, or refunds, all using 20% VAT on income. The accounts listed are "LMB30 – Shopify Sales" and "LMB31 – Shopify Refunds."

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

A screenshot of the Profit and Loss report page in Xero. The selected date range is 28 Feb 2023 to 28 Feb 2023, and the organization shown is LMB Demo Xero. The report includes two turnover line items:  Shopify Refunds: –195.83  Shopify Sales: 536.37  Total Turnover: 340.54  Below this, all lines for Gross Profit, Operating Profit, Profit on Ordinary Activities Before Taxation, and Profit after Taxation also show the same value of 340.54.  On the left panel, under “Common formats,” several options are listed. A red arrow highlights “Compare LMB Tracking Codes” as a selectable report format. There is also a “Learn more” section with a link to learn how to create a custom report.

You should end up with something that looks like this:

A Profit and Loss report in Xero for LMB Demo Xero, covering the period 28 February 2023 to 28 February 2023, broken down by tracking categories: Debenhams, Sephora UK, and Superdrug, along with the total for the full date range.  Under the Turnover section:  Shopify Refunds:  Debenhams: –195.83  Sephora UK & Superdrug: £0.00  Total: –195.83  Shopify Sales:  Debenhams: 224.17  Sephora UK: 257.50  Superdrug: 54.70  Total: 536.37  All other lines — Total Turnover, Gross Profit, Operating Profit, Profit on Ordinary Activities Before Taxation, and Profit after Taxation — show the same amounts as the sales totals in each column:  Debenhams: 28.34  Sephora UK: 257.50  Superdrug: 54.70  Overall Total: 340.54

Now you can see your figures from each of the different Mirakl Marketplaces 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 Mirakl 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?