How to Keep Track of Bills in Excel

To keep track of bills in Excel, create a list with one row per bill due, record its due date and amount, and update a Paid? column after you pay. Add a status formula and filters to spot what is coming up or overdue. You will need Excel for Microsoft 365 on Windows, the bill details you want to track, and a few minutes to set up the sheet.

What You’ll Need

Excel for Microsoft 365 on Windows. The steps also work in recent desktop versions of Excel; Mac menu names are generally similar, with keyboard shortcuts noted where they differ.
Your bills’ names, due dates, expected amounts, payment frequency, and payment method, if you want to record it.
A safe place to save the workbook. It may contain personal financial details, so avoid sharing it publicly or storing it somewhere other people can access.

Step-by-Step

Create a workbook and clear headings. Open a blank workbook and rename Sheet1 to Bills by double-clicking its tab. In row 1, add these headings: Bill, Due Date, Amount, Frequency, Paid?, Date Paid, Payment Method, Notes, and Status. Use one row for each bill occurrence, rather than one row for a recurring bill that you overwrite every month. That preserves a simple history of what was due and when it was paid.
Enter the bills you want to monitor. Starting in row 2, enter one bill per row: for example, Internet, November 2026, $65, Monthly, No, blank, Bank transfer, and any useful note. Use the actual due date for the cycle you are tracking. Include irregular expenses, such as annual insurance, if you want them in the same view. Do not put a date or amount in a heading row, and avoid merging cells inside the list because that can interfere with sorting and filtering.
Format dates and amounts so they are easy to read. Select the Due Date and Date Paid columns, then use Home > Number Format and choose a date format. Select Amount and choose Currency or Accounting from the same number-format menu. Apply the format to the whole column or a generous range of rows so new bills match. Enter actual Excel dates, not labels such as “the 15th” or text such as “Nov 3”; real dates can be sorted and compared by formulas.
Turn the list into a table. Click inside the list and press Ctrl+T on Windows. Check that the range includes the headings and select My table has headers, then click OK. On a Mac, use Command+T or Insert > Table, and confirm the header option. A table gives you filter arrows, consistent formatting, and room to add future rows. Choose a restrained table style from Table Design if you want the headings to stand out without making the sheet hard to scan.
Make payment tracking consistent. In Paid?, enter Yes for a paid bill and No for one still awaiting payment. To reduce inconsistent entries, select the cells in that column and choose Data > Data Validation. Set Allow to List and enter Yes,No in the Source box, then click OK. If your Excel installation uses a different list separator, use the separator shown by the dialog. Leave Date Paid empty until you have paid the bill; then enter the date and, if useful, the payment method or confirmation detail.
Add an automatic status. With bill names in A, due dates in B, amounts in C, and Yes/No payment entries in E, put this formula in H2, the first Status cell: =IF(E2="Yes","Paid",IF(B2="","",IF(B2<TODAY(),"Overdue",IF(B2=TODAY(),"Due today","Upcoming")))). If E2 is No and B2 is November 1, 2026, the result on November 3, 2026 is Overdue; if B2 is November 3, the result is Due today. The formula leaves a blank due date’s status empty and marks a bill Paid when E2 is Yes. Fill it down the Status column, or enter it in the first table row and let Excel fill the calculated column. TODAY updates when Excel recalculates, so the status can change from Upcoming to Overdue without editing the formula.
Show the total still unpaid, if that helps. For bill amounts in C2:C1000 and payment entries in E2:E1000, put this in an empty cell outside the table: =SUMIFS(C2:C1000,E2:E1000,"No"). It adds amounts only on rows marked No. For example, if the unpaid entries are $80, $45, and $120, the result is $245. Update the ranges if your tracker extends past row 1000. This is a total of the bills you entered, not a forecast of every possible expense or a substitute for checking account balances.
Make important items easier to notice. You can filter the table by Status to show only Overdue or Due today items: select the Status filter arrow and choose the values you want. To color overdue entries, select the Status cells and choose Home > Conditional Formatting > Highlight Cells Rules > Text that Contains. Enter Overdue, choose a format, and click OK. Consider using a different rule for Due today. A clear visual cue is useful, but keep the words in the Status column so the information remains understandable without color.
Save, then use the tracker on a regular schedule. Save the file with a recognizable name, such as Household Bills.xlsx, in a private folder. Once a week, review bills due soon, confirm amounts against the bill or provider account, and update Paid? and Date Paid after payment. When a new billing cycle begins, add a new row for each recurring bill and change its due date and expected amount as needed. Keep old rows rather than replacing them if you want a useful payment record.

Common Mistakes

Typing dates as text: A date that looks correct may not sort or compare properly if Excel stored it as text. Enter dates in a recognizable date format and check that changing the cell’s number format changes how the date appears. If Excel still treats it as text, re-enter it or convert the column using Data > Text to Columns, checking the date interpretation before finishing.

Using different payment labels: Entries such as Paid, Y, Done, and Yes are not interchangeable to the status formula. Use exactly Yes or No in the Paid? column, or update the formula and validation list to match your chosen labels. Also avoid marking a bill paid before the payment is actually complete.

Overwriting recurring bills: Changing last month’s row to this month’s due date erases the old record and can make your totals misleading. Add a separate row for each cycle. Another common problem is forgetting to update a variable bill’s amount; use the latest statement or provider account rather than assuming last month’s amount is still correct.

Mixing tracking with reminders: An Excel status is not necessarily a notification. The formula can label a bill Overdue when the workbook recalculates, but it will not reliably send an alert while the file is closed. Keep a separate calendar or provider reminder if you need a notification.

Tips

Use the Notes field for practical details such as an account nickname, autopay status, or where to find a confirmation number. Avoid storing full card numbers, passwords, or other sensitive credentials in the workbook.
Keep Frequency values consistent, such as Monthly, Quarterly, and Annual. Record the actual due date for each row; Frequency is descriptive and does not automatically create next month’s bill.
Use the table’s filter arrows to focus on a particular month, provider, or status rather than maintaining several competing copies of the tracker.
Check that the computer’s date is correct. The status formula uses TODAY(), which reads the system date and updates when Excel recalculates the workbook.
Save a backup occasionally, particularly before making a large edit or changing the layout. If you use OneDrive, check that the workbook has finished syncing before relying on the latest copy on another device.

Troubleshooting

The formula displays the formula text instead of a status. The cell may be formatted as Text, or Show Formulas may be enabled. Change the cell format to General, press F2, then Enter to re-enter the formula. On Windows, Ctrl+` toggles Show Formulas; on a Mac, the shortcut may depend on the keyboard layout, so use Formulas > Show Formulas if available in your ribbon.

A bill shows the wrong status. Check that the due date is a real date, the Paid? entry is exactly Yes or No, and the formula refers to the right row. If every row shows the same status, check that the row references change as you fill the formula down. TODAY() follows the computer’s date, so confirm that date and recalculate with F9 on Windows or Fn+F9 on some Mac keyboards.

The unpaid total is zero or too high. Confirm that amounts are numeric values rather than text, that unpaid rows say No, and that the formula’s ranges include the rows you entered. A bill with a blank Paid? cell is not counted by the example SUMIFS formula because it specifically looks for No. Either choose No for each unpaid bill or deliberately adjust your tracking process and formula criteria.

New rows do not have the same formatting or formula. Add the row directly beneath the table so Excel can extend it, and confirm that the Status formula is a calculated column. If you are using a plain range instead of a table, copy the formatting and formula down to the new row. If filter arrows disappear, click in the data and recreate the table with Ctrl+T (Command+T on Mac), making sure the header option is selected.

A filter hides bills you expected to see. Open the filter arrow and select Clear Filter, or choose the relevant status values again. Filters do not delete rows; they temporarily hide rows that do not match. Clear all filters before deciding that an entry has gone missing.

Frequently Asked Questions

Can Excel remind me before a bill is due?
Excel can show Upcoming or Due today when you open or recalculate the workbook, but a standard formula does not send a notification while the file is closed. Use a calendar, provider alert, or another reminder service if you need an active notification.

Should I use one row per bill or one row per month?
Use one row per bill occurrence. A monthly internet bill gets a new row for each month, with that cycle’s due date, amount, and payment status. This keeps the past record intact and lets you filter the list by date.

Can I track automatic payments?
Yes. Note Autopay in Payment Method or Notes, but still check that the payment cleared and mark Paid? as Yes only when you have confirmed it. A scheduled automatic payment can fail or be delayed, so the tracker should reflect what happened rather than what was expected.

Will the total show what I owe this month?
The example total adds all rows marked No in its range, including any dates you have entered there. To see only a particular month, filter the Due Date column to that month and review the visible unpaid bills, or keep the tracker focused on one billing period. Verify the bill amounts against current provider statements.

Can I use the workbook in Excel for the web?
Yes. You can open and edit a saved workbook in Excel for the web, and basic tables, formulas, and filters are supported. Ribbon layout and some formatting options may differ from desktop Excel, so use the equivalent available controls if a menu path is not shown.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.