# How to Create a GST Rental Invoice Format in Excel – 5 Steps

This is the sample dataset.

### Step 2 – Calculate the Subtotal

• Go to C13 and use the following formula
`=SUM(C5:C12)`

• Press ENTER.

This is the output.

### Step 3 – Calculate the Tax Amount

Consider a 15% tax:

• Go to C14 and use the formula:
`=C13*15%`

• Press ENTER to see the output.

Read More: Tally Sales Invoice Format in Excel

### Step 4 – Determine the Total Due

• Go to C15 and use the following formula:
`=C13+C14`

• Press ENTER.

### Step 5 – Calculate the Total Due After Due Date

Consider a penalty of 10% for late payment:

• Go to C16 and use the following formula
`=C15+C15*10%`

• Press ENTER to see the output.

## Related Articles

<< Go Back to Excel Invoice Templates | Accounting Templates | Excel Templates

Get FREE Advanced Excel Exercises with Solutions!
Akib Bin Rashid

AKIB BIN RASHID, a materials and metallurgical engineer, is passionate about delving into Excel and VBA programming. To him, programming is a valuable time-saving tool for managing data, files, and internet-related tasks. Proficient in MS Office, AutoCAD, Excel, and VBA, he goes beyond the fundamentals. Holding a B.Sc in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology, MD AKIB has transitioned into a content development role. Specializing in creating technical content centred around Excel and... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF