Just like any other rental ledger for personal and business uses available here, this one also serves similar purpose. You can capture the rental income from one specific property using this excel template. However, in single workbook you can create multiple sheet for multiple properties. This template is useful for flat owners, residential apartment owners, real estate agents and even useful to personal level for keeping track on rental payments.
With this rental ledger template you can capture the following kind of information with the pre-defined columns, rows and fields;
- Address of your property
- Year to keep track (example, 2024, 2023)
- Tenant name
- Move-in date
- Security Deposit
- Monthly rent
- Payment Due date
- Email of tenant
- Payment date
- Amount due
- Amount paid
- Late Fees
- Balance payment
- Notes (terms and conditions)
Now, as per the rent agreement with the tenant, you will get many information required in the fields. For any lease or rent, there should be an agreement between the tenant and owner. This will give legal validity to the transaction. You can find the total income from renting out with the help of this template. If you want to capture the expenditure done on the specific apartment (from your pocket) you can also find rental ledger template with expenses here. You will need to deduct the expenses to find out the “Net Rental Income“.