Link My Books Zero-Rated Products: UK VAT Guide

In this guide
The quick answer
How does Link My Books identify zero-rated products?
Link My Books can automatically group Amazon and Shopify sales into standard, reduced and zero-rated VAT categories using the tax data provided by those platforms. For eBay, TikTok Shop and other channels, you can assign products to tax groups manually or through a bulk CSV upload. The important condition is that your underlying tax settings must be correct: the software organizes tax data; it does not decide your product's legal VAT status.
If you sell products with different UK VAT rates, bookkeeping gets complicated quickly. A single marketplace payout might include a zero-rated book, a reduced-rated child's car seat, and a standard-rated household product. Sending the whole payout to one VAT category can distort your accounts.
In my conversation with the Link My Books team, we explored the exact question sellers ask: how does the software know which products qualify for zero-rated VAT? Below, I'll turn that explanation into a practical setup guide, including important updates to Shopify's tax handling.
Affiliate disclosure
Some links in this article are affiliate links. If you subscribe through them, I may earn a commission at no extra cost to you. This supports my free ecommerce tutorials. Read the disclosure.
What is a zero-rated product under UK VAT?
A zero-rated product is still a taxable supply, but VAT is charged at 0%. That differs from an exempt supply or a transaction outside the scope of UK VAT. The distinction matters when preparing VAT returns and considering whether input VAT can be reclaimed.
For typical UK domestic sales, the main rates are 20%, 5% and 0%. The rate depends on the specific product and circumstances of sale, not simply whether its description includes words such as "baby," "food" or "health."
| VAT category | UK rate | Common example |
|---|---|---|
| Standard-rated | 20% | Most general retail goods |
| Reduced-rated | 5% | Qualifying children's car seats |
| Zero-rated | 0% | Most basic food, qualifying children's clothes and books |
These are examples, not a classification for every SKU. Check the HMRC VAT rates guidance before assigning a rate. Sales to other countries, bundled products and exports may require a different analysis.
Which sales channels support automatic VAT grouping?
Automatic grouping based on Product Tax Codes recorded in Amazon's VAT data, assuming the codes and account setup are correct.
Automatic grouping based on the tax Shopify actually calculates for each order line, including regional settings and tax overrides.
Manually assign SKUs to the correct VAT product group, or upload your assignments in bulk.
Use the same manual product-group approach where the required tax classification is not provided through the integration.
According to the official Product Groups guide, automatic product grouping is enabled by default for Amazon and Shopify accounts configured through the Accounts & Taxes wizard after 2 May 2023. Older setups may need their settings reviewed.
Amazon: how Product Tax Codes control zero-rated sales
Amazon uses a Product Tax Code, or PTC, to help determine VAT treatment where its VAT calculation services apply. The common default is A_GEN_STANDARD. If you leave that default on an item that qualifies for another rate, the tax data flowing into your accounts may be wrong.
- Review the product's VAT classification with your accountant or the applicable HMRC notice.
- In Amazon Seller Central, inspect the listing's tax code in Manage Inventory > Edit > Offer, or review your account-level VAT defaults.
- Save the correct code in Amazon, then allow the updated tax data to flow into subsequent settlement reports.
- In Link My Books, check that the SKU appears in the intended standard, reduced or zero-rated group before sending the settlement to your books.
Link My Books reads VAT reports associated with Amazon settlements and uses the PTCs to separate sales and refunds. The status may temporarily show Awaiting VAT Data while the relevant report is being processed. That is not the same as a completed posting error.
The automatic VAT grouping documentation also explains how to correct a wrong PTC and what to do when an older settlement needs reprocessing.
Shopify: why the actual order-line tax rate matters
The video gives a simple explanation using Shopify's taxable and non-taxable product settings. There is an important distinction in the current documentation: Link My Books reads the tax Shopify calculated on each order line, rather than relying only on the product checkbox.
Shopify's result can depend on the customer's shipping address, regional tax rules, product overrides and your store configuration. A product that looks correctly configured on its edit page might still be charged another rate on a particular order.
Important Shopify detail: For a genuinely zero-rated product, Link My Books advises configuring "Charge tax on this product" as enabled with a 0% rate, rather than simply switching tax collection off. A non-taxable checkbox setting and a properly recorded zero-rated taxable supply are not necessarily equivalent.
To investigate a mismatch, open Shopify Settings > Taxes and duties, inspect product overrides, then compare a real order's tax breakdown with the corresponding Link My Books settlement. Confirm the result with your accountant before changing historical records.
Link My Books offer
Try automated ecommerce bookkeeping before subscribing
No credit card required, with a free bookable one-to-one onboarding call.
50% off for your first three paid months when the offer is eligible and accepted.
Start free trial and onboarding
Check the code, plan eligibility and renewal price at checkout. The discount is not a promise of perpetual half-price billing.
eBay and TikTok Shop: assign VAT rates with Product Groups
With eBay, TikTok Shop and other channels that do not provide the necessary product-level tax classification through the connection, Link My Books cannot safely infer the right VAT category from the product name. You need to classify the relevant SKUs.
- Open the Accounts & Taxes wizard and enable grouping for standard, reduced and zero-rated goods where appropriate.
- Go to Inventory > Product Groups and open the Product SKUs tab.
- Find each SKU and select the appropriate product group from its dropdown.
- Review the group's tax-rate and account mappings before sending settlements to Xero or QuickBooks.
- Repeat the check when you launch new products or begin selling a different category.
Newly discovered SKUs usually enter the default group, which is initially standard-rated. If your catalog is mixed, consider a clearly named To Be Assigned group so new items are easier to spot and review.
How to bulk upload VAT classifications for hundreds of SKUs
If you manage a large eBay or TikTok Shop catalog, changing every product through a dropdown becomes repetitive. Link My Books lets you export your product list, assign groups in a spreadsheet and import the completed CSV.
Choose Bulk Upload on the Product Groups page and download your current product file.
Enter the Product Group name for each SKU in the template's designated column.
Save as CSV, upload it to Link My Books and spot-check the results.
The current template instructions specify Column D for the Product Group name. Do not alter SKU identifiers, and use care when opening CSV files in Excel so product codes are not reformatted.
What happens when the data reaches Xero or QuickBooks?
Product Groups are useful because marketplace payouts often combine different transactions into one deposit. Link My Books breaks down settlement information, separates revenue and refunds where configured, and maps product groups to the corresponding tax rates and bookkeeping accounts.
Imagine a payout containing standard-rated homeware, zero-rated books and reduced-rated car seats. Without meaningful separation, a single tax treatment might be applied to sales that should be reported differently. Product Groups help produce more informative entries in Xero or QuickBooks Online.
Remember that the VAT treatment of Amazon's selling or fulfilment fees is a separate accounting question from the VAT rate on products sold. Check fee mappings and your marketplace tax documents independently.
Check before auto-posting: Compare a real payout, its product groups, the tax breakdown and the resulting accounting entry. Automating an incorrect mapping simply repeats the error faster.
For a broader walkthrough of connections, settlements and reconciliations, see my complete Link My Books tutorial.
How can you tell whether your own product is zero-rated?
When a seller in the video asks how to choose tax codes for a new product, the answer starts with HMRC and ends with a qualified accountant. That remains the safest practical order.
- Write down the exact product, materials, intended use, packaging and the countries where you supply it.
- Check the relevant HMRC VAT category guidance and any linked specialist notice.
- Ask your accountant to confirm unclear classifications, particularly for bundles, food, children's products and cross-border sales.
- Record the reason for the selected rate, update the selling platform and test one subsequent transaction.
For instance, qualifying children's clothing is commonly zero-rated, while children's car seats are generally reduced-rated at 5%. Some foods are zero-rated, but confectionery and other exceptions may be standard-rated. "Baby product" and "food product" are not reliable VAT codes by themselves.
AI tools can help you locate a relevant official notice or prepare questions, but they should not be the sole authority for a VAT filing. Link My Books also makes clear that its onboarding team provides technical setup support, not individualized tax advice.
Five mistakes to check before trusting automatic VAT reports
- Keeping Amazon's default PTC for every listing. Products requiring another rate may be grouped incorrectly until the code is fixed.
- Unticking Shopify tax instead of setting a valid 0% rate. The order-line tax record can produce unexpected grouping.
- Ignoring new eBay or TikTok SKUs. Items left in the default group may receive the wrong treatment.
- Confusing zero-rated, exempt and outside-scope transactions. All may show no VAT charged, but their accounting treatment differs.
- Assuming a correction changes history automatically. Already-sent settlements may require a coordinated correction in both Link My Books and your accounting software.
For historical corrections, the official instructions describe correcting the group, then rolling back, refreshing and resending the affected settlement. If the entry has already reached Xero or QuickBooks, coordinate the voiding or reversal first to avoid duplicate postings.
Link My Books free trial, pricing and VOVA20 coupon
Link My Books currently advertises a 14-day free trial without a credit card, plus a free bookable onboarding call. During a trial, you can connect supported sales channels and your bookkeeping platform, check the imported settlements and assess whether the product grouping works for your store.
Paid pricing varies with order volume, number of connected sales channels and plan options. Use the Link My Books pricing page rather than relying on figures from an older video.
My coupon VOVA20 is advertised as 50% off the first three paid months of an eligible subscription. Confirm that it is accepted and that the renewal amount is clear before paying. Link My Books notes that its direct-billing coupons cannot be applied to subscriptions billed through the Shopify App Store.
Free onboarding and limited-time savings
Check your VAT setup with Link My Books
Explore your Amazon, Shopify, eBay or TikTok Shop workflow with support available during setup.
A three-month introductory discount on eligible direct-billed paid subscriptions.
Claim free trial and VOVA20 offer
Apply the code at an eligible checkout. Terms and subscription rates may change.
Frequently asked questions about zero-rated products
Does Link My Books automatically detect zero-rated VAT?
Yes, for supported Amazon and Shopify setups using the correct product tax data. On channels that do not supply the necessary signals, assign each SKU to a product group manually or through a CSV upload.
Can it handle both zero-rated and reduced-rated products?
Yes. Product Groups can separate standard-, reduced- and zero-rated sales. The correct legal rate and mapping still need to be confirmed for each SKU and selling jurisdiction.
Why is my zero-rated Shopify product showing 20% VAT?
Link My Books reads the rate Shopify applied to the actual order line. Check the tax region, product overrides, customer destination and whether the item is configured to charge tax at 0%, rather than simply marked non-taxable.
Can I correct VAT on settlements already sent to Xero?
Yes, but it is not simply a matter of changing today's product group. Review the historical entry, make the appropriate reversal or void in your accounting platform, then follow Link My Books' rollback, refresh and resend instructions with your accountant.
Is zero-rated the same as VAT-exempt?
No. Zero-rated goods are taxable at 0%; exempt and outside-scope supplies follow different rules. Do not put all zero-VAT transactions into one group without confirming their treatment.
The bottom line: automate the mapping, verify the VAT
Link My Books can remove much of the repetitive work involved in mixed-rate ecommerce bookkeeping. Amazon supplies Product Tax Codes; Shopify supplies actual order-line tax calculations; other channels can use manual Product Groups and bulk uploads. Those differences are the key to understanding what the software will handle automatically.
I would start with one real settlement, verify the VAT treatment of a few representative SKUs, and ask an accountant to review the resulting entry. Once the mapping is right, automation becomes genuinely useful. For more on avoiding common errors, read my UK VAT and bookkeeping guide.