• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Download Rent Receipt Excel Template

Download Rent Receipt Excel Template

Rent Receipt Template is a ready-to-use excel template to issue a receipt of rent collected from the tenant and maintain the record of the same.

In addition to the above, it also consists of a Tenant Ledger where you can record the incoming rent along with each tenant detail and particulars of the payments.

Furthermore, it consists of a printable version that you can print and use for issuing a receipt for the rent received.

Usually, real estate agents and individuals who have multiple properties to maintain and manage have to keep a record of everything.

When it comes to micromanaging these details, it becomes tough. Many times rents have been paid but not accounted for. Sometimes some fraud happens then these receipts can be useful for both tenants and landlords.

To avoid discrepancy it is always advisable to demand or issue a receipt. This template can be useful to real estate agents, property investors, and real estate companies.

Table of Contents

  • Rent Receipt Excel Template
  • Contents of Rent Receipt Excel Template
    • Tenant Ledger
    • Rent Receipt
    • Printable Rent Receipt Format

Rent Receipt Excel Template

We have created a simple and easy Rent Receipt Excel Template with predefined formulas and formats. Print and issue your receipt in less than a minute.

Insert the details of rent received along with payment details. Go to the receipt template. Type in the receipt number and it is ready to print.

Click here to download Rent Receipt Excel Template.

Click here to Download All Personal Finance Excel Templates for ₹299.

In addition to the above, you can also download other personal finance templates like Investment Tracker With ROI, Savings Goal Tracker, Household Budget, Credit Card Payoff Calculator and Personal Income Expense Tracker from our website.

Let us discuss the contents of this template and how to use it.

Contents of Rent Receipt Excel Template

This template consists of 3 sheets: Tenant Ledger, Rent Receipt and Printable Rent Receipt.

Tenant Ledger

At the top, insert the name of the landlord and his PAN No. or TAX number.

Tenant Ledger

This is the main sheet of all three sheets in this template. This sheet consists of 3 sections: property details, tenant details, and receiver’s details.

Property detail section consists of the following heads:

Receipt No: This cell consists of a predefined custom format. As you insert 1 it displays along with predefined prefix.

Date of Receipt: Insert the date on which you receive the payment.

Property No: Property id.

Property Address Line 1 & 2: Property Address.

Type: Property Type (Godown, factory, Row House, Shop, Bungalow).

Tenant Ledger

Tenant & Rent details section consists of the following:

Monthly Rent: Insert the rent per month for the respective property.

Tenant’ Name: Name of the Tenant.

Rent From and To: Enter the dates of the months for which the tenant pays.

No. of Months: This cell is auto-populated and counts the number of months automatically.

Total Rent: This cell is also auto-populated and displays the total rent for the applicable months.

Rent Received: Enter the amount received from the tenant. Sometimes they pay less or more hence enter the amount manually.

Balance Amount: This cell displays the balance amount. If it is less or more it will subtract and display the amount in this cell. If it is 0 then it will display NIL.

Mode of Payment: Insert mode of payment. ( Cash, Cheque, Demand Draft, NEFT, IMPS, UPI, etc.

Cheque/DD/UTR/Transaction No: Insert the cheque number, dd number or transaction id in this column.

Dated: This field is required mostly for Cheques and Demand Drafts. But you can enter the transaction details also for NEFT.

Tenant Ledger

Receiver Details section consists of the following:

Receiver’s Authority: Title of the receiver. It can be any of these; solicitor, landlord, manager, trustee, etc.

Receiver’s Name: Enter name if and only if it is different from the landlord.

Payee’s Name: This field is applicable only when the payee is other than the tenant himself. Insert their name.

Tenant Ledger

Rent Receipt

The rent receipt sheet requires only one entry. Insert the receipt number and it will automatically fetch the details from the tenant ledger.

Rent Receipt

That’s it and your receipt is ready to print.

Rent Receipt

Printable Rent Receipt Format

This section is for those who want to issue handwritten receipts. Just change the company name and logo and print the file.

Printable Rent Receipt

Insert data manually and give the receipt to your tenant.

Click here to download the Printable Rent Receipt Format.

We thank our readers for liking, sharing and following us on different social media platforms.

If you have any queries please share in the comment section below. We will be more than happy to assist you.

« Download Wedding Guest List Excel Template
Download Rental Property Management Excel Template »

Filed Under: Personal Finance Templates

You are Here: Home / Excel Templates / Personal Finance Templates / Download Rent Receipt Excel Template

About Shabbir Bhimani

I have worked in Excel and like to share functional excel templates at ExcelDataPro.

Personal Finance Templates

  • Portfolio Analysis With BSE Bhav Copy Data Excel Template
  • Loan Amortization Excel Template
  • Personal Budget Excel Template
  • Income Tax Calculator FY 2018-19 Excel Template
  • Personal Income-Expense Tracker Excel Template
  • Savings Goal Tracker Excel Template
  • Credit Card Payoff Calculator Excel Template
  • Monthly Household Budget Excel Template
  • Debt Reduction Calculator Excel Template
  • Investment Tracker With ROI Excel Template
  • Wedding Guest List Excel Template
  • Rent Receipt Excel Template
  • Rental Property Management Excel Template
  • Loan Comparison Calculator Excel Template
  • Rental Property Maintenance Register Excel Template
  • Home Remodel Budget Excel Template

ExcelDataPro

Free Excel Pro Templates

  • Glossary
    • Accounting Glossary
    • HR & Payroll Glossary
    • Tax Glossary
  • Templates
    • Accounting
      • Financial Analysis
      • Financial Statement
    • Educational
    • Taxation
      • Federal Income Tax
      • GST
      • UAE VAT
      • UK VAT
    • Human Resources
      • HR & Payroll
      • HR Metrics
    • School Management
    • Social Media
    • Sales-Marketing
    • Personal Finance
    • Other
      • Health & Fitness
  • Functions
  • FAQ’s
  • Blog
  • Home
  • Contact
  • Privacy
  • Terms

© ExcelDataPro 2023. Content Licensed Under Creative Commons with Attribution Required

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT