In this sheet, you only need to enter previous outstanding and rent received. If the tenant pays in full then there will be no outstanding. It consists of 3 columns: Previous outstanding, Due rent, Total Outstanding, Rent Received, and Balance Outstanding. Rent Ledger consists of monthly details of rent collection. Remarks: If any additional details enter in the remarks column. If they have multiple contact details enter them respectively. Service Category: Category of the service provider.Īddress: Address of the service provider.Ĭontact Person: Name of the person/representative that is responsible for your contract maintenance.Ĭontact Number (1 – 2 – 3): Enter contact number. Whenever you receive a call for maintenance you can refer to this sheet and call the respective service provider. For each task, an AMC or contract is done. In this sheet, you need to record the service provider’s details. The monthly totals for each month are given at the bottom. This sheet consists of the following columns all 12 months: Maintenance Description and amount. ![]() You can record such expenses monthly in this sheet. The serial number and property number are auto-populated. Hence if the tenant can keep a pet select “Yes” or else “No” from the dropdown.Īdditional Information: If you need to enter any additional information related to the tenant, insert in this cell.Įvery rental property requires to maintain the gardens, elevator, and other miscellaneous maintenance jobs. Pets Allowed: Some properties don’t allow pets. ![]() Partial Payment: If partial payment is allowed to the tenant for the said property then select “Yes” from the dropdown list otherwise select “No”. Late Fee/Day: If the tenant doesn’t pay even after that then a late fee is applicable per day. Initial Late Fee: To avoid delay of rent payments, the landlord charge a late fee. The security deposit is for this purpose. Usually, tenants damage while leaving the property or leave behind unpaid utility bills. Security Deposit: Insert the amount of security deposit taken from the tenant. Once you enter the property number or id it will fetch from the respective sheet. Rent Amount: This cell will auto-fill using Vlookup. Rental Contract: Enter the start date and end date. Tenant At Property No: Insert the property number or ID in which the tenant lives.Īddress: Permanent Address of the tenant apart from the rented property. The first section is for searching individual tenant details and the second one is for recording details of all tenant currently living at the respective property. Only enter the property ID or property number in the light blue column and it will fetch the data for you. This performance report provides you all the property details along with ROI, purchase price and rent details of an individual property. Purchase Price: Enter the purchase price of the property. Property Name: Enter the property name or the name with which it is easier for you to identify the property.Īrea (Sq.ft.): Insert the size of the property. It can either be lower or higher than the expected amount.Īrea/Locality: Area/locality in which your property is located. Property Type: Select the property type from the drop-down list.Įxpected Monthly Rent: Depending on the industry standards and location, define an expected monthly rent.Īctual Monthly Rent: Insert the Actual rent per month. Property No: Property number or a unique ID. This sheet consists of the following columns: This data is used to make a drop-down list in other sheets. The property type can be a flat, warehouse, industrial shade, bungalow, Banquet Halls, etc. ![]() This template consists of 9 sheets: Property Type List, Property Details Sheet, Property Performance Report, Tenant Details, Maintenance Accounts, Service provider Details, Rent Ledger, Rent Outstanding Report, and Late Fee Calculator. Contents of Rental Property Management Excel Template Let us understand the contents of the template in detail. In addition to the above, you can download other property management templates like Rent Receipt Template, Asset Inventory Tracker, Apartment Maintenance Accounts and much more. Click here to Download All Personal Finance Excel Templates for ₹299. Additionally, this template will generate multiple reports related to property and tenants.Ĭlick here to download the Rental Property Management Excel Template. List down your properties, keep records of tenants, property maintenance, and rental ledger. We have created a simple and easy Rental Property Management System in Excel with predefined formulas to manage multiple properties accounts all in one place. ![]() Rental Property Management Excel Template Contents of Rental Property Management Excel Template.Rental Property Management Excel Template.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |