Budgeting

Subscription total review: annualise and rank everything

Review all your subscriptions by converting weekly, monthly, quarterly and yearly plans to a yearly cost, then rank them and find the top three's share.

Editorial illustration for Subscription total review: annualise and rank everything

To review your subscriptions, convert each to a yearly cost (weekly × 52, monthly × 12, quarterly × 4, yearly × 1), add them up, and rank them from biggest to smallest. The ranking matters more than the total: a few items usually carry most of the cost, and those are the ones worth a closer look.

Why annualise instead of comparing monthly prices?

Because plans are billed at different gaps. ₹350 a week, ₹2,500 a month and ₹6,000 a quarter cannot be compared at a glance. Converting everything to one year puts them on the same scale, and a yearly figure feels more real than a monthly one: ₹499 a month sounds small until you see ₹5,988.

What does a ranked list look like?

Here is a hypothetical list of 11 items, sorted from highest yearly cost to lowest.

ItemBilledAmountYearly cost
Gym membershipQuarterly₹6,000₹24,000
Weekly fruit and vegetable boxWeekly₹350₹18,200
Language-learning appYearly₹5,999₹5,999
Second streaming serviceMonthly₹499₹5,988
NewspaperMonthly₹420₹5,040
Video streamingMonthly₹299₹3,588
Fitness appYearly₹2,400₹2,400
Cloud storageMonthly₹130₹1,560
News appYearly₹1,499₹1,499
Music appMonthly₹119₹1,428
AntivirusYearly₹899₹899

The total is ₹24,000 + ₹18,200 + ₹5,999 + ₹5,988 + ₹5,040 + ₹3,588 + ₹2,400 + ₹1,560 + ₹1,499 + ₹1,428 + ₹899 = ₹70,601 a year, or about ₹5,883 a month. The top three (₹24,000 + ₹18,200 + ₹5,999 = ₹48,199) make up about 68% of the total. The bottom five together come to ₹7,786, about 11%, so the small items matter far less than the big ones.

How do you set it up in a spreadsheet?

List each item with its billing period in column B and the amount in column C. In D2, convert to a yearly cost:

  • =IF(B2="Weekly", C2*52, IF(B2="Monthly", C2*12, IF(B2="Quarterly", C2*4, C2))) and fill it down.
  • Total: =SUM($D$2:$D$12)
  • Largest: =LARGE($D$2:$D$12, 1), then the same with 2 and 3.
  • Top three share: =(LARGE($D$2:$D$12,1)+LARGE($D$2:$D$12,2)+LARGE($D$2:$D$12,3))/SUM($D$2:$D$12)
  • Monthly average: =SUM($D$2:$D$12)/12

These work in Excel and Google Sheets. Sort the sheet by column D from largest to smallest to get the ranking.

What do you do with the ranking?

  1. Start at the top. Is the largest item used often enough to justify its cost? Divide the yearly cost by the number of times you used it: ₹24,000 for 60 visits is ₹400 a visit.
  2. Look for overlaps, such as two streaming services where one would do.
  3. Check whether a yearly plan or a different billing gap changes the cost. Compare only after multiplying out, never by the headline monthly price.
  4. Cancel or pause anything you have not used in the last month, and note when you did it.

A quick example of why multiplying out matters: a plan at ₹499 a month costs ₹5,988 a year, so a yearly plan at ₹5,999 is actually ₹11 dearer, not cheaper. A yearly plan only wins if it comes in below twelve times the monthly price, and only if you are sure you will keep using the service for the whole year. Paying upfront also means you cannot stop halfway and save the rest.

Which subscriptions are you missing?

Scan 12 months of statements for the same merchant and amount appearing more than twice. If you import statements into SpendixAI, its Report builder can filter and group by merchant, and merchant aliases help when one service shows up under several names. Anything on that list that is not in your sheet is one you forgot.

Next steps

  • Finish the list and rank it.
  • Write down the yearly total and the top-three share.
  • Decide on one change this week: cancel, pause or downgrade.
  • Repeat in six months, when renewals have come round again.
SPENDIXAI JOURNAL

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

Explore your reports