Skip to content
Sheetli
Templates › Money › Bill Calendar
Calendar — every bill on the day it lands, with the day’s total and what it is for

Calendar — every bill on the day it lands, with the day’s total and what it is for

What it does

A late fee is just money you set on fire for no reason.

A real wall-calendar grid where every bill sits on the day it lands — with the amount and the name right there in the square. Tick one off and the payment logs itself.

Days with bills tint blue. Anything past due and unpaid turns red.

No hunting, no scrolling. You look at the month and you know.

It handles the awkward ones.

Monthly, quarterly, half-yearly, annual — set the frequency once and the calendar works out which months it lands in. A bill due on the 31st automatically moves to the 28th in February instead of quietly disappearing. That last part sounds small until it's your rent.

Statuses look after themselves.

Every bill is marked PAID, OVERDUE, DUE SOON or UPCOMING against today's real date, so the sheet is correct every morning without you touching it.

The number nobody wants to see.

Year View adds up all twelve months and shows what each category actually costs you per year. Subscriptions is usually the one that stings.

What's inside

6 tabs

  • Calendar — a proper month grid with each day’s bills and totals, anything overdue in red; today is highlighted
  • The month list beside it: every bill sorted by the day it lands, marked PAID / OVERDUE / DUE SOON / UPCOMING, with a PAY box that logs the payment for you
  • Bills — 25 slots: amount, due day, Monthly / Quarterly / Half-yearly / Annual, category, autopay checkbox, and what each one really costs per year
  • Payments — 300 rows, filled by the PAY box or by hand
  • Year View — all twelve months, due against paid, and what every category costs you over a year
  • Start Here — plain-English setup
  • Sample bills and payments preloaded so you can see it working, then clear them in seconds

Why this one

Checked, not eyeballed

  • A bill due on the 31st moves itself to the last day of a short month — it shows on 28 February, not nowhere
  • Quarterly, half-yearly and annual bills count forward properly from the month you nominate, so the once-a-year one stops ambushing you
  • Checked against Google's own calculation engine: 753 checks, including every cell of the calendar grid, in every month of the year
  • Google Sheets — nothing to install, and the checkboxes work in the phone app
Formulas924
Evaluation errors0
Independent checks753
Bugs caught before release7

Rebuilt natively in Google Sheets (v2), re-themed to the design charter 3 Sep 2026. 753 checks against Google's own calculation engine, including all 42 calendar cells character-for-character across the whole month grid, the 25-row sorted month list, all twelve monthly due-flags per bill, and every year-view and category total. Seven bugs caught across the three passes — the newest being a half-finished edit to the verifier's own category-icon map, which the verifier itself caught on the next run and reported as nine mismatched calendar cells.

The details

What you get
  • A thank-you page and email with your view-only Google Sheets link — open it, then File → Make a copy
  • Real checkboxes, sparklines and charts, built natively in Sheets
  • Instant delivery after payment; the link never expires
Your data stays yours
You take a copy into your own Drive. Everything you type lives in your copy. You can never edit the master, and I can never see a number in yours.
Good to know
Digital product — nothing is posted. Google Sheets only; you'll need a free Google account. Works on the Sheets mobile app. For personal use; please don't resell or redistribute the file. Something not working? Email me and I'll fix it.
Refunds
Instant digital downloads can't usually be returned once delivered — but if something doesn't work, message me before asking for a refund and I will sort it out. Full policies.

Goes well with

All templates →
Bill Calendar
$7
Coming soon