Free Excel template

Free Excel subscription tracker template

For anyone who suspects they pay for more apps, streaming services and memberships than they use. List each subscription with its price, how often it bills and the last charge date; the template works out the next renewal, turns every price into a monthly cost, warns you before renewals so you can cancel in time, and shows what cancelling the ones you marked No would save in a year.

cellwise-subscription-tracker-template.xlsxExcel workbook · 6.1 KB · works in Excel, Google Sheets, Numbers and LibreOffice · no signup

Download free template

Preview and try it

This is the template's sheet, calculated by the same engine as the Cellwise app. Change any number to see the formulas react before you download.

	A	B	C	D	E	F	G	H	I
1	Subscription tracker
2	As of date	Nov 2, 2026
3	Warn me this many days before a renewal	14
4
5	Subscription	Category	Price	Billed every (months)	Last charged	Next renewal	Monthly cost	Keep?	Alert
6	Video streaming (main)	Entertainment	15.49	1	Oct 14, 2026	46340	15.49	Yes	Renews Nov 14
7	Video streaming (second)	Entertainment	7.99	1	Oct 21, 2026	46347	7.99	Maybe	OK
8	Music, family plan	Entertainment	16.99	1	Oct 5, 2026	46331	16.99	Yes	Renews Nov 5
9	Sports streaming add-on	Entertainment	11.99	1	Oct 12, 2026	46338	11.99	No	Cancel before Nov 12
10	Cloud storage, 2 TB	Software	9.99	1	Oct 28, 2026	46354	9.99	Yes	OK
11	Phone storage upgrade	Software	2.99	1	Oct 30, 2026	46356	2.99	Yes	OK
12	Password manager	Software	35.88	12	Mar 2, 2026	46448	2.99	Yes	OK
13	Photo editing app	Software	119.88	12	Nov 10, 2025	46336	9.99	Maybe	Renews Nov 10
14	Antivirus	Software	49.99	12	Nov 28, 2025	46354	4.17	No	OK
15	News site	News and reading	4	1	Oct 8, 2026	46334	4	Yes	Renews Nov 8
16	Audiobooks	News and reading	14.95	1	Oct 17, 2026	46343	14.95	Maybe	OK
17	Print magazine	News and reading	24	12	Jun 1, 2026	46539	2	No	OK
18	Gym	Health	39	1	Oct 10, 2026	46336	39	Yes	Renews Nov 10
19	Meditation app	Health	69.99	12	Jan 15, 2026	46402	5.83	No	OK
20	Language learning app	Education	59.99	12	Nov 14, 2025	46340	5	No	Cancel before Nov 14

How the formulas work

Next renewal from the last charge

F6=IF(E6="","",EDATE(E6,D6))

EDATE adds the billing period in months to the date you were last charged: 1 for monthly plans, 12 for yearly ones, 3 for quarterly. Copy the date from your bank or card statement. After the next charge, update Last charged and the renewal moves on a period.

Monthly cost, whatever the billing period

G6=IF(OR(A6="",D6<=0),"",ROUND(C6/D6,2))

Dividing the price by the months it covers puts yearly and monthly plans on the same footing. The $119.88 photo editing app is $9.99 a month, about the same as cloud storage, which is not obvious when one bills once a year and the other every month. The monthly total in C27 is the real cost of all of them.

Alerts before a renewal

=IF(F6="","",IF(F6<$B$2,"Check date",IF(F6-$B$2<=$B$3,IF(H6="No","Cancel before "&TEXT(F6,"mmm d"),"Renews "&TEXT(F6,"mmm d")),"OK")))

When the next renewal is within the warning window in B3, the alert says when it renews, and for anything you marked No it says Cancel before that date. In the sample the photo app renews on Nov 10 and the sports add-on and language app need cancelling by Nov 12 and Nov 14. Check date appears when the renewal is already in the past, which usually means a newer charge has not been entered.

What cancelling would save

C30=ROUND(SUMIF(H6:H25,"No",G6:G25)*12,2)

SUMIF adds the monthly cost of every row marked No and the result is multiplied by 12 for a yearly figure. C31 does the same for Maybe, so you can see how much is riding on the ones you are unsure about. A number like this is often what it takes to actually make the calls.

Spot the biggest subscription

C33=IFERROR(INDEX(A6:A25,MATCH(MAX(G6:G25),G6:G25,0)),"None")

MAX finds the highest monthly cost, MATCH finds its row and INDEX returns the name. It compares monthly costs, so a yearly plan is judged on the same basis as a monthly one. In the sample that is the gym.

Make it yours

Find forgotten subscriptions by searching your last 12 months of bank and card statements for repeating charges, and check your phone's app store subscriptions list, which shows renewals you may not see on a statement.
Color the alerts: select I6:I25, Home > Conditional Formatting > Highlight Cells Rules > Text that Contains, type Cancel and choose red fill. Add Renews in yellow.
Before cancelling, check the terms. Some yearly plans do not refund the unused months, so cancelling just before the renewal date is usually the cheapest moment; the Cancel before alert is built for that.
There is no TODAY() in the file on purpose, so the sample statuses stay put. Type today's date in the As of date cell when you open it, or replace that cell with =TODAY() if you want it to update by itself.

FAQ

How do I track subscriptions in Excel?

List each subscription with its price, billing period in months and last charge date. EDATE(last_charge, months) gives the next renewal, and price divided by months gives a monthly cost you can total. This template adds a Keep? column and alerts before renewals.

How do I compare monthly and yearly subscriptions?

Convert both to the same period. Divide a yearly price by 12 for a monthly cost, or multiply a monthly price by 12 for a yearly one. The Monthly cost column does this for every row.

Does the tracker remind me automatically?

Excel does not send reminders. The alert column updates when you change the as of date (or use =TODAY()), so open the sheet once a week, or put the renewal dates in your calendar for the ones you plan to cancel.

Functions used

Related guides

More free templates

Updated November 2, 2026