A credit card EMI is counted statement by statement. Look for the instalment line on each card statement, note how many months the conversion was set for, and count the statements where the line already appeared. The balance of months is what is left. The exact layout depends on your card, so check how your own statement labels these lines.
Where does the count live?
- On the card statement, in the transactions list, as a repeating instalment line.
- On the card's online page, in a section for EMI or instalment plans, if your issuer provides one.
- In the conversion confirmation you received when you converted the purchase, which states the tenure.
The sources can disagree on wording but they should agree on tenure. If you cannot find the original confirmation, the statement history is your fallback, and the card issuer can tell you the booked tenure.
A worked example with made-up numbers
Say a ₹30,000 purchase was converted into 6 instalments. Each month the statement shows ₹5,000 of principal plus ₹400 of interest, so the instalment is ₹5,400. The plan therefore costs 6 × 5,400 = ₹32,400 in total.
| Statements so far | EMIs paid | EMIs left | Amount still to come |
|---|---|---|---|
| 2 | 2 | 4 | 4 × 5,400 = ₹21,600 |
| 4 | 4 | 2 | 2 × 5,400 = ₹10,800 |
| 6 | 6 | 0 | Nil |
The 10,800 in the second row is the sum of remaining instalments, not the foreclosure figure. If you want to close early, the number the issuer quotes can differ because of their own terms, and you should ask for it in writing before deciding.
How do you avoid miscounting?
- Count statements, not calendar months; the instalment lands on the statement date, which may be mid-month.
- Check that the instalment line appears once per statement. Two lines in one month may mean two purchases were converted.
- Keep a separate note per conversion, with item, amount, tenure and the first statement it appeared on.
- Compare the total of instalments left with the unbilled amount shown in the card summary, if the card shows one.
How can a spreadsheet help?
List each plan in a sheet with the start date, tenure and instalment amount in B, C and D. To count the lines that appeared, use a filtered statement export and the COUNTIF function: =COUNTIF($B$2:$B$200, "*EMI*") counts rows that mention EMI in the description column, assuming your statement labels them that way. If your issuer uses different wording, use that word instead. For months left, subtract the count from the tenure: =C2 - COUNTIF($B$2:$B$200, "*EMI*"). Where you have more than one plan on a card, count them separately by amount to avoid mixing.
Where does the app help?
Upload the card statement to SpendixAI, pick the card as the account, review the rows, and then use the report builder to filter by merchant or description and count the instalment rows. Statement import is available on the free plan, and Pro adds custom reports and advanced filters. SpendixAI does not know your EMI terms, so the original conversion confirmation remains your source for tenure.
What if you convert more purchases later?
Each new conversion starts its own clock. The statement may show several instalment lines, each with its own amount and its own month of ending. Give every plan a name in your note, such as Laptop 9 months or Sofa 6 months, and track the months left per plan. The monthly burden from all plans together is the figure to compare with your income.
What to record
- Purchase, amount, tenure and the date it was converted.
- Instalment amount and the interest portion shown.
- The statement where it first appeared.
- Any fee that appeared at conversion, with its line on the statement.
If a figure in the statement does not match your confirmation, write to the issuer with both documents and keep the reply.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
