Subscription Tracker

Who this is for

Every recurring payment on one sheet, converted to the same unit. Enter the cost and the billing cycle; the monthly and yearly figures and the totals follow.

Anyone who suspects the small monthly charges add up to more than they think, and households where nobody is sure who signed up for what.

What this helps you track

• Everything that charges you on a schedule, in one list
• The monthly and yearly cost of each, whatever cycle it bills on
• The total per month and per year across all of them
• Which ones are not being used, and when each next renews

How to use it

1. Go through a few months of bank and card statements and list every recurring charge — the sheet is only as complete as the statements you check.
2. Enter the cost and pick Monthly or Yearly. The monthly and yearly equivalents are worked out in the browser and workbook; on paper, divide or multiply by twelve.
3. Write the next renewal date and how it is paid, so a cancellation can be made before the next charge.
4. Tick used for anything that earned its place in the last month. Leave the rest unticked and decide what to do about them.
5. Add the monthly total to your budget as one line, and keep the sheet current as things are added or cancelled.

Formats

• Printable PDF (A4 and US Letter)
• Fillable PDF with form fields
• Fill in online, saved in your browser
• Excel / Google Sheets workbook

The printable is laid out inside a box that fits both A4 and US Letter, so the two files are identical and neither one is scaled. The fillable PDF has real form fields. The workbook uses plain formulas only — SUM, IF, COUNTIF and the like — so it opens in Excel, LibreOffice and Google Sheets without anything breaking, and every calculated cell is grey so you can see which figures it worked out.

How to print

Download the A4 or US Letter file to match the paper in your printer, open it in a PDF reader and print at 100% — not "fit to page", which shrinks the writing space. Both files leave a 14 mm margin, which clears the unprintable edge on home printers. To print the online version with your entries in it, use the Print this sheet button, which prints only the sheet and none of the page around it. More on printing.

Questions

What about subscriptions billed weekly or quarterly?

Convert them to a monthly or yearly cost before entering — a quarterly charge is that amount times four for the year. The sheet has the two cycles most subscriptions use; the note column can record the real one.

Does it cancel anything?

No. It shows what you are paying and when the next charge falls. Cancelling is done with the provider, and how much notice they need is in their terms.

Should I include insurance and utilities?

That is up to you. Some people keep this sheet for the optional things and leave the essentials on the bills tracker; others want every regular charge here. The category column lets you tell them apart either way.

Why a used column?

Because the unticked rows are the decision. The count of unused subscriptions and their cost is the figure most people are looking for when they start this sheet.