Bill Tracker | Google Sheets Template

Never miss a bill again. This Google Sheets bill tracker lists every bill with its due date, puts them on a monthly calendar, gives you a paid checklist for all 12 months and shows what is left to pay on a dashboard that updates automatically.

WHAT'S INSIDE (7 tabs)

- START HERE: quick setup steps and tips

- Dashboard: average monthly bills, due this month, paid, left to pay, bills on autopay, next 5 bills due, bills by category and paid vs still to pay by month

- Calendar: pick a month to see a calendar grid with every bill on its due date

- Payment Checklist: 12 months of every bill with the amount due and a paid checkbox, plus totals per month

- Bills: your bill list with category, frequency, due day, autopay, monthly average and the next due date

- Payment Log: an optional record of each payment with date, amount, account and confirmation number

- Setup: currency, year, name, bill categories and accounts

HOW IT WORKS

1. After purchase, download the PDF from the link in your confirmation email.

2. Click the link. Google asks you to make a copy, which is saved to your own Google Drive.

3. Add your bills once with their due day and amount, then tick them off as you pay. The calendar and dashboard update automatically.

GOOD TO KNOW

- Two versions included: one with sample data to explore and a blank one ready for your own numbers

- Handles weekly, monthly, quarterly and yearly bills

- Works in Google Sheets on computer, tablet and phone. A free Google account is needed. Not made for Excel or Numbers

- Cells that calculate show a gentle warning if you try to edit them, so formulas are not deleted by accident

- This is a digital product. No physical item will be shipped

- For personal use only. Please do not share or resell

- Because this is a digital download, returns are not accepted. If you have any problem, email me and I will be happy to help