You can keep track of your rental income by using this excel template. This template comes with Card Design for Income and expenses. There is another card for Net Income as well. This template is useful for property owners and real estate developers.
You can capture the following information with the help of this template;
- Property description and location
- Tenant Name
- Transaction date and transaction description
- Total Amount
This is a very basic rental ledger template.
Now in this template, all the incoming payments (income) will be in black color and outgoing payment (expenses) will be in red colored text. This is because of the conditional formatting in Excel. Furthermore, the total happens automatically in the Card Designs. Furthermore, the default currency in this template is United States Dollars (USD). You can modify that as per your requirement.
Explore other rental ledger templates as well.