Things You'll Need:
- computer
- internet
- excel spreadsheet software
- paper
- pen
- printer
- family budget records
-
Step 1
First decide on a budget format for your spreadsheet that meets your family income schedule.
-
Step 2
Second list your family income sources as your top category on your budget spreadsheet.
-
Step 3
Next group your all your family expenses into budget categories starting with must pay and then prioritizing down your spreadsheet by need.
-
Step 4
Then include a category at the bottom of your spreadsheet for Miscellaneous Family emergency savings and liquid cash on hand. Your family should have about three months income in this fund at all times.
-
Step 5
Its a good idea to break your family budget spreadsheet into two columns representing proposed family budget goals and actual family budget to chart and compare income and expenses.
-
Step 6
Project your family income first, followed by must pay, then emergency, and then project other budget needs by priority on your spreadsheet.
-
Step 7
Subtract all proposed expenses from proposed income to get a projected balance and use this as a guide to chart your actual amounts and compare to make adjustments.
