To flag auto-debits, add a column that searches each narration for keywords such as EMI, NACH and ECS, then total the flagged rows by month. The result shows what leaves your account without you pressing anything, which is the money most easily forgotten. The keywords are examples, so confirm the exact wording on your own statement.
Which keywords should you search for?
Banks word recurring debits differently, so scan a few months of your statement before writing the list. Common candidates are EMI for loan instalments, NACH and ECS for mandate-based debits, and ACH or SI for similar instructions. Be careful with short codes such as SI, because SEARCH finds them inside ordinary words and will flag half your statement. Use them only with a surrounding space or slash, for example " SI " or "/SI/".
UPI AutoPay mandates may appear in the UPI narration instead, with no such word, so a keyword list will not catch every recurring payment. The recurring-payments method on a cleaned merchant column catches the rest.
What is the flag formula?
Put your keywords in H2:H8, with no blank cells in that range, and the narration in A2:
- =IF(SUMPRODUCT(--ISNUMBER(SEARCH($H$2:$H$8,A2)))>0,"Auto-debit","")
SEARCH tests every keyword against the narration, ISNUMBER marks the hits, and SUMPRODUCT counts them. If the count is above zero, the row is labelled Auto-debit. Fill it down and filter on the label to see the list at a glance.
How do you build a monthly view?
Add a month column, say E2, with the first day of the month: =EOMONTH(B2,-1)+1, where B2 is the date. Format it as mmm yyyy. Then you have two routes.
- Pivot table: put the month in Rows, the flag in Filters set to Auto-debit, and the debit amount in Values as a Sum.
- Formula: =SUMIFS($D$2:$D$500,$F$2:$F$500,"Auto-debit",$E$2:$E$500,H10), where H10 holds the month.
A worked example with invented numbers. Say October has an EMI line of ₹12,500, a NACH line of ₹799 and an ECS-labelled line of ₹1,200. The Auto-debit total is 12,500 + 799 + 1,200 = ₹14,499. Say November shows the same EMI and ₹799, but the ₹1,200 line is missing and a new ₹350 line appears. Then the total is 12,500 + 799 + 350 = ₹13,649. The change of ₹850 is a prompt to ask what stopped and what started.
| Month | EMI | NACH | Other auto-debit | Total |
|---|---|---|---|---|
| October | ₹12,500 | ₹799 | ₹1,200 | ₹14,499 |
| November | ₹12,500 | ₹799 | ₹350 | ₹13,649 |
What should you look for in the list?
- A debit you do not recognise. Ask the bank, or the merchant named in the narration.
- A mandate that continued after you stopped using the service.
- An amount that changed from one month to the next without your knowing.
- Two debits for the same thing in one month.
Check the arithmetic against the statement as well. Add a row to the monthly table that sums every debit for the month, and compare the Auto-debit total with it. The difference is everything else you spent. Say October's debits come to ₹58,000 in all: with ₹14,499 of auto-debits, the other spending is 58,000 - 14,499 = ₹43,501. Seeing the fixed part separately makes it easier to judge how much room is left once the month begins.
A routine for each month
- Paste the new statement rows under the old ones.
- Let the flag fill down, and filter for rows with an empty flag but a repeating narration.
- Add any new keyword to the list.
- Compare this month's total with last month's and read the difference.
If you prefer a view that is built for you, SpendixAI has budgets, bills and savings goals on Pro, and imports statements you upload so each row can be reviewed before it is saved. The formula above is enough to start with.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

