PERSONAL FINANCE · BILLS
How to Keep Track of Bills So You Never Miss a Due Date
Keeping track of bills comes down to three things: one complete list, a calendar of due dates, and a routine to check it. Here is how to set that up in a spreadsheet, how to match bills to your paychecks, and a calculator that shows which half of the month is your tightest.
THE SHORT ANSWER
The simplest way to keep track of bills
Why bother: payment history makes up 35% of a FICO Score, the largest single factor. A card issuer can charge a late fee as soon as a payment is late, and a late payment is generally reported to the credit bureaus once it's 30 days past due.
STEP 1
Make a list of every bill you pay
Pull the last two or three months of bank and card statements and write down every recurring charge. People usually forget the small and the yearly ones, which are exactly the bills that end up late.
| Type | Examples | Easy to miss because |
|---|---|---|
| Housing | Rent or mortgage, HOA, renters or home insurance | Insurance is often yearly or twice a year |
| Utilities | Electric, gas, water, trash, internet, phone | Amounts change every month |
| Transportation | Car payment, car insurance, registration, transit pass | Registration is once a year |
| Debt | Credit cards, student loans, personal loans, buy now, pay later | Each card has its own due date |
| Subscriptions | Streaming, apps, cloud storage, gym, memberships | Small charges on different cards |
| Health and family | Health insurance, childcare, tuition, medications | Some come out of your paycheck, some don't |
| Yearly and irregular | Domain renewals, warehouse club, property tax, tax payments | Not on a monthly statement at all |
For each bill, record six things: name, amount, due day, frequency, how it's paid (autopay or manual) and which account it comes from. Yearly bills are best handled as sinking funds: divide the amount by 12 and set it aside every month.
BILL CALENDAR CALCULATOR
See your bills by due date
BILL DUE-DATE CALCULATOR
Which half of the month is tighter?
Enter monthly amounts and due days (1–31). Leave a bill at 0 if you don't have it. The calculator totals your bills, splits them into the 1st–14th and the 15th–end of the month, and lists them in calendar order.
A planning aid, not financial advice. A due day of 29–31 falls on the last day in shorter months. Results stay in your browser.
With the defaults, bills total $2,650 a month, and $2,225 of it (84%) is due between the 1st and the 14th, mostly because rent and the car payment land in the first week. If you're paid twice a month, that's the paycheck that has to carry most of the load.
STEP 2
Match bills to your paychecks
Missed bills are often a timing problem, not a money problem: the money arrives on the 15th, the bill was due on the 12th. Three fixes:
- 1
Assign each bill to a paycheck
Put a "Paycheck" column next to each bill: Paycheck 1 covers bills due before the second payday, Paycheck 2 covers the rest. If you're paid every two weeks, see how to budget biweekly paychecks.
- 2
Ask to move a due date
Many card issuers, utilities and lenders let you change the due date, often online. Moving one or two bills to the second half of the month can even out the split.
- 3
Keep a one-month buffer
Once a full month of bills sits in checking, the payday timing stops mattering. Build it slowly: a little each payday until it's there.
DO IT YOURSELF
How to make a bill tracker in Excel or Google Sheets
- 1
Create the columns
Bill, Amount, Due day, Frequency, Paid with, Paycheck, Paid (checkbox). In Excel, insert a checkbox from the Insert tab (newer Microsoft 365 versions) or use a Yes/No dropdown; in Google Sheets, Insert › Checkbox.
- 2
Calculate this month's due date
Put the month you're tracking in a spare cell, say
J1, as a date (for example 1/1/2027). Add a Due date column in H; with the due day in column C, the formula below gives the real date and handles short months. - 3
Total what's still unpaid
=SUMIF(G:G, FALSE, B:B)adds up the bills whose Paid box is unchecked, so you always know what's still coming this month. - 4
Highlight what's due soon
Conditional formatting on the due-date column: a custom formula rule like
=AND($G2=FALSE, H2-TODAY()<=3)colors bills that are unpaid and due within three days.
EOMONTH finds the last day of the month, so a bill due on the 31st shows on the 30th in April and the 28th or 29th in February. Works in both Excel and Google Sheets.AUTOPAY OR MANUAL?
Should you put every bill on autopay?
| Bill | Good fit for autopay | Watch out for |
|---|---|---|
| Fixed amounts: rent, car, loans, insurance | Yes | Make sure the money is in the account a few days before |
| Credit cards | Yes, at least the minimum | Pay the full statement balance when you can to avoid interest |
| Utilities that change monthly | Often | Check the amount each month for spikes or billing errors |
| Subscriptions | They're automatic anyway | Review the list every few months and cancel what you don't use |
| Tight months, uneven income | Manual can be safer | Overdraft fees if autopay hits an empty account |
Autopay removes the "I forgot" problem, but not the tracking. Keep the bills on your list either way and mark them paid when they clear.
READY-MADE TEMPLATES
Skip the setup: bill tracker spreadsheets
If you'd rather start with the calendar already built, our bill calendar tracker works in Excel and Google Sheets. Check the product page for its current features.
Bill Calendar Tracker Template for Excel & Google Sheets
The listing describes a calendar you update by choosing a month and year: enter bills and due dates, and it shows which are paid and unpaid, with automatic calculations and any currency.
- Select a month and year to update the calendar
- Paid and unpaid bills at a glance
- Up to 50 bills per day, custom colors
Prefer a different look? The Bill Payment & Tracking Essentials bundle includes five bill trackers and calendars in different themes.
Product features and compatibility are listed on each product page and may change.
FAQ
Questions about keeping track of bills
What is the best way to keep track of bills?
One list of every bill with amount, due date and payment method, a calendar view of due dates, and a weekly ten-minute check. A spreadsheet, a notebook or an app can all do it; what matters is that every bill is in one place.
How do I organize bills by paycheck?
Write down your paydays, then assign each bill to the paycheck that arrives before its due date. If one paycheck carries much more than the other, ask to move a due date or build a one-month buffer in checking.
When does a late bill hurt my credit?
A late fee can apply as soon as you miss the due date, but a late payment is generally reported to the credit bureaus once it's at least 30 days past due. If you miss a date, pay as soon as you can.
How do I track bills that change every month?
Keep a typical amount in your list for planning, then type in the actual amount when the bill arrives. Over a few months you'll see the range, which helps you budget for winter heating or summer cooling.
Should yearly bills go in the tracker?
Yes. Put them on the list with their month and set aside a twelfth each month, so a yearly insurance premium or registration fee doesn't land on one paycheck.
Sources and further reading
Checked November 13, 2026. The calculator, formulas and examples were built by SpreadsheetsHub; amounts are illustrations, not averages. Not financial advice.