| Family | HTML |
Excel |
|
|---|---|---|---|
| Vacation / Travel | HTML |
Excel |
|
| Pet Costs | HTML |
Excel |
|
| Blank | HTML |
Excel |
|
| Custom | HTML |
Under Budget Amount, enter the projected cost for the expense. When the month is over, enter the actual cost under Actual Amount. This helps you see how well you estimate your expenses.
In the Summary Calculation section at the bottom of the worksheet, enter your monthly net income. Your Net Income is income after taxes and all payroll deductions have been taken out.
If you get paid weekly, figure four paychecks per month. If you get paid biweekly, figure 2 paychecks per month. This will give you four "extra" paychecks each year to use as a buffer.
If your income fluctuates, make an estimate by averaging the last 12 months.
In the Summary Calculation section, sum up the total of expenses and subtract that value from your net income. If you end up with a negative number, you will have a deficit by the end of the month.