If you prefer to continue editing the spreadsheet on your computer, you can use the drop-down in the checkbox columns to check off when a bill is paid. If a payment is variable, you can enter the average amount at first, and then update it with the actual amount after you get the bill.įinally, you can print a copy of the worksheet if you want to include it in your planner or display it somewhere as a reminder. Next, enter the expected amounts for the bills for each month. The Day column is just for your own reference. In the Day column, you can list the day of the month that the bill is typically due, such as 1st, 15th, EOM (for end-of-month), etc. ![]() I would recommend listing them in order of priority, with the most critical bills to pay at the top. How to Use the Bill Tracker Worksheetįirst, list all your expected bills. ![]() You may not need this if you are already using the money management spreadsheet, but if you like to manage your budget by hand, this worksheet can be a very useful tool to include in your budget planner. You can use this bill tracking spreadsheet to list all your recurring bills with their expected payment amounts, and then check them off when they are paid.
0 Comments
Leave a Reply. |