Cards and UPI

Subscription audit spreadsheet: the columns that actually matter

A subscription audit template for Excel or Google Sheets: the nine columns that matter, a formula for monthly cost, and five filled example rows.

Editorial illustration for Subscription audit spreadsheet: the columns that actually matter

A good subscription tracker spreadsheet needs only nine columns: service, plan, billing cycle, amount, payment method, next charge date, monthly equivalent, last used and decision. The monthly equivalent column is the one that changes behaviour, because it puts a yearly ₹1,188 and a monthly ₹99 on the same footing.

Which columns should you set up?

  1. A: Service, the name you will recognise on a statement.
  2. B: Plan, for example family, basic or student.
  3. C: Billing cycle, typed as Monthly, Quarterly, Yearly or Weekly.
  4. D: Amount in ₹, per cycle, as charged.
  5. E: Payment method, such as a card or a UPI autopay.
  6. F: Next charge date.
  7. G: Monthly equivalent, calculated by formula.
  8. H: Last used, a date.
  9. I: Decision, limited to Keep, Review or Cancel.

Use a dropdown (data validation) for columns C and I so spellings stay identical; the formula depends on it.

What formula puts everything on a monthly basis?

In G2, enter this and fill down. It works in Excel and Google Sheets:

=IF(C2="Monthly", D2, IF(C2="Quarterly", D2/3, IF(C2="Yearly", D2/12, IF(C2="Weekly", D2*52/12, ""))))

Add a total below the list with =SUM($G$2:$G$50). For how long since you used each service, in a spare column enter =TODAY()-H2, which gives days. A number above 60 deserves a question.

What does it look like filled in?

These five rows use invented services and prices, only to show the arithmetic.

ServiceCycleAmountMonthly equivalentLast usedDecision
Video streamingMonthly₹399₹399Two days agoKeep
Music appYearly₹1,188₹99YesterdayKeep
Cloud storageYearly₹1,200₹100Last monthReview
GymQuarterly₹2,700₹900Not for 70 daysReview
Language appYearly₹3,000₹250Not for 120 daysCancel

The total is 399 + 99 + 100 + 900 + 250 = ₹1,748 a month, or ₹20,976 a year. The language app alone is ₹3,000 a year for something you have not opened in four months.

How do you fill the sheet without missing anything?

  • Start from your statements, not memory. Scan three months of your card and bank for repeating merchants.
  • Check your email for words such as renewal, receipt and invoice.
  • Look at the subscription pages in your phone's app stores.
  • Ask the household: shared plans often sit on someone else's card.

What do you do with the Decision column?

Review once a quarter. Keep means used recently and worth the price. Review means you are unsure; set yourself a date and a question, such as whether you would sign up again today at this price. Cancel means do it now, and add the cancellation date in a notes column. Keep rows you cancelled for a month or two as proof, then delete them.

How often should you review it?

Five minutes a month is enough. Update the Last used column, tick off charges that landed, and add anything new from your latest statement. Once a quarter, sort by monthly equivalent from largest to smallest and ask about the top three. You can also colour a row red when =TODAY()-H2>60 is true, using conditional formatting with that formula, so unused services stand out without effort.

  • Monthly: update dates and add new services.
  • Quarterly: decide on every Review row.
  • Yearly: re-check prices, because plans often change.

When does a sheet stop being enough?

If you have several cards or months of statements, copying merchants by hand gets tedious. SpendixAI lets you upload statements as PDF, CSV or Excel and review the rows before saving, so recurring merchants are already in your records and you only need to note the decision. Until then, the sheet above is a complete system.

SPENDIXAI JOURNAL

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

Explore your reports