Download UAE VAT Progress Billing Excel Template

Contents

Popular Categories in Excel Template
Trednding in Excel Template

Product Price

Product Price, the term is used in economics and finance, is the act of determining …

Read More

GPA Calculator

Probably this GPA calculator excel template is one of those simple template where you can …

Read More

Employee Absent Rate Calculator

Employee Absent Rate Calculator is a simple and hassle-free excel template with predefined formulas that …

Read More

Debt Payoff Tracker

Debt is usually money, borrowed by one person from another. Debt is used by many …

Read More
Search
Generic filters

UAE VAT Progress Billing Invoice with predefined formulas for progress billing under the new VAT System.

This is a type of invoice use to obtain part payment of the total contract amount from your clients as agreed in the contract.

Whereas under progress billing, as the duration of contract is long and contract amount is also big, payments are released at different stages as agreed in the contract.

Construction contractors, architects, landscapers, interior designers, IT system providers, consultants use progress billing.

VAT in UAE and Saudi has effect from 1st Jan 2018. Thus, business dealing in such kind of long-term contracts has to issue VAT compliant progress billing invoice to their clients.

We have created UAE VAT Progress Billing Invoice template in excel with predefine formulas.

Just enter your company details in the header section and start using this template.

You can also use this template for Saudi Arabia. Change the country to Saudi Arabia in place of UAE and it will automatically change the currency at all places on the invoice.

Contents UAE VAT Progress Billing Invoice Template

Similar to other invoice templates this template also consists of 2 sheets:

  1. UAE VAT Progress Billing Invoice Template
  2. Client Database

The customer database has name, address, contact details and VAT numbers of your customers. you just need to input the names and details once.

This sheet is link to the invoice template and you can fetch customer information in customer details section with the help from dropdown list. VLOOKUP is use here.

The UAE VAT Progress billing Invoice consists of 6 sections:

  1. Your Company Details / Header Section
  2. Client Detail
  3. Contract Details
  4. Progress Billing Detail
  5. Milestone or Work Completed Details
  6. Company Seal and Signature

1. Your Company Details / Header Section

This section contains of supplier’s/your company name, logo, address, VAT number etc. It is mandatory to mention your VAT number on the invoice.

2. Client Details

Client details consists of the client’s company name, address, contact number and VAT number. The user just needs to select the name of the customer name from the dropdown list created using data validation.

3. Contract Details

Details of Contract consist of the following:

  1. Contract number
  2. Duration of Contract
  3. Value of Contract
  4. Advance Amount
  5. Payments Till Date
  6. Balance Amount

Here, the balance Amount is calculated using the below formula:

Balance Amount = Contract value – Advance Amount – Payments Till date

4. Progress Billing Details

Progress Billing details consist of the following:

  1. Invoice Number
  2. Taxable Value
  3. Additional Costs if any
  4. Adjustment Amounts if any
  5. 5 % VAT Calculations
  6. Total Invoice Amount
  7. Amount In Words

Also, VAT Amount is calculated using the below formula:

VAT Amount = (Taxable Amount + Additional Costs + Adjustments) X 5% VAT

So, Enter a negative amount of adjustments, if you want to decrease excess received amounts.

5. Milestone or Work Completed Details

Moreover, Here you need to enter the predefined milestone of your original contract that has been completed or the amount of work completed.

In case, there are any other details to be clarified, you can enter them in the Additional comments section.

6. Company Seal and Signature

Lastly, there is the thanking message along with the space for company seal and authorized signatory.

Download UAE VAT Progress Billing 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 UAE VAT Progress Billing 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: