Simple monthly budget worksheet pdf
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.
#Simple monthly budget worksheet pdf update
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.
#Simple monthly budget worksheet pdf how to
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.
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.