Open Sheets UK Business Tools
Business Tools

UK VAT Invoice Template Template

Professional, HMRC-compliant VAT invoice template. Customise with your branding and business details.

Download Free Template Free download, no signup required

File format: .xlsx (Microsoft Excel, Google Sheets, LibreOffice compatible)

What is it?

What is a VAT Invoice?

A VAT invoice is a legal document that records the sale of goods or services between a seller and a buyer. For VAT-registered businesses in the UK, it is a legal requirement to provide a proper VAT invoice for most transactions, and it must contain specific information to be valid for VAT reclaims.

Common use cases:

  • Charging customers for goods or services provided
  • Reclaiming VAT on business purchases (as a buyer)
  • Providing proof of transaction for HMRC records
  • Tracking sales and payment terms
  • Maintaining professional relationships with clients

When to use this template

  • You are VAT-registered and need to issue compliant invoices
  • You want a professional invoice format for your business
  • You need to track invoice numbers and payment status
  • You want to calculate VAT automatically at 20%
What's included

What Your Template Contains

Everything you need, pre-built and ready to use. Just enter your data in the blue cells.

Business Details Section

Your company name, address, phone, email, and VAT number (if applicable).

Client Details Section

Customer name, address, and contact information.

Invoice Number & Date

Sequential numbering with automatic date stamping.

Itemised List

Description, quantity, unit price, and line total for each item or service.

VAT Calculation

Automatic 20% VAT calculation with subtotal, VAT amount, and total due.

Payment Terms & Bank Details

Due date, payment methods, and bank details for bank transfers.

Benefits

How This Template Helps Your Business

HMRC Compliant

Includes all mandatory fields required by HMRC for a valid VAT invoice. No guesswork.

Professional Appearance

Clean, modern layout that looks professional to clients. First impressions matter.

Saves Time

Auto-calculates VAT, totals, and running balances. No more calculator errors.

How to use

Get Started in Minutes

No accounting knowledge required. Follow these simple steps and you'll be tracking your finances in no time.

Download Template
1

Open the template in Excel or Google Sheets

2

Enter your business details in the settings section (these auto-fill on every invoice)

3

Fill in the customer details for each invoice

4

Add your line items — description, quantity, and price

5

VAT and totals calculate automatically

6

Save as PDF for emailing or print for posting

FAQ

Frequently Asked Questions

Quick answers about this template

Ready to Get Started?

Download this free template and take control of your business finances today.

Free download, no email required. Works in Excel and Google Sheets.