![budget planner excel template budget planner excel template](https://i.etsystatic.com/24175709/r/il/8b273d/2750672161/il_1588xN.2750672161_r8cb.jpg)
![budget planner excel template budget planner excel template](https://www.maketecheasier.com/assets/uploads/2019/02/excel-templates-manage-budget-personal.jpg)
These are your utilities, subscriptions, and other recurring bills that may be variable, but are pretty much consistent and predictable.
![budget planner excel template budget planner excel template](https://images.template.net/wp-content/uploads/2016/11/11094823/Budget-Planner-Spreadsheet-Template-Excel.jpg)
Whether you list your mortgage as a big bill or a debt is up to you. If you have a lot of different debts, you may need to lump some of them into categories such as "credit cards" and "students loans." If you are using a debt snowball, only include the MINIMUM monthly payments in this section! The debt snowball is included in the Savings section. The point is that you have a place called BIG BILLS to remind you to budget for the big important stuff, the stuff that if you don't plan for, could break you. Whether you call some of these categories "sinking funds" or "short-term savings" doesn't matter in this worksheet.
![budget planner excel template budget planner excel template](https://i.etsystatic.com/21169988/r/il/7c6f5f/2656979113/il_1588xN.2656979113_7qjn.jpg)
Some people like to track the savings for big bills in separate accounts, sometimes even a separate sub-accounts. You can divide in Excel using a formula such as =1500/12. For a monthly budget, divide the total average yearly cost of a large bill by 12. Things like medical bills, home repairs, and car repairs can be budgeted ahead of time so that you have the money when you need it. Nobody makes it through life without unexpected big bills. This would also be a place to pull out priority savings to apply the "pay yourself first" principle. If you pay a tithe (the "pay God first" principle), then you can multiply by a percent in excel using a formula such as =10%*B9 where B9 is the Total Income. This category is for making adjustments to your gross income, such as listing the tax withholdings and other deductions from your paycheck. They are designed to help you apply the 'Pay God First' principle, the 'Pay Yourself First' principal, the 'Debt Snowball' and 'Savings Snowball' techniques, the 'Sinking Funds' idea, and the 'Envelope Budget' system. The categories in this worksheet have a very purposeful structure. Step 2: Enter Your Budget (Savings and Expenses) If your income varies a lot, you can base your budget on what you expect the minimum for the month will be. If you get paid weekly, you can base your budget on 4 weeks. If you actually get paid biweekly, you may want to base your budget on just two weeks of pay, then use your extra paycheck twice per year to do something special. See our articles How to Make a Budget and 5 Basic Budgeting Tips if you are just getting started or new to budgeting.If you are creating a monthly budget, list all sources of income for the month. The help worksheet is much more detailed now. Percentages below the category totals show you what percent of the total family budget is going to that category. New in Version 2.0: The new graphs show your spending and savings balance over time. If you are moving or buying a home, you can analyze your budget to see where you may need to cut back to be able to afford an increase in rent or a higher mortgage. For example, if you are changing jobs, you can use the planner to estimate whether the increase (or decrease) in pay will still allow you to make ends meet. This free family budget planner worksheet will help you create a yearly budget by entering amounts based on the month in which expenses are incurred.īy creating a yearly budget, you can more easily predict how major life changes will affect your finances.