Once a year, after the financial year ends in March, take your loan statement and run ten checks: balances, EMI count, interest total, extra payments, fees, rate or tenure notices, mandate details, personal details, the projected closure date and your notes. It takes about thirty minutes and catches most problems while they are small.
What do you need before you start?
- The statement for 1 April to 31 March, and the previous year's closing balance
- The sanction letter and the repayment schedule
- Your bank statement for the same year
- Your loan page with notes from earlier years
The ten checks
| No. | Check | What to compare | Done |
|---|---|---|---|
| 1 | Opening balance | Equals last year's closing balance | [ ] |
| 2 | Closing balance | Equals opening minus principal paid | [ ] |
| 3 | EMI count | Twelve EMIs received, or the number you expect | [ ] |
| 4 | Interest total | Matches your own tally or the interest certificate | [ ] |
| 5 | Extra payments | Each part-payment appears on the right date | [ ] |
| 6 | Fees and charges | Each fee matches the sanction letter or a notice | [ ] |
| 7 | Rate or tenure notes | Any change was communicated and reflected | [ ] |
| 8 | Mandate details | Bank account and amount in the auto-debit are current | [ ] |
| 9 | Personal details | Address, phone and email are correct | [ ] |
| 10 | Closure date and notes | Projected closure date and your own notes are updated | [ ] |
A worked check of the first four
Say the opening balance is ₹6,00,000 and twelve EMIs of ₹11,000 were paid, which is ₹1,32,000. If the statement shows interest of ₹61,500, the principal paid is ₹1,32,000 minus ₹61,500, which is ₹70,500. The closing balance should then be ₹6,00,000 minus ₹70,500, which is ₹5,29,500. If your statement shows a different number, mark the line and find the reason before you move on.
How do you do check four without the lender's certificate?
List every EMI date and the interest part from your records, then add them. In a sheet with the interest figures in C2 to C13, the formula is =SUM(C2:C13). If you keep a longer list with the financial year in column A and the interest in column C, =SUMIFS($C$2:$C$200,$A$2:$A$200,"2025-26") gives the total for that year. Compare the result with the lender's certificate. A difference of a few rupees can come from rounding, but a difference of hundreds of rupees needs an explanation.
Which checks catch the most problems?
- The EMI count. A missing EMI can mean a failed auto-debit you never noticed.
- Fees. A charge you did not expect is easier to question soon after it appears.
- Mandate details. A closed bank account or a changed limit can quietly break the auto-debit.
What if something does not match?
Mark it, write down the date, amount and what you expected, and ask the lender in writing. Give the details and attach the statement page. Keep their reply with the statement. For a question about interest or tax, ask your CA, since rules change and this checklist does not interpret them.
Where does a tracker help?
In SpendixAI you can use the Report builder to filter your uploaded bank statements by the lender's name, group them by month and see the twelve EMIs together for check three. The interest and principal split still comes from the loan statement, so check four stays in your own sheet.
After the review
- Save the statement with the year in its name.
- Update the loan page with the closing balance and interest total.
- Note any questions you sent and the date.
- Set the date for next year's review.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

