Getting started

How to build a subscription tracker that you will actually keep up

Build a subscription tracker in a sheet: columns, a renewal calendar, a yearly cost formula and a quarterly review that decides what to keep.

Editorial illustration for How to build a subscription tracker that you will actually keep up

A subscription tracker is a single list with one row per recurring payment, showing what it costs, how often it renews and when the next charge lands. Build it once from three months of statements, then review it every quarter. The goal is to see the yearly cost of each plan, because that is the number people underestimate.

How do I find every subscription I pay?

  1. Download or open the last three months of bank and card statements.
  2. Sort by description, or filter for names you recognise as services.
  3. Look for the same amount appearing at the same time each month, and for annual debits that appear once in the three months.
  4. Check UPI autopay or mandate lists in your payment apps for scheduled debits.
  5. Search your email for words such as renewal, receipt or invoice.
  6. Add each to the sheet, even the ones you plan to cancel.

What columns should the sheet have?

ColumnExample (made up)Note
NameCloud storagePlain label
Amount₹130What you are charged
CycleMonthlyMonthly, quarterly or yearly
Monthly equivalent₹130So all plans compare fairly
Yearly cost₹1,560Monthly equivalent times 12
Next renewal12 DecThe date to act by
Pay fromCard or UPIWhich account
VerdictKeep, review or cancelDecide each quarter

How do I turn yearly and quarterly plans into monthly figures?

Divide by the number of months in the cycle. A ₹999 yearly plan is ₹999 divided by 12, which is ₹83.25 a month. A ₹449 quarterly plan is ₹149.67 a month. In a spreadsheet, with amount in B and months in cycle in C, use =B2/C2 for monthly equivalent and =B2/C2*12 for yearly cost. This is how you compare a monthly plan of ₹99 against a yearly plan at ₹999: twelve monthly payments cost ₹1,188, so the yearly costs ₹189 less, provided you really keep it for the full year.

A worked review

Say you find six plans: ₹199, ₹130, ₹149, ₹499, ₹59 and ₹299, all monthly. The total is ₹1,335 a month, or ₹16,020 a year. You rarely use two of them, ₹149 and ₹59. Cancelling them saves ₹208 a month, ₹2,496 a year. Without the yearly view, ₹59 looks too small to bother with.

How do I get reminded before a renewal?

  • Add each renewal date to your phone calendar, with an alert two days before.
  • Highlight in the sheet any date within the next 14 days using conditional formatting and the formula =AND(F2>=TODAY(),F2<=TODAY()+14).
  • Keep the date column as real dates, not text, so sorting works.

When is a sheet not enough?

If your subscriptions arrive through several accounts, copying from statements each month becomes a chore. SpendixAI can take statements from each account, keep every transaction tied to its account, and, on the Pro plan, track bills. Describing what it does not do is equally useful: it has no bank sync and does not read SMS, so you still upload the statements.

What should I do each quarter?

  • Mark every row Keep, Review or Cancel, and give a reason in a few words.
  • Cancel through the service's own account page and note the date.
  • Check the next statement to confirm the charge stopped.
  • Update amounts for any price change.

What about subscriptions shared with family?

If you pay for a family plan and others reimburse you, log the full amount you are charged and record each repayment as money back against it. Say a ₹299 plan is shared by three people and two send ₹100 each. Your real cost is ₹299 minus ₹200, which is ₹99. If you only log what you send out and forget the repayments, the plan looks three times as expensive as it is, and you may cancel the wrong thing.

SPENDIXAI JOURNAL

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

Explore your reports