First, track your spending and expenses for the next 30 days. You can begin by recording all your purchases on a weekly expense report worksheet that you fill out each day. Save your receipts from each purchase and then record a description of the purchase, the amount, its category, and how you made the purchase; whether by cash, check, or credit card.
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.