Organization
·

Subscriptions are designed to be forgotten. A free trial turns into a monthly charge, a yearly renewal arrives without warning, and bills land on different days every month. A bill and subscription tracker in Google Sheets puts all of it on one page, with the real monthly cost and the next due date for everything you pay.
Quick answer: To track bills and subscriptions in Google Sheets, list each one with its amount, billing cycle and start date. Convert every cycle to a monthly cost with a SWITCH formula, calculate the next due date, and highlight anything due in the next seven days. Add a checkbox for paid. The Budget Planner includes a subscription tracker for up to 15 subscriptions and a bill calendar with checkboxes.
Why track bills and subscriptions in one sheet?
Bills are usually fixed and essential, like rent, phone and insurance. Subscriptions are smaller and easier to forget, like streaming, apps and memberships. Together they make up your fixed costs, and knowing that number is the foundation of any budget.
Seeing everything in one list also makes cancelling easier. When the monthly total is in front of you, it’s obvious which services you don’t use.
The columns you need
Name: The bill or service.
Amount: What you pay each cycle.
Cycle: Weekly, Biweekly, Monthly, Quarterly or Yearly.
Start or last paid date: Used to calculate the next due date.
Next due: Calculated by the sheet.
Monthly cost: Calculated by the sheet.
Paid: A checkbox for this month.
Notes: Account, card used or cancellation link.
How to build the tracker in Google Sheets
Add the headers above in A1 to H1.
Make a cycle dropdown. Select C2:C30 and use Data > Data validation with Weekly, Biweekly, Monthly, Quarterly and Yearly.
Calculate the monthly cost. In F2 enter
=SWITCH(C2,"Weekly",B2*52/12,"Biweekly",B2*26/12,"Monthly",B2,"Quarterly",B2/3,"Yearly",B2/12)and fill down. A yearly $120 plan becomes $10 a month, which makes it easy to compare.Find the next monthly due date. For monthly bills,
=EDATE(D2,DATEDIF(D2,TODAY(),"M")+1)returns the next due date after today. For quarterly bills use multiples of three months, and for yearly ones use=EDATE(D2,12*(DATEDIF(D2,TODAY(),"Y")+1)).Count the days left. In a spare column,
=E2-TODAY()shows days until each payment.Highlight what’s due soon. Select A2:H30, open Format > Conditional formatting, choose Custom formula is and enter
=AND($E2-TODAY()>=0,$E2-TODAY()<=7)with a soft yellow fill.Add paid checkboxes. Select G2:G30 and choose Insert > Checkbox.
Totals. Monthly fixed costs:
=SUM(F2:F30). Yearly:=SUM(F2:F30)*12. Still to pay this month:=SUMIF(G2:G30,FALSE,B2:B30).

A 10-minute subscription audit
Once your list is in, do this once:
Sort by monthly cost, highest first.
Mark each one as Love, Use sometimes or Forgot about it.
Cancel the “forgot” list today, while you’re thinking about it.
Downgrade the “sometimes” list to cheaper plans or yearly billing if you’ll keep it.
Set a calendar reminder a week before any yearly renewal.
The ready-made option: the Budget Planner
The Budget Planner handles bills and subscriptions inside a full budget. Its Subscription Tracker holds up to 15 subscriptions with weekly, biweekly, monthly or quarterly terms, and calculates renewal dates and the monthly total for you.
The Calendar and Checklist tab lets you add bills, subscriptions and to-dos to their day and tick them off as you pay. Days with a task highlight automatically. On the main dashboard, bills show their due dates with checkboxes for paid vs. remaining, next to your income, expenses, debt and savings. Adding your bills to the calendar takes about five minutes at the start of each month.
Bill tracker vs. bank alerts vs. apps
Bank alerts: Useful, but they tell you after money leaves. A tracker shows what’s coming.
Subscription apps: Some connect to your bank and find subscriptions for you, but many charge a fee and need account access.
Google Sheets: Private, free to build and always in your control. You enter things yourself, which also keeps you aware of what you pay.
Frequently asked questions
How do I track subscriptions in Google Sheets?
List each subscription with its amount, billing cycle and start date. Convert each cycle to a monthly cost with a SWITCH formula and total the column.
How do I calculate the next due date in Google Sheets?
For monthly bills, use =EDATE(start,DATEDIF(start,TODAY(),"M")+1). It adds whole months to the start date until it passes today.
How do I highlight bills due this week?
Use conditional formatting with =AND($E2-TODAY()>=0,$E2-TODAY()<=7), where column E holds the due date.
Can I track bills on my phone?
Yes. Tick bills as paid in the Google Sheets app.
How many subscriptions does the Budget Planner track?
Up to 15 subscriptions with weekly, biweekly, monthly or quarterly terms, plus bills on the calendar and dashboard.
The bottom line
A bill and subscription tracker turns surprise charges into a calendar you can plan around. Build the simple version above, or get a full budget with bills, subscriptions, debt and savings in the Budget Planner. If you’re setting up the rest of your budget too, see how to make a monthly budget in Google Sheets. New here? Enter code WELCOME20 at checkout for 20% off your first order.
