Regular bills include phones, garbage collection, grocery shopping, and car insurance. To maximize its usefulness, ensure your payment schedule accounts for both regular bills and debts. The second column on this payment schedule is labeled ‘Pay To,’ and is where you write down the name of each business you need to pay each month.
If you add a row in the middle of the payment schedule, you will need to update all the numbers below. If you have more than 25 items to add, you can right click and insert an extra row. The first column is simply a numbered list.
To help you visualize how to use it, a sample payment schedule is on the template. The Payment Status section is light grey. They are color coded to make things even easier for you. There are two main sections in this worksheet: Payment and Payment Status. If that sounds like you, this Excel template can help you stay current. Our Monthly Simple Worksheet is designed for people who aren’t used to budgeting in this way, and who keep getting dinged with late charges. If you need a more robust and detailed version, please see our Monthly Detailed Worksheet, below. This is the simple version of our payment schedule. Prepare the Monthly Simple Worksheet for Your Payment Schedule
If you don’t know these details off the top of your head, go ahead and track them down. Whether each bill is automatically paid.The name of each business that you need to pay,.Spend some time looking them over and pick the one that will be most useful for you to use.īefore you proceed with either, please take some time to gather information about your bills. Monthly Detailed - See when your bills are due, how much your minimum payment is, and how much you pay, with this more detailed version of the payment tracker.Monthly Simple - Keep track of your bills with this simple monthly tracker so you never miss a payment.There are two worksheets included in this document:
This way you can continue using this Excel payment tracker year after year. You can quickly change the year when you edit this template. Rather, it’s a way to help you budget your payments and meet your financial goals. It’s important to note that this payment tracker is not an amortization table. Do you wish you had a simple way to track your monthly payments? Are you tired of forgetting about bills and incurring late fees and penalties? This payment schedule template in Excel will help you pay your bills on time.