Download free excel template for summary of rent from start of the rental property. This template also serves the purpose of having a General Ledger for Rental to the owners. You can implement this template for your rental business. It is printable excel template hence, you can download and take a printout to make a manual register for rental income.
About Summary of Rent Ledger Excel Format
Once you download this excel template for summary of rent, you can find that this template captures basic information pertaining to rental payments from various tenants. You can capture information like –
- Address of the rental property
- Weekly rental amount, can be customized to monthly as well.
- Tenant Name
- Property Owner
- Week count
- Date of Rental Due
- Period of rent (From and To dates)
- Amount of rent due
- Amount actually paid by the tenant and,
- Date of payment of rental
In addition to above information, if you think there is need of additional information, you can capture the same by inserting rows or columns as per your requirement. Usually, advances are also given by the tenant, the same can be shown as adjustments as well.
Download and use Summary of Rent excel format
To use this free Summary of Rent template in excel, you should have Microsoft Office/ Microsoft Excel. You can only use this template if you have these applications in your system. or Use, Google Sheets.
Once extracted, you can open the file using Excel and start entering data or customizing the template.