Bill Payment Checklist
A monthly bill checklist with due days, autopay flags, and a running total — copy the sheet for each month and never miss a due date again.
Preview
The workbook ships with the example values below plus blank rows — every total is a live formula.
| Bill | Amount | Due (day) | Autopay | Paid? |
|---|---|---|---|---|
| Rent / mortgage | $1,650.00 | 1 | Y | ✓ |
| Electricity | $96.10 | 12 | N | ✓ |
| Internet | $64.99 | 15 | Y | ✓ |
| Phone (family) | $115.00 | 18 | Y | ✓ |
| Car insurance | $142.00 | 22 | Y | |
| Water & trash | $58.00 | 28 | N | |
| Monthly total | $2,126.09 | Paid: 4 of 6 |
How to use it
- List every recurring bill with its amount, day of month due, and whether it is on autopay.
- Mark Paid? as you pay each month (✓ or Y) — the Paid count updates via COUNTIF.
- The monthly total sums every bill, so you always know the fixed-cost floor of your budget.
- Tip: duplicate the sheet per month (right-click the tab → Move or Copy) to keep a payment history.
Related online calculators
Free for personal use. The file contains no macros — just data, formatting, and standard spreadsheet formulas that work in Excel, Google Sheets, and LibreOffice.