Budgeting Worksheet Tip : Your Personal Cash Flow Analysis _ A fully functional budgeting worksheet should calculate your monthly cash flow analysis so that you can determine if you are overspending based on your income on a monthly basis. In order to determine your cash flow for the month, you will need to provide your monthly income information. A good worksheet should do all the math for you, generate a meaningful chart or two so that you can quickly see the areas in your budget that need to be improved upon. If you are over spending, you will need to adjust. If you are under spending, start saving towards your goals!
Your next task is to identify all your expense areas whether they're irregular or not. Set up two columns for each pay period (as shown below); IMAGE NOT AVAILABLE HERE The first column called "Bdgt" is the portion of your income that each expense area will be assigned. The total of this column should never exceed the income you receive for that period. The second column "Used" shows a negative amount and is a record of what has been spent from that period. The beauty of this system is that it will always give you a running balance.