• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Download UK VAT Invoice Excel Template

Download UK VAT Invoice Excel Template

UK VAT Invoice is a ready-to-use excel template that helps you to issue a VAT compliance invoice to your clients for taxable goods and services with auto calculations.

VAT was introduced earlier as consumption tax and later on termed as Value Added Tax. Currently, there are 3 different VAT rates in the UK – 20%, 5%, and 0%.

To know more about the UK VAT you can visit the official website of the Ministry of Finance – UK www.gov.uk.

Table of Contents

  • Guidelines For UK VAT Invoice
  • UK VAT Invoice Excel Template
  • Content of UK VAT Invoice Excel Template
    • Customer Database Sheet
    • UK VAT Invoice Template
      • Header Section
      • Customer Details
      • Product Details
      • Other Details

Guidelines For UK VAT Invoice

Invoice information

Full invoice

Unique invoice number that follows on from the last invoice

Yes

Your business name and address

Yes

Your VAT number

Yes

Date

Yes

The tax point (or ‘time of supply’) if this is different from the invoice date

Yes

Customer’s name or trading name, and address

Yes

Description of the goods or services

Yes

Total amount excluding VAT

Yes

The total amount of VAT

Yes

Price per item, excluding VAT

Yes

Quantity of each type of item

Yes

Rate of any discount per item

Yes

Rate of VAT charged per item – if an item is exempt or zero-rated make clear no VAT on these items

Yes

The total amount including VAT

No

Source: www.gov.uk

UK VAT Invoice Excel Template

We have created a UK VAT Invoice excel template with predefined formulas and formatting as per the above guidelines. You can easily issue the invoice to your customers with the help of this template.

UK VAT Invoice

Click here to Download UK VAT Invoice Excel Template As Per UK Government Guidelines.

You can also download other VAT templates like UAE VAT Multiple Tax Invoice, UAE VAT Dual Currency Invoice, and UAE VAT Payable Calculator.

Content of UK VAT Invoice Excel Template

This template consists of 2 worksheets; UK VAT Invoice Template and Customer Database sheet.

Customer Database Sheet

The database sheet contains a list of your customers. These customers are those whom we issue the invoices for the goods supplied or services rendered regularly.

UK VAT Invoice

UK VAT Invoice Template

The UK VAT Invoice contains the Performa of the invoice as per the guidelines. It consists of 4 sections.

Header Section

The header section consists of your company’s logo, name, VAT Registration Number and the heading of the invoice.

Customer Details

UK VAT Invoice

The customer details section consists of the client’s details as below:

Company Name
Street Address
Phone
Email
Invoice
Date
Customer ID
Due Date
Time Of Supply

This section is connected with data validation and the VLOOKUP function to the database sheet. Thus, when you select the name of the customer it automatically updates the Address, phone, email, and customer id. Before making any invoice update the customer database sheet.

In addition to that, on the right-hand side, you need to enter the invoice number, invoice date, due date of payment and time of supply or tax point.

In case of a credit invoice, the due date is set to 30 days from the date of the invoice. If your invoice is cash then leave it blank.

Product Details

UK VAT Invoice

The product details section consists of the following columns:

Description: Insert description of goods or services to your client.

Quantity: Quantity of the product.

Unit Price: Price per product.

Amount: This column shows the total amount of supply per item using Quantity multiplied by Unit Price. The final total of this column us the taxable amount.

Other Details

UK VAT Invoice

Other details section consists of the following:

Amount in words: No need to insert anything here. It will automatically convert the amount in words using Spell Number GBP.

Terms & Conditions: Insert your invoice terms and conditions.

VAT computation: Select the type of VAT from the dropdown list. If you select Standard, the cell next to it will display 20% and if you select Reduced then it will display 5%. When Zero-rated is selected the cell will display 0%. The VAT amount is calculated on the basis of percentage.

UK VAT Invoice

Taxable Amount X VAT % = VAT Amount

VAT Amount + Taxable Amount = Final Invoice Amount

Company seal: A blank space is given for the company seal. After printing the invoice you can stamp here.

Signature: A blank space is given for the authorized signatory. After printing the invoice the authorized personnel can sign the invoice here.

Thank You Note: Insert a thank you note of your choice here.

That’s it and your UK VAT Invoice is ready to print. This template can be helpful to small and medium scale business people to issue VAT compliance invoices to their clients.

We thank our readers for liking, sharing and following us on different social media platforms.

If you have any queries please share in the comment section below. We will be more than happy to assist you.

Filed Under: UK VAT Templates

You are Here: Home / Excel Templates / General Templates / Download UK VAT Invoice Excel Template

About Shabbir Bhimani

I have worked in Excel and like to share functional excel templates at ExcelDataPro.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

ExcelDataPro

Free Excel Pro Templates

  • Glossary
    • Accounting Glossary
    • HR & Payroll Glossary
    • Tax Glossary
  • Templates
    • Accounting
      • Financial Analysis
      • Financial Statement
    • Educational
    • Taxation
      • Federal Income Tax
      • GST
      • UAE VAT
      • UK VAT
    • Human Resources
      • HR & Payroll
      • HR Metrics
    • School Management
    • Social Media
    • Sales-Marketing
    • Personal Finance
    • Other
      • Health & Fitness
  • Functions
  • Calculators
  • Home
  • Contact
  • Privacy
  • Terms

© ExcelDataPro 2025. Content Licensed Under Creative Commons with Attribution Required

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT