Subscription Tracker Google Sheets Template: Free Columns and Formulas
To build a subscription tracker in Google Sheets, paste one header row, give each subscription its own line and add two formulas: monthly cost and days until the next charge. A color rule then flags anything renewing within a week.
Build the tracker
Create a blank Google Sheet with these columns:
- Service
- Plan
- Cost
- Billing cycle
- Next charge
- Payment method
- Status
- Cancel link
- Last checked
- Notes
Freeze the first row and turn on a filter. You can then isolate active subscriptions, yearly plans, or charges tied to one card.
Use one row per subscription. Do not combine services in one cell. Separate rows are easier to sort, filter, and review.
A useful first row contains the service, monthly or annual charge, next billing date, payment card, and a direct account-management link.
Free subscription tracker template for Google Sheets
Copy the line below, paste it into cell A1 of a blank sheet, then click Data and Split text to columns. Sheets spreads the headers across columns A to L, as Google's help on splitting text describes.
Service,Plan,Cost,Billing cycle,Next charge,Payment method,Status,Cancel link,Last checked,Notes,Monthly cost,Days left
The first ten columns are the ones described above. Monthly cost and Days left are filled by formulas, so you do not type them. Enter Next charge as a date in your usual format, not as words like "mid November", so the formulas can count with it.
For the Status column, select G2 down to G100, click Insert and Dropdown, and add four values: Active, Trial, Check and Cancelled. A dropdown keeps the spelling identical, and that matters because the total below counts rows by status.
Find subscriptions you already have
Check recent bank and credit-card statements, Apple or Google account subscriptions, and email searches for phrases such as subscription confirmed, free trial, renewal, receipt, and membership.
Add each active plan. If its status is uncertain, use Check instead of guessing. Merchant names on statements can differ from familiar product names, so record both in Notes. For a full search across statements, email, Apple, Google Play and PayPal, follow how to find all your subscriptions.
Keep related purchase records when they may matter later. The same habit helps when a dishwasher breaks and you need the receipt.
Record the billing cycle accurately
Keep the actual charge and original terms rather than replacing everything with a monthly estimate. Use clear cycles:
- Weekly.
- Monthly.
- Every two months.
- Quarterly.
- Yearly.
- Lifetime.
A lifetime purchase is not a subscription, but recording it prevents later confusion.
For a free trial, enter the price that starts afterward, put the conversion date in Next charge, and set Status to Trial. After the first payment, change it to Active.
When a price changes, update Cost and record the old price in Notes. Clear records also help when following Honey price alerts.
Keep status labels simple
Four values are usually enough:
- Active.
- Trial.
- Check.
- Cancelled.
Keep the status factual. Put uncertainty or intentions in Notes rather than inventing labels such as probably cancelling soon.
Do not delete a cancelled row. Change its status, record the cancellation date, and retain the details. The history helps if another charge appears or you later wonder whether you tried the service.
Extra structure creates maintenance, which is why Obsidian vs Notion vs Apple Notes often comes down to the system you will keep current.
Make renewal dates visible
Sort by Next charge. Add conditional formatting so upcoming and overdue dates stand out.
Colour is only a prompt to inspect the row. It is not proof that a charge will occur. Confirm the price and renewal inside the service before making a financial decision.
For yearly plans, add a calendar reminder early enough to decide. The sheet stores the facts; the reminder returns the decision at the right time.
Formulas for a subscription tracker in Google Sheets
Three formulas turn the list into answers. Paste each one into row 2 and drag it down.
Monthly cost in K2 converts every billing cycle to a monthly figure:
=IF(D2="Monthly",C2,IF(D2="Yearly",C2/12,IF(D2="Quarterly",C2/3,IF(D2="Every two months",C2/2,IF(D2="Weekly",C2*52/12,0)))))
Days left in L2 counts down to the next charge with TODAY:
=IF(E2="","",E2-TODAY())
Your monthly total goes in any free cell. SUMIF adds up the Monthly cost of rows marked Active:
=SUMIF(G2:G100,"Active",K2:K100)
To flag renewals due within a week, select A2:L100, click Format and Conditional formatting, choose Custom formula is under "Format cells if" and enter:
=AND($E2<>"",$E2-TODAY()<=7)
Pick a fill color and click Done. The whole row lights up a week before the charge, following Google's conditional formatting steps. The same columns and formulas work in Excel, which also has IF, SUMIF and TODAY.
Can Google Sheets remind you before a subscription renews?
Not by itself. Notification settings in Google Sheets cover comments and edits to the file, according to Google's notification help, so the sheet will not warn you that a date in a cell is close. Anything more specific needs Apps Script.
The simple fix is a calendar reminder for each yearly plan, set before the date you must cancel by. Many plans need notice before renewal, and how to cancel before the renewal date shows how to find that deadline. You can also forward the sign-up email to Tracy in dEssence and ask her to come back before the renewal.
Capture new subscriptions immediately
Add the row while the confirmation is open. Copy the name, price, cycle, renewal date, payment method, and account link. Add one short reason, such as: Needed the export feature for a client project. That context helps you judge whether the plan still earns its place.
Use the same habit for coupons you clipped, Black Friday wishlist items, and small commitments you might otherwise forget.
If spreadsheet upkeep does not suit you, send the confirmation email to Tracy in dEssence instead. It still depends on sending the subscription when you start it.
Review without turning it into a project
Filter for Active, Trial, and Check, then sort by Next charge. When you want to decide what stays, the subscription audit template walks through keep, downgrade, pause or cancel. Open the account page whenever an answer is unclear. If you cancel, update the status and save the confirmation in Notes.
Filter by payment method when replacing a card. This identifies services needing new billing details and forgotten plans that might otherwise fail or move into collection.
Annual audits, abandoned notes lists, budgeting apps that require bank connections, and panic-driven statement scrolling all have tradeoffs. The strongest tracker is not the most elaborate one. It is the list you update at sign-up and check before a charge surprises you.
Frequently asked questions
Is there a free subscription tracker template for Google Sheets?
Yes. Paste the header row from this article into cell A1, split it into columns and add the three formulas. It costs nothing and you can change any column.
How do I see how much I spend on subscriptions each month?
Add a Monthly cost column that converts every billing cycle, then use =SUMIF(G2:G100,"Active",K2:K100) to total the rows marked Active.
Can I use this subscription tracker template in Excel?
Yes. The columns are the same, and Excel has the IF, SUMIF and TODAY functions the formulas use.
Can Google Sheets send me a reminder before a renewal?
No. Its notifications cover edits and comments, not dates in cells. Use a calendar reminder or ask an assistant to remind you.