Household monthly budget Spreadsheet

Document Sample
Household monthly budget Spreadsheet Powered By Docstoc
					                          Total Projected Cost    Total Actual Cost     Total Difference   Projected Monthly Income
                                       $3,941               $4,034                 ($93)   Income 1                              $1,500
                                                                                           Income 2                              $1,200      MONTHLY EXPENSES                              Water
                                                                                                                                                                                           Refuse collection
Housing                    Projected Cost           Actual Cost          Difference        Extra income                            $300                                                    Maintenance or repairs
Second mortgage or rent                      $0                    $0                 $0   Total monthly income                  $3,000                                                    Gas
Supplies                                     $0                    $0                 $0                                                                                                   Cable TV
Other                                        $0                    $0                 $0   Actual Monthly Income                                                                           Phone
Water                                        $8                    $8                 $0   Income 1                              $4,000                                                    Electricity
Refuse collection                           $10                   $10                 $0   Income 2                              $1,200                                                    Mortgage or rent
                                                                                                                                                                                           Vehicle 1 payment
Maintenance or repairs                      $23                   $23                 $0   Extra income                            $300                                                    Vehicle 2 payment
                                                                                                                                                                                           Bus/taxi fare
Gas                                        $22                 $35                  -$13   Total monthly income                  $5,500
                                                                                                                                                                                           Fuel
Cable TV                                   $34                 $34                    $0
                                                                                                                                                                                           Maintenance
Phone                                     $120                $120                    $0   Projected balance                    ($941)
                                                                                                                                                                                           Licensing
Electricity                                $44                 $44                   $0    Actual balance                       $1,466
                                                                                                                                                                                           Groceries
Mortgage or rent                        $1,100              $1,100                   $0    Difference                           $2,407                                                     Dining out
Total                                  $1,361              $1,374                 ($13)

Transport                  Projected Cost           Actual Cost          Difference        Entertainment              Projected Cost        Actual Cost        Difference
Vehicle 1 payment                        $350                 $350                   $0    Videos/DVDs                                                                      $0
                                                                                                                                                                                       savings
                                                                                                                                                                                                                                                          EXPENSES
Vehicle 2 payment                        $200                 $200                   $0    CDs                                                                              $0
Bus/taxi fare                            $100                 $100                   $0    Cinema                                   $50                $50                  $0                                                                            BY CATEGORY
                                                                                                                                                                                 personal care
Fuel                                      $60                   $60                  $0    Concerts                                $300               $300                  $0                                      housing                                         1300
Insurance                                 $50                   $50                  $0    Sporting events                                                                  $0                                      transportation                         housing   800
                                                                                                                                                                                          pets
Maintenance                               $20                    $0                 $20    Theatre                                 $100               $100                  $0                                      insurance                                        500
                                                                                                                                                                                                                                                           transportation
                                                                                                                                                                                          gifts                     food
Licensing                                                                            $0    Other                                                                            $0                                                                             insurance 700
Other                                                                                $0    Total                                  $450               $450                   $0                                      children                                         500
                                                                                                                                                                                 entertainment                                                             food
Total                                    $780                $760                   $20                                                                                                                             entertainment                                    500
                                                                                                                                                                                      children                                                             children
                                                                                           Gifts and Donations        Projected Cost        Actual Cost        Difference
                                                                                                                                                                                                                    gifts                                  entertainment
                                                                                                                                                                                                                                                                     400
                                                                                                                                                                                          food
Insurance                  Projected Cost           Actual Cost          Difference        Charity 1                                                                        $0                                      pets                                   gifts     800
Home                                                                                  $0   Charity 2                                                                        $0       insurance                      personal care                          pets      200
Health                                      $50                   $50                 $0   Charity 3                                                                        $0                                      savings                                          500
                                                                                                                                                                                 transportation                                                            personal care
Life                                                                                  $0   Total                                       $0                 $0                $0
Other                                                                                 $0                                                                                                                                                                   savings
                                                                                                                                                                                        housing
Total                                       $50                $50                    $0   Pets                       Projected Cost        Actual Cost        Difference
                                                                                           Food                                                                             $0                    0
                                                                                                                                                                                                      200    400
Food                       Projected Cost           Actual Cost          Difference        Vet                                                                              $0                                        600
Groceries                                $200                 $300                -$100    Grooming                                                                         $0                                                800
                                                                                                                                                                                                                                     1000   1200
Dining out                               $500                 $200                 $300    Toys                                                                             $0                                                                     1400
Other                                                                                $0    Other                                                                            $0
Total                                    $700                $500                 $200     Total                                       $0                 $0                $0

Children                   Projected Cost           Actual Cost          Difference        Personal Care              Projected Cost        Actual Cost        Difference
Medical                                                                               $0   Medical                                                                        $0
Clothing                                 $200                 $200                    $0   Hair/nails                                                                     $0
School tuition                                                                        $0   Clothing                                $100               $400             -$300
School supplies                          $200                 $200                    $0   Dry cleaning                                                                   $0
Administration fees                                                                   $0   Health club                                                                      $0
Lunch money                              $100                 $100                    $0   Admin                                                                          $0
Childcare                                                                             $0   Other                                                                          $0
Toys/games                                                                            $0   Total                                  $100               $400             ($300)
Other                                                                                 $0
Total                                    $500                $500                     $0   Loans                      Projected Cost        Actual Cost        Difference
                                                                                           Personal                                                                         $0
Legal                      Projected Cost           Actual Cost          Difference        Student                                                                          $0
Solicitor                                                                             $0   Credit card                                                                      $0
Child support                                                                         $0   Credit card                                                                      $0
Payments                                                                              $0   Credit card                                                                      $0
Other                                                                                 $0   Other                                                                            $0
Total                                        $0                   $0                  $0   Total                                       $0                 $0                $0

Savings/Investments        Projected Cost           Actual Cost          Difference        Taxes                      Projected Cost        Actual Cost        Difference
Retirement account                                                                    $0   Income tax                                                                       $0
Investment account                                                                    $0   Council rates                                                                    $0
College/University                                                                    $0   Other                                                                            $0
Other                                                                                 $0   Total                                       $0                 $0                $0
Total                                        $0                   $0                  $0