A free printable bill tracker is a one-page table listing every recurring bill you owe — name, due date, amount, and a box to tick when it's paid. Print one copy per month, put it somewhere you see it daily, and no due date slips past you. The layout below is ready to copy into Google Sheets and print in about two minutes, and the print settings further down make it come out as a clean single page instead of the usual spreadsheet overflow mess.
Most printable-template sites hand you a decorative PDF and stop there. This page gives you the actual tracker as a copyable table, the exact setup to print your own version, and a worked example month so you can sanity-check yours against real numbers.
The Bill Tracker Layout (Copy This)
This is the whole tracker. Six columns, one row per bill per month:
| Bill | Due date | Amount due | Date paid | Amount paid | Paid |
|---|
| Rent | 1st | $1,450.00 | | | ☐ |
| Electric | 5th | | | | ☐ |
| Water/sewer | 8th | | | | ☐ |
| Internet | 10th | $79.99 | | | ☐ |
| Phone | 12th | $55.00 | | | ☐ |
| Car insurance | 15th | $118.40 | | | ☐ |
| Streaming | 18th | $15.49 | | | ☐ |
| Gym | 22nd | $29.00 | | | ☐ |
Two deliberate choices in this layout:
Fixed-amount bills get a printed amount; variable bills stay blank. Rent, insurance, and subscriptions are the same every month, so pre-printing the amount lets you spot a price increase the moment the statement arrives — if the electric company never sends the same number twice, that cell stays blank and you write it in. The tracker's job for variable bills is confirming the bill arrived and got paid, not predicting the amount.
"Amount paid" is separate from "amount due." This is the column most free printables skip, and it's the one that saves you. If you pay a credit card in two chunks, or the water bill was higher than usual, "date paid + amount paid" documents what actually left your account — which matters when a provider claims non-payment three months later.
Sort rows by due date, not alphabetically. The sheet then reads top-to-bottom as the month unfolds, and whatever's above today's date should already be ticked.
How to Print It from Google Sheets
- Open Google Sheets, paste or type the table, and bold the header row.
- Set column A (bill name) to about 2 inches wide; the rest can stay default.
- Set the font to 10 or 11 pt — anything larger pushes you to two pages.
- Go to File → Print and use these settings:
- Orientation: Portrait
- Scale: Fit to width
- Margins: Narrow
- Formatting: Show gridlines, repeat frozen row on each page
- Print one copy per month. Keep the sheet itself as the master so next month's copy takes ten seconds.
Twenty rows at 11 pt with narrow margins fits comfortably on one page — enough for the roughly 10–15 recurring bills a typical household carries, with spare rows for annual or quarterly bills the month they come due.
If you're already keeping your budget in a spreadsheet, the same table works as a tab inside your monthly budget template instead of a printout — same columns, checkbox cells instead of printed boxes.
A Worked Example: One Month on the Tracker
Here's a filled-in June for a two-person household so you can see what "done" looks like:
| Bill | Due date | Amount due | Date paid | Amount paid | Paid |
|---|
| Rent | 1st | $1,450.00 | Jun 1 | $1,450.00 | ☑ |
| Electric | 5th | | Jun 6 | $94.17 | ☑ |
| Water/sewer | 8th | | Jun 9 | $61.30 | ☑ |
| Internet | 10th | $79.99 | Jun 10 | $79.99 | ☑ |
| Phone (×2) | 12th | $110.00 | Jun 12 | $110.00 | ☑ |
| Car insurance | 15th | $118.40 | Jun 14 | $118.40 | ☑ |
| Streaming | 18th | $15.49 | Jun 18 | $18.49 | ☑ |
| Gym | 22nd | $29.00 | Jun 22 | $29.00 | ☑ |
Two things this example shows that an empty template can't:
The streaming row is the tracker earning its keep. Amount due said $15.49; the charge came through at $18.49. That's a quiet price increase — the kind that runs for a year before anyone notices. A pre-printed "amount due" next to "amount paid" makes a $3 jump visible in June instead of next April.
The monthly total is a number worth writing at the bottom. This household's fixed bills came to $1,961.35. Write yours in the margin each month. After three months you'll know your true fixed-cost floor — the number that decides how much of your income is actually discretionary, and the starting point for any zero-based budget.
Printable vs Spreadsheet vs App: Which Fits You
Paper is genuinely the right tool for some households and the wrong one for others. Pick on the number and type of bills, not on aesthetics:
| Printable tracker | Spreadsheet | Automated tracker |
|---|
| Setup time | 10 minutes | 30–60 minutes | 15 minutes + bank CSV import |
| Catches a missed payment | Yes — empty box is visible daily | Yes, if you open the sheet | Yes — compares actual transactions to expected bills |
| Catches a price increase | Yes, if you pre-print amounts due | Yes, with a variance formula | Yes, automatically |
| Works for variable bills | Write in amounts by hand | Formulas and history | Automatic, with categorization |
| Shared household | Fridge copy everyone sees | Shared Google Sheet | Shared, updates itself |
| History / trend analysis | Stack of paper | Strong | Strongest |
Paper's real advantage is frictionless visibility: it doesn't live behind a login, and an unticked box on the fridge is harder to ignore than a notification. Its ceiling is about 15 bills, all paid from one account, by one person who updates it.
When the Printable Version Stops Being Enough
Be honest about the upgrade signals, because each one is where paper starts hiding problems instead of exposing them:
You pay bills from more than one account. A printed sheet can't tell you whether the rent cleared the joint account or your personal one. That reconciliation step is exactly what bank-transaction tracking automates — see the complete guide to bank transaction categorization for how that works.
Your subscriptions keep changing price or multiplying. If the streaming row in the example above looked familiar, the fix is a periodic audit of what you're actually subscribed to, not a bigger piece of paper.
You're sharing bills with a partner or roommates. A fridge copy handles "did we pay it?" but not "who paid what, and who owes whom." At that point a shared spreadsheet setup pays for its setup time in the first month.
Quarterly cross-check, whatever you use: once every three months, compare your tracker against one month of actual bank transactions. Any charge on the statement that isn't a row on your tracker is a bill you're tracking by luck. This ten-minute check is the difference between a bill tracker and a bill hope tracker.
Related Articles
