Bill Tracker in Google Sheets: Never Miss a Due Date
How to track every bill with its due date and a paid checkbox in Google Sheets, flag bills due in the next few days, and see what's still left to pay this month.
Efficiency Sheets ·
Late fees usually come from forgetting, not from not having the money. A bill tracker puts every bill, its due date and whether it's paid in one place, so you can check in once a week and know nothing is slipping.
What to track for each bill
- Name of the bill
- Amount
- Due date
- Paid this month (a checkbox)
- Date paid
- How it's paid: autopay, card, bank transfer
Setting it up in Google Sheets
Put bills in rows: name in A, due date in B, amount in C. Select column D and use Insert → Checkbox for the paid box.
Total of all bills this month:
=SUM(C2:C30)
What's still left to pay:
=SUMIF(D2:D30,FALSE,C2:C30)
How many bills are still unpaid:
=COUNTIF(D2:D30,FALSE)
Highlight bills that are due soon
Select the bill rows, then Format → Conditional formatting → Custom formula is:
=AND($D2=FALSE,$B2-TODAY()<=3,$B2>=TODAY())
Pick a highlight colour. Any unpaid bill due in the next three days now stands out when you open the sheet. Add a second rule for overdue bills:
=AND($D2=FALSE,$B2<TODAY())
A full year at a glance
For recurring bills, a year view helps: one row per bill and one checkbox column per month, January to December. You can see at a glance which months are fully paid, and spot a bill you forgot in March before it turns into a late fee.
Make it a weekly habit
Pick one day a week, Sunday works for many people, and spend five minutes ticking off what's been paid and looking at what's due in the next seven days.
A ready-made version
The Bill Payment Tracker has an annual tracker with a paid checkbox for every bill for every month, four quarterly tabs that log the date paid and total each month, and a one-month view.
Questions
Can Google Sheets remind me when a bill is due?
It can highlight bills that are due soon when you open it, using conditional formatting. It won't send a notification on its own, so pair it with autopay or a calendar reminder for the most important bills.
Should I track bills on autopay?
Yes. Autopay can fail or charge the wrong amount, and you still need the money in the account. Tick them off when you see the charge.
How is a bill tracker different from a budget?
A budget plans all your money. A bill tracker focuses on due dates and whether each bill is paid. Many people use both.
What about bills that change every month?
Enter the expected amount, then update it when the real bill arrives. Utilities are the usual example.
The Bill Payment Tracker
$11.97 · one-time · instant download