AI and MCP

Gemini prompts to find subscriptions in your bank statement

Gemini prompts that group repeat debits by merchant and interval, split subscriptions from habits, and list what to review, with an annual-cost example.

Editorial illustration for Gemini prompts to find subscriptions in your bank statement

To find subscriptions in a bank statement with Gemini, paste three to six months of debit lines (twelve if you want yearly renewals), then ask it to group repeat debits by merchant, work out the interval, and separate fixed-amount recurring charges from habitual shopping. Finish with a list of what to review. Here are the prompts and an example with OTT, cloud storage and a gym.

How much of the statement should I paste?

Use at least three months to catch monthly charges and a full twelve months to catch yearly ones. Paste only date, narration and amount, and remove your name and account details first. Also check the tool's privacy settings, since the text goes to an outside service.

Which prompts find the recurring charges?

  1. "These are debit lines from an Indian bank statement. Group them by merchant. Show only merchants that appear at least twice. For each, list the dates and amounts."
  2. "For each group, tell me the interval between charges (weekly, monthly, quarterly, yearly or irregular) and whether the amount is always the same, changes slightly, or varies a lot."
  3. "Classify each group as Likely subscription (same amount, regular interval) or Habitual spending (varying amounts, irregular dates). Explain each decision in one line."
  4. "Give me a table of likely subscriptions with the monthly cost and the yearly cost, and a grand total of yearly cost."
  5. "Which of these should I review, and what should I check on each? Do not tell me to cancel anything; list questions I should ask myself."

What does the example show?

Take these made-up findings from six months of statements.

MerchantPatternCharge (₹)Yearly cost (₹)
OTT video serviceMonthly, same amount1992,388
Cloud storageMonthly, same amount1301,560
GymEvery three months3,60014,400
Food deliveryAlmost weekly, varying amountVariesHabit, not a subscription

The three subscriptions add up to ₹18,348 a year, found as 2,388 plus 1,560 plus 14,400. The gym looks small by the month and large by the year, which is the main thing the exercise shows. Food delivery appears often but the amounts change, so the assistant should label it habitual, and the decision about it is yours.

To get the yearly figure yourself, multiply a monthly charge by 12 and a quarterly one by 4. A spreadsheet row per subscription with those two formulas is enough to check what the assistant gives you.

What do I still have to check myself?

  • Whether a repeat debit is truly a subscription or just a favourite shop. Fixed amounts and regular dates are a clue, not proof.
  • Yearly renewals that fall outside the period you pasted.
  • Charges made on a credit card, which sit on a different statement.
  • Whether a standing instruction or auto-debit mandate is behind a charge. Look in your bank and UPI apps for the list of active mandates, since where it sits differs between apps.

Can I catch double charges as well?

That is a different check, but worth doing at the same time. If you import statements into SpendixAI, a ready-made report lists possible duplicate charges, meaning the same amount to the same merchant within two days, and imports also flag possible duplicates. It does not detect subscriptions for you, so keep this prompt set for that.

A last step

Write the survivors into a sheet with a renewal date and a note about why you keep each one. Set a calendar reminder a few days before every yearly renewal, so a charge never arrives as a surprise. A simple review every six months is enough.

If you spot a subscription you no longer use, note the date you decided to stop it and check the next statement to confirm the charge really ended.

SPENDIXAI JOURNAL

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

Explore your reports