To find the interest you paid on a loan in a year, add up the interest part of each of the twelve monthly instalments shown on your loan statement. You can cross-check it: total EMIs paid minus the fall in the outstanding principal should equal the same number. The example below uses an invented statement, so you can follow the arithmetic.
What do you need from the lender?
Ask for, or download, a statement of account or repayment schedule for the period. It should show each instalment split into interest and principal, plus the balance after each payment. Names and layouts vary by lender, so look at your own document for the column headings. If you only have the EMI amount and the loan balance, the cross-check in the last step still works.
What does an invented statement look like?
Say you have a loan of ₹3,00,000, repaid with ₹10,000 a month, where the interest each month is 1 per cent of the balance at the start of that month. This is a simplified loan for practice. A real statement can differ by a few rupees because of rounding and the number of days in a month.
| Month | Interest | Principal | Balance after EMI |
|---|---|---|---|
| 1 | ₹3,000.00 | ₹7,000.00 | ₹2,93,000.00 |
| 2 | ₹2,930.00 | ₹7,070.00 | ₹2,85,930.00 |
| 3 | ₹2,859.30 | ₹7,140.70 | ₹2,78,789.30 |
| 4 | ₹2,787.89 | ₹7,212.11 | ₹2,71,577.19 |
| 5 | ₹2,715.77 | ₹7,284.23 | ₹2,64,292.96 |
| 6 | ₹2,642.93 | ₹7,357.07 | ₹2,56,935.89 |
| 7 | ₹2,569.36 | ₹7,430.64 | ₹2,49,505.25 |
| 8 | ₹2,495.05 | ₹7,504.95 | ₹2,42,000.30 |
| 9 | ₹2,420.00 | ₹7,580.00 | ₹2,34,420.30 |
| 10 | ₹2,344.20 | ₹7,655.80 | ₹2,26,764.50 |
| 11 | ₹2,267.65 | ₹7,732.35 | ₹2,19,032.15 |
| 12 | ₹2,190.32 | ₹7,809.68 | ₹2,11,222.47 |
How do you add it up in a sheet?
Type the interest figures into a column and total them. If the interest sits in cells B2 to B13, the formula is the same in Excel and Google Sheets:
- =SUM(B2:B13) gives the year's interest, here ₹31,222.47.
- =SUM(C2:C13) gives the principal repaid, here ₹88,777.53.
- =SUM(B2:C13) gives the total of twelve EMIs, here ₹1,20,000.00.
How do you cross-check the answer?
Use a second route, so one mistake does not slip through. Start with the total of EMIs paid, ₹1,20,000, which is 12 times ₹10,000. Then work out how much the balance fell: ₹3,00,000 at the start minus ₹2,11,222.47 at the end is ₹88,777.53. Interest is the difference: ₹1,20,000 minus ₹88,777.53 equals ₹31,222.47, the same as the column total.
If the two numbers disagree, check for a month you missed, a part-prepayment that reduced the balance without being an EMI, or a fee line that is not interest. Treat those as separate amounts.
What about a loan with a changing rate or part-prepayments?
The method does not change. Interest is still whatever the statement says it is for each month, and the cross-check still works, as long as you add any prepayment to the amount paid. If the interest rate has changed during the year, your statement will show that in the interest column, and you simply add the actual figures.
If you import the bank account that pays the EMI into SpendixAI and put the EMIs in their own category, the report tools can total the year's EMI payments, which gives you the first number for the cross-check. The interest and principal split still comes from the lender's statement.
Keep the working, not just the answer. A sheet with the twelve rows, the two totals and the cross-check line takes a few minutes to save and saves you from redoing the sums when someone asks next year.
A short checklist
- Get the statement for the exact period you need.
- Add the interest column, then add the EMIs paid.
- Subtract the fall in outstanding balance from the EMIs and compare.
- Note any prepayment or fee separately.
- Save the statement and your sheet together, in a folder named with the loan and the year.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


