For the last 9 years I’ve used a Google Spreadsheet
called McBryde Bill Pay Checklist to keep track of our recurring bills and help manage our finances. Every time either my wife or I get paid, I open this spreadsheet, pay the bills that are due between that day and the next pay day, and mark it on this list. I also add those transactions to a free online tool from Intuit called Mint (https://www.mint.com). All of our financial accounts are connected to this tool so I can easily track checking account balances, remaining mortgage debt, retirement accounts, etc. as well as create goals and budgets. It’s very simple to use and available on any computer with an internet connection which is way better in my opinion than the old Quicken software I used to use that was only on one computer.
But back to the Bill Pay Checklist. Here’s how to use it.
- Download this Excel file: Bill Pay Checklist 2016
- If you like to use Google Drive, upload the file to your Drive and convert it to a Google Spreadsheet. This way you can access it from multiple computers.
- Add all of your recurring expenses to the spreadsheet sorted by due date.
- If you want to get fancy, color code the expenses by charitable giving, retirement, savings, utilities or whatnot.
- Use it every time you get paid.
- Each year start a new sheet and adjust as needed.
Practice this discipline over time and it becomes second nature.
This is not super complex and has been an essential tool in managing our finances. I hope it helps you, too!