This is important to enable Excel automatically add the totals whenever you put in figures. Sixth Step: After creating the heading and subheadings for income and expenditure, the next step is to input your calculations. This may be on utility, TV license, mortgage payments, leisure, shopping, gas, broadband, insurance, etc.
The names on this column will depend on the things you and your household spend your money on. The next thing to do is to include the expenditure column in the same column you typed the income. Begin by typing each month (in the example below we begin from January) on a separate cell in the spreadsheet as shown below.įourth Step: Next, add heading and subheading for the income and below it, such as benefits, pension, salary, depending on the type of income received. Third Step: You need to input the months for which you want to make the budget. Usually, Excel will total up the expenditure and income for you. Since we are talking about budget here, you will need to put in figures for “expenditure” and “income”. Second Step: You need to input data to help you calculate the figures for the budget. This is done by clicking the Excel icon in your computer (located on your desktop or your start-up page) But before you begin, you need to have a computer with Excel spreadsheet (preferably the latest version) installed.įirst Step: Start up the Excel program as it opens up a blank spreadsheet. This section shall take you step by step on the best way to prepare household budget in Excel. Preparing your household budget in this manner can help you do a lot of things such as planning for holiday expenses or preparing for Christmas. With Excel, you can automatically update changes using spreadsheet calculations. A complete plan with Excel can help you see your expenses and incomes at a glance, ensuring that you plan your family’s finances effectively. How To Create Household Budget In Excel Excel is a very important application for the planning of household budget.