How do you track the bill due dates and payments?
Over the years, I used many methods, none of them were perfect, until I started my Excel worksheet. After starting this worksheet two years ago, I never had a late payment.
Download the Free monthly bill due dates and payments tracking – Excel Template
Click the below links to download the LATEST version of the free Debt Snowball Excel Worksheet with Chart.
- Free monthly bill due dates and payments tracking – Excel Template (XLSX file).
- Free monthly bill due dates and payments tracking (XLS file for older versions of Excel).
You can read the instructions for using the worksheet here.
Monthly bill due date and payment tracking template excel
Features:
- This worksheet can track the bill payment due dates and the actual payment details.
- Every weekend, I make the payment for the bills which are due in the next 10 days and record that in this spreadsheet.
- It calculates my average monthly payments for the year, which helps me to see if I am overspending too much for a month or not.
- To facilitate online payment, the payment items are hyperlinked to the corresponding websites. Please see the attached image.
Instructions:
This monthly bill due dates and payments worksheet can track your bill payment due dates and the actual payment details.
Setup:
- On column A, enter the name of account for which payment is to be made sorted by the payment day in the month starting with the account with the earliest payment day in the month.
- To facilitate online payment, the payment items can be hyperlinked to the corresponding websites.
- On Column B, enter the due day of that month for that account.
For every payment:
- On Column C, enter the actual payment date.
- On Column D, enter the payment reference number for online payment or any other tracking information.
- On Column E, enter the payment amount.
Automatic Calculation:
Calculates the total and average monthly payment amount for the whole year.
Reusing the worksheet for the Next Year:
Once a year is over, you can duplicate the sheet for the next year.
Unlocking the protected cells:
Some of the cells are protected to prevent accidental changes by inexperienced users. If you are an experienced Excel user, you can check the “Help” worksheet to see the password to unlock the worksheet.
How do you track the due dates and payment for your bills?
Please comment below.