Bill Tracker Spreadsheet

Every bill, every month, in one place: enter each bill once with its due day and the tracker dates it for the whole year, tells you what is due in the next 7 days, what is overdue, what you have paid this month and what is still to pay, and keeps the year's history by bill and by category.

WHAT YOU GET

• Bill Tracker (Excel): Start here, Dashboard (due in the next 7 days, overdue, paid and still to pay this month, autopay count, totals by category), Monthly (the month's bills with due date, paid amount, paid date, status), Year (paid by bill and month with a chart), Bills (60), Payments (12 months x 60 bills, dated automatically)
• Quick-start PDF

6,524 formulas, recalculated and checked for errors before listing.

HOW TO USE

1. Buy, then download on the page that opens right after payment (your Stripe receipt email carries the same link).

2. Open the workbooks in Excel 2016 or later, Google Sheets or LibreOffice; the quick-start PDF opens in any PDF app.

3. Yellow cells are inputs, grey cells calculate. Replace the example rows with your own.

PLEASE NOTE

• Digital download only; nothing is shipped. Returns are not possible on digital files; if a file will not open, email [email protected] and it gets fixed.
• Works in Excel 2016 or later, Google Sheets and LibreOffice. Status uses today's date, so it updates every time you open the file.
• Templates are not legal, tax or insurance advice. Have agreements reviewed by your own counsel and follow your own operating rules.
• For use in one business. Not for resale or redistribution.

Designed by A3E Studio (Ontario, Canada) and generated by our own software; every formula is recalculated and checked before listing.