Skip to content
Bill calendar with paid bills marked with green checks and unpaid bills in amber, next to an alarm clock and a stack of envelopes

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.

Complete bill listDue-date calendarPaycheck splitBill calculator

THE SHORT ANSWER

The simplest way to keep track of bills

1. ListEvery bill with its amount, due date, how you pay it and the account it comes from
2. CalendarDue dates laid out by day, so you can see crunch weeks before they arrive
3. RoutineTen minutes on the same day each week to mark what's paid and what's next

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.

TypeExamplesEasy to miss because
HousingRent or mortgage, HOA, renters or home insuranceInsurance is often yearly or twice a year
UtilitiesElectric, gas, water, trash, internet, phoneAmounts change every month
TransportationCar payment, car insurance, registration, transit passRegistration is once a year
DebtCredit cards, student loans, personal loans, buy now, pay laterEach card has its own due date
SubscriptionsStreaming, apps, cloud storage, gym, membershipsSmall charges on different cards
Health and familyHealth insurance, childcare, tuition, medicationsSome come out of your paycheck, some don't
Yearly and irregularDomain renewals, warehouse club, property tax, tax paymentsNot 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.

Rent or mortgage
Car payment
Subscriptions
Electric and gas
Phone
Internet
Car insurance
Credit card minimums
Bills per month——
Due 1st–14th——
Due 15th–end——

      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. 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. 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. 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. 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. 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. 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. 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.

      =DATE(YEAR($J$1), MONTH($J$1), MIN(C2, DAY(EOMONTH($J$1, 0))))Due date for this month in H2, with the due day in C2. 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.
      Copy the sheet once a month (or add a Month column) so you keep a history. A year of bill history makes it easy to spot creeping prices on insurance, phone and subscriptions.

      AUTOPAY OR MANUAL?

      Should you put every bill on autopay?

      BillGood fit for autopayWatch out for
      Fixed amounts: rent, car, loans, insuranceYesMake sure the money is in the account a few days before
      Credit cardsYes, at least the minimumPay the full statement balance when you can to avoid interest
      Utilities that change monthlyOftenCheck the amount each month for spikes or billing errors
      SubscriptionsThey're automatic anywayReview the list every few months and cancel what you don't use
      Tight months, uneven incomeManual can be saferOverdraft 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
      EXCEL + GOOGLE SHEETS

      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
      View the bill calendar

      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.

      Back to top