Debt

Yearly loan statement review: a 10-point checklist

A ten-point yearly loan statement review checklist covering balances, EMI count, interest total, extra payments, fees, notices and mandate details.

Editorial illustration for Yearly loan statement review: a 10-point checklist

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.CheckWhat to compareDone
1Opening balanceEquals last year's closing balance[ ]
2Closing balanceEquals opening minus principal paid[ ]
3EMI countTwelve EMIs received, or the number you expect[ ]
4Interest totalMatches your own tally or the interest certificate[ ]
5Extra paymentsEach part-payment appears on the right date[ ]
6Fees and chargesEach fee matches the sanction letter or a notice[ ]
7Rate or tenure notesAny change was communicated and reflected[ ]
8Mandate detailsBank account and amount in the auto-debit are current[ ]
9Personal detailsAddress, phone and email are correct[ ]
10Closure date and notesProjected 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

  1. Save the statement with the year in its name.
  2. Update the loan page with the closing balance and interest total.
  3. Note any questions you sent and the date.
  4. Set the date for next year's review.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports