In order to track you spending you will need the following two budget worksheets: Weekly Expenses Report Worksheet _ On this worksheet you will record all the spending for a given week. You will want to have four copies of this worksheet for a given month. Carry it with you to record expenses or make a habit of recording expenses at the end of the day with your daily receipts. Make sure to include a description of the item, the date purchased, the amount and the expense category. You will also want to write down how you paid for the item whether by cash, check, or credit card. This will give you a very detailed report of your weekly spending.
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.