A rent deposit tracker is a short table where every move-in payment gets a line: date, what it was for, amount, how you paid, who received it and whether it is refundable. A column for refundable amounts shows how much of your outlay is money you should get back at move-out, and how much is gone for good.
What goes in the move-in table?
Use one row per payment, with these columns: A Date, B Item, C Amount, D Payment mode (UPI, NEFT, IMPS, cheque, cash), E Paid to, F Refundable (Yes, No, Partly), G Refundable amount, H Proof (link to a screenshot, receipt or agreement page).
Typical lines for a new tenant are the security deposit, brokerage, agreement charges, any maintenance or society advance, and the purchases to make the flat liveable, such as curtains, a mattress or a water filter. Treat the list as a prompt, not a rule: what you owe depends on your city, landlord and agreement, so use only the lines that apply to you.
How do I total what is refundable?
Fill column G with the amount you expect to get back. In a summary block, use:
- Total paid: =SUM(C2:C30)
- Refundable: =SUM(G2:G30)
- Not recoverable: =SUM(C2:C30)-SUM(G2:G30)
- Deposit alone: =SUMIFS(C2:C30,B2:B30,"Security deposit")
Made-up example: rent is ₹25,000 and the deposit is ₹75,000. Brokerage is ₹12,500, agreement charges ₹1,500, a maintenance advance ₹5,000 that the agreement says is adjustable, and set-up purchases ₹18,000. Total paid is 75,000 + 12,500 + 1,500 + 5,000 + 18,000 = ₹1,12,000. If only the deposit and the advance come back, refundable is 75,000 + 5,000 = ₹80,000, and the not-recoverable amount is ₹32,000.
| Item | Amount | Refundable | Refundable amount |
|---|---|---|---|
| Security deposit | ₹75,000 | Yes | ₹75,000 |
| Brokerage | ₹12,500 | No | ₹0 |
| Agreement charges | ₹1,500 | No | ₹0 |
| Maintenance advance | ₹5,000 | Partly | ₹5,000 |
| Set-up purchases | ₹18,000 | No | ₹0 |
How do I follow the deposit through to move-out?
Add a second small table called Move-out. Its columns: A Notice given on, B Move-out date, C Deposit as per agreement, D Deductions claimed (with reason), E Amount received, F Date received, G Pending. In G2 write =C2-D2-E2, which shows what is still outstanding, and keep the reasons for deductions in a Notes column. Update it as the conversation with the landlord develops.
The sheet works best if you collected evidence at both ends. On day one, photograph each room, note meter readings and list existing damage. On the last day, repeat it. Those photos carry more weight than anyone's memory.
What should I note about the rent itself?
Keep a separate list for monthly rent, with a Due date, Amount, Paid on and Mode column. Rent changes at renewal, so add a line for the revision date and the new amount. Many tenants also record when the electricity, water and society bills were paid, since landlords sometimes ask for a final no-dues confirmation. A simple column called No dues taken (Yes or No) on the move-out table serves that purpose.
Can I connect it to my expense records?
The deposit and rent payments should match your bank statement. If you import statements into SpendixAI, you can file rent under Rent and the one-time costs under a category like Moving, then compare totals with the sheet. The tracker remains the place for the refundable column, which a normal expense list does not hold.
Before you sign
- Read the agreement for the deposit amount, notice period, rent increase terms and what can be deducted.
- Confirm how and when the deposit will be refunded after you vacate.
- Take dated photos of the home on arrival.
- Record each payment in the sheet the same day.
- Save scans of the signed agreement and receipts in one folder, and put the link in column H.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


