Rent Collection Register in Excel (Free) – Month-wise Tenant Rent Tracker with Dues

Rent collection register in Excel – month-wise grid with paid, part paid and due

Advertisement

Quick answer: A rent collection register lists every tenant in a row and every month in a column. Each cell shows the rent received for that month. The rent due to date minus the rent received gives each tenant’s balance.

Download a free rent collection register in Excel below. You enter only the payments. The month-wise grid colours itself: green for paid, yellow for part paid and red for due.

Key takeaways

  • Tenants sheet for up to 40 shops, flats or rooms, with rent, start date, security and due day.
  • Payments sheet: one line per payment, including part payments, with the month it is for.
  • Register grid for 12 months in colour.
  • Due, paid and balance per tenant, with a status such as “3 month(s)”.
  • Rent starts counting from the tenant’s start month.

↓ Jump to the free download

FOR LANDLORDSRent, receipts, increases and dues — handled.XploreRent applies rent increases, prints receipts with PAN, chases dues on WhatsApp and gives your ITR working.See XploreRent — from ₹499 →⚡ Instant download · ♾️ Lifetime access · 💳 Pay onceXploreRent

Rent collection register in Excel – month-wise grid with paid, part paid and due
Eight units. Flat 201 has not paid for three months, and Flat 102 paid only part of September.

Rent received entry sheet

Rent received entry sheet in Excel with unit, month and mode
Type the unit and the month the rent is for. A late September rent paid on 18 October still goes in the September column.

How to use the template

  1. Tenants: type the property name, the year start, the month dues are counted up to, and each unit with its tenant, rent and start date.
  2. Payments: each time rent comes in, add a line with the date, unit, month it is for, amount and mode.
  3. Register: see who has paid and who owes. Each month, move “Dues up to” forward on the Tenants sheet.

Tips for landlords

  • Record the month the rent is for, not just the date it came. That stops arrears hiding in a later month.
  • Give a receipt for every payment. Tenants claiming HRA will ask for it anyway.
  • Follow up when a tenant owes one month, not three.
Outgrown the free sheet? Here’s what XploreRent adds

Free sheetXploreRent
Dues with WhatsApp reminders—✓
House-property income for ITR—✓
Late fee & interest—✓
Security deposit tracking—✓
Tenant statement—✓
Fill-in forms & one-click PDF (macro edition)—✓

⚡ Instant download · ♾️ Lifetime access · 💳 Pay onceGet XploreRent — from ₹499 →

Download the free Rent Collection Register

There are three sheets: Tenants, Payments and Register. Fill in the yellow cells; everything else is worked out.

Get updates and new free templates

Your download below doesn’t need this. Leave your WhatsApp number or email and I’ll send you fixes for this file and new free templates. No spam, unsubscribe anytime.

Was this template useful?

FAQs

What if the rent changes in the middle of the year?

This free register uses one rent per tenant. Add a new row for the new rent from the change month, or use XploreRent, which handles increases.

Advertisement

A tenant paid two months together. How do I enter it?

Enter two lines, one for each month, with the same date.

Can I use it for a PG or hostel?

Yes. Make one row per room or bed.

More free templates

Advertisement

Amanpreet Kaur Bharaj
I'm Amanpreet Kaur Bharaj from Hoshiarpur, Punjab. I've worked in Excel for about 12 years, and since 2022 I've run my own ethnic-wear boutique, Punjabi Libas, on Excel files I built myself. XplorExcel is where I share those files: free templates for everyday business work, and ready-made Excel software for shops, boutiques, clinics, dairies, mandis and offices. Every file comes with a filled-in sample so you can see how it works. Stuck with one? Message me and I'll help.