eHow launches Android app: Get the best of eHow on the go.

How To

How to Do a Household Budgeting Spreadsheet

Member
By jenstewart
User-Submitted Article
(0 Ratings)
household budgeting spreadsheet
household budgeting spreadsheet

A Household Budgeting Spreadsheet can help you manage your family's personal budgeting needs. This spreadsheet can be adaptable to fit differing budgeting situations in the household.

Difficulty: Moderate
Instructions

Things You'll Need:

  • Computer with Internet
  • excel spreadsheet software program
  • pen
  • paper
  • printer
  • household budgeting records
  1. Step 1

    First set up your budgeting spreadsheet according to your specific household income schedule.

  2. Step 2

    List all household income sources at the top of your budgeting sheet. If you are a two income family you can make your budgeting schedule every other week or combine to budget monthly.

  3. Step 3

    Then make two columns for budgeting. Projected and Actual. This applies to household income and expenses.

  4. Step 4

    Next organize your household expenses according to your budgeting needs and prioritize them on your spreadsheet.

  5. Step 5

    List your household necessities first and then any other budgeting needs from most important to least down your spreadsheet.

  6. Step 6

    Examples of household budgeting necessities include:
    1. Mortgage or rent
    2. Homeowners Insurance
    3. Utilities

  7. Step 7

    Next prioritize other needs like:
    1. Food
    2. Cell phones
    3. entertainment
    4. clothing and school supplies

  8. Step 8

    Lastly, make a household budgeting category for emergency or unexpected cash needed on hand. Also use this fund to help increase savings and gain some liquidity.

Tips & Warnings
  • Be realistic when estimating projected budgeting amounts
  • Always have two months worth of household monthly income on hand for emergency
  • Start with must pays and savings and use the rest with discretion to adjust and balance your household budget
Subscribe

Post a Comment

Post a Comment

Related Ads

  • Have you done this? Click here to let us know.
I Did This
Get Free Personal Finance Newsletters

Copyright © 1999-2009 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy.   en-US Portions of this page are modifications based on work created and shared by Google and used according to terms described in the Creative Commons 3.0 Attribution License.

eHow Personal Finance
eHow_eHow Business and Finance