Find every subscription and regular payment in your bank statements
A year of bank and card exports turned into a list of what comes out, and how often.
A real run on 13 November 2026, on a Linux computer, using Claude Code with Opus, on a Claude plan. The waiting is sped up; it took 2 min 59 s in real time.
The short answer.
Download a year of transactions as CSV from your bank and card, open them in Excel, and make a PivotTable with the description in Rows and the count and average amount in Values: names that repeat with steady amounts are your subscriptions. Watch for weekly, fortnightly and yearly ones, and price rises. Stella (stella.sh) reads the exports on your computer and builds a spreadsheet of each subscription and bill with its current price, how often it's charged and its yearly cost, without logging in to your bank.
Stella does this on Windows, Mac and Linux.
What happened.
About 3 minutes. Checked afterwards against an answer key written before the run: all 13 subscriptions and regular payments listed (including the weekly, every-two-weeks and yearly ones, the trial that turned paid, rent and utilities), the current amount right for each, a yearly cost for each, no everyday spending or salary listed, and both exports unchanged. One optional point was marked missed: see the limits.
The bank, card, merchants and transactions are fictitious, made for this run, in US dollars. The work is sped up 11×.
How Stella does it.
- Reads both exports in Downloads, a checking account and a credit card with different column layouts, 968 transactions over 12 months
- Groups charges by merchant, including ones written two ways on the statement, and looks at how regularly they come out and how much they vary
- Finds monthly, weekly, every-two-weeks and yearly charges, plus rent, utilities that vary, and a free trial that turned paid
- Uses today's price for each (StreamView after its June rise), and leaves groceries, coffee, fuel, salary and card payments out
- Saves a spreadsheet with yearly costs, totals for bills and subscriptions, and a second tab of every matching charge, and points out overlaps such as paying for two fitness services
The prompt.
Go through my two bank exports in Downloads and find every subscription and regular payment I'm paying. Make me a spreadsheet with what each one is, how much it is, how often it comes out and what it costs me a year.
This is the exact prompt from the recording. If your files are somewhere else, say where.
Do it yourself.
Download a year as CSV
In online banking, look for Export or Download transactions on each account and card, and choose CSV for the last 12 months. A full year catches yearly renewals. If you only have PDFs, see bank statement PDF to Excel first.
Put everything in one sheet
Open the files in Excel or Numbers and paste them under one set of headers: Date, Description, Amount, Account. Make money out one sign (negative) so totals make sense.
Make a PivotTable
In Excel, select the data, Insert, PivotTable, put Description in Rows and Amount in Values twice, set to Count and Average. Sort by Count. Merchants with 12 charges are probably monthly; 52 weekly; 26 every two weeks.
Look for the sneaky ones
Search the descriptions for “annual”, “yearly”, “trial” and “renew”. Compare the first and last charge of each subscription to spot price rises. Check your phone's App Store or Google Play subscriptions too, since those appear under the store's name.
Work out the yearly cost
For each one, multiply the current amount by how often it's charged in a year (12, 52, 26 or 1). Variable bills like utilities: add up the last 12 months instead.
Where it stops.
- The answer key had one optional point marked missed: a gaming membership that stopped in February should be left out or marked cancelled. Stella's summary did mark it “Stopped, looks cancelled” and left it out of the totals, but its old charges are listed unmarked on the second tab, which the check counted against it.
- Stella finds and lists. Cancelling happens on each service's own site or app; Stella can open the page for you.
- Your transactions go to the AI model you use in Stella. Remove account numbers from the exports first if you prefer; Stella never needs your banking login.
- Charges billed through someone else (app stores, PayPal) show under that name, so the service behind them may need checking.
- Recorded on Linux with free tools. Works the same with exports on Windows or a Mac; the spreadsheet opens in Excel, Numbers or Google Sheets.
Questions.
How do I find all my subscriptions?
Go through 12 months of bank and card transactions for names that repeat at regular gaps, then check your phone's app store subscriptions and your email for “renewal” receipts.
Do I need a subscription tracker app?
Not to find them. Tracker apps link to your bank and some charge a fee. A downloaded CSV and a PivotTable, or Stella, finds the same things without sharing your login.
How do I spot a free trial that turned into a paid plan?
Look for a new merchant with a £0 or tiny first charge followed by regular full charges. Stella flagged one here that started in July and began charging in August.
Can I see my spending by category too?
Yes: see summarize a spreadsheet by category. To split shared bills, split bills with roommates.
Is Stella free for this?
Yes. Free with the ChatGPT or Claude plan you already have. Sign in with your ChatGPT plan, or use your Claude plan through Claude Code, and this task costs nothing extra. New accounts also get a small free trial of Stella’s own models.
Can I control what Stella changes on my computer?
Yes. Stella works on Windows, Mac and Linux with your own files and shows each step in the chat, so you can watch it and stop it at any point. Tell it what it may not do, as the prompts on these pages do (“don't delete anything without asking”). In the Downloads recording it deleted nothing until it was told to go ahead. It also refuses commands that would wipe a whole disk, your home folder or system folders.
Checked against these sources on 13 November 2026.