Excel + Google Sheets
Bill Tracker
Enter each bill once. The sheet builds the whole year's payment schedule, sorts it by date, and paints it onto a calendar you can actually read. Never again "wait, was that due yesterday?"
Coming to Etsy this week
Instant download on Etsy: Excel files plus a link to your own Google Sheets copy.
What’s inside · 6 tabs
- Welcome: A 3-step start guide, the category legend and print instructions
- Dashboard Overview: Big KPI cards, donut and bar charts. What's due, what's paid, what's left
- Setup: Set once. Currency (10 to pick from), monthly income, and every bill, subscription and debt payment with its name, frequency (weekly to yearly) and first payment date
- Payment Schedule: Every payment of the year, sorted by date; filter by paid status, year, month or category; override a date or amount when life happens, add a note, tick it paid
- Calendar: This month and next as colour-coded calendars. Income, bills, subscriptions and debt each get a colour, today is marked, and paid items show a green strikethrough
- Annual Dashboard: All 12 months with charts. Income vs outflow, outflow by category and running cash flow, calculated from the schedule
Features
- Visual Dashboard Overview tab: big KPI cards (income, bills due, paid, still to pay, net cash), donut and bar charts that update from your entries; pick a month or the full year to filter
- One entry becomes a full year of scheduled payments: no copy-pasting rows
- Every frequency: weekly, biweekly, monthly, quarterly, yearly
- Overrides for the month a bill changes, without breaking the original
- Print-ready: landscape, fit to page
- 10 currencies to pick from (USD, CAD, AUD, EUR, GBP, BRL, MXN, ARS, COP, CLP); pick the year, reuse it every year
- Filled EXAMPLE workbook + clean BLANK workbook included
- Excel AND Google Sheets versions, both in this listing
- Every formula tested before publishing
You’ll need
- Microsoft Excel 2016 or newer (desktop; Microsoft 365 not required) or a free Google account for the Google Sheets version.
- Best on desktop or laptop; printing is set up for landscape, fit to page.
More in Budget
