Worksheet _ Repayment of Debt Worksheet _ You will need one of these worksheets for each creditor you have. Each month when you make a payment, you will record it on this worksheet and bring down the balance after each payment has been made. Worksheet _ Monthly Financial Report _ On your monthly financial report is where you will enter your income and all your expenses for the month. By filling out this worksheet correctly you will find out if you are operating your household budget in the black or the red. Worksheet _ Monthly Budget Worksheet _ Now that you have filled out your monthly financial report you can work on your monthly budget. You can see where you can cut expenses in order to run your household with money left over at the end of the month.
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.