How to Track Bills and Due Dates in Google Sheets (So You Stop Wondering “Did I Pay That?”)

You're in the grocery line when it hits you: did you pay the internet bill? You pull out your phone, open the bank app, scroll, squint at the dates. Maybe. You think so. You can't tell.

It's a small moment, but it repeats every month, and it adds up to a low hum of “what am I forgetting?” This guide shows you how to build a bill tracker in Google Sheets that answers that question at a glance, and what you get once it's set up.

What changes once your bills live in one list

• You can answer “did I pay that?” in a few seconds instead of scrolling a bank app.
• You see what's due this week before it's due.
• Overdue bills stand out, so you notice them sooner.
• Your recurring bills stay separate from everyday spending, so both are easier to read.

I'd check my account, see a number that felt low, panic, then not look at it again for weeks.

If you've done that, you're not careless. When the information is scattered, looking at it feels bad, so it's natural to look away. A bill list you can read at a glance makes the checking a lot less painful.

A bill payment tracker in Google Sheets: build it yourself

Step 1: Start a Bills tab

Open a blank Google Sheet and name the first tab Bills. In row 1, add four headings: Bill, Due day, Amount and Paid?

Step 2: List every recurring bill, once

Rent, utilities, phone, internet, insurance, subscriptions, anything that comes around on a schedule. Write the due day as a number (rent due on the 1st is 1). Bills repeat every month, so a day of the month is easier to keep up than a full date, and you only write this list once.

Step 3: Add a Paid? dropdown

Click the Paid? column, choose Insert, then Dropdown, and add two options: Y and N. Start every bill at N. When you pay one, switch it to Y and enjoy that small win.

Step 4: Sort by due day

Select your list, choose Data, then Sort range, and sort by the Due day column from A to Z. Now your bill payment schedule reads in the order the bills come due.

Step 5: Make overdue bills impossible to miss

Select your list (for example A2:D50), choose Format, then Conditional formatting, and set the rule to Custom formula is. Paste this in and pick a fill color:

=AND($D2="N",$B2<DAY(TODAY()))

It colors any unpaid bill whose due day has already passed this month. The rule only looks at the current month, so set the Paid? column back to N when a new month starts.

Step 6: Check it once a week

Pick one day: payday, or Sunday morning. Look down the list, switch what you've paid to Y, and see what's due in the next few days. That one habit is what keeps the whole thing working.

It's just an extra way to visualize what is due when and how much.

The bill tracker that does the highlighting for you

The Bills tab in the Grab-and-Go Budget System is a monthly bill tracker that fills in its own status. You add each bill with its due day and expected amount, and choose Y when you've paid it. Here's what you get to see:

• Paid: you marked it Y.
• Due Soon: unpaid and due within 7 days.
• Overdue: unpaid and past its due date.
• Upcoming: unpaid and not due yet.

Below the list, the tab shows your paid and unpaid totals, how many bills fall due in the next 7 days and how many are already overdue. Open it on a Monday morning and the answer to “what's coming up?” is already there.

Bills and everyday spending stay on separate tabs on purpose. Recurring costs go on the Bills tab. The Expenses tab is your expense tracker for day-to-day spending, with budget vs actual for 8 categories and a chart. The Summary tab then shows money in, money out and money left for the month.

It's one Google Sheet with six tabs: Start Here, Income, Bills, Expenses, Accounts and Summary. You type in the white cells, and the green cells hold the formulas. If Google asks whether you really want to edit a green cell, that's the protection doing its job. Nothing is broken.

It costs $11.99 once, with no subscription and no bank login. You get a PDF access guide with your link and three steps to make your own copy, plus a backup Excel (.xlsx) copy. You'll need a free Google account to make your copy.

Not for: debt-payoff plans, savings-goal tracking, investing, business bookkeeping, or an app that connects to your bank. Not right for you? Email us within 30 days of buying to request a refund.

Bill tracker questions

What's the best way to track bills?

The best way is the one you'll check. A list sorted by due day with a Paid column works, and so does a sheet that flags what's due. What matters is looking at it on the same day each week.

Is there a bill tracker for Google Sheets?

You can build one with the steps above, or start from a ready-made sheet. The Grab-and-Go Budget System includes a Bills tab with automatic statuses as part of a full monthly budget.

How do I make a monthly bill tracker?

List each bill with its due day and amount, add a Paid column, and reset the Paid column at the start of every month. That's the whole system.

What's the difference between bills and expenses?

Bills are recurring costs with a due date, like rent, internet and insurance. Expenses are the day-to-day purchases, like groceries and gas. Keeping them separate makes both easier to read.

How often should I check my bills?

Once a week works for many people, and payday is a natural time to do it. Add a check on the 1st of the month to reset your Paid column.

Should I track the due day or the full due date?

For bills that repeat every month, the day of the month is enough. It also means you don't have to retype dates each month.

More: how to make a budget in Google Sheets and how to budget with a biweekly paycheck.

A budgeting tool for personal use, not financial or tax advice.