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:
- UAE VAT Progress Billing Invoice Template
- 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:
- Your Company Details / Header Section
- Client Detail
- Contract Details
- Progress Billing Detail
- Milestone or Work Completed Details
- 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:
- Contract number
- Duration of Contract
- Value of Contract
- Advance Amount
- Payments Till Date
- 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:
- Invoice Number
- Taxable Value
- Additional Costs if any
- Adjustment Amounts if any
- 5 % VAT Calculations
- Total Invoice Amount
- 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.