Monthly bill tracker: a copyable table and payday routine

Updated September 6, 2026.

A bill can be on autopay and still go unpaid. The payment might fail, the amount might change or the money might leave before your next paycheck arrives.

A monthly bill tracker puts the amount, due date, paying account and payment status in one place. Keep "scheduled" separate from "paid," then check the bills due before each payday. You can copy the table below into a spreadsheet or a notebook.

What belongs in your bill tracker?

Start with statements and invoices. Include rent or mortgage payments, utilities, insurance, phone service, loan payments and subscriptions. Add quarterly and annual bills to a separate section so they do not disappear between payments.

For each bill, record:

The amount due, with estimates clearly marked.
The due date and the date you plan to send payment.
The account or card that pays it.
Whether you pay manually or have an automatic arrangement.
The status and payment confirmation when available.

Keep groceries and other day-to-day spending in your . They still need room in the budget even when they have no invoice or due date.

Copy this monthly bill tracker

The following amounts and dates are illustrative. Replace them with the details from your own bills. Use account labels rather than account numbers if you share the sheet.

Bill	Amount due	Due date	Planned payment	Paying account	Method	Status
Rent	$1,200	Sep 1	Aug 28	Checking	Manual transfer	Confirmed paid
Electricity	$90 estimate	Sep 12	Sep 10	Checking	Automatic debit	Awaiting statement
Internet	$50	Sep 15	Sep 12	Checking	Bank bill-pay	Scheduled
Phone	$40	Sep 22	Sep 20	Checking	Automatic debit	Scheduled
Card statement	$180	Sep 25	Sep 22	Checking	Manual payment	To pay
Total cash needed for listed payments	$1,560					Includes an estimate

The total is a payment requirement for these bills, not your total monthly spending. For example, a card statement can contain groceries you already recorded as expenses. Include the payment here for timing, but do not count those purchases again in your spending report.

If a payment goes by bank bill-pay, check whether it is sent electronically or by check and allow the provider's stated delivery time. A planned payment date must leave enough time to reach the biller by the deadline.

Use payment statuses that mean something

A simple set is enough:

Status	Meaning	Next action
Awaiting statement	Final amount is not yet known	Replace the estimate when the bill arrives
To pay	You need to arrange payment	Check funds and send it in time
Scheduled	A payment is set up	Confirm the amount and expected date
Confirmed paid	The payment has completed and the biller shows it received	Keep the confirmation
Needs attention	Failed, late, disputed or otherwise unresolved	Check with the provider and record what happens next

Autopay is a payment method. It is not evidence that the bill has been paid. Avoid a green "paid" cell simply because the automatic payment switch is on.

Check bills against payday

At each payday, look ahead to the next one. Add the bills due in between, then account for essential daily spending and transactions that have not cleared.

Here is a separate example:

Before the next payday	Amount
Available checking balance after pay arrives	$1,100
Bills due before the next payday	-$650
Grocery and transport allocation	-$250
Other known payments not reflected in the available balance	-$60
Amount left after those commitments	$140

Only subtract a pending payment separately if it is not already reflected in the balance you started with. Otherwise you will reserve the money twice.

If the result is negative, identify which due dates create the gap. Ask a biller whether a different date or payment arrangement is available, and wait for confirmation before changing your schedule. For variable pay, the can help you plan around money received.

Use autopay with a balance check

The CFPB's automatic payment guidance distinguishes two arrangements: automatic debit lets a company take money from your account, while bank bill-pay instructs your bank to send it. Both still need enough money available when the payment happens.

Read the amount and timing of the authorization, keep a copy and review the account. Automatic payments can lead to overdraft or insufficient-funds fees when the balance is too low. Add a calendar reminder before the payment date so you have time to check it.

For a credit card, record whether your instruction pays the minimum, a fixed amount or the statement balance. Those are different amounts. Paying a minimum does not clear the full debt, and interest may still apply. Use the statement's actual required payment and due date in your tracker.

Turn annual bills into planned savings

An annual bill has two dates to track: when you need to pay it and when you need to start reserving money. Divide the amount still needed by the number of contributions left before payment.

These are example bills:

Bill	Amount due	Already reserved	Contributions left	Needed per contribution
Annual insurance	$900	$300	6	$100
Membership renewal	$120	$0	4	$30
Vehicle registration	$240	$120	3	$40

Dividing every annual bill by 12 only works when you have a full year to save and no starting balance to account for. A bill due in three months needs a three-month plan.

Use a for the reserved amounts. Keep expected bills separate from money for unpredictable repairs or other emergencies.

Keep one weekly review

Check the next set of due dates, replace estimated amounts and confirm completed payments. Look for a bill whose amount or timing changed. At the start of the next month, copy the recurring bill names and reset their statuses so last month's "paid" does not carry forward.

Expense records can help you find charges to include. can help capture receipt spending and categories, while your biller's statement and payment confirmation remain the records to check for what is due and paid.

Start by entering your next three bills, their due dates and the account that will pay them. Then add a reminder to review that account before the earliest payment.