| To design out your budget planner worksheet, you can | | | | budget planner amount and balance the worksheet |
| either use Excel or Word. | | | | again. Keep tracking the spending in the 'actual amount' |
| 1. You should decide on a budget schedule according | | | | column. |
| to your pay periods and bill due dates. | | | | With the budget planner already under way, let us see |
| 2. Next, divide the worksheet into budget categories - | | | | how important the home budget spreadsheet is. |
| income at the top followed by salary, bonuses, | | | | While making your own home budget spreadsheet, |
| commissions, business profit, investments, etc. | | | | keep the following in mind: |
| 3. After point 2 is complete, complete the rest of the | | | | 1. It is easy to use; come on, you are doing a small |
| categories - must pays, family necessities, needs, | | | | home budget and not the budget for a multinational |
| pocket money and emergency. | | | | company or a government department! |
| 4. Type in the budget types - savings, household, | | | | 2. It is a flexible data representation - you can |
| automotive, entertainment, personal allowance. | | | | represent the data in different ways to make analysis |
| 5. After sorting out your income and expense | | | | and taking decisions easier. |
| categories, make two columns at the top of the | | | | 3. In order to make immediate and quick calculations, |
| worksheet for entering the budget amount. | | | | on-hand calculator is available that can be used in the |
| 6. One column should be for 'projected amount' and | | | | absence of a calculator at home. |
| the other column should be for 'actual amount'. | | | | So, before making the spreadsheet, consider the |
| What you have to do is the fill in the 'projected | | | | above three points. In any case, nowadays every |
| amount' column. Then subtract the projected budget | | | | housewife seems to devote time to work out this |
| expense amount from income totals to get a balance | | | | spreadsheet! |
| estimate. You can make necessary changes in the | | | | |