Cards and UPI

Separating EMIs from subscriptions when both are autopay

Keep loan EMIs and subscriptions apart when both are autopay, using two categories and one tagging rule so repayments never hide in subscription costs.

Editorial illustration for Separating EMIs from subscriptions when both are autopay

Create two separate categories, one for loan EMIs and one for subscriptions, and tag every autopay debit by what it is for, not by how it is paid. An EMI and a streaming plan may both leave your account through the same kind of mandate, but they answer different questions: one is a debt you are repaying, the other is a service you can cancel.

Why do EMIs end up inside the subscription total?

Statements describe both as recurring debits. A bank narration for a loan instalment and a narration for an app plan can look alike, with a mandate reference and a short merchant code. If your tracker groups by "recurring" or "autopay", the two merge, and your subscription spend looks inflated by thousands of rupees.

The damage is practical. You may believe you spend ₹9,000 a month on subscriptions when ₹7,500 of that is an EMI you cannot cancel. You then hunt for savings in the wrong place.

What are the two categories?

  • Loan EMIs: repayments with a fixed end date, such as a phone on instalments, a vehicle loan or a personal loan.
  • Subscriptions: services that renew until you stop them, such as streaming, apps, cloud storage and memberships.

If you like finer detail, add sub-categories under EMIs for each loan, so a vehicle loan and a gadget loan are separate lines. Keep subscriptions as one flat list or split by type, such as entertainment and work tools.

Which tagging rule works?

Ask one question of each autopay debit: could I stop this tomorrow without owing anything more? If yes, it is a subscription. If stopping would mean missing a repayment, a penalty or a default, it is an EMI. Credit card bill payments by autopay belong in neither category. They are a payment towards purchases that you have already categorised.

Autopay debit (example)Could I stop it tomorrow?Category
Video streaming planYesSubscriptions
Two-wheeler loan instalmentNo, it is owedLoan EMIs
Cloud storage planYesSubscriptions
Phone bought on instalmentsNo, it is owedLoan EMIs
Credit card bill autopayIt repays purchasesCard payment, not a spending category

How do I make the rule automatic?

Most trackers let you set a rule that matches a merchant name or a phrase in the narration and assigns a category. Create one rule per recurring payee. In SpendixAI, your own rules are applied first when a statement is imported, then your history and similar merchants, so correcting a debit once and saving it as a rule means next month's lines arrive in the right category. You can also review rows before saving.

In a spreadsheet, keep a small lookup table of payee text and category, and use a lookup formula to fill the category column. For example, with the lookup table in $G$2:$H$50 and the narration in B2, use =IFERROR(VLOOKUP(B2,$G$2:$H$50,2,FALSE),"Review"). That works in Excel and Google Sheets, but it matches the whole cell exactly, so the lookup text must equal what you put in the narration column. Clean the narration down to a payee name first.

What should I do when a loan finishes?

  1. Check that the last instalment was debited and that the loan is closed with the lender.
  2. Remove or end the mandate so no extra debit appears.
  3. Keep the closure letter or final statement with your records.
  4. Watch the next month's statement for any stray debit with the same reference.

How can I see both on one page without mixing them?

Build a monthly view with two totals side by side. A made-up month might show EMIs ₹7,500 and subscriptions ₹1,350. Together they are ₹8,850 of autopay, but only ₹1,350 is room you can trim. Your total commitments and your trimmable spend then stay visible separately.

A short setup checklist

  • Create the two categories.
  • List every autopay debit from the last three statements.
  • Tag each one with the stop-tomorrow question.
  • Save a rule for each payee.
  • Review the first month's results and fix any mistags.
SPENDIXAI JOURNAL

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

Explore your reports