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.
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.
Similar to other invoice templates this s=template also consists of 2 sheets:
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.
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:
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.
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.
Once you select the name of the customer, the system will automatically fetch the data you have entered in the client sheet.
Details of Contract consist of the following:
Here, the balance Amount is calculated using the below formula:
Balance Amount = Contract value – Advance Amount – Payments Till date
Progress Billing details consist of the following:
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.
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.
Lastly, there is the thanking message along with the space for company seal and authorized signatory.
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.
To simplify the process, we have created a simple and easy UK VAT Taxable Turnover…
Every business has to register for VAT with HM Revenue and Customs if their VAT…
We have created the UK VAT Dual Currency Invoice excel template with predefined formulas that…
We have created a simple and easy UK VAT Purchase Register Excel Template with predefined…
We have created a simple and easy UK VAT Sales Register Excel Template with predefined…
We have created a ready to use UK VAT Progress Billing Invoice template in excel…