What a rent register is
A rent register, or rent ledger, is one running record of what each tenant was asked to pay and what they paid. Kept well, it answers the question every landlord asks at the start of the month: who still owes what?
It can be a notebook, a spreadsheet or software. What matters is that every bill and every payment goes in, on the day it happens.
The columns to keep
- Date: the day of the entry.
- Tenant and property: who, and which flat, shop or room.
- Entry: a rent bill, a payment, or a correction.
- For month: the month the rent is for. A payment made in September can be for August.
- Billed: the amount asked for, on a bill line.
- Paid: the amount received, on a payment line.
- Payment mode and reference: cash, UPI, bank transfer or cheque, with the UPI reference, transaction ID or cheque number.
- Receipt number: the receipt you gave for that payment.
- Balance: what the tenant owes after this line.
Keep one register for each tenant, or one for everyone with a tenant column you can filter. Water and electricity can go in as their own entries, or in a register of their own.
A worked example
A tenant pays ₹12,000 a month. In August they pay ₹8,000, and they clear the rest in September. Bills go in Billed, payments go in Paid, and the entry names the month each one is for:
| Entry | Date | Billed | Paid | Balance |
|---|---|---|---|---|
| August bill | 1 Aug | ₹12,000 | ₹12,000 | |
| August, UPI | 6 Aug | ₹8,000 | ₹4,000 | |
| September bill | 1 Sep | ₹12,000 | ₹16,000 | |
| August, cash | 4 Sep | ₹4,000 | ₹12,000 | |
| September, UPI | 5 Sep | ₹12,000 | ₹0 |
Each balance is the one above it, plus what was billed, minus what was paid. If the last balance does not match what you believe the tenant owes, a line is missing.
Rules that keep it right
- Write a line for every bill and every payment, even small ones.
- Never rub out or overwrite a line. Add a correction line that says what it fixes, so the history stays readable.
- Note the month each payment is for. When one payment covers two months, write two lines.
- Check the payments against your bank statement once a month.
- Record security deposits on their own, outside the rent balance, so a deposit is never counted as rent by mistake.
- Give a receipt for each payment and note its number on the payment line.
At move-out, the register shows exactly what is still owed. Refunding a security deposit at move-out covers the final settlement.
Download a free template
The rent register template is a blank sheet with the columns above. It opens in Excel, Google Sheets or LibreOffice. In a spreadsheet, each balance can be a formula: the balance above, plus Billed, minus Paid.
For the receipts, the free rent receipt generator makes one for any month, and What a rent receipt should include lists the details.
When a register stops being enough
A register works well for a few tenants. It gets harder as they grow in number: bills are written out by hand each month, part payments spread across rows, and nothing tells you when rent is late.
SetURent keeps the same record for you. Generate This Month creates every tenant's rent bill, Record Payment adds a payment against a bill with its mode and reference, and Rent Dues lists who still owes what. Reports can export the payments in any date range as a CSV for your accountant. Switch from spreadsheets shows where each column of your sheet goes.