Monday, March 12, 2012

How to Use the Excel Monthly Household Budget Template


1.
Open Excel. If you are using Excel 2007, click the 'Office Button' and then click 'New.' In Excel 2003, click 'File' and then 'New.' Type 'Family Monthly Budget' in the 'Search Online For' box and click 'Go.'
2.
Click 'Family Monthly Budget Planner' to select that template. Click the 'Download' button. The template will open as a new Excel worksheet.
3.
Start in the 'Projected Cost' column. Type in what you expect the costs to be for each item listed that month. You can round off your costs to whole numbers, or put in exact numbers and the template will round them off for you. If you are uncertain how much you might spend on an item, look at past bills or receipts and make an estimate.
4.
Enter the information into the 'Total Actual Cost' column as the month goes along. Every time you spend money or pay a bill, enter the amount into the correct cell. If you already have a number in that cell, add the 2 numbers together and enter the new number into the cell. The template will automatically calculate the difference between your projected and actual spending.
5.
Enter your projected monthly income at the beginning of the month. As you earn money throughout the month, enter this data into the cells in 'Actual Monthly Income.' Your household budget template will help you see what you actually have coming in and where it is going.

Blogger news