Rent Collection Tracker
Track rent collection, due dates and payment history for multiple properties.
For a landlord, knowing exactly who has paid and who hasn't is essential. This free Rent Collection Tracker records rent due, received, late and outstanding for each tenant and month, so you always have a clear picture of your rental income and can chase late payments promptly.
How to use it: list your tenants and their rent amounts, and mark each month's payment as received or outstanding. The tracker shows who's behind and your total collected, making rent management and follow-up straightforward.
Key features
- Track rent due, paid and outstanding
- By tenant and month
- Spot late payments fast
- Clear income picture
- Works in Excel and Google Sheets
This template is designed for professionals and teams working in Real Estate & Property who want to manage Rental Management tasks efficiently in Microsoft Excel — without the need for expensive specialist software.
The Rent Collection Tracker is part of our Real Estate & Property collection — downloaded 11 times and counting. Built from real-world experience by the ExcelGurukul team and tested across multiple industries and roles.
Frequently asked questions
Is it free?
Yes, free download with no sign-up.
Can it track multiple tenants?
Yes, each tenant across each month.
Does it show arrears?
Yes, outstanding rent is clear at a glance.
Which currency does it use?
Any — enter amounts in your own currency.