Bill Tracker & Bill Calendar

List every bill once, log each payment and see what is due soon, what is overdue and what is paid, on a month calendar and a 12-month checklist.

  • Never pay a bill late
  • A calendar of what is due each day
  • A 12-month paid checklist
$5.99
Buy on Etsy

Instant download on Etsy. Checkout on this site is coming soon.

Bill Tracker & Bill Calendar in Google Sheets on a laptop, shown with sample data

What's inside

  • Start HereYour welcome page: a 5-step setup checklist, how the tabs fit together, a guide to every tab with clickable links, and the color legend.
  • Bill CalendarA month calendar showing the bills due each day by name (up to two, then +N more) with the day's total. Paid days turn grey and unpaid, past-due days turn red. The month's bills are also listed in date order.
  • BillsEvery recurring bill with its amount, how often it is due and a date it was or will be due. The next due date, days left and a status (Due soon, Due today, Overdue or Paid) work themselves out.
  • Paid ChecklistA 12-month grid for any year showing which bills were paid in which month. A check mark appears when a payment for that bill is logged in that month.
  • Bill PaymentsLog each bill you pay: the date, the bill and the amount. Bills, the calendar and the checklist use it to show Paid and Overdue.
  • SettingsSet up once: your household name, how many days ahead a bill is flagged Due soon, how early a payment still counts, and how long a bill stays flagged Overdue.

A closer look

Every bill, on a calendar: Bill names and totals on each day, paid bills grey, late bills red. (Bill Tracker & Bill Calendar, sample data)
Know what is due soon: Days left and a status for every bill: Due soon, Overdue or Paid. (Bill Tracker & Bill Calendar, sample data)
The month's bills in order: A date-ordered list under the calendar, with To pay or Paid. (Bill Tracker & Bill Calendar, sample data)
A 12-month paid checklist: A check mark for every bill paid in every month. (Bill Tracker & Bill Calendar, sample data)
Log a payment in seconds: Pick the bill, type the amount: everything else updates. (Bill Tracker & Bill Calendar, sample data)

Screenshots show the Sample copy with made-up data.

Get set up in minutes

  1. Open your copy's Start Here tab.
  2. Settings: how many days ahead to flag a bill, and how early a payment counts.
  3. Bills: list each recurring bill with any date it is due.
  4. Bill Payments: log each bill you pay.
  5. Bill Calendar and Paid Checklist: see what is due and what is paid.

Good to know

  • Google Sheets: you need a free Google account. This isn't an Excel file.
  • Works in any browser on a computer, tablet or phone. Setup is easiest on a computer.
  • Nothing to install: no add-ons, no scripts.
  • You get a ready-to-use copy plus a Sample copy filled with example data, and a step-by-step PDF guide.
How Bill Tracker & Bill Calendar fits together

Ready when you are

$5.99
Buy on Etsy

Instant download on Etsy. Checkout on this site is coming soon.

More in Personal Finance

Personal Finance Command Center Google Sheets template
All-in-onePersonal Finance

Personal Finance Command Center

Run your household money from one Google Sheet: budget by paycheck and by month, bills, spending, savings goals, debt payoff and net worth, all…

$30.99View template →
Paycheck Budget Planner Google Sheets template
Personal Finance

Paycheck Budget Planner

Budget by paycheck: see which bills each paycheck covers, what to set aside for savings and debts, and how much is safe to spend before the next…

$8.99View template →
Monthly Budget Spreadsheet Google Sheets template
Personal Finance

Monthly Budget Spreadsheet

Plan each category, log what you spend and see plan against actual for any month and for the whole year, with Over and Watch flags. No bank logins.

$7.99View template →
Spending Tracker Google Sheets template
Personal Finance

Spending Tracker

Log each purchase with a category, then see where the money goes by category and month, your top spending categories and a chart. No bank logins.

$4.00View template →

See all Personal Finance templates →