A yearly home loan statement lists each EMI and divides it into two parts: interest, which is the cost of borrowing, and principal, which reduces what you still owe. To use it, total the interest column and the principal column separately for the financial year, and check that together they equal the EMIs you paid.
What are the columns in a home loan statement?
Layouts differ from bank to bank, so treat this as a general guide and read the headings on your own statement. Most show some version of these.
- Date of the instalment or of the transaction.
- Opening balance: the principal outstanding before that instalment.
- EMI or instalment amount received.
- Interest component: the part of the instalment that went to interest.
- Principal component: the part that reduced the loan.
- Closing balance: opening balance less the principal component.
- Other entries such as charges, insurance premiums or part-prepayments, which are not part of the EMI split.
How do I read a small statement? A made-up example
Say the loan is ₹50,00,000 and the EMI is ₹40,000. These are invented numbers to show the mechanics, not typical rates or amounts.
| Month | Opening balance | EMI | Interest | Principal | Closing balance |
|---|---|---|---|---|---|
| April | ₹50,00,000 | ₹40,000 | ₹33,000 | ₹7,000 | ₹49,93,000 |
| May | ₹49,93,000 | ₹40,000 | ₹32,950 | ₹7,050 | ₹49,85,950 |
| June | ₹49,85,950 | ₹40,000 | ₹32,900 | ₹7,100 | ₹49,78,850 |
Each row follows the same logic. In April, 40,000 less 33,000 leaves ₹7,000 of principal, and the balance falls from ₹50,00,000 to ₹49,93,000. Notice that interest eases a little each month and principal rises, because the balance is shrinking. That is why early years of a loan are interest-heavy.
How do I total each component for my CA?
Add the interest column over the whole year and do the same for the principal column. For the three months above, interest is 33,000 + 32,950 + 32,900 = ₹98,850 and principal is 7,000 + 7,050 + 7,100 = ₹21,150. Together that is ₹1,20,000, which equals three EMIs of ₹40,000. The same check works over twelve months, so if your two totals do not add up to the EMIs paid, something has been missed.
A second check uses the balance. Opening balance on the first day less closing balance on the last day should equal the principal total. Here, 50,00,000 less 49,78,850 is ₹21,150, which matches.
Be careful with floating-rate loans. When the bank revises the rate, it may change the EMI or keep the EMI and stretch the tenure, and the statement then shows interest and principal moving differently from before. The columns work the same way, but the pattern in your made-up checks will not repeat exactly, so always total from your own statement and not from a formula you built for last year.
Why might my totals not match?
- A part-prepayment was made, which shows as an extra principal entry rather than a regular EMI.
- The interest rate changed during the year, so the EMI or the loan period was revised.
- A processing fee, insurance premium or other charge was debited to the loan account.
- The statement covers a different date range from the financial year.
- An EMI bounced and was paid late, so two instalments appear close together.
Can a spreadsheet or app help?
A sheet with columns for month, interest and principal is enough, and a simple total at the bottom gives you both figures. When you would rather have your EMI debits sitting beside the rest of the year's spending, SpendixAI can import the bank statement so each EMI is recorded under the account it came from. The bank's own loan statement remains the document to rely on for the split.
What should I do each April?
- Request or download the statement for 1 April to 31 March.
- Confirm the period, loan account number and borrower name.
- Total interest and principal separately.
- Run the two checks above.
- File the statement and your totals together in the loan folder.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


