Guides › Bills and payday timing

Bill calendar template: a free layout with paydays built in

A bill calendar is a month view with every bill written on the day it's due and every payday marked, so you can see which paycheck pays which bill before the money arrives. Below is a free template to copy (a bill list and a calendar grid), a filled-in December 2026 month, and how to set it up on paper or in Google Sheets or Excel in about 20 minutes.

What a bill calendar is for

A list of bills tells you what you owe. A calendar tells you when, next to when the money comes in. That's what stops the two most common problems on a tight budget:

• Three big bills landing in the same week as the smaller of your two paychecks.
• An autopay running the day before payday, and an overdraft fee on top of the bill.

Once both dates are on one page, the gaps are obvious, and so is the fix: move a due date, pay one bill early, or set part of a check aside for the next one.

What to put on your bill calendar

For each bill, write:

1. Name (rent, electric, car loan)
2. Amount (for bills that change, like electric, use the highest of the last few months)
3. Due day
4. How it's paid: autopay (A) or you pay it (M, for manual)
5. Which paycheck pays it
6. Paid ✓, ticked when the money has actually left

And on the calendar itself, mark every payday in a different color, plus any yearly or quarterly bill due that month.

Bill list template

Start with this list. Copy it into a notebook, a document or a spreadsheet, one row per bill.

To find them all, go through two months of bank and card statements line by line. Bills paid by card are easy to miss because they show on the card statement, not the bank one.

Calendar template

Then a month grid. Each square gets the day number, any bill due (name and amount) and a mark if it's a payday.

To print a blank one, print this page, or draw five rows of seven boxes on a sheet of paper. A big wall or fridge calendar works just as well; what matters is that the bills and the paydays are on the same page.

A filled-in example: December 2026, paid every other Friday

Take-home pay is $1,650 every two weeks, paid on Fridays. In December 2026 the paydays fall on the 4th and the 18th; the next one is January 1, 2027. Bills:

On the calendar it looks like this (💵 = payday):

Now it's easy to read. December's rent on the 1st comes before the first December check, so it was set aside from November's checks. Each check pays the bills due before the next payday:

The calendar shows the problem right away: the second check carries January's rent and is left with $238 for two weeks of groceries and gas. The fix is to set part of the rent aside from the first check. Bills for the month total $1,932, so each check should carry about $966:

Same bills, same pay, and now both fortnights have $684 to live on. That rebalancing is the main reason to keep a bill calendar. Our guide on how to pay bills when you get paid biweekly covers the other two ways to do it, and how to budget biweekly paychecks shows what to do with the $684.

How to make a bill calendar in Google Sheets or Excel

A spreadsheet version takes about 20 minutes and updates itself every month.

1. Sheet 1, "Bills": columns A to F as in the bill list above: Bill, Amount, Due day (just the number, like 14), Autopay, Paid from, Paid.
2. Add checkboxes to column F (in Google Sheets: select the column, then Insert › Checkbox). Untick them all on the 1st of each month.
3. Sort by due day (Data › Sort range by column C), so the list reads in date order.
4. Flag what's late: add conditional formatting to the rows with the custom formula =AND($F2=FALSE,$C2<DAY(TODAY())) and a red fill. Any unpaid bill past its day turns red.
5. Fill "Paid from" automatically if you're paid twice a month on set days, for example the 1st and 15th: =IF(C2<15,"1st check","15th check"). For biweekly pay, type the payday dates in for the month instead, because they move.
6. Total per check: =SUMIF(E:E,"1st check",B:B) and the same for the second check. Compare each total with that check's take-home pay.
7. Sheet 2, "Calendar": optional. A 7-column grid with the month's dates, where you type each bill on its day. Some people skip it and use their phone's calendar instead (below).

The same formulas work in Excel; Excel adds checkboxes from the Insert menu in recent versions, or you can type an "x" in column F and change the formula to =AND($F2="",$C2<DAY(TODAY())).

Paper, spreadsheet or phone calendar?

Many people use two: the spreadsheet (or paper list) to plan which check pays what, and repeating phone reminders set two days before each manual bill.

Don't forget the bills that aren't monthly

Quarterly and yearly bills are the ones that wreck a month. Keep a second list for them and write each one onto the right month's calendar:

• Car registration and inspection
• Car or renters insurance paid every 6 or 12 months
• Water and trash billed every 2 or 3 months
• Yearly subscriptions and memberships
• Property tax, if not part of your mortgage (and if you pay the mortgage biweekly, mark the two three-paycheck months: see biweekly mortgage payments)
• School fees, holidays, birthdays

Divide each by the number of paychecks before it's due and set that much aside every payday. Our guide to sinking funds categories has the full list and the per-paycheck amounts.

A 5-minute weekly bill check

1. Look at the next 10 days on the calendar.
2. For each autopay, check the money is already in the account it pulls from.
3. Pay any manual bills due before the next payday.
4. Tick off what has actually cleared.
5. Note anything that came in higher than planned and adjust the next check's plan.

Autopays timed for a day or two after payday, plus this check, are the simplest way to stop overdrafts; how to avoid overdraft fees has the bank settings that help too. If money still seems to vanish between paydays, the free 2-minute money leak quiz shows where it usually goes.

When a due date doesn't work: move it

Most card companies, and many lenders, utilities and phone companies, let you pick or change a due date, often online or with one call. If the calendar shows a bill always landing just before payday, ask to move it to a few days after a payday. Changes can take a billing cycle to take effect, so pay the current bill on its old date in the meantime.

Bill calendar mistakes

• Writing bills but not paydays. Without paydays it's just a list.
• Using last month's lowest electric bill. Plan with the high month so the surprise is good, not bad.
• Ticking "paid" when you scheduled it. Tick it when the money has left the account.
• Leaving out card-paid subscriptions. They still need money, just on the card's due date.
• One calendar per person in a couple. Shared bills belong on one shared calendar.

Get two months of statements, fill in the bill list tonight, and put next month's paydays and bills on one page. The free money leak quiz helps if you're not sure where the rest of the money goes. More guides are on the Ahead Again guides page.

Budgeting help only. This guide isn't financial or legal advice.

Sources

1. Consumer Financial Protection Bureau, Your Money, Your Goals toolkit: the bill calendar and income and expense tools. consumerfinance.gov
2. Consumer Financial Protection Bureau, "What is an overdraft fee?" and overdraft guidance. consumerfinance.gov
3. Google Docs Editors Help, "Add and use checkboxes" and "Use conditional formatting rules in Google Sheets." support.google.com