2027 Subscription Tracker Spreadsheet: Free Trial Cancel-By Dates, Renewals, Yearly Cost, Excel and Google Sheets
See every subscription and free trial in one list: when each one charges next, the last day to cancel, when trials turn into paid plans, and what it all costs per month and per year.
What's inside:
- Subscriptions: up to 80 rows with name, category, price, billing cycle (weekly, monthly, every 3 or 6 months, or yearly), status (Active, Free trial, Paused, Canceled), payment method and who uses it.
- The next charge date rolls forward from any past charge date you type, so you don't have to update it every month. Free trials show the trial end date and a cancel-by date.
- Alert column: Trial ends soon, Trial over - check, Cancel by date, Cancel now (past notice), Coming up or Paused.
- Worth it? column (Keep, Maybe, Cancel): the Dashboard shows what the Maybe and Cancel ones cost per year, and canceled rows show what you're saving.
- Next 12 Months: the charges to expect each month, so yearly renewals don't surprise you.
- Dashboard: monthly and yearly totals, free trials, charges coming up, the next 10 charges with cancel-by dates, the most expensive subscription and cost by category.
- Instructions tab first, dropdowns, locked formula cells and a layout designed for small screens.
Who it's for: Anyone who has lost track of streaming, apps, memberships and free trials and wants to see the real yearly cost and cancel on time.
Everything is typed in by hand. The file doesn't connect to your accounts, can't cancel anything and can't send reminders. Cancel-by dates are a reminder based on the notice days you choose. Check each service's own terms for its real deadline.
Not financial advice. The file only does math on the numbers you type in.
Everything is typed in by hand. There is no live data and no account connection. The sample data is made up, so you can delete it and enter your own.
Format: one .xlsx file. Open it in Excel, or upload it to Google Sheets. It uses only standard formulas that both support. No macros, no add-ons, no links to other files.
Delivery: instant download after checkout. The download link is also in your receipt email.
Questions or a problem with the file? Use this store's Contact page, or email the address in your receipt. If the file doesn't work for you, we'll fix it or refund you.
License: personal use. Use it for yourself and your household. Please don't resell, share or re-upload the file.
Built and tested with AI assistance.