Getting started

How many subscriptions do I have, and what do they cost each month?

Count your subscriptions and their true monthly cost by scanning three months of statements, converting annual plans to monthly, and totalling in dollars.

Editorial illustration for How many subscriptions do I have, and what do they cost each month?

Scanning three months of card and bank statements for repeating charges shows how many subscriptions you have and what they cost each month; list each one with its billing cycle and convert everything to a monthly figure. Annual and quarterly plans are the ones people miss, because they appear in only one month of the three.

How do you find them all?

  1. Open the last three months of statements for every card and account you use.
  2. Mark any charge that repeats at the same amount, or appears in a pattern.
  3. Search statement text for words such as renewal, membership, plan, premium and subscription.
  4. Check your phone's list of app subscriptions and the email inbox for receipts.
  5. Look back twelve months for annual charges by searching for amounts you do not recognise.

Free trials deserve a line of their own. A trial that ends and starts billing shows up as a new charge, so check the end date when you sign up.

How do you build the list?

NameAmountCycleMonthly equivalent
Video streaming$16Monthly$16
Music$11Monthly$11
Cloud storage$3Monthly$3
News$8Monthly$8
Gym$40Monthly$40
Photo app$48Yearly$4
Software licence$120Yearly$10

The monthly equivalents add up to 16 + 11 + 3 + 8 + 40 + 4 + 10 = $92 a month, and 92 × 12 = $1,104 a year. The seven items are the count. Notice that the two yearly plans look like $168 spread over twelve months, which is $14 a month; in the month they bill, they look expensive, and in other months they vanish from view.

What formulas do the work?

  • Monthly equivalent in column D: =IF(C2="Yearly", B2/12, IF(C2="Quarterly", B2/3, B2))
  • Total per month: =SUM(D2:D40)
  • Count of subscriptions: =COUNTA(A2:A40)
  • Total per year: =SUM(D2:D40)*12

These work in both Excel and Google Sheets. Enter amounts as plain numbers and keep the cycle spelled the same way each time.

What should you do with the list?

For each row ask two questions: did I use this in the last month, and would I buy it again today at this price? Keep what passes both. For the rest, check how cancellation works with that provider and note the date you cancelled, along with any confirmation. Cancellation terms differ, so read yours.

How often should you do this?

Twice a year is enough for most people, with a quick look whenever you sign up for something new. A line in your tracker for new subscriptions keeps the list from going stale.

What are the sneaky ones?

  • Bundles: a plan you pay for twice because another service includes it.
  • Family or shared plans where you pay the whole bill and others reimburse you irregularly.
  • Price rises that arrive by email and take effect on the next bill.
  • Charges that show a parent company name instead of the product name.
  • Small amounts under a few dollars that nobody looks at twice.

When a charge name means nothing to you, search your email for the amount and date before assuming it is an error. If it still means nothing, ask the card issuer to identify the merchant, and note the date you asked. Once you know what a charge is, rename that row in your list so the next review takes seconds, and add the payment card it uses so you know which statement to check each month.

A final checklist

  • Every card and account checked, not just the main one.
  • Annual and quarterly charges converted to monthly.
  • Count and monthly total written at the top of the sheet.
  • Next review date set.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports