How to Track Subscriptions and Cancel the Ones You Forgot

Here is how to track subscriptions without missing any: find every recurring charge by going through 12 months of bank and card statements, then your app store, payment service and email accounts. List each one in a tracker with its price, billing cycle, next renewal date and yearly cost. Once a month, look at what renews next and cancel, downgrade or rotate anything you are not using.

The yearly cost is the number that changes minds. A $4 charge every four weeks looks harmless until you see it is $52 a year.

Where Subscriptions Hide: How to Find All of Them

Subscriptions are easy to start, easy to forget and billed from more places than most people check. Go through each of these:

• Bank and credit card statements, 12 months back. Monthly charges show up in any month, but a yearly renewal shows up once. Look for the same amount on roughly the same date, and for small charges under $5 that are easy to skim past.
• Your phone’s app store. Subscriptions bought inside an app are often billed by Apple or Google rather than the app company, so the statement shows the store’s name. On an iPhone, the list sits under your name in Settings. On Android, open the Play Store, tap your profile picture and look for Payments and subscriptions.
• Payment services. PayPal and similar services can hold automatic payments that reach your card under the service’s name.
• Shopping and streaming accounts. Online stores sell memberships and repeat deliveries, and streaming devices sell add-on channels.
• Email. Search for “subscription”, “renewal”, “your receipt”, “free trial” and “membership”.
• Phone and internet bills. Some services are billed through your provider, so they appear on that bill rather than as their own charge.
• Family members. A shared card can carry a child’s game subscription or a partner’s app you have never heard of.

Menu names change between phone updates. If a path above does not match, search your phone’s settings for “subscriptions”. Once you have every recurring charge, the regular bills among them belong on your bill calendar; how to organize bills covers that side.

How to Track Subscriptions in a Spreadsheet

You do not need a dedicated app. One tab in Google Sheets or Excel with these columns does the job:

Column	Example	What it tells you
Service	Music streaming	What it is
Price	$10.99	The amount per charge
Billing cycle	Monthly	How often it charges
Yearly cost	$131.88	The real price
Next renewal	Oct 11	When you must decide
Paid with	Credit card	Where to look on statements
Signed up through	App store	Where to cancel
Who uses it	Everyone	Whose call it is
Last used	This week	Whether it still earns its cost
Status	Keep, cancel or rotate	The decision

The “signed up through” column saves the most frustration. A subscription bought in an app store has to be canceled in that store, and deleting the app does not stop the charge.

If you already run a budget, give subscriptions their own category group rather than burying them in bills. Our budget spreadsheet is set up that way, with subscriptions as a separate group next to bills, expenses, savings and debts, and its bill tracker spreadsheet schedules each renewal across the year from one entry.

Subscription Tracker Formulas: Monthly to Yearly Cost

Billing cycles are what make subscriptions hard to compare. Weekly, every-four-weeks and yearly prices do not add up in your head, so convert every one to a yearly cost.

Make a small lookup table on a tab called Cycles, with the cycle name in column A and the number of charges per year in column B:

Cycle	Charges per year
Weekly	52
Every 2 weeks	26
Every 4 weeks	13
Monthly	12
Quarterly	4
Yearly	1

Use the same list as a dropdown for your billing cycle column so every entry is spelled the same way. Then, with the price in C2, the cycle in D2 and the next renewal date in column G, these formulas work the same in Google Sheets and Excel:

• Yearly cost, in E2: =C2*VLOOKUP(D2,Cycles!$A$2:$B$7,2,FALSE)
• Monthly equivalent, in F2: =E2/12
• Total per year: =SUM(E2:E50)
• Charges due in the next 30 days: =SUMIFS(C:C,G:G,">="&TODAY(),G:G,"<="&TODAY()+30)

Here is an example list. The prices are made up for illustration, not any real service’s price:

Subscription	Price	Cycle	Yearly cost	Per month
Video streaming A	$15.49	Monthly	$185.88	$15.49
Video streaming B	$9.99	Monthly	$119.88	$9.99
Music streaming	$10.99	Monthly	$131.88	$10.99
News site	$4.00	Every 4 weeks	$52.00	$4.33
Coffee delivery	$18.00	Every 2 weeks	$468.00	$39.00
Cloud storage	$29.99	Yearly	$29.99	$2.50
Fitness app	$69.99	Yearly	$69.99	$5.83
Phone game	$2.99	Monthly	$35.88	$2.99
Total			$1,093.50	$91.13

Two things stand out. The coffee delivery, at $18 a time, costs more per year ($468) than all three streaming services together ($438). And the news site charges 13 times a year, not 12, because four weeks is shorter than a month. In total, this list costs about $1,094 a year, or $91 a month.

How to Cancel Unused Subscriptions: A Cancel-or-Rotate Routine

Once a month, ideally as part of your monthly budget review, spend 10 minutes on the list:

1. Sort by next renewal date. Only the subscriptions renewing in the next 30 days need a decision now.
2. Work out the cost per use. Divide the monthly equivalent by the number of times you used it last month. The fitness app above costs $5.83 a month, so three workouts make it $1.94 a session. Video streaming B watched twice costs $5 a viewing.
3. Give each one a status.
   • Keep if you use it often and the cost per use feels fair.
   • Downgrade if a cheaper tier, an ad-supported plan or a family plan shared with others covers what you actually use.
   • Rotate if you like it, but not every month.
   • Cancel if you have not used it in 30 days and cannot name the next time you will.
4. Cancel where you signed up. Check the “signed up through” column: the app store, the payment service or the company’s own website.
5. Save the proof. Screenshot the confirmation or keep the email, and note the date your access ends.
6. Check the next statement. If the charge shows up again, contact the company first, then your card issuer.

How Rotating Saves Money

Rotation works best for video streaming, since you usually watch one service’s shows at a time anyway. Say you pay for three services at $15.49, $9.99 and $11.99 a month (example prices). Keeping all three all year costs $449.64. Keeping one at a time, four months each, costs $149.88, a saving of about $300, and you still get to watch what each one offers. Mark the current one “keep” and the other two “rotate”, with the month you plan to switch.

Free Trials

The moment you start a free trial, add it to the tracker with the trial end date as its next renewal and “cancel” as its status. Cancel a day or two before it ends. Some services end the trial the moment you cancel and others let you finish it, so check before you cancel on day one.

If trimming subscriptions sparks a bigger reset, a no spend challenge is a natural next step, and our list of budget categories shows where subscriptions sit among the rest of your spending.

Start today with the easiest source: open your phone’s subscription list and copy every entry into your tracker before you close it.