Docstoc

Download Budget Spreadsheet

Document Sample
Download Budget Spreadsheet Powered By Docstoc
					 Budget Planner - Overview / Help

Instructions
                                                                                                              Budget By
You may move from worksheet to worksheet by clicking on the dark blue buttons                 Quick Budget
                                                                                                               Month
located at the top of each worksheet or the blue tabs at the bottom of this workbook.

Enter data in only the white cells with gray borders:        400
Use the drop down boxes Aug To Date           to chart different time periods (Current Month, Prior Month, Yearly, Jan, Feb, etc.)

Quick Budget
Create a quick and easy budget by filling out the white cells on the "Quick Budget" sheet. Enter the "Frequency" by using the drop down menu
provided in each cell. The Monthly/Yearly figures are calculated for you and compared to your Tracking (actual) figures on the "Comparison" sheet.
Make sure "Use this budget for comparison purposes" is selected. (If this box is not selected, the "Budget By Month" figures will be used for
comparison purposes instead.)

Budget by Month
Use the "Budget By Month" sheet to create a budget with greater detail. Select your first budget month by using the drop down box in
the "Income" section. To unhide future months, click the grey button at the top of the sheet labeled "Click here then Ctrl+Shift+0".
Make sure "Use this budget for comparison purposes" is selected if you are building 'a budget by month. (If this box is not selected,
the "Quick Budget" sheet figures will be used for comparison purposes instead.)

Tracking
Use this sheet to track your actual income and spending. Select your first tracking month by using the drop down box in the "Income" section.
These figures will be compared to your budgeted figures on the "Comparison" page.

Comparison
Use this sheet to monitor how well you are sticking to your budget. Compare different time periods by using the drop down box above the
"Income" section

Daily Spending
We've provided this sheet for those interested in tracking their spending on a daily basis. This simple record goes a long way in helping
you stick to your budget.
Quick Budget
                                                                                                                                Chart: Monthly
Income                             Frequency     Amount      Monthly     Yearly                                 Budget Summary
Total Income (net)                                            20000.00   240000.00
  Salary/Wages                   Monthly          10000.00    10000.00   120000.00
  Salary/Wages (Spouse)          Monthly          10000.00    10000.00   120000.00                                                                       20000
  Other                          Weekly                           0.00        0.00
  Other                          Monthly                          0.00        0.00
  Other                          Monthly                          0.00        0.00                                                                       20000


Spending                Total:                        0.00        0.00        0.00
                                                                                          0
Transportation                                        0.00        0.00        0.00
  Auto Loan/Lease                Monthly                          0.00        0.00
  Insurance                      Monthly                          0.00        0.00   $0                $5,000        $10,000        $15,000         $20,000

  Fuel                           Monthly                          0.00        0.00                        Balance     Income    Expense
  Maintenance                    Semi-Annually                    0.00        0.00
  Registration/Inspection        Yearly                           0.00        0.00
                                 Monthly                          0.00        0.00
                                                                                                                Spending Summary
                                 Monthly                          0.00        0.00
  Other                          Monthly                          0.00        0.00                                       00


Home                                                  0.00        0.00        0.00
  Bond                           Monthly                          0.00        0.00
  Garden Service                 Monthly                          0.00        0.00
  Maintenance                    Monthly                          0.00        0.00
  Insurance                      Monthly                          0.00        0.00
  Furniture                      Yearly                           0.00        0.00
  Household Supplies             Monthly                          0.00        0.00
  Groceries                      Weekly                           0.00        0.00
  Rates & Water                  Monthly                          0.00        0.00
  Maid                           Monthly                          0.00        0.00
  Wine club                      Quarterly                        0.00        0.00

Utilities                                                         0.00        0.00
   Phone - Home                  Monthly                          0.00        0.00            Transportation        Home                Utilities
   Phone - Cell                  Monthly                          0.00        0.00
                                                                                              Health                Entertainment       Miscellaneous
   DSTV                          Monthly                          0.00        0.00
   Gas                           Yearly                           0.00        0.00
   Water                         Monthly                          0.00        0.00
   Electricity                   Monthly                          0.00        0.00
   Internet                      Monthly                          0.00        0.00
   Other                         Monthly                          0.00        0.00
   Other                         Monthly                          0.00        0.00

Health                                                            0.00        0.00
  Dental                         Monthly                          0.00        0.00
  Medical                        Monthly                          0.00        0.00
  Medication                     Monthly                          0.00        0.00
  Vision/contacts                Semi-Annually                    0.00        0.00
  Life Insurance                 Monthly                          0.00        0.00
  Other                          Monthly                          0.00        0.00
  Other                          Monthly                          0.00        0.00

Entertainment                                                     0.00        0.00
  Golf                           Monthly                          0.00        0.00
  Dining out                     Monthly                          0.00        0.00
  Events                         Monthly                          0.00        0.00
  Subscriptions                  Monthly                          0.00        0.00
  Movies                         Monthly                          0.00        0.00
  Music                          Quarterly                        0.00        0.00
  Hobbies                        Weekly                           0.00        0.00
  Travel/ Vacation               Semi-Annually                    0.00        0.00
  Other                          Monthly                          0.00        0.00
  Other                          Monthly                          0.00        0.00

Miscellaneous                                                     0.00        0.00
  Dry Cleaning                   Monthly                          0.00        0.00
  New Clothes                    Semi-Annually                    0.00        0.00
  Donations                      Monthly                          0.00        0.00
  Child Care                     Monthly                          0.00        0.00
  Tuition                        Monthly                          0.00        0.00
  College Loans                  Monthly                          0.00        0.00
  Pocket Money                   Monthly                          0.00        0.00
  Gifts                          Monthly                          0.00        0.00
  Credit Card                    Monthly                          0.00        0.00
  Hair                           Quarterly                        0.00        0.00
  Other                          Monthly                          0.00        0.00
  Other                          Monthly                          0.00        0.00
Budget By Month
                                                                                                                                         Chart:        March
                                                                                                      6




Income                           Mar      Apr      May     Jun     Jul      0 Months                                              Budget Summary
                                                                                        Mar to Date




Total Income (net)                 0.00     0.00    0.00    0.00     0.00        0.00                 0




  Salary/Wages                                                                   0.00                 0




  Salary/Wages (Spouse)                                                          0.00                 0
                                                                                                              0
  Other                                                                          0.00                 0




  Other                                                                          0.00                 0




  Other                                                                          0.00                 0
                                                                                                              0


Spending                Total:     0.00     0.00    0.00    0.00     0.00        0.00                 0
                                                                                                              0
Transportation                     0.00     0.00    0.00    0.00     0.00        0.00                 0




  Auto Loan car 1                                                                0.00                 0




  Insurance                                                                      0.00                 0
                                                                                                          0                0             0             1             1         1

  fuel                                                                           0.00                 0                        Balance        Income       Expense
  Maintenance                                                                    0.00                 0




  Registration/Inspection                                                        0.00                 0




  annual licence fees                                                            0.00                 0


                                                                                                                                 Spending Summary
  children transport                                                             0.00                 0




  Other                                                                          0.00                 0
                                                                                                                                                 00

Home                               0.00     0.00    0.00    0.00     0.00        0.00                 0




  bond                                                                           0.00                 0




  Rent                                                                           0.00                 0




  Garden Service                                                                 0.00                 0




  Insurance                                                                      0.00                 0




  Furniture                                                                      0.00                 0




  Wine club                                                                      0.00                 0




  Groceries                                                                      0.00                 0




  Rates & water                                                                  0.00                 0




  domestic help                                                                  0.00                 0




  Maintenance                                                                    0.00                 0




Utilities                          0.00     0.00    0.00    0.00     0.00        0.00                 0




   Phone - Home                                                                  0.00                 0

                                                                                                                  Transportation             Home                Utilities
   Phone - Cell                                                                  0.00                 0




                                                                                                                  Health                     Entertainment       Miscellaneous
   DSTV                                                                          0.00                 0




   Gas                                                                           0.00                 0




                                                                                 0.00                 0                           Budget by Month
  Electricity                                                                    0.00                 0




  Internet                                                                       0.00                 0




  Other                                                                          0.00                 0


                                                                                                          1
  Other                                                                          0.00                 0
                                                                                                          1
                                                                                                          1
Health                             0.00     0.00    0.00    0.00     0.00        0.00                 0
                                                                                                          1
  Dental                                                                         0.00                 0
                                                                                                          1
                                                                                                          1
  Medical                                                                        0.00                 0




                                                                                                          0
  Medication                                                                     0.00                 0


                                                                                                          0
  Vision/contacts                                                                0.00                 0
                                                                                                          0
  Life Insurance                                                                 0.00                 0   0
  Other                                                                          0.00                 0
                                                                                                          0
  Other                                                                          0.00                 0
                                                                                                                    Mar             Apr             May         Jun          Jul


Entertainment                      0.00     0.00    0.00    0.00     0.00        0.00                 0
                                                                                                                                    Expense            Income
  golf                                                                           0.00                 0




  Dining out                                                                     0.00                 0




  Events                                                                         0.00                 0




  Subscriptions                                                                  0.00                 0




  Movies                                                                         0.00                 0




  Music                                                                          0.00                 0




  Hobbies                                                                        0.00                 0




  Travel/ Vacation                                                               0.00                 0




  Other                                                                          0.00                 0




  Other                                                                          0.00                 0




Miscellaneous                      0.00     0.00    0.00    0.00     0.00        0.00                 0




  Dry Cleaning                                                                   0.00                 0




  New Clothes                                                                    0.00                 0




  Donations                                                                      0.00                 0




  school trips etc                                                               0.00                 0




  Tuition                                                                        0.00                 0




  College Loans                                                                  0.00                 0




  Pocket Money                                                                   0.00                 0




  Gifts                                                                          0.00                 0




  Credit Card                                                                    0.00                 0




  Hair                                                                           0.00                 0




  Other                                                                          0.00                 0




  Other                                                                          0.00                 0
Tracking
                                                                                                              Chart:        September

Income                          Mar     Apr     May     Jun     Mar to Date                 Actual Income/Spend Summary
Total Income (net)               0.00    0.00    0.00    0.00          0.00
  Salary/Wages                                                         0.00
  Salary/Wages (Spouse)                                                0.00
                                                                                      0
  Other                                                                0.00
  Other                                                                0.00
  Other                                                                0.00           0

Spending
                                                                                      0
Total Spending:                  0.00    0.00    0.00    0.00          0.00
Transportation                   0.00    0.00    0.00    0.00          0.00
  Auto Loan/Lease                                                      0.00       0             0             0             1             1         1
  Insurance                                                            0.00                         Balance       Income        Expense
  Fuel                                                                 0.00
  Maintenance                                                          0.00
  Registration/Inspection                                              0.00                            Actuals by Month
                            0                                          0.00
                            0                                          0.00
  Other                                                                0.00   1
                                                                              1
Home                             0.00    0.00    0.00    0.00          0.00   1
  Bond                                                                 0.00
                                                                              1
  Garden Service                                                       0.00
                                                                              1
  Maintenance                                                          0.00
  Insurance                                                            0.00   1
  Furniture                                                            0.00   0
  Household Supplies                                                   0.00   0
  Groceries                                                            0.00   0
  Rates & Water                                                        0.00
                                                                              0
  Maid                                                                 0.00
                                                                              0
  Wine club                                                            0.00
                                                                                          Mar             Apr                May              Jun
                                                                                                         Expense           Income
Utilities                        0.00    0.00    0.00    0.00          0.00
   Phone - Home                                                        0.00
   Phone - Cell                                                        0.00
   DSTV                                                                0.00
   Gas                                                                 0.00
   Water                                                               0.00
   Electricity                                                         0.00
   Internet                                                            0.00
   Other                                                               0.00
   Other                                                               0.00

Health                           0.00    0.00    0.00    0.00          0.00
  Dental                                                               0.00
  Medical                                                              0.00
  Medication                                                           0.00
  Vision/contacts                                                      0.00
  Life Insurance                                                       0.00
  Other                                                                0.00
  Other                                                                0.00

Entertainment                    0.00    0.00    0.00    0.00          0.00
  Golf                                                                 0.00
  Dining out                                                           0.00
  Events                                                               0.00
  Subscriptions                                                        0.00
  Movies                                                               0.00
  Music                                                                0.00
  Hobbies                                                              0.00
  Travel/ Vacation                                                     0.00
  Other                                                                0.00
  Other                                                                0.00

Miscellaneous                    0.00    0.00    0.00    0.00          0.00
  Dry Cleaning                                                         0.00
  New Clothes                                                          0.00
  Donations                                                            0.00
  Child Care                                                           0.00
  Tuition                                                              0.00
  College Loans                                                        0.00
  Pocket Money                                                         0.00
  Gifts                                                                0.00
  Credit Card                                                          0.00
  Hair                                                                 0.00
  Other                                                                0.00
  Other                                                                0.00
Comparison                      Compare October                  to Budget                                     October

Income                           Budget       Oct Actual       Vs Budget                           Tracking vs Budget Summary
Total Income (net)                  20,000              0         -20,000
  Salary/Wages                      10000            0.00      -10,000.00                                                                                   20000
  Salary/Wages (Spouse)             10000            0.00      -10,000.00
                                                                             Budget                                                                         20000
  Other                                  0           0.00            0.00
  Other                                  0           0.00            0.00                 0
  Other                                  0           0.00            0.00

                                                                                          0
Spending
                                                                             Tracking 0
Total Spending:                           0                0           0
Transportation                           0              0              0                  0
  Auto Loan/Lease                     0.00           0.00           0.00
  Insurance                           0.00           0.00           0.00              0                5,000          10,000        15,000              20,000
  Fuel                                0.00           0.00           0.00
                                                                                                  Balance (Savings)        Income        Expense
  Maintenance                         0.00           0.00           0.00
  Registration/Inspection             0.00           0.00           0.00
                            0         0.00           0.00           0.00
                            0         0.00           0.00           0.00                                Spending Comparison
  Other                               0.00           0.00           0.00

Home                                     0              0              0
  Bond                                0.00           0.00           0.00
  Garden Service                      0.00           0.00           0.00
  Maintenance                         0.00           0.00           0.00
  Insurance                           0.00           0.00           0.00
  Furniture                           0.00           0.00           0.00
  Household Supplies                  0.00           0.00           0.00
  Groceries                           0.00           0.00           0.00
  Rates & Water                       0.00           0.00           0.00
  Maid                                0.00           0.00           0.00
  Wine club                           0.00           0.00           0.00          0           0    0     0     0     0         0    0     0         0   0    0

                                                                                                   Budget                                Tracking
Utilities                                0              0              0
   Phone - Home                       0.00           0.00           0.00                  Transportation           Home                 Utilities
   Phone - Cell                       0.00           0.00           0.00                  Health                   Entertainment        Miscellaneous
   DSTV                               0.00           0.00           0.00
   Gas                                0.00           0.00           0.00
   Water                              0.00           0.00           0.00
   Electricity                        0.00           0.00           0.00
   Internet                           0.00           0.00           0.00
   Other                              0.00           0.00           0.00
   Other                              0.00           0.00           0.00

Health                                   0              0              0
  Dental                              0.00           0.00           0.00
  Medical                             0.00           0.00           0.00
  Medication                          0.00           0.00           0.00
  Vision/contacts                     0.00           0.00           0.00
  Life Insurance                      0.00           0.00           0.00
  Other                               0.00           0.00           0.00
  Other                               0.00           0.00           0.00

Entertainment                            0              0              0
  Golf                                0.00           0.00           0.00
  Dining out                          0.00           0.00           0.00
  Events                              0.00           0.00           0.00
  Subscriptions                       0.00           0.00           0.00
  Movies                              0.00           0.00           0.00
  Music                               0.00           0.00           0.00
  Hobbies                             0.00           0.00           0.00
  Travel/ Vacation                    0.00           0.00           0.00
  Other                               0.00           0.00           0.00
  Other                               0.00           0.00           0.00

Miscellaneous                            0              0              0
  Dry Cleaning                        0.00           0.00           0.00
  New Clothes                         0.00           0.00           0.00
  Donations                           0.00           0.00           0.00
  Child Care                          0.00           0.00           0.00
  Tuition                             0.00           0.00           0.00
  College Loans                       0.00           0.00           0.00
  Pocket Money                        0.00           0.00           0.00
  Gifts                               0.00           0.00           0.00
  Credit Card                         0.00           0.00           0.00
  Hair                                0.00           0.00           0.00
  Other                               0.00           0.00           0.00
  Other                               0.00           0.00           0.00
Daily Spending Record
Income
Spending                        23rd          24th          25th          26th          27th          28th          29th          30th          31st          1st          2nd          3rd          4th          5th          6th          7th          8th          9th          10th          11th          12th          13th

Total Day's Spending:           1,080.00             0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00          0.00          0.00          0.00          0.00
Transportation                         0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00          0.00          0.00          0.00          0.00
  Auto Loan/Lease
  Insurance
  Fuel
  Maintenance
  Registration/Inspection
                            0
                            0
  Other

Home                            1,080.00             0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00          0.00          0.00          0.00          0.00
  Bond
  Garden Service
  Maintenance
  Insurance
  Furniture
  Household Supplies
  Groceries                      980.00
  Rates & Water
  Maid                           100.00
  Wine club

Utilities                              0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00          0.00          0.00          0.00          0.00
   Phone - Home
   Phone - Cell
   DSTV
   Gas
   Water
   Electricity
   Internet
   Other
   Other

Health                                 0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00          0.00          0.00          0.00          0.00
  Dental
  Medical
  Medication
  Vision/contacts
  Life Insurance
  Other
  Other

Entertainment                          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00          0.00          0.00          0.00          0.00
  Golf
  Dining out
  Events
  Subscriptions
  Movies
  Music
  Hobbies
  Travel/ Vacation
  Other
  Other

Miscellaneous                          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00          0.00          0.00          0.00          0.00
  Dry Cleaning
  New Clothes
  Donations
  Child Care
  Tuition
  College Loans
  Pocket Money
  Gifts
  Credit Card
  Hair
  Other
  Other
14th          15th          16th          17th          18th          19th          20th          21st          22nd      Month

       0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00      0.00    1,080.00
       0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00      0.00       0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00

       0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00      0.00    1,080.00
                                                                                                                               0.00
                                                                                                                               0.00
                                                                                                                               0.00
                                                                                                                               0.00
                                                                                                                               0.00
                                                                                                                               0.00
                                                                                                                             980.00
                                                                                                                               0.00
                                                                                                                             100.00
                                                                                                                               0.00

       0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00      0.00       0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00

       0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00      0.00       0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00

       0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00      0.00       0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00

       0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00      0.00       0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00
                                                                                                                              0.00

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:5
posted:8/14/2011
language:English
pages:7