Free rent collection tracking sheet (Excel)
A ready sheet for property management offices and landlords: one row per rent payment with unit, tenant, due date, amount, payment method and status (due, collected, late, bounced). It opens in Arabic in Excel and Google Sheets and can be sorted by due date to see what's due this month.
Last updated:
Download the sheet (Excel / CSV)
Columns in the sheet
- Unit, landlord, tenant and phone
- Lease start, end and annual rent
- Payment number, due date and amount
- Payment method (cheque, transfer, cash) and cheque number
- Status: due, collected, late, bounced
When is a sheet not enough?
A sheet works for a few units. With dozens of leases it won't remind you before each payment or lease end, or send landlords their report. In RabetCRM rent is split into payments automatically, you get reminders before each payment and 90, 60 and 30 days before the lease ends, and each landlord has a link to see their units and collections.
Read more
More templates
FAQ
Is the sheet free?
Yes, no sign-up or email needed.
Does Arabic display correctly in Excel?
Yes, the file is UTF-8 with a BOM.
Does it suit post-dated cheques?
Yes, one row per cheque with its number, date and status.