Friday, December 11, 2009

How to make a simple budgeting spreadsheets

make a simple budgeting spreadsheets


It's interesting:
"I have been for months trying to write a wedding speech, I wish I'd found this site sooner. It's going to ... You can find speech material to suit any style of wedding."

Here is an easy way to manage your finances by creating simple budgeting spreadsheets template. These free budget spreadsheets are printable making them both user friendly and versatile.

Things You'll Need

  • laptop or home computer
  • financial software like Microsoft Money
  • calculator
  • printer
  • debts, income

Instructions

    • 1

      If you have a home desktop PC, mac or personal notebook, you may access for free or can download a management software such as Microsoft Money to help design your own free budgeting spreadsheets template.

    • 2

      Design your excel budgeting spreadsheets around 6 main categories: 1. Total Monthly Gross Income 2. Monthly Housing Expenses 3. Monthly Car Expenses 4. Monthly Debts 5. Monthly Family Miscellaneous Expenses 6. Total Net Monthly Income (free income available)

    • 3

      Household budgeting expenses should include rent or mortgage, property and casualty, payments, utilities, taxes, and any household repairs.

    • 4

      Automotive expenses include car loans, gasoline, auto insurance, and maintenance make up the next category on your excel budgeting spreadsheets.

    • 5

      Debts should include any credit loans and monthly balance you choose to pay make up the next budgeting category on your spreadsheets template.

    • 6

      Next list any Miscellaneous budgeting expenses are any other expenses such as: -childcare/school -clothing, groceries -family entertainment, cable, videos, newspaper, magazines -medical, vet -clubs, association dues -investments, life insurance -vacation, gifts for holidays -haircuts, nails, etc.

    • 7

      Figure total monthly income at top of your budgeting spreadsheets, then total your monthly budget expenses for each category, and subtract to get your net income balance at the bottom.

Tips &- Warnings

  • Always round up when estimating your monthly expenses

  • Get your budgeting spreadsheets categories completed first and list as many as you can think of under miscellaneous before writing your own expenses in.

  • Divide your budgeting spreadsheets in 2 if paid bi-weekly or 4 if every week to help determine your payment schedules

  • Always include an category in your excel template under miscellaneous for emergency or liquid expenses and decide how much you can free up each month to add to this fund


Source: www.ehow.com

Tags: budgeting spreadsheets, category your, simple budgeting, simple budgeting spreadsheets, spreadsheets template, your budgeting