Bill Tracker 2027
List every recurring bill with its amount, frequency, first due month and due day. The 12-month checklist highlights the months when each bill is due, you type x when it is paid, and the file totals what is due this year and per month.
Real screenshots of the file
Images of the file with example data. Tap an image to enlarge it.
What's inside
Linked sheets, with instructions on the first sheet.
A worked example
In the example six bills are listed, from rent to home insurance, and January is ticked.
Example data in the file, there to overwrite. Amounts use the currency symbol you set in Settings.
| Bills per month (equivalent) | 1,900.99 |
| Due this year, from each first due month | 22,811.88 |
| Annualised (per month × 12) | 22,811.88 |
| Rent: paid / due months | 1 / 12 |
| Car insurance, half-yearly from March: due months | 2 |
Getting started
- Settings: year, currency symbol and your categories.
- Bills: one row per bill with amount, frequency, first due month and due day.
- Type x in the checklist when a bill is paid: counts and totals update by themselves.
Compatibility and limits
Compatibility
- Plain .xlsx file, no macros, standard functions only.
- Tested by full recalculation in Excel for Microsoft 365.
- Calculations also checked in Google Sheets (upload the file to Google Drive).
- Not tested in Apple Numbers or Excel for Mac.
Good to know
- Entries are typed in; there is no bank connection.
- One year per file: for the next year, save a copy and clear the ticks.
- This template helps you organise your money; it is not financial advice.
Questions
What if a bill starts in March?
Set the first due month to 3: January and February are not counted as due, and the yearly total only includes the months from March.
Can I change the categories?
Yes, in Settings; the dropdown in Bills updates.
Will anything be posted to me?
No. It's a digital file you download from Etsy straight after purchase.