Using a spreadsheet program or app to keep track of your budget is not only a great an important thing to do with tech but it can also be quite addicting and actually fun. With being in control of your money and knowing where you stand financially, you start to feel proud and satisfied when you can add a new amount to the “earnings” section of the budget.
Sure if you have been avoiding effectively managing your finances, at the beginning you may be put off by your current financial situation but with some time the most satisfying part would be watch your earnings and savings increase as you cut back on spending.
But what if you need to pay an upcoming bill and you’re flat broke?
Relax, there’s no need to panic. Fortunately, your handy budget chart will help you cut back on spending hopefully without losing the roof over your head.
In addition, keeping track of your expenses will help you avoid spending money unnecessarily, so more funds can be allocated to saving.
Keeping Track Of Income And Expenses
This Simple Tutorial Can Work For Any MS Excel Style Spreadsheet:
- Open a new spreadsheet
- In the first rows, type in the factors that you would like to track (earned, spent, saved)
- Below the label, select the formula area, and type “=sum(A2:A30)”
This is one of the simplest formulas that can be used in Excel. It simply adds the amount of numbers that are found in column A between row 2 and 30.
You can put in the dates on the side of each row, but it’s easier to just use the default row values and remove any additional rows. For example, if there are 300 rows, delete 270 so that you’ll have 30 rows left, one for each day of the month.
Keeping Track Of Your Saving and Spending Percentages
The formula above will add the amounts in a range of rows. But what if you want to determine a percentage difference of two labels? For example, you want to keep track of the percent that you save on a monthly basis.
Follow This Process:
- Type this formula in to the formula area of the spreadsheet: “=sum(A2/B3)”, assuming that you’re “Total Earned” amount was on A2 and your “Total Spent” amount was on B3.
- Right click on the percentage label
- Format the cell as a percentage (from the drop down list of formatting options)
Congratulations! You just made an incredibly simple budget chart!
Benefits of Using Your Budget Chart
When you start to use this budget chart, you’ll begin to notice that each time you add an amount to the “earned” section, the spreadsheet will update, and you’ll be able to see at a glance how much you’ve been earning and spending.
Get into the habit of using the budget chart and you’ll be able to easily manage your finances.
When you can actually see the cause and effect of your spending you will start to want to increase your savings percentage and you will look for ways to spend less and save more.
Conclusion
The chart or any other budget app will serve as motivation to save money because no one wants to be reminded that they are spending a lot of money. It will be a little mind game to see how high you can make that “Percent Saved” number go. When you have to spend money, that percentage will decrease, which will make you want to bump it back up.
Using this chart will create the mentality that you need to save money, which is one of the most beneficial life decisions that you can make. Use any budget tool to allow you to get your head in the game, but do use something to track your budget. So create that budget chart and see how much money you can save!
BAM! Be A Man. Do The Right Thing. Take Care Of Yourself And Your Money
BAM! Be A Man. Do The Right Thing.
Be The DtRTy Guy!
