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

Download UAE VAT Progress Billing Invoice Excel Template

Download UAE VAT Progress Billing Invoice Excel Template

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

Progress Billing Invoice is a type of invoice used to obtain part payment of the total contract amount from your clients as agreed in the contract.

It is different from standard invoicing. In standard invoicing, a client pays the amount in full against the goods or services obtained.

Whereas under progress billing, as the duration of the contract is long and the 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, etc use progress billing.

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

UAE VAT Progress Billing Invoice

We have created a ready to use UAE VAT Progress Billing Invoice template in excel with predefined formulas.

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

Click here to download UAE VAT Progress Billing Invoice Excel Template.

You can also download other UAE centric templates like Arabic VAT Invoice Template, GCC VAT Invoice Template With Discount and UAE VAT Payable Calculator

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

UAE VAT Progress Billing Invoice Let us discuss the contents of the template in detail.

Contents of UAE VAT Progress Billing Invoice Template

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

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

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

UAE VAT Progress Billing Invoice

This sheet is linked to the invoice template and you can fetch all customer information in customer details section with the help fo dropdown list. VLOOKUP is used here.

The date section is configured using TODAY Function. It will display the system date.

The UAE VAT Progress billing Invoice consists of 6 sections:

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

1. Your Company Details / Header Section

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

UAE VAT Progress Billing Invoice

2. Client Details

Client details consist of 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.

UAE VAT Progress Billing Invoice

Once you select the name of the customer, the system will automatically fetch the data you have entered in the client sheet.

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

UAE VAT Progress Billing Invoice

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

UAE VAT Progress Billing Invoice

VAT Amount is calculated using the below formula:

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

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

5. Milestone or Work Completed Details

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

UAE VAT Progress Billing Invoice

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.

UAE VAT Progress Billing Invoice

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.

« Download GCC VAT Invoice Template With Discount
Download UAE VAT Multiple Tax Invoice Excel Template »

Filed Under: UAE VAT Templates

You are Here: Home / Excel Templates / UAE VAT Templates / Download UAE VAT Progress Billing 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 *

UAE VAT Templates

  • UAE VAT Tax Invoice Excel Template As Per The Federal Law 8 of 2017 on VAT
  • UAE Invoice Template With VAT in Excel – Arabic
  • UAE VAT Credit Note Excel Template
  • UAE VAT Debit Note Excel Template
  • UAE VAT Inventory Management Excel Template
  • UAE VAT Purchase Register Excel Template
  • UAE VAT Sales Register Excel Template
  • UAE VAT Payable Calculator Excel Template
  • VAT Invoice Template for Bahrain, Kuwait, Oman, Qatar, Saudi Arabia and UAE
  • VAT Credit Note Template for Bahrain, Kuwait, Oman, Qatar, Saudi Arabia and UAE
  • GCC VAT Payable Calculator For All 6 GCC Countries
  • Arabic VAT Invoice Template for Bahrain, Kuwait, Oman, Qatar, Saudi Arabia and UAE
  • GCC VAT Invoice Template With Discount
  • UAE VAT Progress Billing Invoice Excel Template
  • UAE VAT Multiple Tax Invoice Excel Template
  • UAE VAT Dual Currency Invoice Excel Template
  • Bilingual UAE VAT Invoice Excel Template
  • Bilingual Saudi VAT Invoice Excel Template
  • Saudi VAT Payable Calculator Excel Template
  • UAE VAT Invoice Format for Rent A Car Business In Excel

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