Shopping

Who actually uses each subscription? A family usage sheet

Build a family subscription usage tracker: one sheet that shows who uses which shared plan, how often, and what each plan costs per day of use.

Editorial illustration for Who actually uses each subscription? A family usage sheet

A family subscription usage tracker is one sheet with a row per shared plan, a column per family member, and the number of days each person opened that service in the last month. Divide the plan's price by the total days and you see which subscriptions are loved and which are only paid for. It takes about twenty minutes to set up and five minutes a month to refresh.

What columns does a family usage sheet need?

Keep it narrow enough to read on a phone. One row per subscription, then these columns:

  • A: Subscription name
  • B: Monthly cost in rupees (for a yearly plan, divide the yearly price by 12)
  • C: Who pays, so you know whose card or UPI mandate to touch if you cancel
  • D to G: one column per family member, holding the days that person used it in the last 30 days
  • H: Total days of use, the sum of D to G
  • I: Cost per day of use, which is B divided by H
  • J: Renewal date

Why days and not hours? Because nobody logs hours. Asking "did you open it this week?" is a question a child, a parent and a grandparent can all answer honestly.

What does a made-up family of four look like?

Say Asha and Ravi have two children, Meera and Kabir, and the household pays for five shared services. The numbers below are invented to show the method. The usage counts come from asking each person to tell you roughly how many days they used each service.

SubscriptionCost per monthAshaRaviMeeraKabirTotal daysCost per day of use
Video streaming₹39912815035₹11.40
Music family plan₹179203252270₹2.56
Cloud storage₹13042006₹21.67
Kids learning app₹25000235₹50.00
News app₹1000260026₹3.85

The five plans cost ₹399 + ₹179 + ₹130 + ₹250 + ₹100 = ₹1,058 a month. In the formula column, I2 is =B2/H2 and H2 is =SUM(D2:G2). Copy both down the rows. Put =SUM(B2:B6) under the cost column for the monthly total.

What do the totals suggest?

Read the last column first. The music plan costs about ₹2.56 per day of use because three of four people use it nearly every day. The learning app works out to ₹50 per day of use, because it was opened five times in the whole month. That does not prove it is a waste. Maybe exams are over and it will be busy in January. But it is the first row to question.

Look at the zeroes as well. Kabir has not touched video streaming, and Ravi barely uses music. A zero is not a reason to cancel, but it can tell you the plan is doing the job of one person only, and a cheaper single-user plan might fit.

How do you count usage without nagging anyone?

  1. On the first Sunday of the month, put the sheet on the table or share it in the family chat.
  2. Each person fills their own column from memory. Rounded numbers are fine: 0, 2, 5, 10, 20 or 30.
  3. If someone is unsure, leave a question mark and treat it as the lowest guess, then check next month.
  4. Tick nothing about hours or what anyone watched. You are counting use, not watching people.

Many streaming and music apps show your own recent activity inside the app. If yours does, use it to jog memory, and check what the app says rather than assuming.

Should you cancel the lowest-use plan?

Not straight away. Ask three things first. Does anyone need it at one specific time of year, such as an exam season or a cricket tournament? Could the plan be paused or shifted to a cheaper tier instead of cancelled? And is anything stored there that you would lose?

If a plan is truly unused, cancel it, and then note the freed monthly amount somewhere so it does not just disappear into general spending. The tracker is a decision aid, not a verdict.

Keeping the sheet next to your real spending

A usage sheet tells you how much each plan is used. Your bank or card statement tells you what was actually charged. Once a quarter, compare the two: does the price in your sheet match the debit, and is there any charge you forgot to list? If you track expenses in SpendixAI, you can upload the statement, review the rows and filter by merchant to see what each subscription really cost over the quarter, then copy those numbers into column B.

A five-line monthly routine

  • Refresh the usage columns on the first Sunday.
  • Look at cost per day of use and circle the highest two rows.
  • Ask one question about each circled row: pause, downgrade, share or cancel?
  • Update renewal dates for anything that changed.
  • Write down the rupee amount saved, if any.
SPENDIXAI JOURNAL

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

Explore your reports