For a loan against property, track one page of facts: the loan amount, tenure, EMI and balance, which property papers the lender holds, and where the money was used. A tracker like this is useful during the loan and at the end, when you want every paper back. The example below uses invented figures.
What fields should the tracker have?
| Field | Example (invented) | Where to find it |
|---|---|---|
| Lender and loan account number | Lender name, account ending 7712 | Sanction letter or statement |
| Property pledged | Shop, ground floor, described as in the papers | Loan agreement |
| Loan amount | ₹25,00,000 | Sanction letter |
| Tenure | 120 months | Sanction letter |
| EMI and date | ₹30,000 on the 5th | Repayment schedule |
| Last EMI date | A date ten years after the first instalment | Repayment schedule |
| Balance outstanding, latest | ₹22,40,000 as on 31 March | Lender statement |
Fill in a row for each item and update the balance row every quarter or after a prepayment. Use only the figures in your own papers.
How do you record which property papers the lender holds?
Lenders commonly ask for property documents as part of the process, and what they keep differs, so write down exactly what you handed over and what you were told. List each paper, the date you gave it, to whom, and whether it was an original or a copy. Ask for the list in writing, and keep your copy of the receipt.
- Name of each document, such as sale deed or title paper, as written on the receipt.
- Original or photocopy.
- Date handed over and the name of the person who received it.
- Reference number on the acknowledgement.
- Date returned, left blank until the loan closes.
Why record where the money was used?
A loan against property often goes into several purposes, and memory fades quickly. Keep a short table of the amount, the date and what it paid for. Say the ₹25,00,000 was used as follows.
| Use of money | Amount | Date paid out |
|---|---|---|
| Stock for the shop | ₹12,00,000 | April |
| Repaying an older personal loan | ₹8,00,000 | April |
| Home renovation | ₹5,00,000 | May to July |
| Total | ₹25,00,000 | Matches the loan amount |
Check: 12,00,000 plus 8,00,000 plus 5,00,000 equals 25,00,000. If the totals do not match, find the gap now. Whether the use of the money matters for anything else, such as taxes or lender conditions, is a question for your CA or the lender, not for this record.
What do you update during the loan?
- The balance and the EMI date after every statement.
- Any change in interest rate or EMI, with the date of the lender's letter.
- Any part-payment or prepayment, with the amount and the new balance.
- Conversations with the lender, in a short call log.
SpendixAI can help here by importing the account the EMI leaves from, so every debit sits against that account, and by keeping receipts with their transactions, such as the acknowledgement for a prepayment.
What happens at the end?
When the final EMI is paid, ask the lender for a closure or no-dues letter and for the return of every paper on your list. Compare what comes back with what you handed over. Anything missing should be raised in writing, quoting your list and the reference number from the original receipt.
Take photographs of every acknowledgement and receipt when you receive it, and save them in the loan folder. Paper fades and gets lost, while a dated image of the receipt, along with the list of papers, is easy to find years later when you ask for them back.
A starting checklist
- Create the tracker page from the sanction letter and agreement.
- List every property paper the lender holds, with dates.
- Record where the loan money went and check the total.
- Update the balance each quarter.
- Keep everything in one folder, with a note of where it is.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


