Depending on payment terms, you may now be responsible for a late fee.Ĭontinue documenting the bills you pay in the correct monthly column. If you look across the Navient row, you can see that it was due on January 2nd. And if the payment date in the month column is after the due date, it turns red. This happened because this Excel workbook uses conditional formatting to give you visual clues. If you paid your student loan bill to Navient on January 3, go to the January column and enter the numeral 3 in the row with Navient. In this column, you enter your payment date. In the lighter gray Payment Status section, find the current month. Now that you have recorded your payment terms, your payment schedule is ready to use. How to Use the Monthly Simple Worksheet for Your Payment Schedule This adds the amounts from this column together. When you look at the bottom of this column, you can see how much money you have scheduled to pay in a given month. I recommend recording your minimum payment here. The fifth column shows how much you need to pay. For bills that you manually pay, you can leave this column blank or enter an X in the cell (this is what the sample shows.) If any of your bills are automatically paid, put the date the payment comes out of your account in this column. Other people put their credit cards on auto payment. For instance, some student loan payments are set to come out of your bank account on a certain date. In the fourth column, mark if the bill is automatically paid. If a bill is due on the fifth of the month, simply enter the numeral 5. Appropriately labeled “Due,” this is where you record the due date for each bill. Once you have entered each bill you need to pay, it’s time to move onto the third column. Debts could include your mortgage, student loans, money owed, credit cards, or payment agreement plans for medical debt. 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 Typically pay the same amount on each bill every month, or.Want to avoid late payments and charges,.There’s not a lot of clutter to distract you from the important data. The Monthly Simple Payment Scheduleĭesigned with simplicity in mind, the Monthly Simple Worksheet has only the minimum amount of information you need to pay your bills on time. Below, you will find directions for each of the worksheets. When you have this information, you are ready to get your Excel spreadsheet setup. You may need to look at old statements, contact your lender, or review past payments from your bank account. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |