It also means the creation of emergency funds Emergency Funds An emergency fund is a source of money that you refrain from spending and store away safely to use in the time of need. It includes allocating funds towards investments from our savings and paying of retirement premiums and other required savings plans.

This section captures all the premiums and investment-related fees that we must pay towards our investment needs. Any miscellaneous amount spent against property is also captured in this section. The repairs spent on home or maintenance amount spent over the property and the property tax paid are also shown here. Internet, which is an essential requirement for every home now, is also captured in this section. Also, expenses like electricity, gas, water, telephone, and cable are captured here. It takes care of the home loan, which is the EMI paid to the bank. Here in this part, all the expenses related to home/house gets captured. read more from investment and additional recurring/non-recurring incomes flow. The other section can be interested in deposits earned or dividends earned Dividends Earned Dividends refer to the portion of business earnings paid to the shareholders as gratitude for investing in the company’s equity. We capture all the possible sources of income and add it up as the total income. A person can have multiple sources of income. Here we take into account all the income-related numbers.

Finally, the net arrives, which is either positive or negative. Here we calculate the difference between projected and actual income and expense.

A positive net means income is more than expenses, and a negative net means expenses are more than income earned. Finally, the net gives us the difference between expenses and income. The total expenses take the addition of all the expenses which are possible in one’s lifestyle. The total income is the addition of the incomes one gets from various sources. Here we need to enter the set budget/projected balance we plan to allocate from our regular source of income. It sets up an initial budget balance and also gives a projection of the end balance, which is expected to be there after deductions of all the expenses from the incomes. Used to calculate the totals at the bottom of the budget spreadsheet.The household budget template captures all the sources of income one has and also the spending. Otherwise, the difference between the budget amount and the actual amount is calculated and displayed. If no values are present in the corresponding cell of the 'Actual Amount' column, the entry in the 'Difference' column remains blank. Used to keep the 'Difference' column of the budget spreadsheet tidy. The subtraction operator is used to calculate the difference between the actual amount and the budgeted amount, for each entry in the spreadsheet. The Excel functions and operators used in the above Household Budget spreadsheet are: - operator

Click on Protection and from the sub-menu, select Un protect Sheet.įunctions Used in the Excel Household Budget Template.

Select the Review tab on the ribbon at the top of the Excel Workbook.In current versions of Excel (2007 and later): However, if you wish to have more control over the spreadsheet, you can unlock it by: Some of the cells in the spreadsheet have been locked, to prevent you from accidentally overwriting the formulas in these cells. You can change the row labels to suit your own types of income and outgoings, and insert additional rows if you wish. 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. Using the Excel Household Budget Template Simple Excel Budget Template that automatically calculates the difference between budgeted and actual outgoings, and compares this to income. Excel Household Budget Template Versions:

Household budget spreadsheet template