Receiver’s Authority: Title of the receiver. Receiver Details section consists of the following: But you can enter the transaction details also for NEFT. ( Cash, Cheque, Demand Draft, NEFT, IMPS, UPI, etc.Ĭheque/DD/UTR/Transaction No: Insert the cheque number, dd number or transaction id in this column.ĭated: This field is required mostly for Cheques and Demand Drafts. If it is less or more it will subtract and display the amount in this cell. Sometimes they pay less or more hence enter the amount manually.īalance Amount: This cell displays the balance amount. Rent Received: Enter the amount received from the tenant. Total Rent: This cell is also auto-populated and displays the total rent for the applicable months. of Months: This cell is auto-populated and counts the number of months automatically. Rent From and To: Enter the dates of the months for which the tenant pays. Monthly Rent: Insert the rent per month for the respective property. Tenant & Rent details section consists of the following: Type: Property Type (Godown, factory, Row House, Shop, Bungalow). Property Address Line 1 & 2: Property Address. As you insert 1 it displays along with predefined prefix.ĭate of Receipt: Insert the date on which you receive the payment.

Receipt No: This cell consists of a predefined custom format. Property detail section consists of the following heads: This sheet consists of 3 sections: property details, tenant details, and receiver’s details. This is the main sheet of all three sheets in this template. Tenant LedgerĪt the top, insert the name of the landlord and his PAN No. This template consists of 3 sheets: Tenant Ledger, Rent Receipt and Printable Rent Receipt. Let us discuss the contents of this template and how to use it. 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. Click here to Download All Personal Finance Excel Templates for ₹299. Type in the receipt number and it is ready to print.Ĭlick here to download Rent Receipt Excel Template. Insert the details of rent received along with payment details. Print and issue your receipt in less than a minute. We have created a simple and easy Rent Receipt Excel Template with predefined formulas and formats. Contents of Rent Receipt Excel Template.

Rent receipt template ontario