Bill Tracker Spreadsheet With a Printable Bill Calendar

A bill tracker spreadsheet lists every recurring bill with its amount and due date, shows what is due each week, and lets you mark each payment as done. In our budget spreadsheet the bill tracker is three connected pieces: a recurring transactions tab, a payment schedule you tick off, and a printable bill calendar. It suits anyone juggling bills on different dates, especially if you are paid weekly or every two weeks.

What the bill tracker spreadsheet tracks

Each piece does one job:

• Recurring transactions. You enter a bill once with its amount, frequency, first date and, if it stops, an end date. The spreadsheet schedules every occurrence over the year.
• Payment schedule. Every scheduled bill appears in a list. Tick each one as paid, or adjust a single occurrence (a higher electric bill this month, say) without changing the rest of the year.
• Bill calendar. A monthly grid shows past and upcoming bills with a summary for each week. You can show recurring transactions, variable ones or both, and the calendar prints on one page.

The same entries flow into the monthly tabs and the dashboard of the budget spreadsheet, so you never type a bill twice. One-off bills, such as a vet visit or a car repair, go in the variable transactions log instead.

Worked example: a month of bills

Here is a household’s bill list for October 2026, using example amounts. Each bill was entered once, with its frequency and first date. The gym contract has an end date of November 30, and the electric bill uses a $120 estimate that was adjusted to the real $134 in October.

Bill	Amount	Repeats	First date	Due in October	Yearly cost
Rent	$1,450	Monthly	Jan 1	Oct 1	$17,400
Phone	$65	Monthly	Jan 8	Oct 8	$780
Internet	$70	Monthly	Jan 12	Oct 12	$840
Car insurance	$540	Every 6 months	Apr 15	Oct 15	$1,080
Water and sewer	$96	Every 2 months	Feb 18	Oct 18	$576
Streaming	$18	Monthly	Jan 20	Oct 20	$216
Electric	$120 (estimate)	Monthly	Jan 22	Oct 22 ($134 actual)	$1,440
Gym (ends Nov 30)	$40	Monthly	Jan 25	Oct 25	$440
Student loan	$210	Monthly	Jan 28	Oct 28	$2,520
Total				$2,623	$25,292

Grouped by calendar week (Sunday to Saturday), October looks like this:

Week	Bills due	Total
Oct 1 to 3	Rent	$1,450
Oct 4 to 10	Phone	$65
Oct 11 to 17	Internet, car insurance	$610
Oct 18 to 24	Water, streaming, electric	$248
Oct 25 to 31	Gym, student loan	$250

Three lessons come out of these two tables:

1. October is a heavy month. Bills total $2,623, while the yearly total of $25,292 averages $2,108 a month. The gap comes from car insurance and water, which do not arrive monthly. Setting aside $138 a month ($90 for insurance, $48 for water) turns those spikes into a steady amount, which is exactly what our sinking funds tracker is for.
2. Weeks are lopsided. The first three days need $1,450 and the next full week needs $65. Rent is due before an October 2 paycheck arrives, so the last paycheck in September has to cover it. The weekly view shows which paycheck pays for which bills.
3. End dates matter. The gym costs $440 this year, not $480, because the contract stops after 11 payments. Enter the end date once and December is already right.

How to set up the bill tracker

1. On the setup tab, add each bill as a category in the bills group, and put streaming and app charges in the subscriptions group so they are easy to review later.
2. Open the recurring transactions tab and enter each bill once: amount, frequency, first date, and an end date for anything that stops, such as a contract or a loan’s final payment.
3. For a bill that varies, like electric or gas, enter a typical amount. You will correct it when the real bill arrives.
4. When a bill is paid, tick it in the payment schedule. If the amount differs from the estimate, adjust that one occurrence.
5. Log one-off bills in the variable transactions tab as they come up.
6. Open the bill calendar for the month, choose whether to show recurring transactions, variable ones or both, and print it if you like a paper copy on the fridge.
7. Once a week, compare the week’s summary with your checking balance so a large bill never lands on an empty account.

The method: a simple bill system

A bill tracker only works if every bill is in it. Start by listing everything that leaves your accounts on a schedule: statements from the last two or three months, plus annual renewals you might have forgotten. Our guide on how to organize bills walks through that inventory, when to use autopay and when to pay manually, and a yearly sweep to cut what you no longer use.

Subscriptions deserve their own pass, because they hide in app stores and on credit cards. How to track subscriptions shows where to look and how to turn monthly charges into a yearly cost. If you pay some bills by card, read how to budget with credit cards so the bill and the card payment are not counted twice. For matching bills to paydays, see how to budget biweekly paychecks or the biweekly budget template, and for the non-monthly bills in the example above, what sinking funds are and how to size them.

Build your own bill tracker in Google Sheets or Excel

If you want a basic version of your own, one tab is enough. Use four columns: A for the due date, B for the bill name, C for the amount and D for paid. Put each occurrence on its own row.

To schedule a bill, type its first due date in A2. In the row below, =EDATE(A2,1) gives the next month’s date and =EDATE(A2,6) gives the date six months later. EDATE works the same in both apps and handles short months, so January 31 becomes February 28. If Excel shows a five-digit number instead of a date, format the column as a date.

These formulas are identical in Google Sheets and Excel:

• Days until due, in E2: =A2-TODAY()
• Start of the current week (Sunday), in G1: =TODAY()-WEEKDAY(TODAY(),1)+1
• Total due this week, in G2: =SUMIFS(C:C,A:A,">="&G1,A:A,"<"&G1+7)

The paid column is where the apps differ:

• Google Sheets: select D2:D200 and choose Insert > Checkbox. Unpaid bills this week: =SUMIFS(C:C,A:A,">="&G1,A:A,"<"&G1+7,D:D,FALSE)
• Excel: use Data > Data Validation with a list of Yes,No, and fill new rows with No. Unpaid bills this week: =SUMIFS(C:C,A:A,">="&G1,A:A,"<"&G1+7,D:D,"No"). Recent Microsoft 365 versions also offer Insert > Checkbox, which stores TRUE and FALSE, so the Google Sheets formula works there.

To highlight unpaid bills due within three days (and anything overdue), select A2:D200 and add a formula rule. In Google Sheets, use Format > Conditional formatting > Custom formula is, with =AND($A2<>"",$D2=FALSE,$A2-TODAY()<=3). In Excel, use Home > Conditional Formatting > New Rule > Use a formula, with =AND($A2<>"",$D2="No",$A2-TODAY()<=3).

What a basic sheet lacks is the calendar grid and the scheduling from a single entry, which take far longer to build than the columns above.

Who it suits and who it does not

This bill tracker suits you if you have several bills on different dates, you are paid weekly or every two weeks and need to know which paycheck covers what, or you share bills with a partner and want each payment visible (see the couples budget spreadsheet). It also suits anyone who likes a printed monthly calendar.

It is less useful if every bill is on autopay from one account and your balance always covers them with room to spare. It also will not send reminders or pull payments from your bank: you enter bills once and tick them off yourself.

Start with the three bills that would hurt most if missed, usually housing, insurance and loans, and add the rest over the following week.