Life events

Annual subscriptions that auto-renew: find them in your statement

How to find once-a-year auto-renew charges by scanning twelve months of card statements, then put each renewal date on a calendar before it hits.

Editorial illustration for Annual subscriptions that auto-renew: find them in your statement

To find annual subscriptions, gather twelve months of statements for every card and bank account, then look for merchants that appear only once with a round-looking amount. Searching for words like annual, yearly, renewal and membership catches many of them. Add each one you find to a calendar two weeks before its renewal date, because that is when you can still decide.

Why do yearly charges slip past you?

A monthly subscription shows up twelve times, so you notice it. A yearly one appears once, often months after you signed up for a free trial, and by then you have forgotten the reason. It also tends to sit in a statement beside bigger items, so it looks like any other bill.

Step by step: scanning twelve months

  1. Download statements covering the last twelve months for each credit card, bank account and UPI-linked account you use. Most banks let you pick a custom period in their statement section; check your own bank for the route.
  2. Put every row in one sheet with columns for date, description, amount and account. If you only have PDFs, copy them into rows, or import them into a tracker.
  3. Sort by description so the same merchant sits together.
  4. Mark any merchant with exactly one charge in the twelve months, and any with twelve near-identical charges separately; the second group are monthly plans, the first are yearly candidates.
  5. For each yearly candidate, note date, amount and what it is for.
  6. Open the merchant's app or your email for a renewal notice and confirm whether it renews automatically.

Words and patterns that give them away

Clue in the statementWhat it often means
Annual, yearly, renewal, membershipDirect label from the merchant
Play Store or App Store in the descriptionAn app subscription billed by the store, not the app
Same amount, same date, a year apartStrong sign of auto-renew
Odd amounts with GST includedSoftware or cloud tools priced before tax
A foreign merchant name with a rate conversionOverseas service billed in another currency

A formula helps when the list is long. If merchant names are in column B from row 2 to row 500, put =COUNTIF($B$2:$B$500,B2) in column E and filter for 1. This works in both Excel and Google Sheets, but it only works if the same merchant is spelt the same way every time, so clean up the names first.

Which kinds of charges tend to be yearly?

  • Insurance premiums paid as one yearly amount
  • Society, club or gym memberships paid in a lump sum
  • Domain names, web hosting and cloud storage
  • Antivirus and other software licences
  • Magazine, newspaper and learning-app plans
  • App-store annual plans that were started as a free trial

What should I do once I find one?

Decide on the spot: keep, switch to monthly, or cancel. Then create a calendar entry named with the merchant, amount and date, set about fifteen days before the renewal. If you cancel, note the date and keep the confirmation, because a charge that still appears afterwards is easier to raise with proof.

Making the next scan quicker

The twelve-month scan is tedious by hand, which is a good reason to keep statements in one place. SpendixAI accepts bank or card statements as PDF, CSV or Excel, lets you review the rows before saving, and keeps each transaction with its account. You can then search by merchant instead of scrolling pages. You still make the keep-or-cancel call yourself.

A short closing checklist

  • List of yearly charges found, with dates and amounts
  • Calendar entry for each renewal
  • Decision noted beside each one
  • Next scan booked for the same month next year
SPENDIXAI JOURNAL

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

Explore your reports