Monthly Bill Tracker (Google Sheets)

Welcome to the Monthly Bill Tracker Spreadsheet!

Full YouTube video tutorial here: https://youtu.be/RCw9UIwN-bk

This spreadsheet will help you simply keep track of all your Monthly Bills. You will be able to track up to 60 different custom Monthly Bills and enter in unique Days of the Month that each Bill becomes due.

The spreadsheet will automatically alert you when a Bill is within 10 days of the due date (by turning the cell Orange) or when a Bill has become overdue (by turning the cell Red). This gives you a quick and simple visualization of whether you are staying on top of your Monthly Bills.

The spreadsheet will also automatically calculate how much you have spent on each of your Bills throughout the year.

I've even included an additional "Bills Summary" section that will show you the total amount of Bills currently due, the total amount of Bills within 10 days of their due date, and the total amount of Bills that are currently overdue.

After setting up the Bills you want to keep track of, all you have to do is enter in the Bill amounts each month and check the box when each Bill is paid each month, and let the spreadsheet automatically do the rest!