For one rented-out flat, keep a single folder with two halves: the rent you received, month by month, and the repair bills for that flat, labelled with the tenant period they fall in. When a question comes up about what the flat earned and what it cost, both answers are in the same place.
How should the folder be laid out?
- Flat 4B (top folder, named by flat and building).
- Agreement and tenant papers: rent agreement, ID copies the tenant gave you, any police verification slip, the deposit receipt.
- Rent received: one subfolder per tenant period, such as 2026-27 Mr Rao, with a sheet of monthly receipts.
- Repairs: one subfolder per tenant period, with a bill and a before-and-after photo for each job.
- Society and utility: maintenance receipts, water and property bills, and who paid them.
Label every file with the flat, the date and the tenant period. For example: 4B 2026-06-18 plumbing bill 1800 Rao period.
What should the rent record contain?
One row per month: the due date, the date received, the amount, the mode, and the reference number if it came by UPI or transfer. Say the monthly rent is ₹18,000. Twelve months give 12 × ₹18,000 = ₹2,16,000. If one month arrives late or part-paid, write the actual date and amount, so the sheet shows what happened and not what was supposed to happen.
What should the repair bills show?
| Detail | Why it matters |
|---|---|
| Date and vendor name | Shows when the work was done and by whom |
| Work description | Plumbing leak in bathroom, repainting after tenant, AC service |
| Amount and mode of payment | Links the bill to a statement line or a cash note |
| Who paid | Owner, or tenant adjusted against rent |
| Photos before and after | Shows the condition and what was done |
A made-up year for a flat: a plumbing repair of ₹1,800, repainting between tenants for ₹14,500 and an AC service for ₹1,200. The repair total is ₹1,800 + ₹14,500 + ₹1,200 = ₹17,500, against rent received of ₹2,16,000.
What if the tenant paid for a repair and adjusted it against rent?
This is common and needs care. Keep the tenant's bill and the message or note in which you agreed the adjustment. In the rent sheet, write the full rent due, the amount adjusted and the amount actually received. Say ₹1,800 of the ₹18,000 is adjusted: the sheet should show ₹18,000 due, ₹1,800 adjusted for the plumbing bill and ₹16,200 received. Hiding the adjustment would leave you unable to explain the shortfall, even to yourself.
How do you connect rent credits to the bank?
Mark each rent credit on your statement with the month it covers. If you receive rent into an account that also holds other money, the note in your sheet is what tells you which credit was rent. Repair payments should likewise point back to a bill.
In SpendixAI you can record each repair bill as an expense under a category you create for the flat, for example Rental flat repairs, and keep the bill photo with the transaction; statement rows from the payment account can be given the same category.
Keep quotes as well as final bills for larger jobs. A painter's written quote, the final bill and the payment proof form a short trail showing the job was agreed, done and paid. For small jobs paid in cash, ask for a handwritten slip with the date, the work and the amount, and photograph it before the ink fades.
When the tenant changes
- Photograph the flat on the day the tenant leaves and on the day the next one moves in.
- Close the repairs and rent folders for the departing tenant period.
- Open new folders for the incoming tenant, with the new agreement and deposit receipt.
- File any repair bills for the gap between tenants under a separate label.
- Check that every rent month has a credit and every bill has a payment.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

