BILL TRACKER SPREADSHEET for Google Sheets & Excel, with a smart bill calendar, paycheck planner and subscription audit.
Type your bills in once. The Smart Calendar puts every bill on its due day. The Bill Checklist shows what's paid, what's due soon and what's overdue. The Annual Bill Calendar shows your expensive months long before they arrive.
━━━━━━━━━━━━━━━━━━
WHAT'S INSIDE THE SPREADSHEET (12 tabs)
• Dashboard: due this month, paid so far, still to pay, overdue, your next 10 bills, yearly totals and a chart.
• Bill List: the only tab you have to fill in. Room for 60 bills.
• Smart Calendar (NEW): pick a month and every bill appears on its due day, with daily totals. Paid bills show a tick.
• Bill Checklist (NEW): tick bills paid for all 12 months. Next due date, days left and status (Paid, Due soon, Overdue, Autopay) update on their own.
• Annual Bill Calendar: your whole year on one page. Weekly, every-2-weeks, quarterly, twice-yearly and yearly bills land in the right months. Shows your heaviest month and the buffer to keep.
• Paycheck Planner (NEW): paid weekly, every 2 weeks, twice a month or monthly? See which paycheck covers which bill, what's left over, and when a 3-paycheck month is coming.
• Sinking Funds (NEW): what to set aside each month for insurance, registration, Prime and other annual bills, with progress bars.
• Subscription Audit: cost per year, cost per use, and a verdict for each one: Keep, Review, Negotiate or Cancel.
• Cancel & Save: log each cancellation and watch the yearly saving add up.
• Payment Log and Monthly Summary: planned bills against what you actually paid, plus spending by category.
• Start Here: settings (year, currency symbol, "due soon" days) and setup steps.
━━━━━━━━━━━━━━━━━━
BONUS: 16 PRINTABLE PAGES (US Letter + A4)
Bill List · Year at a Glance · Monthly Bill Calendar · Monthly Bill Checklist · 12-Month Payment Checklist · Paycheck Planner · Sinking Funds · Colour-In Savings · Subscription Tracker · Subscription Audit · Cancel & Save Log · Payment Log · Year in Review · Bill Account Info · Bill Negotiation Log · Year-End Review
━━━━━━━━━━━━━━━━━━
WORKS WITH
Google Sheets (free), Microsoft Excel 2010 and newer on Windows and Mac, Apple Numbers and LibreOffice. Works on desktop, tablet and phone. No macros, no subscription, no account to create.
To use Google Sheets: upload the file to Google Drive, open it, then File > Save as Google Sheets. Formulas, dropdowns and charts carry over.
Any currency: type your symbol once. Undated: use it this year and every year after.
━━━━━━━━━━━━━━━━━━
HOW IT WORKS
1. Buy. The files appear in your Etsy downloads straight away.
2. Unzip, open the spreadsheet and type over the sample bills on the Bill List tab.
3. Pick a month on the Smart Calendar and set up the Paycheck Planner.
4. Tick bills as you pay them. Everything else updates itself.
━━━━━━━━━━━━━━━━━━
YOU RECEIVE
• Bill Tracker spreadsheet (.xlsx, 12 tabs)
• Printables, US Letter (PDF, 16 pages)
• Printables, A4 (PDF, 16 pages)
• Start Here guide (PDF)
The first three come in one ZIP file. The Start Here guide is also attached on its own. On a phone, save the ZIP and open it on a computer, or use the Files app.
PLEASE NOTE
This is a digital download. Nothing is shipped. Files are delivered instantly, so all sales are final. If anything won't open, message us and we'll fix it the same day.
Personal use only. Please don't share or resell the files.
ClearToolsCo · CTC-FIN-BILLCAL-XLSX
