VAT Record & Return Template
Track all VATable transactions for quarterly VAT returns. Records inputs and outputs, calculates net VAT payable, and simplifies HMRC VAT Return submissions.
What's Included
- Format: Microsoft Excel Spreadsheet (XLSX)
- File: vendorpad-vat-record-template.xlsx
- Category: Quotes & Finance
- Ready to customise for your business
- Free to download — no account needed
How to Use This Template
This spreadsheet tracks your VAT on sales and purchases if you're VAT-registered (or approaching the threshold). It includes columns for date, description, net amount, VAT rate, VAT amount, and gross total — with separate tabs for sales and purchases. A summary tab calculates your quarterly VAT return figures.
Enter every sale and purchase with the correct VAT rate. Most food and drink is zero-rated for VAT, but hot takeaway food served at events is standard-rated (20%). Catering services are always standard-rated. Equipment and supplies you buy will usually include VAT you can reclaim.
Update this weekly so your quarterly return isn't a scramble. If your annual turnover exceeds the VAT threshold (currently £90,000), you must register. Even below the threshold, voluntary registration lets you reclaim VAT on purchases — worth considering if you're buying expensive equipment.
Who This Is For
- All event vendors
Related Searches
Download Free
Get this template instantly
Free — just enter your email
More Quotes & Finance Templates
Quote / Proposal Template
Clean, professional quote template with itemised pricing, VAT calculation, deposit breakdown, and your branding. Works for any event type.
Event Profit & Loss Calculator
Calculate your true profit per event. Tracks revenue, food/supply costs, staff costs, travel, and overhead to show actual margin per gig.
Pricing Calculator
Work out your per-head, package, and hourly rates. Factors in food costs, staff, travel, overheads, and desired margin to set profitable prices.
Invoice Template
Professional invoice template with automatic calculations, VAT handling, payment terms, and bank details section. Tracks deposit paid and balance due.