Download VAT Invoice Template Excel Template

Contents

Popular Categories in Excel Template
Trednding in Excel Template

Boat Loan Calculator

Use our free Boat Loan Calculator to estimate  monthly payment for a fixed-rate loan and create …

Read More

Gratuity Calculator

Gratuity Calculator Template in Excel easily calculate your gratuity amount as per the Gratuity Act …

Read More

2021 Monthly Calendar Landscape

We all have different strengths, and while some of us flow through computer task with …

Read More

Exercise Chart

Our Exercise Chart lets you create a list of exercises for your fitness plan, including …

Read More
Search
Generic filters

VAT Invoice Template is an excel template in compliance with GCC VAT Law. You can issue VAT invoice for 6 GCC Countries;  Bahrain, Kuwait, Oman, Qatar, Saudi Arabia and UAE easily and efficiently using template.

All 6 GCC countries have sign agreement for introduction of VAT throughout the GCC in 2018.

Business operating in GCC countries have to prepare for compliance with GCC VAT Law 2018.

We have create a ready to use VAT Invoice Template in Excel. The user needs to select his country and can start issuing VAT compliance invoices to their customers.

Before proceeding to template contents, you need to select your country from the box given beside the template.

When you select the country, it will automatically change the currency in all the cells of template.

Content of VAT Invoice Template

This template consists of 2 worksheets.

  1. VAT Invoice Template
  2. Database Sheet

Database sheet contains list of names of your customers. This list is use for creating the drop-down list in customer details section of VAT Invoice Template.

The invoice Template consists of 4 sections:

  1. Header Section
  2. Customer Details Section
  3. Product Details Section
  4. Other Details Section

1. Header Section

Header section contains the company logo, company name and heading of the invoice ” Tax Invoice”.

2. Customer Details Section

However, Customer Detail section programmed and referenced to database sheet with data validation and VLOOKUP function.

You can select the name of the customer from the drop-down list.

So, When you select the customer names, the template automatically updates other details of customers in the relevant cell.

Moreover, These details include address, phone, email and customer id.

On the right-hand side you need to enter invoice number, invoice date. The due date for payment which is set to 30 days from date of invoice will appear automatically. Then comes your VAT Registration Number.

3. Product Details Sections

Product details section consists of columns of Description, Quantity, Unit Price and Amount.

The formulas use are simple mathematical computations.

Quantity X Unit Price = Amount.

At the end, the subtotal line is given.

4. Other Details Section

Moreover, other details section consists of Amount in words, Terms & Conditions, VAT computations @ 5%.

In addition to this are given space for Company seal, signature box and “Thank you” message business greeting.

Moreover, It automatically computes the 5% VAT of the invoice amount and sums up the final total.

Download VAT Invoice Template Excel Template

To use this free Excel Template, you should have Microsoft Office/ Microsoft Excel. You can only use this template if you have these applications in your system. or Use, Google Sheets. 

After installing Excel or Spreadsheet, download the xlsx file of this template to use it

Once extracted, you can open the file using Excel and start entering data or customizing the template.

Click The Button Below To Download VAT Invoice Template Excel Template

Instruction :

All Excel templates and tools are sole property of xlsxtemplates.com. User can only download and use the excel templates for their Personal use only. All templates provided by XLSX templates are free and no payment is asked. However, you are not allowed to distribute or share in any other website for sole purpose of generating revenue from it.

 You can also download and use our 1000 Best PowerPoint Presentation Templates and 500 Resume Samples from PPTXTemplates.com  Completely Free. All our templates are designed by Professionals

Popular Excel Templates: