Monthly Bill Tracker Spreadsheet with Due Date Calendar
Every bill's due day on one calendar, a 12-month paid checklist, and late bills in red. Excel and Google Sheets.
$5 on its own, or get it with 12 more home money spreadsheets in the Complete Household Money Bundle for $29.
Works in Google Sheets and Excel · Instant download · Nothing shipped
What you get
Real screenshots of the actual tabs, taken from the same .xlsx file you download. All numbers are example data.
Who this is for
- You have a handful of monthly bills and want to see which day each one is due.
- You're fine typing an x when a bill is paid, in a 12-month checklist.
- You want one $5 file for Excel or Google Sheets, with no subscription.
Who it's not for
- Not for you if you want bank sync or automatic payment tracking.
- Not for you if you want phone reminders or notifications. It's a spreadsheet, not an app.
- Not ideal on Excel 2016: the calendar's bill-name column needs a newer Excel (totals still work).
Need more than one?
This sheet is one of the 13 in the Complete Household Money Bundle. Get all 13 home money spreadsheets for $29 (about $69 if bought one by one).
Get the bundle on Payhip – $29 See what's in the bundle
Need the home and the business sets? The Everything Bundle (what's inside) has all 22 (21 spreadsheets + the website template) for $39, about $149 if bought one by one.
Instant download. Works in Google Sheets and Excel.
Instant digital download, sold through Gumroad. Good for: bill tracker, bill organizer, monthly bills, bill calendar, google sheets, budget spreadsheet, excel template, bill planner, budget planner, personal finance.
2 separate spreadsheets (.xlsx files) in one zip: Monthly Bill Tracker v2, Monthly Bill Tracker. Each works in Excel and Google Sheets (import the .xlsx) and opens on a Start Here tab with a short how-to.
How it works
- Download the zip after checkout and unzip it.
- Open each .xlsx in Excel, or upload it to Google Drive and open it with Google Sheets.
- Delete the example rows and type in your own numbers.
Previews and the files use example data only.
What's inside
- List up to 40 bills with amount, due day, category, autopay and account notes.
- Due-date calendar shows which bills hit on each day of the month, with a running total.
- 12-month paid checklist: type x when paid. Unpaid bills past their due day turn red for the current month.
- Summary by category and by month (paid vs. planned) with a chart.
Good to know
- It's a spreadsheet, not an app. No bank syncing and no reminders/notifications.
- Comes with example rows. Delete them before you start.
- Excel 2016 shows an error in the calendar's bill-name column (it needs TEXTJOIN); totals still work.
Previews
Works in Google Sheets and Excel · Instant download · Nothing shipped
Try the free subscription cost calculator →
Try the free bill split calculator →
Try the free electricity cost calculator →
Try the free late fee calculator →
Frequently asked questions
Which apps does it open in?
Excel 2016 or newer (including Microsoft 365 and Excel for the web) and Google Sheets: upload the .xlsx to Google Drive, then open it with Google Sheets. You get one .xlsx file (Excel 2019+/Microsoft 365/Excel for the web, imports into Google Sheets) and a short how-to. Instant digital download.
What happens after checkout?
Gumroad emails you a receipt right after checkout; click View content in it to open your download page. You download a .zip with the .xlsx file(s) and a short how-to. It's an instant digital download; nothing physical ships.
Can I edit it?
Yes. Nothing is locked: rename categories, add rows, change colors and type over the example data.
Does it connect to my bank or send reminders?
No. It's a spreadsheet, not an app: you type in your own numbers and nothing is synced or sent.
Are the numbers in the previews real?
No. Previews and the file use example data only. Delete the example rows and add your own.
Can I get a refund?
It's a digital download, so if something doesn't open or work, reply to your Gumroad receipt and I'll help fix it. Refund requests are handled under Gumroad's refund policy. If you bought it on Payhip, message the shop there.
Is this financial advice?
No. It's an organizing and planning tool with example numbers, not financial, tax, legal or medical advice.
Works in Google Sheets and Excel · Instant download · Nothing shipped
Free guides that use this sheet
- Winter Heating Bill Budget: Plan Dec to Feb
- December Bills Calendar: Plan Holiday Bills by Payday
- How to Budget for Bills That Change Every Month
- How to Ask for a Late Fee to Be Waived (Script + Steps)
- How to Make a Bill Payment Calendar (Example Month)
- How to Lower Your Monthly Bills (Call Script + Checklist)
- How to Set Up Autopay Without Overdrafting
- How to Budget After a Job Loss (Bare-Bones Plan)
Pairs well with
Paycheck Budget Planner ($7)
Match each bill to the paycheck that covers it.
Not ready to buy? Start with the free Starter Budget Sheet.
See all Cedar & Ledger templates
Also see: Winter heating bill budget