How to keep track of rent payments across UPI, cash and cheque

Rent in India rarely arrives the same way twice. The tenant in 101 hands you ₹18,000 in cash on the 2nd. The family in 102 sends ₹15,000 over UPI, usually late. The shop downstairs drops a cheque that takes three days to clear. By the 5th, you’re scrolling WhatsApp trying to remember who paid, who’s short, and whether that cheque actually cleared. The security deposit you’re holding lives somewhere in your head.

It works, until it doesn’t — usually in March, when a tenant asks for a receipt or your accountant wants the year’s figures. Here’s a way to keep track of rent payments that holds up across UPI, cash and cheque, without turning it into a second job.

Why rent is genuinely hard to track here

The difficulty isn’t laziness. It’s that real Indian rent has moving parts most tools ignore:

• Mixed methods in the same month — cash, UPI and cheque, each landing on a different day.
• Part payments — ₹10,000 now, the balance “next week”.
• Arrears — a shortfall from February that quietly rolls into March.
• Several tenants and properties — a flat here, a shop there, an inherited house in another city.

A diary captures none of the relationships, and a chat thread is impossible to search. What you need isn’t more effort — it’s one place that holds everything.

The one idea that fixes it: a single rent ledger

A rent ledger is just one running record where every payment is logged once, the same way each time. For each payment, capture five things:

• Date it arrived
• Tenant and property/unit it’s for
• Period — which month’s rent
• Amount
• Method — cash, UPI, bank transfer or cheque (and the reference, if any)

That’s it. The discipline is recording every payment on the day it comes in, against the right tenant and month. Here’s what a month looks like written down:

Run that against what was due, and the month-end picture falls out on its own:

Reddy’s part payment is the one to watch — logged honestly, the ₹3,000 stays visible instead of slipping away. Do this consistently and the month-end scramble disappears: you can always see who has paid, who is short, and who hasn’t paid at all.

A method that works, even on paper

You don’t need software to start. You need a routine:

1. Record on the day. When money arrives, write it down immediately — before the WhatsApp notification buries it. Cash is the easiest to forget, so log it first.
2. Write a receipt. Give the tenant proof and keep a copy. For cash over ₹5,000, add a ₹1 revenue stamp and sign across it. Our free Rent Receipt Generator does this in under a minute, with the amount filled in words.
3. Reconcile once a month. Set what was due against what came in, per tenant. Paid in full, short by ₹3,000, or nothing yet — you want that visible at a glance, not reconstructed from memory.
4. Track the deposit separately. The deposit isn’t rent. Keep a note of how much you’re holding for each tenant, so there’s no argument when they leave.

Diary, WhatsApp, spreadsheet or app?

Be honest about which one you’ll actually keep up with:

• Diary — fine for a single tenant, hopeless for reconciling or finding anything later.
• WhatsApp — where payment proofs go to disappear. Good for nudging tenants, bad as a record.
• Spreadsheet — a real step up. One row per payment, columns for the five fields above, and a monthly total. It works for a handful of units if you’re disciplined about updating it.
• A ledger app — earns its place once you have several tenants or properties. It reconciles due versus paid for you, flags shortfalls, and keeps receipts and deposits together so you’re not stitching the picture from three places.

There’s no single right answer. The best system is the one you’ll keep using on a busy day.

The cases that trip people up

• Part payments. Record what came in and leave the balance showing as due. Don’t round up “to settle it later” — that’s how arrears get lost.
• Arrears. Carry an unpaid amount forward month to month, clearly, so a long-standing shortfall doesn’t quietly vanish.
• Cash over ₹5,000. Revenue stamp and signature on the receipt.
• Cheques. The rent isn’t really in until the cheque clears — note it as “clearing” so you don’t count it twice or assume it bounced.
• UPI. Jot the reference number. When a tenant insists they paid, a reference settles it in seconds.

A five-minute monthly routine

1. On the 1st, note who owes what this month.
2. As each payment lands, log it and issue a receipt.
3. Around the 5th, reconcile due versus paid and message anyone short.
4. At month-end, file the receipts and update each deposit balance.

Five minutes done regularly beats an afternoon of detective work in March.

Where PropKhata fits

This is exactly the job PropKhata does without the manual upkeep. It’s rent and property management software for India: log a payment the moment it lands — cash, UPI or cheque — against the right tenant and month, and it reconciles what was due against what came in, flags who’s short, and keeps receipts, dues and deposits in one ledger per property. It even sends tenants timely rent reminders on WhatsApp — and a confirmation when a payment is received — so you chase less, while a daily WhatsApp digest keeps you on top of every property. Start free, list as many properties and units as you like, and never wonder on the 5th who still owes.

Whichever method you choose, the principle is the same: one record, every payment, recorded once. Get that habit right and rent stops being something you chase — it becomes something you simply know.