Keep your VAT Margin Scheme records organised with this professional, easy-to-use Excel Record Book.
Designed for UK businesses dealing in eligible second-hand goods, antiques, works of art and collectors’ items, this premium template provides a clear and structured way to record individual purchases and sales.
What’s included:
• Premium VAT Margin Scheme Record Book
• Purchase and sales record for each item
• Unique stock number tracking
• Purchase and selling price records
• Automatic margin calculation
• Automatic VAT on positive margin calculation
• Net margin calculation
• Automatic In Stock / Sold status
• Space for up to 500 records
• Record Summary
• Step-by-step “How It Works” guide
• Worked example included
• Editable Excel file
• Instant digital download
Simple to use
Enter the purchase details when you acquire an eligible item. When the item is sold, add the sale details to the same record. The spreadsheet automatically calculates the margin, VAT on a positive margin and net margin.
Worked Example
Purchase Price: £1,500
Selling Price: £2,000
Margin: £500
VAT on Margin: £83.33
Net Margin: £416.67
Important: This product is a record-keeping template only. It does not prepare or submit your VAT Return and does not determine whether a transaction qualifies for the VAT Margin Scheme. Users must check the applicable HMRC rules and retain appropriate supporting records.
Digital Product: Instant download. No physical product will be supplied.
ZipTax Ltd | UK VAT Margin Scheme Record Book | Template – Must Be Tailored to Your Business Before Use