Docstoc

Monthly Household Budget Planner - Excel Templates

Document Sample
Monthly Household Budget Planner - Excel Templates Powered By Docstoc
					                                    The Mortgage Reduction Centre
                                Visit our website for more customer tools & resources:
                                http://www.mortgagereductions.com.au

                                    Monthly Household Budget Planner
INCOME                           Projected      Actual                 MONTHLY BUDGET SUMMARY
                                                           Difference [42]
Wages                                  0.00         0.00         0.00                                     Projected   Actual      Difference
Interest Income                                                  0.00                 Total Income             0.00        0.00           0.00
Dividends                                                        0.00               Total Expenses             0.00        0.00           0.00
Gifts Received                                                   0.00                          NET             0.00        0.00           0.00
Refunds/Reinbursements                                           0.00
Transfer from Savings                                            0.00
Other                                                            0.00
Other                                                            0.00
               Total INCOME            0.00         0.00         0.00

HOME EXPENSES                    Projected      Actual     Difference   SAVINGS                           Projected    Actual     Difference
Mortgage/Rent                          0.00         0.00         0.00   Emergency Fund                                                    0.00
Electricity                            0.00         0.00         0.00   Transfer to Savings                                               0.00
Gas                                    0.00         0.00         0.00   Retirement                                                        0.00
Water/Council Rates                    0.00         0.00         0.00   Investments                                                       0.00
Phone                                  0.00         0.00         0.00   University Fund                                                   0.00
Cable/Satellite                        0.00         0.00         0.00   Other                                                             0.00
Internet                               0.00         0.00         0.00                  Total SAVINGS           0.00        0.00           0.00
Furnishings/Appliances                 0.00         0.00         0.00
Lawn/Garden                            0.00         0.00         0.00   OBLIGATIONS                       Projected    Actual     Difference
Home Supplies                          0.00         0.00         0.00   Student Loan                                                      0.00
Maintenance                            0.00         0.00         0.00   Other Loan                                                        0.00
Improvements                           0.00         0.00         0.00   Credit Card #1                                                    0.00
Other                                  0.00         0.00         0.00   Credit Card #2                                                    0.00
      Total HOME EXPENSES              0.00         0.00         0.00   Credit Card #3                                                    0.00
                                                                        Maintenance/Child Care                                            0.00
DAILY LIVING                     Projected      Actual     Difference   Federal Taxes                                                     0.00
Groceries                                                        0.00   State/Local Taxes                                                 0.00
Personal Supplies                                                0.00   Legal Fees                                                        0.00
Clothing                                                         0.00   Other                                                             0.00
Cleaning Services                                                0.00            Total OBLIGATIONS             0.00        0.00           0.00
Dining/Eating Out                                                0.00
Dry Cleaning                                                     0.00   BUSINESS EXPENSE                  Projected    Actual     Difference
Salon/Hairdresser                                                0.00   Deductible Expenses                                               0.00
Other                                                            0.00   Non-Deductible Expenses                                           0.00
Other                                                            0.00   Other                                                             0.00
Other                                                            0.00   Other                                                             0.00
          Total DAILY LIVING           0.00         0.00         0.00       Total BUSINESS EXPENSE             0.00        0.00           0.00

CHILDREN                         Projected      Actual     Difference   ENTERTAINMENT                     Projected    Actual     Difference
Medical                                                          0.00   Videos/DVDs                                                       0.00
Clothing                                                         0.00   Music                                                             0.00
School Tuition                                                   0.00   Games                                                             0.00
School Lunch                                                     0.00   Rentals                                                           0.00
School Supplies                                                  0.00   Movies/Theater                                                    0.00
Babysitting                                                      0.00   Concerts/Plays                                                    0.00
Toys/Games                                                       0.00   Books                                                             0.00
Other                                                            0.00   Hobbies                                                           0.00
             Total CHILDREN            0.00         0.00         0.00   Film/Photos                                                       0.00
                                                                        Sports                                                            0.00
TRANSPORTATION                   Projected      Actual     Difference   Outdoor Recreation                                                0.00
Vehicle Payments                                                 0.00   Toys/Gadgets                                                      0.00
Fuel                                                             0.00   Other                                                             0.00
Bus/Taxi/Train Fare                                              0.00         Total ENTERTAINMENT              0.00        0.00           0.00
Repairs                                                          0.00
Registration/License                                             0.00   PETS                              Projected    Actual     Difference
Other                                                            0.00   Food                                                              0.00
    Total TRANSPORTATION               0.00         0.00         0.00   Medical                                                           0.00
                                                                        Toys/Supplies                                                     0.00
HEALTH                           Projected      Actual     Difference   Other                                                             0.00
Doctor/Dentist                                                   0.00                        Total PETS        0.00        0.00           0.00
Medicines                                                        0.00
Health Club Dues                                                 0.00   SUBSCRIPTIONS                     Projected    Actual     Difference
Emergency                                                        0.00   Newspaper                                                         0.00
Other                                                            0.00   Magazines                                                         0.00
                 Total HEALTH          0.00         0.00         0.00   Dues                                                              0.00
                                                                        Club Memberships                                                  0.00
INSURANCE                        Projected      Actual     Difference   Other                                                             0.00
Auto                                                             0.00           Total SUBSCRIPTIONS            0.00        0.00           0.00
Health                                                           0.00
Home                                                             0.00   HOLIDAYS                          Projected    Actual     Difference
Life                                                             0.00   Travel                                                            0.00
Other                                                            0.00   Lodging                                                           0.00
              Total INSURANCE          0.00         0.00         0.00   Food                                                              0.00
                                                                        Rental Car                                                        0.00
EDUCATION                        Projected      Actual     Difference   Entertainment                                                     0.00
School Fees                                                      0.00   Other                                                             0.00
Tuition                                                          0.00                    Total HOLIDAYS        0.00        0.00           0.00
Other                                                            0.00
              Total EDUCATION          0.00         0.00         0.00   MISCELLANEOUS                     Projected    Actual     Difference
                                                                        Bank Fees                                                         0.00
CHARITY/GIFTS                    Projected      Actual     Difference   Postage                                                           0.00
Gifts Given                                                      0.00   Other                                                             0.00
Charitable Donations                                             0.00   Other                                                             0.00
Religious Donations                                              0.00   Other                                                             0.00
Other                                                            0.00   Other                                                             0.00
        Total CHARITY/GIFTS            0.00         0.00         0.00           Total MISCELLANEOUS            0.00        0.00           0.00

                CHECK THE MONTHLY BUDGET SUMMARY AT THE TOP OF THE PAGE FOR TOTAL INCOME AND EXPENSES

Using the Monthly Household Budget Calculator:

  To use this template, fill in the cells highlighted with a light-blue background (the "Projected" and "Actual" columns). Start off by
  inputting the values in the Income & Home Expenses categories. The purpose of this worksheet is to help you compare your
  monthly budget with your actual income and expenses.
  You record your desired budget for each category in the "Projected" column. This represents your goal - you're trying to keep from
  spending more than this amount. At the end of the month, you record in the "Actual" column how much you really spent during t he
  month. The cells in the "Difference" column use conditional formatting to make negative numbers red. In this spreadsheet, the
  calculations are set up so that negative numbers are bad. If you spend more than you budgeted, the Difference between the
  Projected and Actual values will be negative, and if your Actual income is less than your Projected income, the Difference wi ll be a
  negative number.
  The Monthly Budget Summary table totals up all your income and expenses and calculates the Net as Income minus Expenses. If
  your Net is negative, that means you have overspent your monthly budget.
  Adding or Removing categories: The household budget template contains a very detailed list of categories, which you may or ma y
  not need. If you add or remove any categories, just make sure that the formulas used for the totals don't get messed up.

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:66
posted:11/2/2012
language:English
pages:1