Bill tracker spreadsheet with bill calendar

Missed bills usually happen because due dates are scattered across the month. A single list with a calendar view fixes that.

In the Bill Tracker & Bill Calendar you list each bill once with its amount, due day and frequency (monthly, quarterly or yearly). It builds a calendar for any month with each bill on its due day and a 12-month paid checklist whose status updates itself: Paid, Due soon, Overdue or the date it is due. The dashboard lists what is due in the next 14 days and anything overdue.

Works in Excel and Google Sheets.

What you get

You get two files, a blank template and a filled-in example, plus a Start Here guide. Open them in Microsoft Excel, or upload them to Google Drive and open them with Google Sheets (free). You type in the input cells; the formulas, totals and charts update themselves.

Tips

• Include yearly bills like insurance and renewals.
• Check the 14-day list every payday.
• Tick bills off the moment you pay them.