DEV Community

Financely Templates
Financely Templates

Posted on

Find Every Subscription You Forgot About With a Google Sheets Tracker (Monthly Cost, Renewal Dates, Yearly Total)

#googlesheets #productivity #tutorial #beginners

Most people who sit down and list their subscriptions find at least one they forgot was still charging them. A small Google Sheets tracker shows what each one really costs per month and per year, which ones renew soon, and how much you'd save by cutting the ones you don't use. It takes about ten minutes to build.

Step 1: Set up the list

Make a tab called Subs with these headers in row 1:

A: Service B: Price C: Billing (Monthly/Yearly/Weekly) D: Next renewal E: Still using? (Y/N) F: Monthly cost G: Yearly cost H: Days to renewal
Streaming 15.49 Monthly 11/03/2026 Y
Cloud storage 29.99 Yearly 01/15/2027 N

Format B, F and G as currency and D as a date. The easiest way to fill it in is to scroll through the last two or three months of bank and card statements and add every repeat charge you see.

Step 2: Normalize everything to a monthly cost

Yearly and weekly plans are hard to compare with monthly ones. In F2:

=IF(B2="", "", IFS(C2="Monthly", B2, C2="Yearly", B2/12, C2="Weekly", B2*52/12))
Enter fullscreen mode Exit fullscreen mode

Step 3: Yearly cost

In G2:

=IF(F2="", "", F2*12)
Enter fullscreen mode Exit fullscreen mode

Seeing "$185.88 a year" hits harder than "$15.49 a month", and that's the point.

Step 4: Days until the next renewal

In H2:

=IF(D2="", "", D2-TODAY())
Enter fullscreen mode Exit fullscreen mode

Drag F2:H2 down your whole list.

Step 5: Highlight renewals coming up

Select A2:H100, open Format > Conditional formatting, choose "Custom formula is" and enter:

=AND($H2<>"", $H2<=7)
Enter fullscreen mode Exit fullscreen mode

Give it a yellow fill. Add a second rule with =$E2="N" and a light red fill. Now anything you said you don't use, or anything about to charge you this week, stands out.

Step 6: The summary that makes you cancel things

Somewhere off to the side (say J1:K4):

Total per month:

=SUM(F2:F100)
Enter fullscreen mode Exit fullscreen mode

Total per year:

=SUM(G2:G100)
Enter fullscreen mode Exit fullscreen mode

What you'd save per year by cancelling everything marked N:

=SUMIFS(G2:G100, E2:E100, "N")
Enter fullscreen mode Exit fullscreen mode

Number of subscriptions renewing in the next 30 days:

=COUNTIFS(H2:H100, ">=0", H2:H100, "<=30")
Enter fullscreen mode Exit fullscreen mode

Step 7: Keep it honest

Set a reminder to look at the sheet once a month, right after payday. Update any renewal dates that rolled over, flip anything you stopped using to N, and cancel before the yellow rows charge you again.

Done

That's a working subscription tracker: every plan converted to a monthly and yearly cost, renewal countdowns, color warnings, and a "money you'd get back" number.

If you want the rest of your budget in the same kind of sheet, I make templates as Financely Templates (disclosure: these are my products):

Top comments (0)