Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. When it comes to creating a rental invoice, Excel can be helpful. One can easily create a rental invoice format using Excel. In this article, I will show you how to create GST rental invoice format in Excel in easy steps.
Download Practice Workbook
Download this workbook and practice while going through the article.
Introduction to Rental Invoice
When a landlord or property management receives payment for a rental property, they will deliver or mail a rent invoice to the tenant (whether they are renting a single, multi-family, or commercial property). To ensure accurate payment records, the property manager or landlord should keep copies of all relevant paperwork.
GST stands for Goods & Service Tax. It is crucial to remember that the GST is only charged on the rental of commercial property; it is not charged on the rental of residential property.
5 Steps to Create GST Rental Invoice Format in Excel
This is the dataset for today’s article. We have XYZ company. This is a simple format for a rental invoice prepared for this company.
I will show how to create the invoice using this format.
Step 1: Write Down Details of Invoice
The first step is to fill up the amount for different bills. You just have to manually fill up them in.
Read More: Create GST Invoice Format in Excel (Step-by-Step Guideline)
Step 2: Calculate Subtotal from Given Data
The next step is to calculate the subtotal. We will use the SUM function to calculate the subtotal. To do so,
- Go to C13 and write down the following formula
- Then, press ENTER. Excel will return the output.
Read More: How to Remove GST from Total Amount in Excel (With Easy Steps)
Step 3: Calculate Tax Amount from Given Amount
Now, I will calculate the tax amount. In this example, I am considering the tax to be 15%. So, let’s calculate the tax.
- Go to C14 and write down the formula
- Then, press ENTER to get the output.
Read More: Creating GST Purchase Order Format in Excel (Free Template)
Step 4: Determine Total Due
Now, I will show how to calculate the total due. This is the summation of the subtotal and the tax levied on the subtotal. To calculate it,
- Go to C15 and write down the following formula
- Then, press ENTER.
Step 5: Calculate Total Due After Due Date
We are almost done with the steps. Our last step is to consider the late payment. If the tenant does not repay the rent within a certain time, he or she will have to give a penalty. We are considering this amount to be 10%. So, let’s calculate it.
- Go to C16 and write down the following formula
- Now, press ENTER to get the output.
Read More: How to Create GST Bill Format in Excel with Formula
Things to Remember
- GST is only charged only on the rental of commercial property, not on the rental of residential property.
- Format the invoice as you wish.
In this article, I have explained how to create GST rental invoice format in Excel in easy steps. I hope it helps everyone. If you have any suggestions, ideas, or feedback, please feel free to comment below. Please visit Exceldemy for more useful articles like this.