Efficiency Sheets
Simple Sheets
Bill Tracker Spreadsheet for Google Sheets
A bill tracker lists every bill once with its amount and due date, then gives you a paid checkbox for each month, so you can see in one look what's paid and what's still due. Sorting the list by due date is what stops late fees.
Example
A month of bills, sorted by due date
| Bill (due day) | Amount |
|---|---|
| Rent (1st) | $1,400 |
| Car loan (5th) | $310 |
| Phone (8th) | $65 |
| Internet (12th) | $60 |
| Electric (15th) | $95 |
| Car insurance (18th) | $120 |
| Streaming (20th) | $23 |
| Credit card (25th) | $150 |
| Gym (28th) | $35 |
| Bills this month | $2,258 |
On the 14th, four bills are ticked as paid ($1,835) and five are still due ($423), so you know exactly what the next paycheck has to cover.
How to set it up
- Write each bill down once with its amount and the day of the month it's due.
- Sort the list by due date.
- Each month, tick a bill off as you pay it.
- Check the month's total and what's still due before you spend anything extra.
- Use the quarterly tabs to log the date each bill was paid, so you have a record.
Questions
What bills should I track?
Everything that repeats: rent or mortgage, utilities, phone, internet, insurance, loans, credit cards, subscriptions and memberships.
What about bills that change each month?
Enter your usual amount and update it when the bill arrives, like electricity in summer.
Can I get reminders?
Google Sheets doesn't send reminders by itself. Most people check the tracker on payday, and set autopay for bills that never change.
