# Find every subscription and regular payment in your bank statements

> Markdown version of https://stella.sh/how/pdf-excel/find-subscriptions-in-bank-statement for agents and LLMs.
> List every subscription and regular payment in a year of bank and card exports, with its yearly cost, in Excel or with Stella (stella.sh), without linking your bank.

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.

- Checked: 13 November 2026
- Stella does it on: Windows, Mac, Linux

## Stella doing it

Recorded 13 November 2026 on Linux (Omarchy) with Claude Code with Opus, on a Claude plan.
Result: 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×.

Video (44 s): https://stella.sh/media/proofs/pdf-excel/find-subscriptions-in-bank-statement/proof.mp4

Transcript:

- 0:00 Stella on a Linux computer. A year of checking-account and credit-card exports are in Downloads.
- 0:01 The prompt: every subscription and regular payment, what each costs and how often.
- 0:11 Stella replies that it will send the spreadsheet with a yearly total and anything that looks off.
- 0:17 Going through 968 transactions, sped up 11×.
- 0:30 Done: the yearly cost split into bills and subscriptions, a trial that turned paid, a price rise, and a membership that looks cancelled.

What Stella does:

1. Reads both exports in Downloads, a checking account and a credit card with different column layouts, 968 transactions over 12 months
2. 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
3. Finds monthly, weekly, every-two-weeks and yearly charges, plus rent, utilities that vary, and a free trial that turned paid
4. Uses today's price for each (StreamView after its June rise), and leaves groceries, coffee, fuel, salary and card payments out
5. 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 to paste

```text
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.
```

## Find them yourself

1. **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](https://stella.sh/how/pdf-excel/bank-statement-pdf-to-excel) first.
2. **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.
3. **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.
4. **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.
5. **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 Stella 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](https://stella.sh/how/pdf-excel/summarize-spreadsheet-by-category). To split shared bills, [split bills with roommates](https://stella.sh/how/pdf-excel/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.

Sources: [Microsoft: Create a PivotTable to analyze worksheet data](https://support.microsoft.com/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576), [Apple: See or cancel your subscriptions](https://support.apple.com/118428).

## Related problems

- [Convert bank statement PDFs to Excel](https://stella.sh/how/pdf-excel/bank-statement-pdf-to-excel.md)
- [Summarize a spreadsheet by category and month, with totals](https://stella.sh/how/pdf-excel/summarize-spreadsheet-by-category.md)
- [Split bills with roommates and settle up in the fewest payments](https://stella.sh/how/pdf-excel/split-bills-with-roommates.md)
- [Make a budget from your bank statements](https://stella.sh/how/money-household/make-a-budget-from-bank-statement.md)
- [Reduce PDF file size when it's too large to email](https://stella.sh/how/pdf-excel/compress-pdf-too-large-to-email.md)
- [Combine multiple Excel files into one sheet](https://stella.sh/how/pdf-excel/combine-excel-files-into-one-sheet.md)

Get Stella: https://stella.sh/download. Free with the ChatGPT or Claude plan you already have.
