Contractor Payment Certificate Template in Excel

The payment certificate is how a contractor collects what is due. This template calculates the value of the period from cumulative progress, deducts retention, advance recovery and other deductions, and adds VAT to give the net amount due.

What is inside the sheet?

• Contract value with previous and current progress
• This certificate value from the difference between cumulative amounts
• Retention rate, advance recovery and other deductions
• VAT and the final net amount

How to use it

1. Enter the contract value
2. Enter previous and current cumulative progress
3. Adjust the retention rate and any deductions
4. Read the net due including VAT at the end of the sheet

Tips for best results

• Check the contract terms before using a retention rate
• Make sure current progress is higher than previous
• Attach the measured quantities to the certificate

Frequently asked questions

What is retention?

A share of the work value held back until the end of the warranty period according to the contract.

Are the figures binding?

They are helper calculations. The contract and the owner approval remain the reference.

Download the sheet

Press the download button at the top of the page to get an Excel file ready to edit. The sheet is also available in Arabic from the language switcher.

Note: this sheet is for early estimates and day-to-day help. Have a qualified engineer verify results against the applicable code before construction.