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. If you want to give a try on this spreadsheet, you can download it here.Excel Household Budget Template Versions: I put a group function on each month (you can see the (-) minus and (+) plus sign on top of the spreadsheet that you can click to hide or unhide the budget and variance columns. This is your monitor worksheet where you can see your monthly expenses based on your category and compare it with your budget plan. Don't forget to select the correct category for your expenses or the formula won't work as expected. You can periodically fill your income and expenses here and the excel formula will do the rest. Once you finished your budget, you can start filling your real income and expenses in this worksheet. As I already mention above, if you need a household budget with consideration of paying your regular repayments first, this spreadsheet could be the suitable one for you. This is a worksheet where you can put all your budget amount based on your category. You should start from Group Category, then to Category and the last is Subcategory. I already put samples there that you can change. This is a worksheet where you can put your household budget category based on your common category. This file consists of four worksheets with explanation as follows :
I am using this approach based on my expenses where I have to pay all regular repayments first before spare some budget for others. I divided the this household budget into three big parts, budget with regular repayments, budget with irregular repayments but needed monthly and budget as secondary needs or occasionally needed. The basic concept probably the same with many others but the approach is different. The household budget I created here is basically another alternative for many household budget written in excel you can find in internet. It has monthly layout where you can plan your budget monthly within one year period and it is equipped with additional worksheets to manage your particular income and expenses categories. It gives you option to customize the template to meet your specific needs. This is a Household Budget template created for Excel.
0 kommentar(er)
