This column is where this system stands out. It is just a simple SUM(B13:G13) formula which picks up the totals of every expended amount and subtracts it from the total of each budgeted amount. It then shows how much you should have available in each expense area. IMAGE NOT AVAILABLE HERE For example, you will notice that each income period ษ has been going into the electricity account. Your electricity bill is charged every 60 days so you need to accumulate these funds for when the bill arrives. This account is now showing a total of ๛ held.
Tip _ Track you spending _ Tracking your spending for 30 days before creating a budget will give you the concrete numbers of how much you spend in each expense category every month. Many people are surprised to see how all the little purchases at up at the end of the month. By knowing how much you typically spend in each expense category you can now plan those expenses for the next month in your budget. _ Tip _ Plan for periodic expenses _ When creating a monthly budget that actually works you will need to plan ahead for periodic expenses such as car insurance (if not paid monthly), yearly car registration, gift giving, school shopping, and insurance deductibles just to name a few. If you estimate these expenses for the year and then divide by 12 you will get an amount that you can save each month for these expenses.