Fill these cells in throughout the month as you make purchases. This is what you actually paid from the transactions tab. They can walk you through your complimentary review to show you how to stay on track with your budget and apply that towards your future goals. If you find yourself thinking you have too much money going out, you are making too little income, are concerned about making ends meet, or what to do with a surplus – talk to one of our experts. When taking these steps, you will be able to accurately create your financial plan for your future. This will also help you plan for your next large purchase, contribute to a savings account, know how much you spend daily, or even create an emergency fund by letting you see where you can save money, if you need to increase your income, or supplement your income. With this information, you will be able to see where most of your spending goes and where you can change your spending habits. See how your spending compares to the month before. You can change the planned amount (column D on the new month’s summary tab) to reflect what you actually spent from the month previously (column E on the Summary tab). You can do this by right-clicking on them and renaming them to the next month you will be in.Ĭhange the planned amounts in the new month. View the increase in savings and how much was saved this month in columns H - L. Red indicates that you spent more than you had planned for that month in that category and may need to make adjustments for the following month(s). A grey number with a plus sign shows that you spent less than planned that month, allowing you to have more money to save or use elsewhere. See how your actual spending compares to your planned spending by reviewing the difference (Diff.) columns. Just like the purchases, be sure to categorize this as ‘Income’ in column J. Once it is added, you will be able to select this category on the Transaction Tab. If there is a category you do not see on the Budget Tool initially, add it as a custom category (on the Summary Tab). Click the down arrow and select the category the purchase falls under. Which will then show your actual expense in each category (as long as the formulas are still in place).Ĭategorize all purchases in row E. When you fill out the transactions, the summary tab will AUTOMATICALLY update in the Summary Tab in column E. Record all transactions throughout the month. Now that you have set your monthly goals, you will fill out the transactions tab during the entire month.įill out the Transaction Tab. Then, after the first-month update the planned column moving forward.Ĭreate custom categories if there are expense categories that you do not see currently listed in column B. If you do not know the exact amount you spend monthly, estimate the highest amount you believe you spend a month. This will help you see planned versus actual expenses at the end of the month and help calculate your ending balance. Your starting balance is the total amount you have in your bank account when starting your budget.įill all highlighted cells that you have expenses in. If you are an hourly employee - enter the amount that you take home on average. If you are a salaried employee – enter how much take-home income you have after taxes are taken out Only fill out highlighted sections for your planned income that you expect throughout the month. To Get Started:įill out income streams in the Income section in column J. The transactions tab is how you will record the amount you actually spent on your transactions throughout the month. The Summary tab is where you will be able to see your monthly spending versus the amount you thought you spent. There are two tabs that will help create your budget. How to Use Our Monthly Budget Spreadsheet Use the Home Federal budgeting tool below to help you effectively budget and ultimately see how you can reach your financial goals. Not only can you see if you’re over or under-spending, but you can also plan for future purchases by seeing where changes can be made in your monthly spending. What is a Monthly Budget?Ī monthly budget is a financial tool designed to set spending limits and record how your money is being spent within these limits. A monthly budget helps keep finances on track so you can effectively plan and save for the future. Home Federal is committed to providing our clients with the tools and resources required to be financially stable.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |