Personal template
Bill payment tracker
Keep every recurring bill in one list with this month's due date, days left and a paid checkbox. Overdue and soon due bills light up automatically.
- Free
- No account needed to try
- Download as .xlsx
What's inside
Everything is a normal workbook once you open it: change the numbers, rename the sheets and make it yours.
2 sheets
- Bills
- Payment history
79 formulasTotals, lookups and checks are already worked out, so the sheet updates as you type. 330 filled cells in all.
Built in
- Conditional formatting
- Dropdowns
- Checkboxes
- Live dates
- Frozen headers
- 5 conditional format rules
A look at the Bills sheet
The top left of the first sheet, calculated by SheetsBat. Open the template to see all of it.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Bill payment tracker | |||||||
| 2 | Due dates roll to the current month. Tick Paid when a bill is done. | |||||||
| 3 | ||||||||
| 4 | DUE THIS MONTH | PAID | STILL TO PAY | NEXT DUE | OVERDUE | |||
| 5 | $2,700 | $1,968 | $732 | Nov 15 | 1 | |||
| 6 | ||||||||
| 7 | ||||||||
| 8 | Bill | Category | Amount | Due day | Due date | Days left | Autopay | Paid |
| 9 | Rent | Housing | $1,650.00 | 1 | Sun, Nov 1 | FALSE | TRUE | |
| 10 | Electricity | Utilities | $96.40 | 8 | Sun, Nov 8 | TRUE | TRUE | |
| 11 | Water and sewer | Utilities | $54.10 | 12 | Thu, Nov 12 | FALSE | TRUE | |
| 12 | Gas | Utilities | $61.75 | 15 | Sun, Nov 15 | 1 | TRUE | FALSE |
- bills
- due dates
- reminders
- household
More personal templates
PersonalHome renovation budgetCost out a renovation room by room with materials, labor and a contingency buffer. Track status and spending against what you can afford.
PersonalSubscription trackerList every subscription with its price and billing cycle to see the true monthly and yearly cost. Upcoming renewals are flagged so you can cancel in time.
PersonalHabit trackerTick off daily habits on a monthly grid. Progress toward each goal, the best streak and a daily score are calculated for you.
PersonalTo do listA clean task list with priorities, categories and due dates. Finished tasks are struck through and overdue ones turn red.
Start your bill payment tracker now
It opens in your browser in a second. Create a free account to save it, share it and open it anywhere.