Excel Household Budget Template

Excel Household Budget Template

Excel Household Budget Template

Versions: Excel 2003, Excel 2007 & Excel 2010
Description: Simple Excel Budget Template that automatically calculates the difference between budgeted and actual outgoings, and compares this to income.

Download Now




Using the Excel Household Budget Template

If you enter values into the 'Budgeted Amount' and 'Actual Amount' columns of the above household budget template, the 'Difference' and 'Total' fields are automatically calculated. You can change the row labels to suit your own types of income and outgoings, and add additional rows if you wish.

Some of the cells in the spreadsheet have been locked, to prevent you from accidentally overwriting the formulas in these cells. However, if you wish to have more control over the spreadsheet, you can unlock it by:


In Excel 2003:

  • Click on the Tools drop-down menu
  • Click on Protection and from the sub-menu, select Unprotect Sheet...

In Excel 2007 or Excel 2010:

  • Select the Review tab at the top of your Excel Workbook
  • Click on Unprotect Sheet



Functions Used in the Excel Household Budget Template

The Excel functions and operators used in the above Household Budget spreadsheet are:

- operator The subtraction operator is used to calculate the difference between the actual amount and the budgeted amount, for each entry in the spreadsheet.
If function Used to keep the 'Difference' column of the budget spreadsheet tidy. If no values are present in the corresponding cell of the 'Actual Amount' column, the entry in the 'Difference' column remains blank. Otherwise, the difference between the budget amount and the actual amount is calculated and displayed.
Sum function Used to calculate the totals at the bottom of the budget spreadsheet.
Return to the Excel Templates Page

Return to the ExcelFunctions.net Home Page

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2013 ExcelFunctions.net