Purpose-Built for UK Dealers

VAT Margin Scheme Software for UK Dealers

VAT Margin Scheme software that handles the calculations, tracks eligibility, and generates HMRC-compliant reports automatically. Built by a former UK dealer of jewellery, watches, antiques, and luxury goods who spent years wrestling with spreadsheets.

gemjam.app

VAT Return Report

Q1 2026 · 1 Jan 2026 – 31 Mar 2026

Output VAT

£4,216.50

VAT due on sales

Input VAT

£1,840.00

VAT reclaimed

Net VAT

£2,376.50

To pay HMRC

MTD Box Values

Box 1 VAT due on sales £4,216.50
Box 2 VAT due on acquisitions £0.00
Box 3 Total VAT due £4,216.50
Box 4 VAT reclaimed on purchases £1,840.00
Box 5 Net VAT to pay £2,376.50
Box 6 Total sales (excl. VAT) £89,450.00
Box 7 Total purchases (excl. VAT) £52,300.00
Box 8 Total supplies to EU £0.00
Box 9 Total acquisitions from EU £0.00

What Is the VAT Margin Scheme?

The VAT Margin Scheme is an HMRC-approved method for VAT-registered dealers of second-hand goods, works of art, antiques, and collectors' items. Instead of charging VAT on the full selling price, dealers pay VAT only on the profit margin — the difference between what they paid for an item and what they sold it for.

For UK dealers of jewellery, watches, antiques, and luxury goods, the Margin Scheme is essential. Most stock is purchased from private individuals, estate sales, or other non-VAT-registered sources. Without the Margin Scheme, you would owe VAT on the entire selling price with no input VAT to reclaim — wiping out your profit on lower-margin items.

The catch: HMRC requires meticulous record-keeping. Every eligible purchase needs a Stock Book entry with the date, description, purchase price, and seller details. Every sale needs a corresponding record. And you must track which items qualify for the Margin Scheme and which must use standard VAT accounting — because not every purchase is eligible.

This is where most dealers struggle. Spreadsheets can track the numbers, but they cannot enforce the rules, flag errors, or generate the reports HMRC expects at inspection.

How to Calculate VAT on the Margin Scheme

The margin scheme calculation is straightforward in principle but error-prone in practice, especially when tracking hundreds of items across different VAT treatments.

Record the purchase price

Note the price you paid for the item and confirm the seller is not VAT-registered (making the purchase eligible for the Margin Scheme).

Record the selling price

When the item sells, record the full selling price. The margin is the selling price minus the purchase price.

Calculate VAT at 1/6 of the margin

VAT is calculated at 1/6 (16.67%) of the positive margin. For example: buy at £500, sell at £800 — the margin is £300 and the VAT due is £50. If the margin is zero or negative, no VAT is due.

Report on your VAT return

Include the total output VAT from margin scheme sales in Box 1 of your VAT return. The full selling prices go in Box 6. Keep the Stock Book records for HMRC inspection.

Important: You must not show VAT separately on margin scheme invoices.

Customer-facing invoices must show only the total price. The VAT element is not disclosed. This is a common compliance error that GemJam handles automatically by generating dual invoice formats — one for customers and one for your records.

Why Spreadsheets Fail for VAT Margin Scheme

Most UK dealers start with spreadsheets. They work at first — until they don't.

No eligibility tracking

Spreadsheets cannot enforce which purchases qualify for the Margin Scheme. One incorrect entry means the wrong VAT treatment on that item — and you might not notice until an HMRC inspection.

Formula errors compound

A broken formula in row 47 silently corrupts every calculation below it. Margin scheme calculations require perfect accuracy across hundreds of items — one mistake cascades through your entire VAT return.

No audit trail

HMRC expects a clear, traceable record from purchase to sale. Spreadsheets let anyone edit any cell at any time with no history. If HMRC queries a figure, you cannot prove when or how it was entered.

No invoice generation

Margin scheme invoices have specific rules — you must not show VAT separately. Spreadsheets cannot generate compliant invoices, so you end up creating them manually and hoping you remember the rules each time.

How GemJam Handles VAT Margin Scheme

Every feature designed around the specific needs of UK dealers using the Margin Scheme.

Automatic margin calculations

Record the purchase and sale — GemJam calculates the margin and applies VAT at 1/6 (16.67%) automatically. No formulas to maintain, no manual calculation errors.

Purchase eligibility tracking

Mark each purchase as from a VAT-registered or non-VAT-registered seller. GemJam enforces the correct VAT treatment for every item throughout its lifecycle.

HMRC-compliant reports

Generate your VAT Return Report with output VAT split between margin scheme and standard transactions. Export the Stock Book and registers your accountant needs — or export to Xero-compatible format and email to Dext.

Dual invoice formats

GemJam automatically generates customer-facing invoices (no VAT shown, as required) and accounting invoices (with full margin and VAT breakdown) for your records.

Record your purchases and sales. GemJam handles the rest in the background — your stock book, export register, and VAT return are always up to date without a quarterly scramble.

gemjam.app

PUR-2026-0042

Hatton Garden Estates · 15 Feb 2026

Completed

Subtotal

£8,250.00

VAT

£0.00

Margin Scheme

Total

£8,250.00

Line Items

Art Deco Diamond Ring, c.1925

JWL-2026-0089

£3,450.00

Available

Victorian Pearl Brooch

JWL-2026-0090

£1,800.00

Sold

Cartier Tank Watch, 1970s

WCH-2026-0034

£3,000.00

Available

VAT Margin Scheme: GemJam vs the Alternatives

How purpose-built software compares to generic tools for margin scheme compliance.

GemJam

  • Automatic margin VAT calculation
  • Purchase eligibility tracking
  • HMRC-compliant Stock Book
  • Dual invoice formats
  • VAT Return Report
  • Unique item management
  • E-commerce integrations (Shopify; eBay coming soon)
  • Accounting export (Xero/Dext format)

Spreadsheets

  • Manual formulas (error-prone)
  • No eligibility tracking
  • Manual Stock Book setup
  • No invoice generation
  • No accounting integration

Airtable + Zapier

  • Custom build needed for VAT
  • Custom build needed for eligibility
  • No invoice generation
  • Accounting via Zapier (extra cost)

Generic Inventory Software

  • No margin scheme support
  • No eligibility tracking
  • No HMRC-compliant reports
  • Bulk-focused, not unique items

Dedicated Dealer Software

  • Margin scheme VAT calculations
  • Eligibility tracking
  • HMRC-compliant Stock Book
  • Dual invoice formats — Varies
  • VAT Return Report
  • Unique item management
  • No e-commerce integrations (own website only)
  • Limited accounting integration

What about building a custom solution?

You could commission a bespoke system tailored to your exact workflow. But expect 3-6 months of development, £20,000-50,000+ in build costs, and ongoing maintenance fees for hosting, updates, and bug fixes. You would also need to specify every margin scheme rule yourself — and keep it current as HMRC requirements change.

GemJam gives you purpose-built VAT Margin Scheme software, ready to use — with updates included.

New to the margin scheme? Read our complete guide to the VAT Margin Scheme for jewellery and antique dealers — covering eligibility, worked examples, and record-keeping requirements.

Selling second-hand goods through Shopify? Our step-by-step guide explains how to handle the VAT Margin Scheme on Shopify — including common pitfalls and how GemJam automates the process.

VAT Margin Scheme: Common Questions

Practical answers for UK dealers using or considering the Margin Scheme.

Stop Wrestling with VAT Margin Scheme Spreadsheets

GemJam handles the calculations, tracks eligibility, and generates HMRC-compliant reports. Join the waiting list for early access.