How to Track Your Subscriptions (and Stop Paying for Ones You Don't Use)

Ask most people what they spend on subscriptions and they will name two or three services and a number that feels about right. Then ask them to list every recurring charge — streaming, music, cloud storage, apps, software, memberships, delivery passes, news, gaming — and convert the annual ones into monthly amounts, and the real total is usually noticeably higher. Nothing dishonest has happened. Subscriptions are simply designed to be easy to start and easy to forget.

This guide shows you how to track your subscriptions properly: how to find them all, how to work out what each one really costs per month and per year, how to see renewals coming before the money leaves your account, and how to make a calm keep, review or cancel decision about each one. You can do it on paper. The second half shows how a subscription tracker spreadsheet makes the totals and renewal warnings automatic.

Why subscriptions are so easy to underestimate

Three small traps do most of the damage.

• Different billing cycles. A monthly charge of 15 and an annual charge of 180 look very different on a statement, but they cost the same per month. Until everything is converted to one cycle, the annual plans hide.
• Small amounts. A charge of 2.99 or 4.99 never feels worth investigating on its own. Ten of them are a real bill.
• Quiet renewals and quiet rises. Most services renew automatically, and many raise prices by a small amount with one email that is easy to miss. Each rise is minor. Together, over two or three years, they are not.

Tracking fixes all three, not by being stricter, but by making the whole picture visible in one place.

Step 1: Find every subscription you actually have

Do not start from memory. Start from the money.

• Card and bank statements: look back at least three months, and search for repeat amounts and familiar names. Three months catches monthly and quarterly charges.
• Annual plans need a longer look: scan a full year of statements, or search your email for words like renewal, receipt, invoice and "your plan". Annual software, insurance-style apps and storage plans are the ones most often forgotten.
• App stores: on your phone, open the subscriptions page in your app-store account. Trials that converted to paid plans usually live here.
• Payment services: check any wallet or payment account you use, not just your main card. A subscription charged to a second card is still a subscription.

Write down every one you find, even the ones you are sure you will keep. The point of the list is completeness first, judgement second.

If you already use a budgeting app that imports your transactions, check its recurring-expenses view first; it can surface repeat charges you have forgotten. Lunch Money, for example, has a recurring expenses list that groups weekly, monthly and yearly charges. Just remember the app is itself a subscription, so add it to your list too.

Disclosure: the Lunch Money link is a referral link; if you sign up for a paid plan through it we may earn a commission at no extra cost to you.

Step 2: Record the five facts that matter

For each subscription, note:

1. Name — what it is, in words you will recognise in six months.
2. Category — entertainment, software and apps, health and fitness, news and learning, food and delivery, home and utilities, or other. Categories later show you where the money actually goes.
3. Cost and billing cycle — the amount charged, and whether it is weekly, monthly, quarterly or annual.
4. Next renewal date — the next day money will leave your account.
5. Auto-renew and payment method — whether it renews by itself, and which card or account it charges. This matters when a card expires or is replaced.

That is enough to start. Anything more can be added once the habit exists.

Step 3: Convert everything to a monthly and an annual cost

This is the step that changes the picture.

• Weekly cost × 52 ÷ 12 = monthly cost
• Monthly cost stays as it is
• Quarterly cost ÷ 3 = monthly cost
• Annual cost ÷ 12 = monthly cost
• Monthly cost × 12 = annual cost

Now add it up twice: once per month, once per year. The monthly figure tells you what subscriptions do to your regular budget. The annual figure is the one that makes decisions real — a service that looks harmless at a small monthly amount can be several hundred a year, which invites an honest question: would I buy this again today, at that price, knowing what I now know?

In the sample data that comes with our tracker below, twelve ordinary subscriptions — two streaming services, cloud storage, office and design software, a gym app and a studio membership, news, a delivery pass, gaming, antivirus and a language app — add up to 154.67 a month, or 1,856.03 a year. That example is hypothetical, and it is deliberately made of unremarkable services. That is the point: no single line looks like a problem.

If recurring bills beyond subscriptions are also tangled, our guide to how to never miss a bill payment covers the bill-calendar side of the same system.

Step 4: Decide — keep, review, or cancel candidate

Give every subscription one of three labels.

• Keep: you use it regularly and would buy it again today at this price.
• Review: you are not sure. Give it a date — the next renewal is a natural one — and decide then, with a month of honest use behind you.
• Cancel candidate: you have not used it recently, you forgot you had it, or you would not buy it again today. Add up the annual cost of this group on its own. In the sample above, two cancel candidates save 239.76 a year — real money, found without touching anything that is actually used.

Two gentle rules help. First, cancel the candidate, not the category: the goal is to stop paying for what you do not use, not to remove things you enjoy. Second, when you cancel, note what the saved money will do instead — move it to a goal with our free sinking funds calculator, or leave it as breathing room in the month. Savings that have a job are savings that survive.

Step 5: Watch the renewals, not just the total

A list you make once and never open again will be out of date within a quarter. The habit that keeps it alive is renewal awareness:

• Sort or scan by next renewal date, and look about a month ahead. A month is enough time to use a service deliberately, check a cheaper plan, or cancel before the charge — not after.
• After each renewal, move that subscription's next renewal date forward by one cycle, so the warning keeps working.
• Watch annual renewals especially. They are the largest single charges and the easiest to sleep through.

Step 6: Log price rises when they happen

When a service writes to say its price is going up, record the old cost, the new cost and the date before you decide anything. The percentage increase calculates a story that the headline amount hides: a rise from 1.99 to 2.99 is a 50% increase, even though it is "only" one unit of currency.

A short price log answers a question memory cannot: is this service quietly getting more expensive every year, and is it still worth what it now costs? Sometimes the answer is yes — you use it daily and the rise is fair. Sometimes a rise is the prompt that finally moves a Review to a Cancel candidate. Either way, you decided. The rise did not decide for you.

Using a subscription tracker spreadsheet

You can do all of this in a notebook, and for five or six subscriptions that is honestly enough. A spreadsheet earns its keep when the list grows, because the conversions, totals and renewal warnings update themselves while you only type the facts.

A good tracker spreadsheet is built around exactly the steps above. Ours, for example, has:

• A Subscriptions tab for up to 30 recurring charges — cost, billing cycle, next renewal, auto-renew, payment method and your Keep / Review / Cancel candidate decision, with monthly and annual costs calculated automatically
• Renewal warnings that count the days to each renewal and flag anything due inside the warning window you set
• A Price Log for recording increases, with the change and percentage worked out for you
• A Dashboard with your total per month and per year, how much of your subscription budget is left, renewals coming up, what cancelling the candidates would save per year, and cost by category with charts

It works in Excel and Google Sheets, in any currency, and comes with a step-by-step setup guide. It does not connect to your bank — you stay in control of the list, and nothing is charged or cancelled behind your back. While you are looking at the wider picture, our guide to how to calculate your net worth shows where a subscription audit fits into a simple monthly money routine.

A ten-minute monthly routine

Tracking only works if it survives contact with a busy month, so keep it small:

1. Open the list once a month — payday works well.
2. Look at what renews in the next month and make any cancel decisions before those dates.
3. Add anything new you started, and move renewed dates forward.
4. Glance at the annual total. That is your reminder of what the small charges add up to.

Ten minutes, once a month, is enough to make sure every recurring charge in your life is one you chose — and would choose again.

Start with this week's statements

Do not wait for a perfect system. Open your last three months of statements, write down every recurring charge you recognise, convert the annual ones into monthly amounts, and add it up. That first honest total — whatever it is — is the moment subscriptions stop being background noise and become a decision you are actually making.

---

Want the spreadsheet ready-made? The Subscription Spending Tracker does the monthly/annual conversions, renewal warnings, price-rise log and cancel-candidate savings for you, in Excel and Google Sheets, any currency. Just starting out with budgeting? Try the free Monthly Budget Starter.

Originally published on Smart Budget Sheets.