Are you a civil engineer? Or are you involved in construction work in any way? And are you looking for an ideal interim payment certificate format? If the answers to the above questions are yes, then you’ve come to the right place. In this article, you’ll learn how you can create an interim payment certificate format effectively in Excel with appropriate illustrations.

**Table of Contents**Expand

## What Is an Interim Payment Certificate?

Before going into the details, let’s dwell a little on what an interim payment certificate is. In easy words, any certificate of payment issued by the engineer that is not the “Final Payment Certificate” is referred to as an “Interim Payment Certificate”. When a contractor gets a project, they don’t get the whole contract amount at a time. Actually, they get it part by part after completing a successful percentage of the work. This is the interim payment. This refers to everything except the final payment.

## 6 Steps to Make Interim Payment Certificate Format in Excel

This section focuses on how we can construct an interim payment certificate format in Microsoft Excel. Here, we’ll show you the different steps involved in the process of making this payment certificate. To create multiple parts of the payment certificate format, follow the approach step by step.

Here, we have used the *Microsoft Excel 365* version, you may use any other version according to your convenience.

### Step 01: Create Basic Outline

At the very beginning, we’ve to build a basic outline where the basic information of this certificate can fit in. Let’s see the process in detail.

**📌**** Steps:**

- First of all, give a suitable heading in the
**B2:G2**range. In this case, we’ve done it as**Interim Payment Certificate**. - Then, in the
**B4:G7**range, create an area to insert the basic data and information about the project. This includes the**Project Name**,**Contractor**name,**Contract Amount**, etc. This part gives us a clear idea about the project.

**Read More:** How to Create Annual Loan Payment Calculator Excel

### Step 02: Mention Work Details and Bill Quantity

There are multiple types of tasks associated with construction work. Also, a separate payment arrangement is specified for each job. It’s simple and easy. Just follow along.

**📌**** Steps:**

- At first, create a table in the
**B9:E16**range. - In the
**B9:E9**range, give the different headings of the column. Here, we did it as**SL**,**Description,**and**BQ Amount**(bill quantity).

- Secondly, place the first work name and short description in cell
**C10**and put its corresponding bill amount in cell**E10**.

- Similarly, write down the other function’s name of this project in
**Column C**and their respective**BQ Amount**in**Column E**.

### Step 03: Acknowledge Percent of Work Completion

In a payment certificate, how much percentage of the work has been completed should be mentioned. Based on this, the payment amount will be verified. So, without further delay, let’s see how to do it.

**📌**** Steps:**

- At this time, create a new column with the heading
**% Complete**under**Column F**. - Then, in cells in the
**F10:F16**range, write down the completion percentage of each work in order.

### Step 04: Calculate the Total Due Amount

In this section, we’ll calculate the bill’s due amount based on the percentage of completion. It’s the most important part of this certificate. So, without further delay, let’s dive in!

**📌**** Steps:**

- Firstly, create a new column for
**Due Amount**. - In this column, select cell
**G10**and enter the following formula into the**Formula Bar.**

`=E10*F10`

Basically, this formula multiplies the total bill amount in cell **E10** with the completion percentage in cell **F10** to get the due payment amount.

- After that, press the
**ENTER**key.

- Now, bring the cursor to the right-bottom corner of cell
**G10,**and immediately, it will look like a plus**(+)**sign. Actually, it’s the**Fill Handle**tool. - Then, double-click on it to copy the formula to the following cells.

Instantly, the cells in the **G11:G16** range get filled with the correct results.

Currently, we’ll enumerate the grand total of the due amount. To do this,

- Primarily, go to cell
**G17**and write down the formula below.

`=SUM(G10:G16)`

Here, we’ve used the **SUM function** in this formula. It computes the required amount for various types of work in cells in the **G10:G16 **range.

- As usual, press
**ENTER**.

**Read More:** How to Calculate Monthly Payment in Excel

### Step 05: Compute the Due Amount for the Present Payment Certificate

In the previous section, we talked about the total due amount. Here, we’ll show how to calculate the due amount for the present payment certificate. As here we are working with the second interim payment certificate, the payment for the first one must be done. Let’s see it in action.

**📌**** Steps:**

- Initially, we’ll introduce two items:
**10% retention**and**previous payments**. Here, retention means holding up some money for security purposes. Ideally, we took it as 10%. Since it is the second interim payment certificate, the number of previous payments should be 1.

- Presently, go to cell
**G20**and put the following formula into the cell.

`=G17-G18-G19`

- As always, press
**ENTER**.

Additionally, we can display this amount in cell **G20** in words. To do this,

- Firstly, create a range in cells in the
**B22:G22**range.

- After that, go to the
**Develo****p****er Tab**. - Then, click on
**Visual Basic**in the**Code**group.

Immediately, it opens the **Microsoft Visual Basic for Applications** window.

- Now, move to the
**Insert**tab. - Later, select
**Module**from the available options.

Suddenly, it opens a code module where we can write down our code to make it work.

- Following this, copy the following code and paste it into your code module.

```
Function ConvertCurrencytoWords(ByVal GivenCurrency)
Dim USD, C
Words = Array("", "", " Thousand ", " Million ", " Billion ", " Trillion ")
GivenCurrency = Trim(Str(GivenCurrency))
FractionCurrency = InStr(GivenCurrency, ".")
If FractionCurrency > 0 Then
C = TensPlace(Left(Mid(GivenCurrency, FractionCurrency + 1) & "00", 2))
GivenCurrency = Trim(Left(GivenCurrency, FractionCurrency - 1))
End If
GetIndex = 1
Do While GivenCurrency <> ""
GetHundred = ""
GetValue = Right(GivenCurrency, 3)
If Val(GetValue) <> 0 Then
GetValue = Right("000" & GetValue, 3)
If Mid(GetValue, 1, 1) <> "0" Then
GetHundred = OnesPlace(Mid(GetValue, 1, 1)) & " Hundred "
End If
If Mid(GetValue, 2, 1) <> "0" Then
GetHundred = GetHundred & TensPlace(Mid(GetValue, 2))
Else
GetHundred = GetHundred & OnesPlace(Mid(GetValue, 3))
End If
End If
If GetHundred <> "" Then
USD = GetHundred & Words(GetIndex) & USD
End If
If Len(GivenCurrency) > 3 Then
GivenCurrency = Left(GivenCurrency, Len(GivenCurrency) - 3)
Else
GivenCurrency = ""
End If
GetIndex = GetIndex + 1
Loop
Select Case USD
Case ""
USD = "No USD"
Case "One"
USD = "One Dollar"
Case Else
USD = USD & " USD"
End Select
Select Case C
Case ""
C = " and No C"
Case "One"
C = " and One Cent"
Case Else
C = " and " & C & " C"
End Select
ConvertCurrencytoWords = USD & C
End Function
Function TensPlace(TensDigit)
Dim Output As String
Output = ""
If Val(Left(TensDigit, 1)) = 1 Then
Select Case Val(TensDigit)
Case 10: Output = "Ten"
Case 11: Output = "Eleven"
Case 12: Output = "Twelve"
Case 13: Output = "Thirteen"
Case 14: Output = "Fourteen"
Case 15: Output = "Fifteen"
Case 16: Output = "Sixteen"
Case 17: Output = "Seventeen"
Case 18: Output = "Eighteen"
Case 19: Output = "Nineteen"
Case Else
End Select
Else
Select Case Val(Left(TensDigit, 1))
Case 2: Output = "Twenty "
Case 3: Output = "Thirty "
Case 4: Output = "Forty "
Case 5: Output = "Fifty "
Case 6: Output = "Sixty "
Case 7: Output = "Seventy "
Case 8: Output = "Eighty "
Case 9: Output = "Ninety "
Case Else
End Select
Output = Output & OnesPlace(Right(TensDigit, 1))
End If
TensPlace = Output
End Function
Function OnesPlace(OnesDigit)
Select Case Val(OnesDigit)
Case 1: OnesPlace = "One"
Case 2: OnesPlace = "Two"
Case 3: OnesPlace = "Three"
Case 4: OnesPlace = "Four"
Case 5: OnesPlace = "Five"
Case 6: OnesPlace = "Six"
Case 7: OnesPlace = "Seven"
Case 8: OnesPlace = "Eight"
Case 9: OnesPlace = "Nine"
Case Else: OnesPlace = ""
End Select
End Function
```

We got them from the article Convert Currency to Words in Excel. You can follow this article for better learning.

- In this instance, save the file in macro-enabled (.xlsm) format and return to the worksheet.
- In cell
**C22**, start to write**=con**and you’ll see the function**ConvertCurrencytoWords**in the suggestion. Double-click on it.

The result and formula in cell **C22** look like the following.

### Step 06: Construct Certification and Authorization Space

Now, we’ll create a separate section to express the consent of both parties. So, let’s see it.

**📌**** Steps:**

Here, we built an isolated area in cells in the **B24:G36** range. In this section, they can give their opinions and signatures.

You may download the following Excel workbook for better understanding and practice yourself.

## Conclusion

This article provides easy and brief solutions to create an interim payment certificate format in Excel. Don’t forget to download the Template file. Thank you for reading this article. We hope this was helpful. Please let us know in the comment section if you have any queries or suggestions.

**Related Articles**

- How to Create Snowball Payment Calculator in Excel
- Create Progressive Payment Calculator in Excel
- How to Create Line of Credit Payment Calculator in Excel
- Make a Cash Payment Voucher Format in Excel
- How to Calculate Car Payment in Excel
- How to Calculate Auto Loan Payment in Excel

**<< Go Back to Finance Template | Excel Templates**

A brilliant article. I really learn a lot from this article and it will help. I hope I will be able to create an interim certificate template following these steps.

Thanks

Hello

Abubakar,You are most welcome. We hope so you will be able to create an interim certificate template following these steps.

Regards

ExcelDemy