Google Sheets and Excel · version 1.0
Bill Tracker
Know what is paid, what is due and what is late.
Type each bill one time: name, amount, due day and how often. Every month the sheet puts your bills in due-date order, marks each one paid, due soon or late, and adds up what you still owe before payday.
Pay on Etsy. Download right after you pay.
- Works on your phone with the free Google Sheets app
- Also Microsoft Excel 2010 or newer
- Something not working? Tell us and we fix it
How it works
- 1
MY BILLS
Add each bill once: name, amount, due day and how often it comes. Room for 25.
5 minutes, one time
- 2
THIS MONTH
Type the date of your next paycheck.
10 seconds
- 3
YEAR
When you pay a bill, pick Yes under that month.
5 seconds
Then check THIS MONTH. Every bill says Paid, Due today, Due in a few days or Late.
See it
What's inside: 4 tabs
- START HERE
- The 3 steps and an "Is everything OK?" line.
- MY BILLS
- Up to 25 bills with category, usual amount, due day, how often and autopay. On top: what your bills cost in a year and in a typical month, and totals by category.
- THIS MONTH
- Any month you pick, or this month if you leave it empty. Each bill with its due date, amount, paid and status. Totals for the month, paid, still to pay, late, and the amount due before payday.
- YEAR
- The 12 months side by side. A Yes box for each bill in each month, and totals for each month and the year.
Made to be easy
- You only type in the yellow boxes. Ten example bills show how it works.
- The sheet sorts your bills by due date for you.
- One line tells you what to pay next, like "Pay $390.00 before payday (Oct 30)".
- Late bills turn orange, so they jump out.
- Monthly, every 3 months or once a year: each bill shows up only in the months it is due.
- Due on the 31st? In shorter months it moves to the last day.
- Typos get an orange "Check" note, like a due day of 35.
What it counts
- Room for 25 bills
- A status for each bill: paid, due soon or late
- The amount to pay before your next payday
- What is still to pay this month
- Your bills for a year, and for a typical month
- 12 months on one tab
What you get
- Bill_Tracker.xlsxThe light version, with 10 example bills
- Bill_Tracker_Dark.xlsxThe same sheet with a dark look. Pick the one you like
- Quick Start Guide (PDF)Short plain-English steps, and buttons that make your own copy in Google Sheets
Works on
- Google Sheets (free), on your phone or computer. The guide has buttons to make your own copy.
- Microsoft Excel 2010 or newer.
- No macros. No add-ons. No account with us.
What it does not do
- It does not pay bills or send reminders, and it has no bank link. You type your own bills.
- Not financial advice. It does the math on your month.
Want every due date in one list?
$1.98. Pay once and download right away. Open the guide, make your copy, type your bills. About 5 minutes.
Questions people ask
How do I get the files?
This is a digital download. Nothing is shipped. After you pay on Etsy, download the files from your Etsy account (Purchases). Open the PDF guide first.
Does it work on my phone?
Yes. Use the free Google Sheets app. The guide has buttons to make your own copy, light or dark. It also works in Microsoft Excel 2010 or newer.
How does "before payday" work?
Type your next payday. The sheet adds up this month's bills that are not paid yet and are due before that date. Late bills are in the total too.
Can I add a bill I pay every 3 months, or once a year?
Yes. Choose how often and the month it is due. It shows up only in those months.
Will it pay my bills or email me?
No. It is a sheet you open when you want to check. It shows what is paid, due soon or late. It does not connect to your bank.
Something is not working. What do I do?
Send us a message on Etsy. We answer and fix it. If we can't, we review your case for a refund.
Good to know
- The bills inside are examples. Type yours over them.
- Paid a different amount one month? Type it there, and the totals use it.
- This is a planning tool. It is not tax, legal or financial advice.
- Single-user license: for you and your home. Please do not resell or share the files.
- We design every spreadsheet. We use AI tools to help write and test some formulas and text. Every formula is tested before sale.