Budget Planner

Family Budget Planner
Starting Balance Total Income Total Expenses NET (Income - Expenses) Projected End Balance
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
JAN
INCOME
Wages & Tips Interest Income Dividends Refunds/Reinbursements Transfer From Savings Other Other Other Total INCOME 0
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
HOME EXPENSES
Mortgage/Rent Electricity Gas/Oil Water/Sewer/Trash Phone Cable/Satellite Internet Furnishings/Appliances Lawn/Garden Home Supplies Maintenance Improvements Other Total HOME EXPENSES 0 0 0 0 0 0 0 0 0
DAILY LIVING
Groceries Personal Supplies Clothing Cleaning Services Dining/Eating Out Dry Cleaning Salon/Barber Movies Discretionary [Name 2] Other Total DAILY LIVING 0 0 0 0 0 0 0 0 0
CHILDREN
Medical Clothing
School Tuition School Lunch School Supplies Babysitting Toys/Games Other Total CHILDREN 0 0 0 0 0 0 0 0 0
TRANSPORTATION
Vehicle Payments Fuel Bus/Taxi/Train Fare Repairs Registration/License Other Total TRANSPORTATION 0 0 0 0 0 600 0 0 0 600
HEALTH
Doctor/Dentist Medicine/Drugs Health Club Dues Emergency Other Total HEALTH 0 0 0 0 0 0 0 0 0
INSURANCE
Auto Health Home/Rental Life Other Total INSURANCE 0 0 0 0 0 554 0 0 0 110 144 300
EDUCATION
Tuition Books Music Lessons Other Total EDUCATION 0 0 0 0 0 0 0 0 0
CHARITY/GIFTS
Gifts Given Charitable Donations Religious Donations Other Total CHARITY/GIFTS 0 0 0 0 0 0 0 0 0
SAVINGS
Emergency Fund Transfer to Savings Retirement (401k, IRA) Investments College Other
Total SAVINGS
OBLIGATIONS
Student Loan Other Loan Chase 8598 Chase 6550 Bealls Alimony/Child Support Federal Taxes State/Local Taxes Legal Fees Other Total OBLIGATIONS 0 0 0 0 0 700 0 0 0 300 400
BUSINESS EXPENSE
Deductible Expenses Non-Deductible Expenses Other Other Total BUSINESS EXPENSE 0 0 0 0 0 0 0 0 0
ENTERTAINMENT
Videos/DVDs Music Games Rentals Movies/Theater Concerts/Plays Books Hobbies Film/Photos Sports Outdoor Recreation Toys/Gadgets Other Total ENTERTAINMENT 0 0 0 0 0 0 0 0 0
PETS
Food Medical Toys/Supplies Other Total PETS 0 0 0 0 0 0 0 0 0
SUBSCRIPTIONS
Newspaper Magazines Dues Club Memberships Other Total SUBSCRIPTIONS 0 0 0 0 0 0 0 0 0
VACATION
Travel Lodging Food Rental Car Entertainment Other Total VACATION 0 0 0 0 0 0 0 0 0
MISCELLANEOUS
Bank Fees Postage Other Other Other Total MISCELLANEOUS 0 0 0 0 0 0 0 0 0
HELP
[42]
0 0 0 0 0 0 0 0 0 0 0 0
Total Average
0 0 0 0 0 0
Monthly
OCT NOV
DEC
Total Average
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0
0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0
600 0 0 0 0 0 0 0 0 600
50 0 0 0 0 0 50
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0
144 300 0 110 0 0 0 0 554
12 25 0 9 0 46
0 0 0 0 0 0 0 0
0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 300 400 0 0 0 0 0 0 0 0 0 700
0 0 25 33 0 0 0 0 0 0 58
0 0 0 0 0 0 0 0
0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0
Instructions
By Vertex42.com
2008 Vertex42 LLC
This family budget planner is meant to help you create a budget for an entire year. Doing this will help you make predictions about where you may stand financially in the future. If you are moving, changing jobs, purchasing a home, or making other major life changes, it is essential to plan for many months down the road. 1. Edit/Create/Delete categories and subcategories Use row operations, such as deleting or inserting an entire row. The subtotal formulas are set up to allow this type of editing without messing up the formulas, but you should always insert a row ABOVE the last row in the group or BELOW the first row, so that the formulas stretch to include the row you added. 2. Verify that all of the subtotal formulas are correctly summing the correct cells 3. Modify the month headings as needed, to start with a different month 4. Enter your starting balance at the top of the worksheet. 5. Fill in the income and expenses for the year a. You can copy and paste cells as needed For example, enter an average fuel cost in Jan, and copy it across through Dec b. Include large lump payments in the months in which they will likely occur or use the approach of averaging the cost across each month. When using the averaging approach, consider that your actual balance may not reflect the predicted balance for the month. If you use the lump payment approach, it may be easier to compare actual balances, but make sure you have enough saved. c. Add cell comments as needed to help explain costs. For example, you might include the names of Birthdays in comments for the Gifts Given category
Updating the Balance Each Month

If your actual balance at the end of a month is substantially different than the projected balance, you may want to overwrite the formula in the "Projected End Balance" with your actual balance, to update the projections for the rest of the year.
2008 Vertex42 LLC
HELP
INCOME
Wages & Tips Interest Income Dividends Refunds/Reinbursements Transfer From Savings Other Other Other Total INCOME
HOME EXPENSES
Mortgage/Rent Electricity Gas/Oil Water/Sewer/Trash Phone Cable/Satellite Internet Furnishings/Appliances Lawn/Garden Home Supplies Maintenance Improvements Other Total HOME EXPENSES
DAILY LIVING
Groceries Personal Supplies Clothing Cleaning Services Dining/Eating Out Dry Cleaning Salon/Barber Movies Discretionary [Name 2] Other Total DAILY LIVING
CHILDREN
Medical Clothing School Tuition School Lunch School Supplies Babysitting Toys/Games Other Total CHILDREN
TRANSPORTATION
Vehicle Payments Fuel Bus/Taxi/Train Fare Repairs Registration/License Other Total TRANSPORTATION
HEALTH
Doctor/Dentist Medicine/Drugs Health Club Dues Emergency Other Total HEALTH
INSURANCE
Auto Health Home/Rental Life Other Total INSURANCE
EDUCATION
Tuition Books Music Lessons Other Total EDUCATION
CHARITY/GIFTS
Gifts Given Charitable Donations Religious Donations Other Total CHARITY/GIFTS
SAVINGS
Emergency Fund Transfer to Savings Retirement (401k, IRA) Investments College Other Total SAVINGS
OBLIGATIONS
Student Loan Other Loan Chase 8598 Chase 6550 Bealls Alimony/Child Support Federal Taxes State/Local Taxes Legal Fees Other Total OBLIGATIONS
BUSINESS EXPENSE
Deductible Expenses Non-Deductible Expenses Other Other Total BUSINESS EXPENSE
ENTERTAINMENT
Videos/DVDs Music Games Rentals Movies/Theater Concerts/Plays Books Hobbies Film/Photos Sports Outdoor Recreation Toys/Gadgets Other Total ENTERTAINMENT
PETS
Food Medical Toys/Supplies Other Total PETS
SUBSCRIPTIONS
Newspaper Magazines Dues Club Memberships Other Total SUBSCRIPTIONS
VACATION
Travel Lodging Food Rental Car Entertainment Other Total VACATION
MISCELLANEOUS
Bank Fees Postage Other Other Other Total MISCELLANEOUS
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31 Total
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0
0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0
INCOME
HOME EXPENSES
DAILY LIVING
CHILDREN
TRANSPORTATION
HEALTH
INSURANCE
EDUCATION
CHARITY/GIFTS
SAVINGS
OBLIGATIONS
BUSINESS EXPENSE
ENTERTAINMENT
PETS
SUBSCRIPTIONS
VACATION
MISCELLANEOUS
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31 Total
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0
0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0
INCOME
HOME EXPENSES
DAILY LIVING
CHILDREN
TRANSPORTATION
HEALTH
INSURANCE
EDUCATION
CHARITY/GIFTS
SAVINGS
OBLIGATIONS
BUSINESS EXPENSE
ENTERTAINMENT
PETS
SUBSCRIPTIONS
VACATION
MISCELLANEOUS
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31 Total
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0
0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0
INCOME
HOME EXPENSES
DAILY LIVING
CHILDREN
TRANSPORTATION
HEALTH
INSURANCE
EDUCATION
CHARITY/GIFTS
SAVINGS
OBLIGATIONS
BUSINESS EXPENSE
ENTERTAINMENT
PETS
SUBSCRIPTIONS
VACATION
MISCELLANEOUS
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31 Total
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0
0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0
INCOME
HOME EXPENSES
DAILY LIVING
CHILDREN
TRANSPORTATION
HEALTH
INSURANCE
EDUCATION
CHARITY/GIFTS
SAVINGS
OBLIGATIONS
BUSINESS EXPENSE
ENTERTAINMENT
PETS
SUBSCRIPTIONS
VACATION
MISCELLANEOUS
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31 Total
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0
0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0
INCOME
HOME EXPENSES
DAILY LIVING
CHILDREN
TRANSPORTATION
HEALTH
INSURANCE
EDUCATION
CHARITY/GIFTS
SAVINGS
OBLIGATIONS
BUSINESS EXPENSE
ENTERTAINMENT
PETS
SUBSCRIPTIONS
VACATION
MISCELLANEOUS
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31 Total
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0
0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0
INCOME
HOME EXPENSES
DAILY LIVING
CHILDREN
TRANSPORTATION
HEALTH
INSURANCE
EDUCATION
CHARITY/GIFTS
SAVINGS
OBLIGATIONS
BUSINESS EXPENSE
ENTERTAINMENT
PETS
SUBSCRIPTIONS
VACATION
MISCELLANEOUS
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31 Total
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0
0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0
INCOME
HOME EXPENSES
DAILY LIVING
CHILDREN
TRANSPORTATION
HEALTH
INSURANCE
EDUCATION
CHARITY/GIFTS
SAVINGS
OBLIGATIONS
BUSINESS EXPENSE
ENTERTAINMENT
PETS
SUBSCRIPTIONS
VACATION
MISCELLANEOUS
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31 Total
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0
0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0
INCOME
HOME EXPENSES
DAILY LIVING
CHILDREN
TRANSPORTATION
HEALTH
INSURANCE
EDUCATION
CHARITY/GIFTS
SAVINGS
OBLIGATIONS
BUSINESS EXPENSE
ENTERTAINMENT
PETS
SUBSCRIPTIONS
VACATION
MISCELLANEOUS
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31 Total
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0
0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0
INCOME
HOME EXPENSES
DAILY LIVING
CHILDREN
TRANSPORTATION
HEALTH
INSURANCE
EDUCATION
CHARITY/GIFTS
SAVINGS
OBLIGATIONS
BUSINESS EXPENSE
ENTERTAINMENT
PETS
SUBSCRIPTIONS
VACATION
MISCELLANEOUS
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31 Total
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0
0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0
INCOME
HOME EXPENSES
DAILY LIVING
CHILDREN
TRANSPORTATION
HEALTH
INSURANCE
EDUCATION
CHARITY/GIFTS
SAVINGS
OBLIGATIONS
BUSINESS EXPENSE
ENTERTAINMENT
PETS
SUBSCRIPTIONS
VACATION
MISCELLANEOUS
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31 Total
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0
0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0
INCOME
HOME EXPENSES
DAILY LIVING
CHILDREN
TRANSPORTATION
HEALTH
INSURANCE
EDUCATION
CHARITY/GIFTS
SAVINGS
OBLIGATIONS
BUSINESS EXPENSE
ENTERTAINMENT
PETS
SUBSCRIPTIONS
VACATION
MISCELLANEOUS
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31 Total
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0
0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0

Budget Planner

Uploaded by

Copyright:

Available Formats

Budget Planner

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Budget Planner

Uploaded by

Copyright:

Available Formats

Family Budget Planner

Travel Lodging Food Rental Car Entertainment Other Total VACATION 0 0 0 0 0 0 0 0 0

144 300 0 110 0 0 0 0 554

0 0 300 400 0 0 0 0 0 0 0 0 0 700

2008 Vertex42 LLC

Updating the Balance Each Month

2008 Vertex42 LLC

You might also like