How to Use the Excel Monthly Household Budget Template

Written by tricia goss | 13/05/2017
How to Use the Excel Monthly Household Budget Template

Microsoft Excel is used by many businesses to track spending, create databases and chart data such as sales and growth percentages. You might not realise, though, that Excel can also help you manage your household. Microsoft offers many free templates that can help you get a handle on things around the house as well as at work. By downloading and completing a monthly household budget, you can plan, track and better control your family's spending.

How to Use the Excel Monthly Household Budget Template

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."

How to Use the Excel Monthly Household Budget Template

Click "Family Monthly Budget Planner" to select that template. Click the "Download" button. The template will open as a new Excel worksheet.

How to Use the Excel Monthly Household Budget Template

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.

How to Use the Excel Monthly Household Budget Template

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.

How to Use the Excel Monthly Household Budget Template

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.

Tip

Save the budget with the month and year added to it by clicking "File" or the "Office Button" and choosing "Save As." Every month save the budget with the new month's name and clear the past month's information.

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.