Bill Tracker: Your Questions Answered
Clear, direct answers to the questions people ask most about the Bill Tracker — setup, categories, taxes, and automation — all in one place.
Get the Bill Tracker (Free)
We’ll email you a copy and open it in a new tab.
We’ll email you a copy and open the template in a new tab. No spam.
Getting started
How do I set up the bill tracker?
Copy the Google Sheet to your Drive, list each recurring bill with its name, amount, due date, and category, then either mark bills paid manually or connect Avery to mark them off automatically. Setup takes about 10 minutes.
What is a bill tracker?
A bill tracker is a structured sheet that lists every recurring bill you owe with its due date, amount, and whether it is paid yet. It gives you a single place to see what is due and when, so nothing slips through and you avoid late fees.
Can I use the bill tracker on my phone?
Yes. The Google Sheets mobile app opens the full tracker, so you can check what is due or mark a bill paid in about 20 seconds from anywhere.
Which bills should I add to the tracker?
Add every recurring obligation — rent or mortgage, utilities, phone and internet, insurance, subscriptions, loan and credit card payments, and any membership. The bills you forget are usually the small recurring ones, so list those too.
Due dates and never missing a bill
How do I make sure I never miss a bill?
Keep every bill in one list sorted by due date and check the calendar view weekly. Because the unpaid bills are grouped and dated in one place, the one you would normally overlook is always visible before its due date.
How does the monthly calendar view work?
The calendar view lays your bills out across the month by due date, so you can see at a glance which bills land in each week. It turns a flat list into a timeline, which makes it easy to plan around the heavy weeks.
How do I track which bills are paid versus unpaid?
Each bill has a paid or unpaid status you tick off as you pay it. The tracker totals what is still outstanding so you always know how much is left to cover this month.
Can it remind me before a bill is due?
The calendar and the sorted-by-date list act as your visual reminder when you check weekly. You can also add a Google Calendar event for each due date, or let Avery mark bills off as they clear so your only task is a quick weekly review.
Customizing it
Can I change the categories?
Yes — rename, add, or delete any category and the dashboard and totals update automatically. Group bills the way that makes sense to you, by type or by account.
Can I track bills for more than one person or household?
Yes. Add a column for whose bill it is, or duplicate the tab per person. Google Sheets lets you both edit in real time, so a couple can run one shared bill tracker.
Can I track annual or quarterly bills, not just monthly ones?
Yes. Log the bill with its real due date and frequency. Annual bills like insurance renewals or quarterly taxes sit in the list with their own dates, so they show up in the right month instead of being forgotten.
Can I see how much my bills cost over the whole year?
Yes. Because every recurring bill and amount is in one place, you can total them by month and across the year — which makes it easy to spot subscriptions worth cutting.
Automating with Avery
How does Avery keep the bill tracker updated?
Avery connects to your bank through a read-only link, imports every transaction, and matches payments to your bills — so a bill gets marked paid automatically when the matching charge lands. You just review weekly instead of ticking each one off by hand.
Can Avery tell which bills have actually been paid?
Yes. As transactions arrive, Avery matches them to the bills in your tracker, so paid bills get marked off and anything still unpaid stays visible. That makes the outstanding total trustworthy without manual reconciliation.
Is my financial data safe with Avery?
The tracker lives in your own Google Drive — you own it, not a third-party app. Avery's bank connections are read-only and bank-grade encrypted and can never move money. Two-factor authentication on your Google account adds another layer.
How much does Avery cost?
The template is free forever. Avery's automatic bank sync and AI categorization are a paid subscription with a free trial, so you can see the automated version of the tracker before paying.
Keep going