# Find Subscriptions on Bank Statement Rows You Forgot

- Author: CheapBankConvert (https://cheapbankconvert.com)
- Published: 2026-10-17
- Category: Cutting costs from your statements
- Canonical: https://cheapbankconvert.com/blog/find-subscriptions-on-bank-statement

> Find subscriptions on your bank statement, including ones billed yearly or under odd names, with a free sort and a recurring-charge check.
To find subscriptions on a bank statement, put twelve months of rows in one spreadsheet, sort them by description, and mark every merchant that charges the same amount on a regular cycle. Monthly services show up at once. Yearly renewals, app store bills and charges routed through PayPal need a second pass, because they hide behind other names.

## What does a subscription charge look like on a bank statement?

A subscription charge is a card or direct debit payment that a merchant takes on a fixed cycle without you pressing buy each time. On the statement it looks ordinary: a date, a short merchant name, an amount. What gives it away is repetition, the same text and a similar amount turning up month after month.

The description is usually the billing name, not the brand you know. A streaming service might print a company name with a city or a phone number tacked on. A small software tool might show the name of the payment processor in front of its own, such as a prefix followed by an asterisk. Many descriptors include the word "subscription", "membership", "renewal" or "recurring", and a search for those words is a quick first catch.

Amounts help too. Subscriptions tend to end in .99 or .00 and stay fixed for months, while groceries and fuel never repeat to the cent. A row of 15.49 on the 3rd of every month is almost certainly a plan of some kind.

Some subscriptions are not on the checking statement at all. If you pay for a service with a credit card, the charge sits on the card statement, so include every card in the search. A household that pays from two checking accounts and three cards needs all five files, or the list will look shorter than it really is.

## Sorting statement rows so subscription repeats line up

Sorting by description is the fastest way to see repeats, because every charge from the same merchant lands in one block. Put the rows from all accounts into one sheet with date, account, description and amount columns, sort by description, then scan for blocks of four or more rows with near-identical amounts.

Getting the rows into the sheet is the slow part when all you have are PDFs. Many banks let you download a CSV of recent transactions from online banking, which is the cleanest route if it reaches back far enough. For older months, a converter saves the retyping. CheapBankConvert, which is getting ready to open, reads a PDF statement into CSV or Excel rows and shows two pages free before any payment, so a short statement can come through at no cost. The [CheapBankConvert homepage](/) lists the early prices.

Once the sheet is sorted, a helper column makes the repeats obvious. In a blank column, count how many times each description appears with a formula such as `=COUNTIF(C:C, C2)`, where column C holds descriptions. Filter that column to values of three or more. What remains is a short list of merchants that charged you repeatedly, and most subscriptions will be in it.

Descriptions do not always match exactly. One month a merchant prints a reference number, the next month a different one, so the text differs and the count breaks. Trim the description to its first two words in another helper column, for example with `=TEXTBEFORE(C2," ",2)` in recent Excel, and count that instead. The match gets looser, which is what you want at this stage.

## Yearly and quarterly subscriptions that skip most statements

Yearly and quarterly subscriptions appear once or a few times a year, so a single month or a three-month window misses them. They are also the expensive ones: an annual plan might cost more than a year of a monthly plan you already know about. Searching twelve months of rows is the only reliable way to catch them.

A yearly charge has a clear shape: one row, a round-ish amount, and a merchant that looks like software, a membership, a domain, cloud storage, a warehouse club or an antivirus product. Sort the full year by amount, largest first, and read the top fifty rows. Anything that is not rent, insurance, a big purchase you remember or a tax payment deserves a note.

Quarterly charges show up as three or four rows spaced about ninety days apart. The COUNTIF trick catches them, but the count will be four, not twelve, so do not set your filter threshold too high. A filter of three or more catches quarterly plans while leaving out most one-off shops.

Write the renewal month next to each yearly charge you find. That month is your next chance to cancel before the money leaves again, and it is easy to forget by the time it comes back around.

## Subscriptions billed through app stores, PayPal and bundles

Subscriptions bought through an app store, a wallet such as PayPal, or a phone or cable bundle often appear under the middleman's name, not the service's. One statement row can cover several services, and the row's amount may change month to month as plans start and end. The fix is to open the middleman's own list of subscriptions.

An app store charge usually prints the store's name and little else. Several apps billed on the same day may be grouped into one row. The statement cannot tell you which apps those are. The account settings on your phone can: both major phone platforms keep a subscriptions list that shows each active plan, its price and its renewal date. Compare that list with the amounts on the statement until they add up.

Wallet payments work the same way. The statement shows the wallet, and the wallet's own activity page shows the merchant and any automatic payments you approved. Some wallets keep a separate page of "automatic payments" or "pre-approved payments", and old ones stay active for years after you stop using the service.

Bundles are the hardest. A phone plan that includes a streaming service shows one charge from the carrier. To see what is inside it, read the carrier's itemized bill, not the bank statement. If a service you pay for separately is also in a bundle, you may be paying twice. Matching a cryptic descriptor to the company behind it, and cancelling in the right place, is covered in [how to cancel subscriptions you forgot about](/blog/cancel-subscriptions-you-forgot).

## A recurring-charge check on twelve months of subscription rows

A recurring-charge check confirms that a row really repeats on a cycle and puts a yearly cost on it. For each candidate merchant, list the months it appeared, the usual amount, and the gap between charges. A steady gap of about 30, 90 or 365 days means a subscription. Multiply the amount by charges per year to get its cost.

The table below is a worked example for one household's year of checking and card rows. The merchants and figures are made up for illustration.

| Merchant (example) | Months seen | Usual amount | Cycle | Charges a year | Yearly cost |
| --- | --- | --- | --- | --- | --- |
| STREAMCO*VIDEO | Jan to Dec | 15.49 | Monthly | 12 | 185.88 |
| CLOUDBOX STORAGE | Jan to Dec | 2.99 | Monthly | 12 | 35.88 |
| APP STORE BILL | Jan to Dec | 4.99 to 12.98 | Monthly, varies | 12 | 101.76 |
| FITCLUB DUES | Jan to Dec | 39.00 | Monthly | 12 | 468.00 |
| VPN SERVICE YRLY | March | 59.88 | Yearly | 1 | 59.88 |
| PHOTO EDITOR PRO | Feb, May, Aug, Nov | 19.99 | Quarterly | 4 | 79.96 |
| NEWSDAILY DIGITAL | Jun to Dec | 4.00 | Monthly, started June | 12 from now on | 48.00 |

Read the table from right to left. The last column is what each plan costs in a full year, and it adds up to $979.36. The app store row varies because it holds more than one plan, so its yearly cost is the sum of the actual rows, not the amount times twelve. The news subscription started in June, so the year so far shows seven charges, but its cost from now on is twelve a year.

### Step by step

1. Filter the sheet to one candidate merchant at a time.
2. Write down the months it appears in and the most common amount.
3. Check the gap between dates: about a month, about a quarter, or about a year.
4. Multiply the amount by the number of charges a full year would hold.
5. Sort the finished list by yearly cost, largest first.

The sorted list is the point of the exercise. A plan that costs $3 a month feels like nothing until it sits next to its yearly total.

## Subscription look-alikes: repeating rows that are not subscriptions

Not every repeating row is a subscription. Loan payments, insurance premiums, utility bills, transfers to savings and bank fees all repeat on a schedule. They belong in a budget, but treating them as subscriptions muddles the list and makes the services you could cancel look smaller by comparison.

Bank fees are the look-alike most worth a closer look. A charge called "monthly service fee" or "maintenance fee" repeats like a subscription, and it is one of the few that you can often stop without losing anything. [What a monthly maintenance fee is and how to stop paying it](/blog/monthly-maintenance-fee) explains the waiver rules banks use.

Transfers are the other trap. A fixed amount moving to savings on the 1st, or a payment to your own credit card, repeats every month but is not spending. Leave it out of the subscription list entirely. The same goes for a regular payment to a person, such as rent paid to a landlord through a payment app.

Some real subscriptions do not repeat neatly. A plan with usage charges, such as cloud storage that bills by the gigabyte or a phone plan with overage, changes amount every month. A free trial that turned into a paid plan shows only the paid months. If a merchant's name keeps appearing at irregular amounts, check its website for an account page before you rule it out.

### When the list is for a business

If the statement belongs to a small business, the same check finds software tools that staff signed up for and nobody uses. In that case, record each subscription as an expense line in your books as well as on the cut list. [Single-entry bookkeeping from bank statements](/blog/single-entry-bookkeeping) shows a simple ledger that holds those rows.

## Which subscriptions on your list deserve a second look?

The subscriptions that deserve a second look are the ones with a high yearly cost, the ones you cannot remember using in the last month, and the ones you pay for twice. Sort the list by yearly cost and give each row a verdict: keep, downgrade, switch billing cycle, or cancel. Decide before the next renewal date, not after.

A few questions sort most rows fast:

- **When did you last use it?** If you cannot name a day in the last month, mark it as a cancel candidate.
- **Do you pay for it twice?** Two music services, two cloud storage plans, or a service you also get through a bundle.
- **Is there a cheaper tier?** Many services offer an ad-supported or family plan that costs less.
- **Is the yearly price lower?** Switching from monthly to annual billing can cut the cost, but only for a service you are sure to keep.
- **Who else uses it?** A shared family plan may be worth keeping even if you rarely open it.

Set a reminder for each yearly renewal month on your list, and repeat the twelve-month search once a year. New plans creep in through free trials and app purchases, and the second search goes faster because you already know the regulars.