When a rental agreement renews, write down four things the same day: the renewal date, the old rent, the increment your agreement specifies, and the new monthly amount with the month it starts. Then compare each credit with the new figure. A credit that matches the old rent after the start date is the sign of a tenant still paying the old amount.
What should the record contain?
One row per agreement is enough. Keep the columns plain so you can read them a year later without help.
- Tenant name and flat or shop.
- Agreement start date and end date.
- Old monthly rent and the increment as written in the agreement, whether a percentage or a fixed rupee amount.
- New monthly rent and the first month it applies from.
- Due date each month and the usual mode of payment, such as UPI or NEFT.
How do I work out the new amount?
Use whatever your agreement says. Say the old rent is ₹15,000 and the agreement has a 5 per cent increase at renewal. The new rent is 15,000 × 1.05 = ₹15,750, which is ₹750 more. In a sheet with the old rent in C2 and the increment written as 5% in D2, the new rent is =ROUND(C2*(1+D2),0). If the agreement instead states a fixed jump of ₹1,000, simply add it: =C2+1000. Only the agreement matters here; this article makes no claim about what increase is allowed.
How do I spot a tenant still paying the old rent?
Set up three columns beside your credits: month, amount expected and amount received. Expected comes from your record; received comes from the bank statement. In Excel or Google Sheets, with the expected amount in E2 and the received amount in F2, the shortfall is =MAX(0,E2-F2). Copy it down. Any month showing 750 in our example tells you the tenant paid ₹15,000 instead of ₹15,750.
| Month | Expected (₹) | Received (₹) | Shortfall (₹) |
|---|---|---|---|
| April | 15,750 | 15,000 | 750 |
| May | 15,750 | 15,000 | 750 |
| June | 15,750 | 15,750 | 0 |
| Total so far | 47,250 | 45,750 | 1,500 |
In this invented run, two months were short by ₹750 each, so ₹1,500 is outstanding even though June looks fine. Totalling the column matters more than checking only the latest month, because the arrears hide behind a correct payment.
If your agreement has a yearly step instead of a one-time increase at renewal, record every step date now. Say rent is ₹15,000 from April 2026 with a 5 per cent yearly step: it becomes ₹15,750 from April 2027 and 15,750 × 1.05 = ₹16,537.50, which you might round to ₹16,538, from April 2028. Writing all three dates and amounts into your tracker at signing means nobody has to remember a clause in year three.
What if the tenant disputes the increase?
Go back to the signed agreement and read the clause as written. Disputes over notice, rent control rules or registration are legal questions and the rules differ by place, so ask a lawyer or the official source before you act. Your tracker's job is to show a clean history of dates and amounts, which helps whichever way the conversation goes.
Can a tracker watch for this?
If the rent lands in an account you import into SpendixAI, a credit from the same tenant each month is easy to find, and a custom category for that flat keeps the credits together. A monthly note of the expected amount is still your job, since the app does not know your agreement. Notifications and the weekly summary can prompt you to look.
A renewal checklist
- Diary the agreement end date sixty days before it arrives, so there is room to talk.
- Record the new rent and its start month in your tracker on the day you sign.
- Tell the tenant the new amount and the first due date in writing.
- After the first new-rent month, compare credits with expected and note any shortfall.
- Add the next renewal date to your calendar immediately.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

