Record each EMI exactly once, on the date the bank debits it, with the same amount, in one loan category. If your books and your statement disagree about an EMI, the cause is almost always that it was entered twice, entered on the wrong date, or entered as two pieces when the bank showed one debit. Fix that and the numbers line up.
Why does a paid EMI look unmatched?
Salaried people usually have an auto-debit set up for a date just after salary arrives. The bank shows a single debit. Your tracker may show that debit from the statement import, and also an entry you typed on the due date, and another when you saw the SMS. Three records, one payment. Or the opposite: you typed nothing and the statement import had no match because the narration is an obscure mandate reference.
What is the right way to record it?
- Use the bank debit as the source of truth. The amount and date on the statement are what actually left your account.
- Record the whole EMI as one debit. Do not split it into principal and interest unless your lender's schedule is in front of you and you have a reason to.
- Put it in one category, for example EMI and Loan Repayment, so every loan sits together.
- Note the loan in the description, such as personal loan, so two loans do not blur.
- If a payment fails, do not record it. When it succeeds later, record that debit, with that later date.
Worked example: one salary cycle
Say your personal-loan EMI is ₹8,450, due on the 5th, and salary arrives on the 1st. Your statement shows one debit of ₹8,450 on the 5th. In your tracker you find a manual entry for ₹8,450 dated the 4th, because you set a reminder, and the imported debit on the 5th.
| State | EMI entries | Counted | Real |
|---|---|---|---|
| Duplicate present | 2 | ₹16,900 | ₹8,450 |
| After deleting the manual entry | 1 | ₹8,450 | ₹8,450 |
Over a year the difference is 12 times ₹8,450, which is ₹1,01,400, against 24 times, which is ₹2,02,800. The books would claim you pay about double what you do.
How should you avoid the duplicate?
Pick one route per account. If you import that bank's statements, do not also type the EMI by hand. If you do not import that account, type it, but only once, on the debit date. SpendixAI lets you add expenses by hand and import statements in PDF, CSV or Excel with rows reviewed before saving, and it flags possible duplicate imports. A debit you typed and a debit that arrives later by import can still sit side by side, so look for matching amounts in the review step and keep only one.
What if the EMI debit date moves?
Holidays and weekends can shift a debit to the next working day. Record the date on the statement, not the date in the loan schedule. If you use a monthly budget, the amount still falls in the month you expected, unless the shift crosses a month end, in which case note it so you do not think you missed a payment.
Does the EMI belong in expenses at all?
Yes, as cash leaving your account, but it is helpful to view it separately from lifestyle spending. A loan repayment is a commitment, not a choice made this month. Reports that show lifestyle spending with and without loan repayments answer different questions: what did I spend, and what is left after commitments. Keep it in its own category so you can include or exclude it as needed.
Before you close the month
- Each loan has exactly one debit in the month.
- The amount equals the statement amount.
- The category is the loan category, not Other.
- Failed attempts are not recorded as payments.
- Penalty amounts, if any, are in the loan agreement or statement; check them there and record the actual charge as a separate row.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
