Bill Tracker Template for Google Sheets (Free, 2026)

Late fees are rarely a money problem. Most of the time the cash was there — the bill just got buried under a dozen others arriving on different days, from different accounts, through email, app, and mail. The fix is not a bigger budget; it is a single place to see every bill, when it is due, and whether it is paid. That is exactly what a bill tracker in Google Sheets does, and this guide gives you a free template plus a simple system to keep it current.

What a bill tracker actually is

A bill tracker has four moving parts for every bill:

1. Name — what the bill is (rent, electricity, phone, that streaming subscription).
2. Amount — what you owe, fixed or variable.
3. Due date — the day it has to be paid by.
4. Status — paid or unpaid this cycle.

Everything else is presentation. Once those four columns exist for every recurring bill, the tracker can sort by due date, total what is still outstanding, and lay the month out as a calendar. The single most useful output is simple: what is due next, and have I paid it.

A bill tracker is different from a budget. A budget plans how much you intend to spend by category; a bill tracker is an operational checklist of fixed obligations and their deadlines. They work best side by side — your fixed bills feed straight into the Monthly Budget template, while the tracker makes sure each one is actually paid on time.

Why Google Sheets is the best home for it

You can track bills on paper, in a notes app, or in your bank's reminders. Google Sheets hits the sweet spot:

• Free and cloud-based. No license, and it auto-saves so you never lose your list.
• Works everywhere. Update it on your laptop, check what is due on your phone with the Sheets app.
• Easy to share. A partner can see and edit the same bill list in real time — no "did you pay the internet?" texts.
• Automatable. It connects to Avery, which matches your bank transactions to your bills and marks paid ones off, so the tracker stays current without manual ticking.

That last point is the difference between a bill tracker you abandon after two weeks and one that is still saving you from late fees a year later.

How to make a bill tracker in Google Sheets (step by step)

You can build one from scratch, but starting from a template means the columns, totals, and calendar view already work. Here is the full process either way.

Step 1: List every recurring bill

Go account by account and write down every recurring charge. The bills you forget are almost always the small, automatic ones, so be thorough. A complete starter list:

• Rent or mortgage
• Electricity, gas, and water
• Internet and phone
• Insurance (auto, renters, health, life)
• Streaming and software subscriptions
• Gym and memberships
• Loan payments
• Credit card minimums (or full balance)

For each, record the name, the amount, and who or what account it comes from.

Step 2: Add a due date to every bill

This is the column that prevents late fees. Enter the day of the month each bill is due. For variable bills like utilities, use the typical due date and update the amount when the statement arrives. Then sort the list by due date so your bills read top to bottom in the order they actually come due.

Step 3: Add a paid or unpaid status

Give every bill a status column you tick off as you pay. A small conditional format helps here — turn a row green when it is marked paid and leave unpaid rows plain, so the outstanding bills stand out at a glance. This is the column you will trust most, so keep it honest.

Step 4: Add the totals and a calendar view

A few formulas turn the list into a dashboard:

• Total due this month — =SUM() of every bill's amount.
• Total paid — =SUMIF() on the status column where it equals paid.
• Still outstanding — total due minus total paid.

Then lay your bills across a simple month grid by due date for the calendar view. Seeing which week carries the heavy bills lets you plan cash flow instead of being surprised by a cluster of due dates.

A sample bill tracker walkthrough

It is easier to picture the system with real numbers. Imagine a single household with these recurring bills, all in USD, sorted by the day of the month they come due:

The totals row at the bottom reads $2,172 due this month, $0 paid, $2,172 outstanding. As bills clear, the status flips to paid and the outstanding figure falls — so on the 16th, with everything through electricity paid, the tracker shows $2,008 paid and $164 still to go (the streaming bundle, gym, and credit card minimum).

Two things jump out the moment the list is laid out this way. First, the heaviest week is the first week of the month: rent, insurance, and internet land within eight days of each other and total nearly $1,850. If payday is the 1st, that is fine; if it is the 15th, that cluster is a cash-flow problem worth fixing by moving a due date. Second, the electricity figure is the only one that will change next month, so it is the only row that needs attention when the new statement arrives. Everything else simply resets to unpaid. That is the whole value of the tracker in one screen: it tells you what is due, when the pressure points are, and where your attention actually needs to go.

How to set up a monthly bill calendar

The list view answers "what is due"; the calendar view answers "when, across the whole month." Both read from the same rows, but the calendar is what makes a cluster of due dates visible before it becomes a cash crunch.

To build one, lay out a simple grid of the month — four or five week rows, seven day columns — on a second tab or beside your list. Then place each bill on the day it falls due, with its amount next to the name. In the sample above, the first row of the calendar is crowded ($1,650 + $128 + $70) while the back half of the month is light. That imbalance is the single most useful thing a calendar surfaces.

You do not have to position every bill by hand. A small formula can pull each bill onto the right day by matching its due date, or you can colour-code the days: green where nothing is due, amber for a normal day, red for a day carrying more than, say, $200. The exact mechanism matters less than the habit it creates — one glance each week at a month-shaped picture instead of scrolling a flat list. Pair the calendar with the weekly review below and the bill you would otherwise forget is always on screen days before its deadline.

How to never miss a bill: organizing due dates

A tracker only prevents late fees if it is part of a routine. Here is the system that works.

Sort by due date, always

A bill list sorted alphabetically hides your next deadline. A list sorted by due date puts it first. Keep the sort live so the bill due soonest is always at the top, and the unpaid ones are grouped where you can see them.

Check the calendar view weekly

Put a recurring ten minutes on your calendar — Sunday evening works well — to scan the calendar view for anything due in the next week. Mark off what you have paid, schedule what you have not, and you are done. The whole point is to surface the one bill you would otherwise forget, before it is late.

Group due dates where you can

If a biller lets you choose your due date, line up bills to land a few days after payday. Clustering your bills into one or two predictable windows each month makes the tracker easier to manage and your cash flow steadier.

Separate fixed from variable bills

Fixed bills (rent, subscriptions) stay the same every cycle, so once they are in the tracker they need almost no attention. Variable bills (electricity, water, credit cards) change, so flag those and update their amounts when the statement lands. Knowing which is which tells you where to spend your weekly review time.

What to put in each column

The strength of a bill tracker is that it is structured the same way every time, so nothing is left to memory. A few columns earn their place:

• Bill name. Be specific. "Insurance" is three different bills; "Auto insurance," "Renters insurance," and "Health insurance" are three rows you will not confuse.
• Amount. Enter the exact figure for fixed bills and your best estimate for variable ones, then correct it when the statement lands. The estimate is what keeps your outstanding total realistic.
• Due date. The single most important column. Use the day of the month so the list sorts cleanly.
• Status. Paid or unpaid this cycle — the column you act on every week.
• Account or payment method. Knowing whether a bill hits your checking account or a credit card helps you anticipate cash flow and spot a card you forgot to pay down.
• Category. Group bills as housing, utilities, subscriptions, debt, and so on, so you can total each type and see where your fixed costs really go.
• Notes. A free-text column for confirmation numbers, "cancel before renewal," or "rate goes up in March." Small reminders that save a phone call later.

You do not need every column on day one. Name, amount, due date, and status are enough to stop the late fees; the rest add detail as your tracker matures.

Fixed, variable, and annual bills

Most guides split bills into two buckets — fixed and variable — but there is a third that quietly causes the most damage: the annual bill. Sorting your rows into all three changes how much attention each one needs.

• Fixed bills are the same every cycle: rent, the streaming bundle, the gym, a loan payment. Enter them once and they need no upkeep beyond ticking them paid. They are the backbone of the list and the easiest to automate.
• Variable bills change month to month: electricity, water, gas, and any credit card you do not pay in full. Flag these rows so you know to update the amount when each statement arrives. Until the real figure lands, your best estimate keeps the outstanding total honest.
• Annual and irregular bills hit once or twice a year and are the ones people forget entirely: auto-insurance renewals, an annual software subscription, property tax, a domain renewal, a yearly membership. A $360 annual charge is easy to overlook for eleven months and then ruins a budget in the twelfth.

The fix for annual bills is to convert them to a monthly figure even though they only charge once. A $360 yearly renewal is $30 a month — so set aside $30 each month in a sinking-fund row, and the bill is fully covered before it ever lands. You can keep a separate "annual bills" section in the tracker that lists each yearly charge, its renewal month, and the monthly amount you are setting aside. When the renewal arrives, the money is already there and the charge is a non-event instead of a shock. Knowing which of the three types a bill is tells you exactly how much of your weekly review it deserves: fixed bills almost none, variable bills a quick amount update, and annual bills a standing monthly set-aside.

A simple monthly routine

The best bill tracker is the one tied to a habit, not the one with the most features. Three short rhythms keep it useful:

1. Once a month, refresh the list. When statements arrive, update variable amounts and reset every status to unpaid for the new cycle. Five minutes.
2. Once a week, review and pay. Open the calendar view, pay anything due in the next seven days, and mark it off. Ten minutes.
3. Once a quarter, prune. Scan for subscriptions you no longer use and bills that crept up in price. Because every recurring cost is in one place, this is where a bill tracker quietly saves you real money.

That is the whole system. It is deliberately small, because anything heavier gets abandoned — and an abandoned tracker is exactly how the late fee finds you.

Common bill-tracking mistakes

A few patterns turn a working tracker into a stale one:

• Tracking only the big bills. Rent is rarely the one you forget. It is the $12 subscription that renews quietly. List everything, however small.
• Leaving due dates blank. A tracker without due dates is just a list. The dates are what let it warn you in time.
• Never marking bills paid. If the status column is not maintained, the outstanding total lies to you and you stop trusting it. This is the exact failure point automation removes.
• Letting it drift from reality. Prices change, subscriptions get added, accounts switch. A monthly refresh keeps the tracker honest enough to rely on.

Most of these come back to the same root cause: manual upkeep is tedious, so it lapses. Building the upkeep into a routine — or handing it to automation — is what makes the difference.

Bill tracker vs. autopay vs. an app

People often ask whether a tracker is even necessary if everything is on autopay. Here is the honest comparison:

Autopay prevents the missed payment but hides the bill — you only find out about a price hike or a forgotten subscription after the money is gone. A tracker gives you visibility before the charge. The two work best together: autopay the bills you trust, track all of them, and review weekly.

Automating paid and unpaid status with bank sync

The status column is the one you act on every week and the first one to go stale, so it is the natural thing to automate. Here is what that actually looks like in practice.

When your bank is connected, every transaction flows into the sheet as it clears — the merchant, the amount, and the date. A paid bill is simply a transaction that lines up with a row in your tracker: an $70 charge from your internet provider around the 8th is your internet bill, paid. Matching on the merchant name plus an approximate amount and date is enough to flip that row from unpaid to paid without you touching it. Variable bills match the same way; the amount that clears becomes the real figure for the month, so your outstanding total corrects itself instead of relying on an estimate.

Two cases are worth understanding because they are where manual trackers usually break:

• A bill that did not clear. If the due date passes and no matching transaction has arrived, the row stays unpaid and stands out — which is exactly the warning you want before a late fee, not after.
• A charge you did not expect. A price hike or a subscription you forgot shows up as a transaction with no matching bill row, so it surfaces instead of slipping through. That is the silent renewal a pure autopay setup would have hidden.

You still decide the rules — which categories count, how loose the amount matching is, what to do with a charge that does not match. But the tedious part, ticking dozens of boxes by hand, is handled. The result is a status column you can trust at a glance, which is the only version of a bill tracker that survives past the first busy month. That is what Avery does with a read-only bank link.

Keeping the tracker current (the part that matters)

Here is the uncomfortable truth about every bill tracker: the paid statuses go stale the moment you stop ticking them off. A tracker full of "unpaid" rows that are actually paid is worse than no tracker, because you stop trusting it.

That is the problem Avery solves. Connect your bank with a read-only link and Avery:

• Imports every transaction automatically.
• Matches payments to your bills, so a bill is marked paid the moment the charge clears.
• Keeps the outstanding total live, so what is left to pay is always accurate.

You go from "tick off every bill by hand" to "glance at the tracker once a week." The statuses stay true, which is the only thing that makes a bill tracker worth keeping.

Related templates and guides

• Bill Tracker template — the free Google Sheet this guide is built around.
• Bill tracker Q&A — quick answers to the most common setup and due-date questions.
• Monthly Budget template — plan the whole month so your bills always have a home.
• Budget Spreadsheet template — a flexible budget to pair with your bill list.
• Expense Tracker template — a dedicated spending log alongside your fixed bills.
• Free monthly budget template guide — the companion walkthrough for monthly budgeting.
• Browse all free templates — the full Avery library.

A bill tracker gives you visibility; automation keeps it honest. Start with the free template, add your bills, and let Avery mark off what you have paid — so the tracker is still catching late fees in month six, not gathering dust.