A1:H16fxCOUNTIFS IF SUM SUMIF TODAY
Subscription Tracker — the first rows of the actual spreadsheet
Subscription Tracker
The opening rows of the file you get — sample data included, not a mock-up.

Personal template

Subscription Tracker

Every recurring payment normalised to a monthly and annual cost, with renewal dates.

$7one payment, yours to keep
  • ✓Instant download
  • ✓Every later version free
  • ✓Commercial use
  • ✓No signup, no watermark
21
live formulas, each one recalculated and checked
8
columns: Service, Category, Cost, Billing, Monthly cost, Annual cost, Renews, Keep?
5
figures worked out for you

Anyone cancelling forgotten subscriptions — usually looking for this when a statement shows charges nobody recognises.

Need more than one? All 9 Personal templates for $39 — $83 bought separately. All 66 for $99.

Works in Excel 2013 and later, Microsoft 365, Google Sheets and LibreOffice Calc. Set up to print on one page wide. Version 1, updated 25 September 2026.

There are free templates. Why this one?

There are, and some are fine. The difference is what has been checked. This file was built from scratch, then every formula in it was recalculated by a separate checker that compares each result against an independently worked-out answer — 21 of them here. A template that looks right and totals wrong is worse than no template at all, and that is the usual failing of one downloaded from a search result.

It also opens with sample rows already filled in, so you can see every formula working before you touch it, and it is set up to print without fighting the page setup. No email wall, no signup, no watermark, and you can use it commercially.

About this Subscription Tracker template

Subscriptions are designed to be forgotten. This Excel subscription tracker lists each service with its cost, billing period and renewal date, converts every one to a monthly and a yearly cost so they can be compared, and lets you mark whether to keep it.

The summary shows your total cost per month and per year, the yearly saving from subscriptions marked to cancel, the cost still under review and what renews in the next 30 days.

Good for

  • →Finding subscriptions you no longer use
  • →Budgeting for annual renewals
  • →Cutting monthly outgoings

What it works out for you

The damage

  • →Total per month
  • →Total per year
  • →Marked to cancel (yearly saving)
  • →Under review (yearly)
  • →Renewing in the next 30 days

What is inside the Subscription Tracker template

The table has 8 columns. Calculated columns fill themselves in; the rest are yours to type over.

  • →Service
  • →Category
  • →Cost
  • →Billing
  • →Monthly cost
  • →Annual cost
  • →Renews
  • →Keep?

How to use the Subscription Tracker in Excel

Monthly and yearly subscriptions are normalised so you can compare them honestly. The annual total is usually the shock.

The file opens with sample rows so you can see every formula working before you change anything. Type your own figures over them. When you need more rows, insert them inside the existing block rather than underneath it, so the totals keep covering every row.

Functions and formulas it uses

Every one of these exists in Excel, Google Sheets and LibreOffice, so the file behaves the same wherever you open it.

COUNTIFSIFSUMSUMIFTODAY

Questions about the Subscription Tracker

How are monthly and yearly subscriptions compared?

Each one is converted to both a monthly and an annual cost, so a yearly plan and a monthly plan sit side by side on the same basis.

What does 'renewing in the next 30 days' show?

The subscriptions due to renew within the next 30 days, so you can cancel any before you are charged.

Does it cancel subscriptions for me?

No. It shows what you are paying so you can decide. Cancel with each provider directly.

What you get with the Subscription Tracker

  • ✓21 formulas, every one recalculated and checked
  • ✓Opens with sample rows already filled in
  • ✓Excel, Google Sheets and LibreOffice Calc
  • ✓Set up to print on one page wide
  • ✓Commercial use, no attribution needed
  • ✓Every later version included free

Get the Subscription Tracker for $7

One payment. The file downloads straight away, and every later version of it is yours at no extra cost.

Buying a few? All 9 Personal templates for $39, or all 66 for $99.

More personal templates

See all Personal →