Excel template · Instant download

Never pay a bill late again.

Every bill in one colour-coded grid. See what’s overdue, what’s due today and what’s coming up, with monthly, quarterly and yearly bills worked out for you. No macros.

Get the tracker $9.99

✓ One-off payment   ✓ Instant download   ✓ Excel for Windows & Mac

Lee from Sheet Leveller
Made by Lee at Sheet Leveller, whose tutorials have been watched 6.3 million times on YouTube.
Bill-Payment-Tracker.xlsx
Due this month$3,367Paid$3,206Overdue1
BillAmountSepOctNovDecJanFeb
Rent$1,450Paid
Electric$96
Internet$65
Water & sewer$128
Car insurance$612
Netflix$15Paid
Renters ins.$180
Start HereDashboardBillsPaymentsSettings
Sound familiar?

Bills are easy to lose track of

📅

Due dates all over the place

Rent on the 1st, the phone on the 22nd, insurance twice a year. Remembering them all is a job in itself.

🔔

Late fees for forgetting

One missed payment can mean a late fee, or a mark on your credit report.

🤷

No idea what bills cost a year

Small monthly bills and big yearly ones add up to more than most people think.

How it works

List your bills once. Tick them off each month.

  1. List your bills

    The amount, how often it’s due and the day of the month. Monthly, every 2 months, quarterly, every 6 months or yearly.

  2. Tick them off

    Pick “Paid” in the grid when you pay. Paid a different amount? Type what you paid instead.

  3. Check the dashboard

    See what’s due this month, what’s left to pay, your next bills and what you spend in a year.

Colour-coded payments

See the whole year at a glance

Twelve months of bills in one grid. Each bill shows up only in the months it’s due: red if it’s overdue, orange if it’s due today, yellow if it’s due soon and green once it’s paid.

  • Monthly, quarterly and yearly bills in one place
  • Type an amount for bills that change
  • Missed payments counted for you
Payments
BillAmountSepOctNovDecJanFeb
Rent$1,450Paid
Electric$96
Internet$65
Water & sewer$128
Car insurance$612
Netflix$15Paid
Renters ins.$180
Next bills to pay

Know exactly what’s coming up

The dashboard lists your next unpaid bills in date order, with how many days you’ve got. It also shows what’s due this month, what you’ve paid and what’s left.

  • This month: due, paid and left to pay
  • Overdue count and progress bar
  • Due vs paid chart for the year
Dashboard · Next bills to pay
DUE$3,367
PAID$3,206
LEFT$161
OVERDUE1
BillAmountDueDaysStatus
Electric$96.4026 Sep3 lateOverdue
Internet$65.0029 SepTodayDue today
Rent$1,450.0001 Oct2 daysDue soon
Gym$40.0003 Oct4 daysDue soon
Car payment$389.0005 Oct6 daysUpcoming
Every kind of bill

Quarterly and yearly bills done for you

Tell it how often a bill is due and the first month it’s due, and the tracker works out every due date for the year. A bill due on the 31st moves to the last day of shorter months.

  • 5 frequencies, from monthly to yearly
  • Next due date for every bill
  • Cost a year and a month by category
Bills
BillAmountHow oftenDue dayNext dueCost a year
Rent$1,450Monthly101 Oct 2026$17,400
Water & sewer$128Quarterly101 Oct 2026$512
Car insurance$612Every 6 months1212 Nov 2026$1,224
Amazon Prime$139Yearly303 Apr 2027$139
Car registration$95Yearly3030 Jun 2027$95
Who it’s for

For anyone with more than a couple of bills

Households

Rent or mortgage, utilities, phones, insurance and subscriptions, all in one place.

Families

Daycare, car payments and the yearly bills that always catch you out, planned ahead.

Side hustlers & freelancers

Software, phone and insurance costs tracked alongside your personal bills.

Everything you get

  • Room for 50 bills
  • 12-month colour-coded payments grid
  • Monthly, every 2 months, quarterly, every 6 months and yearly bills
  • Overdue, due today and due soon warnings
  • Type the actual amount for bills that change
  • Dashboard: due, paid, left, overdue and next bills to pay
  • Cost a year by category with a chart
  • 10 categories you can rename
  • Start Here guide and example bills
Bill Payment Tracker
$9.99

One-off payment. Yours to keep.

Get instant access $9.99

Secure checkout by Payhip · Card or PayPal
Download link emailed straight away

Lee from Sheet Leveller

Hi, I’m Lee

I run Sheet Leveller on YouTube, where I make quick, no-nonsense Excel tutorials.

This tracker uses the colour-coding and date formulas from my tutorials to make a bill tracker that warns you before anything is late.

6.3Mtutorial views
11,900+YouTube subscribers
500tutorials

Questions

What if a bill amount changes each month?

Type what you actually paid in the grid instead of picking “Paid”. The totals use that amount.

Does it cover quarterly and yearly bills?

Yes. Choose how often each bill is due and the first month it’s due, and the tracker works out the rest.

What happens after 12 months?

Save a copy, then change the First month on the Settings tab and clear the payments grid for the next year.

Can I rename the categories?

Yes. Rename or add categories on the Settings tab and the drop-down updates.

Does it use macros?

No. It’s a normal .xlsx file, so there are no security warnings and nothing to enable.

Which versions of Excel does it work with?

Microsoft 365, Excel 2010 or later on Windows, and Excel for Mac. It’s built for Microsoft Excel.

Is this a subscription?

No. You pay once and the file is yours to keep.

Stop wondering if you paid it.

Every bill, every due date and every payment, colour-coded in one simple spreadsheet.

Get the tracker $9.99

Not ready yet? Try the free Monthly Bill Checklist.

Bill Payment TrackerInstant Excel download
Buy · $9.99
Scroll to Top