Can I customize the categories?
Yes. You can create, edit, and delete categories from the Categories page. Categories currently used by subscriptions cannot be deleted until those subscriptions are moved to another category.
Personal Finance template
Subscription & Recurring Bills Tracker
A simple Google Sheets + Apps Script web app for tracking subscriptions, recurring bills, upcoming payments, and payment history. Monitor monthly and yearly subscription costs, organize services by category, record payments, and quickly see which bills are due soon from a clean responsive dashboard.
subscription trackerrecurring bills trackerGoogle Sheets finance trackerApps Script bill trackersubscription managementrecurring payment trackermonthly billsexpense trackerpersonal finance
Template capabilities
What Subscription & Recurring Bills Tracker helps you automate
subscription tracker
Adapt this part of the workflow to your own Google Workspace files, fields, users, and operating process.
recurring bills tracker
Adapt this part of the workflow to your own Google Workspace files, fields, users, and operating process.
Google Sheets finance tracker
Adapt this part of the workflow to your own Google Workspace files, fields, users, and operating process.
Apps Script bill tracker
Adapt this part of the workflow to your own Google Workspace files, fields, users, and operating process.
Common use cases
Built for practical personal finance work
- Track personal streaming and software subscriptions
- Monitor recurring household bills
- Manage freelancer SaaS expenses
- Track small business software subscriptions
- See upcoming recurring payments
- Estimate monthly subscription spending
- Estimate yearly recurring costs
- Keep a history of paid recurring bills
- Identify subscriptions that should be paused or cancelled
- Organize subscriptions by category
How to use it
From access request to working automation
- 1
Make a copy of the Google Sheet
- 2
Open Extensions > Apps Script
- 3
Create the four required Apps Script files
- 4
Paste the provided code into each file
- 5
Run setupDatabase() once if needed
- 6
Authorize the Apps Script permissions
- 7
Deploy the project as a Web App
- 8
Open the Web App URL
- 9
Add or edit your subscriptions
- 10
Set price, billing cycle, and next payment date
- 11
Record payments when bills are paid
- 12
Review upcoming bills and payment history
- 13
Update reminder settings as needed
Setup checklist
Before using the template
Use the correct Google account
Create or copy the Google Sheet
Open the Apps Script editor
Add Code.gs
Add Index.html
Add Styles.html
Add Scripts.html
Save all project files
Run setupDatabase() if the sheets are not created automatically
Review the generated SUBSCRIPTIONS sheet
Review the generated CATEGORIES sheet
Review the generated PAYMENT_HISTORY sheet
Review the generated SETTINGS sheet
Authorize required Google permissions
Deploy as a Web App
Set Execute as: Me
Choose the appropriate access setting
Open and test the deployed Web App
Add a sample subscription
Test editing and deleting subscriptions
Test recording a payment
Test mobile and desktop layouts
FAQ
Questions about Subscription & Recurring Bills Tracker
What billing cycles are supported?
Weekly, Monthly, Quarterly, Semi-Annual, and Yearly.
Does it calculate monthly and yearly subscription costs?
Yes. The dashboard converts active subscriptions into estimated monthly and yearly recurring costs.
What happens when I record a payment?
A payment history record is created and the subscription's next payment date is automatically moved forward based on its billing cycle.
Can I track cancelled subscriptions?
Yes. Subscription statuses include Active, Paused, and Cancelled.
Does it process payments automatically?
No. This is a tracking application only. It does not connect to banks, credit cards, or payment gateways.
Can I change the currency?
The MVP is configured for USD. The settings structure can be extended if you want to support additional currencies.
Does it send email reminders?
No. The MVP uses visual Due Soon, Due Today, and Overdue indicators inside the dashboard.
Where is the data stored?
All application data is stored in Google Sheets.
Do I need an external database?
No. Google Sheets acts as the database.
Does the app require a login system?
No custom login system is included. Access is controlled through the Apps Script Web App deployment settings.
Can I use this for a small business?
Yes. It is suitable for individuals, freelancers, and small businesses that want to track recurring software, service, and subscription expenses.
Related templates
Continue exploring Apps Script automation
Finance & Billing Automation
Smart Invoice & Payment Reminder Tracker
A Google Sheets + Apps Script invoice tracker that helps freelancers, consultants, and small businesses create invoices, track payment status, send email reminders, and manage overdue payments. It solves the problem of forgotten invoices, late payments, and messy billing records.
CRM & Sales Automation
Lightweight CRM + Follow-Up Automation
A lightweight CRM built with Google Sheets and Apps Script to manage leads, clients, status pipelines, notes, and automated follow-up reminders. It helps freelancers, agencies, and small businesses keep track of prospects and improve response consistency. It solves the problem of lost leads, forgotten follow-ups, and disorganized client data.
Booking & Scheduling
Appointment Booking + Email Reminder System
A booking and scheduling app built with Google Sheets and Apps Script that helps service businesses manage appointments, customer details, time slots, and automatic email reminders. It helps reduce no-shows, keeps bookings organized, and makes scheduling easier. It solves the problem of manual appointment handling and forgotten reminders.