Bill Tracker Spreadsheet & Printable
A bill tracker spreadsheet that shows every due date, what is paid and what is still left to pay, for all 12 months. Enter each bill once and tick it off when you pay it.
- Bill List: type each bill once (monthly, quarterly or yearly)
- 12 month tabs: pick ✓ when a bill is paid
- Overdue and due-soon bills change color on their own
- Dashboard: paid, left to pay and overdue for any month
- Bill calendar with every bill on its due day
- Yearly overview by category, with a chart
- 3 color themes: Classic, Neutral and Dark
- 20-page printable planner (US Letter PDF)
Secure checkout by Lemon Squeezy · Download right after payment
What is inside the Bill Tracker
The spreadsheet has 17 tabs. Start Here explains the three steps and holds your year, your categories and the accounts you pay from. On Bill List you type each bill once: its name, category, due day, amount, how often it comes (monthly, every 2 months, quarterly, twice a year or yearly) and whether it is on autopay.
Every bill then appears on its own in the right month tabs (Jan to Dec). A yearly bill due in March only shows up in March, and a quarterly bill shows up every third month. In each month you pick ✓ in the Paid column when you pay. If the amount was different, for example a higher electric bill, type the real amount in Actual and the difference is added up for you. The status column says Paid, Due soon or Overdue without you doing anything.
Dashboard, calendar and yearly overview
The Dashboard shows the month you pick: total bills, how much is paid, what is left to pay, anything overdue, a paid-so-far bar and a chart by category. The Bill Calendar puts every bill on its due day in a normal month grid, so you can see busy weeks at a glance. The Yearly Overview adds up all 12 months by category, so you know what your bills really cost in a year.
Excel, Google Sheets or paper
The download has the same spreadsheet in three color themes (Classic, Neutral and Dark). It works in Microsoft Excel and in Google Sheets with a free Google account. You only type in the yellow cells; every formula is already built in. If you like paper, the 20-page printable planner has a bill list, 12 monthly pages, a yearly tracker, a non-monthly bills page, a blank bill calendar and a bill contacts page.
Paying bills on time starts with knowing what you owe and when. The U.S. Consumer Financial Protection Bureau suggests listing every bill with its amount and due date and checking the list each week; this tracker does exactly that and adds up the totals for you.
Who it is for
It suits anyone who has paid a bill late because it slipped their mind, couples who share household bills, and anyone who wants one simple place to see where the money goes each month. Example bills are filled in so you can see how it works; type over them or clear them and start with your own.
Not ready to buy? Start with the free printable Monthly Bill Checklist.
Questions
Does this bill tracker work in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets, or open it in Microsoft Excel on a computer. All formulas and dropdowns work in both.
Can it track bills that are not monthly?
Yes. Set How often to every 2 months, quarterly, twice a year or yearly, and pick the first month. The bill then appears only in the months it is due.
Do I need to know formulas?
No. Type only in the yellow cells. Totals, status, the dashboard, the calendar and the yearly overview update on their own.
Can I use it again next year?
Yes. Change the year on the Start Here tab, clear the ✓ marks, and all dates move to the new year.
What do I get after I buy?
An instant download: the spreadsheet in 3 color themes and the 20-page printable PDF, plus access any time from My downloads with the email you used at checkout.