To find recurring payments on a credit card statement, put three months of rows together and look for the same merchant appearing in each, usually at the same amount and roughly a month apart. A short formula or a pivot table does the scanning for you, and then you decide, line by line, what to keep.
What should you collect first?
Three consecutive card statements, as CSV or Excel if your issuer offers it, or PDF otherwise. Three is the minimum because a monthly charge needs to appear at least twice to look recurring, and three gives you a margin. If you suspect yearly charges, such as an app renewal, use twelve months of statements instead.
How do you spot them in a sheet?
- Paste all rows in one sheet with Date in A, Merchant in B and Amount in C.
- In D2, enter =COUNTIFS($B$2:$B$500, B2, $C$2:$C$500, C2). Fill down.
- Filter column D for 2 or more. These are repeats at the same amount.
- In E2, enter =COUNTIF($B$2:$B$500, B2), fill down, and filter for 3 or more to see merchants that charged you in every statement, whatever the amount.
Both formulas work in Excel and Google Sheets. The first catches fixed subscriptions. The second catches things like a variable utility or a food-delivery subscription whose total changes.
Is a pivot table quicker?
Yes. Select the data and insert a pivot table. Put Merchant in Rows, a Month column in Columns and Amount in Values, summed. A merchant with a value in every month column is recurring. Merchants with a value in only one column are one-offs. Add a Month column first, for example with =TEXT(A2,"mmm") if the dates are real dates, since a pivot needs something to group by.
A worked example
| Merchant | Month 1 | Month 2 | Month 3 | Verdict |
|---|---|---|---|---|
| Video streaming | ₹299 | ₹299 | ₹299 | Recurring, fixed |
| Cloud storage | ₹130 | ₹130 | ₹130 | Recurring, fixed |
| Food delivery pass | ₹149 | ₹149 | ₹149 | Recurring, check use |
| Fuel pump | ₹2,000 | ₹1,850 | ₹2,200 | Regular, not a subscription |
| Electronics store | ₹0 | ₹5,400 | ₹0 | One-off |
The three fixed charges add up to 299 + 130 + 149 = ₹578 a month, or ₹6,936 over a year. Fuel repeats but varies, and is spending you choose each time, so it is not a subscription to review.
What do you do with each recurring charge?
- Keep it, if you used it in the last month.
- Review it, if you cannot remember when you last used it.
- Cancel it, and note the date and the confirmation.
- Add it to your subscription list so it does not slip out of sight again.
What can hide a recurring charge?
- A merchant that changes its descriptor, so the same service appears under two names in different months.
- A charge in a foreign currency whose rupee amount shifts slightly with the exchange rate, so the same-amount test misses it.
- A plan that bills on the 30th and so lands in different months in a short cycle.
- A free period that ends part-way through your cycle, so the first charge is smaller than the rest.
The merchant-count formula and a quick read of the narrations catch most of these. When a row looks familiar but different, search the statement for the first word of the name.
Where can SpendixAI help?
After you pick the card as the account and import its statements, you can group by merchant in the Report builder and see which merchants appear across months. Corrections to categories become history. It uses what your statements contain, and it does not cancel anything for you; that part is between you and the merchant.
Checklist
- Collect three statements, twelve if you suspect annual items.
- Run the two formulas or build the pivot.
- Mark each recurring row Keep, Review or Cancel.
- Check next month's statement to confirm that cancelled items did not charge.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

