MFT Tax and Shopify Reconciliation: The Silent Discrepancy in UK Stores

If your Shopify reconciliation is consistently off by a few hundred pounds each month, and you cannot explain where the difference comes from, there is a good chance Marketplace Facilitator Tax (MFT) is the cause.

MFT is one of the least understood and most commonly missed items in Shopify accounting. Here is what it is and how to account for it correctly.

What is Marketplace Facilitator Tax?

Marketplace Facilitator Tax (MFT) laws require online marketplaces — including Shopify in certain circumstances — to collect and remit sales tax on behalf of the sellers on their platform, rather than the seller remitting it directly.

In practice for Shopify stores, this means: Shopify collects the sales tax from your customer, deducts it from your payout, and remits it directly to the relevant tax authority. You never see that tax money in your bank account.

This is not a Shopify error or a payout shortfall. It is intentional. But if you are not accounting for it, your reconciliation will show a discrepancy every single month.

How MFT shows up in your payout

In your Shopify payout report, MFT deductions appear as a separate line item — often labelled as marketplace_facilitator_tax in the raw payout data. The amount is the sum of all tax that Shopify remitted on your behalf during the payout period.

Example payout breakdown:

• Gross sales: £15,000.00
• Processing fees: −£435.00
• Refunds: −£200.00
• MFT deduction: −£312.00
• Net payout: £14,053.00

If you only reconcile gross sales, fees, and refunds, your journal will show £14,365.00 net — and your bank shows £14,053.00. The unexplained £312.00 is the MFT deduction.

Why this is a common problem

Most reconciliation tools either ignore MFT entirely or bundle it into a catch-all “adjustments” line. Neither approach produces a correct journal entry.

The correct treatment is to recognise the MFT deduction as a tax collection event. The tax was charged to your customer (and should appear in your revenue line), but Shopify collected it on your behalf and passed it directly to HMRC (or the relevant authority). Your journal should reflect this:

DR  Sales Tax Payable (MFT — Shopify)  £312.00
  CR  Clearing Account — Shopify Payments         £312.00

This way, the tax appears in Sales Tax Payable (matching what your customers paid) and the clearing account correctly nets to the bank deposit amount.

Does MFT apply to UK Shopify stores?

MFT originated in the US, where it applies to most US Shopify stores. For UK and EU stores, the picture is more nuanced.

For UK stores selling to UK customers: standard VAT rules apply and Shopify does not act as a marketplace facilitator in most cases. You remit VAT directly.

For UK stores selling to US customers: MFT may apply to those US sales, and Shopify may deduct and remit US state sales tax on your behalf. This shows up in your payout as an MFT deduction even if you are a UK-based business.

For UK stores that have enabled OSS (One Stop Shop) VAT reporting for EU sales: similar dynamics can apply — Shopify may collect and remit VAT on certain EU sales.

The key indicator is whether your Shopify payout report contains a marketplace_facilitator_tax or similar line. If it does, you need to account for it.

How Rappel handles MFT

Rappel parses the raw Shopify payout data and explicitly detects MFT deduction lines. When present, Rappel:

• Creates a separate journal line for the MFT amount
• Posts it to Sales Tax Payable (MFT) — a sub-account you can configure
• Ensures the clearing account balance equals the bank deposit
• Flags if MFT is present in a payout where it was not present before (anomaly detection)

This means your reconciliation balances, your tax obligations are correctly recorded, and your month-end is clean.