How to Make a Household Budget in Excel (2 Smart Ways)

A planned life is a secured life. We love to plan our life. But most often it does not get along with our plans. We plan again considering the mistakes done the previous time. In our life, we make a household budget to lead our life in a planned way. Here, I am going to explain the procedure of how to make a household budget in Excel.


Download Practice Workbook


2 Smart Ways to Make a Household Budget in Excel

1.  Manual Process to Make a Household Budget

We can manually make a household budget based on our incomes. One of many ways of making a household budget is explained in the following section.


Step-1: Create an Income Summary

We make our household budget depending on our income. So, the whole income summary is the first thing we need to create.

Steps:

  • First of all, estimate all the possible income ways in the Projected Amount column.
  • Then, write down the actual value at the end of the month in the Actual Amount column.

How to Make a Household Budget in Excel

  • Use the following formula to find the difference in income budget:
=C7-D7

Here,
C7 = Projected salary in the job
D7 = Actual salary in the job

  • Now, press ENTER to have the result.

How to Make a Household Budget in Excel

  • Now, input the following formula to have the total projected amount:
=SUM(C7:C9)

Here, the SUM function returns the value adding cells C7:C9.

How to Make a Household Budget in Excel

  • Followingly, press the ENTER button.

  • AutoFill the cells in sideways to have the total value of the Actual Amount and Difference columns.

How to Make a Household Budget in Excel

  • You can customize your data based on your choice.


Step-2: Create an Expense Summary

To make a suitable household budget, one must have an idea about the expenses.

Steps:

  • Write down the projected amount of expenses.
  • Then, calculate the total projected expenses using the following formula:
=SUM(I7:I21)

Here, the SUM function returns the value adding cells I7:I21.

How to Make a Household Budget in Excel

  • Press ENTER to have the result.

  • Next, use Fill Handle to the right cell to AutoFill the summation of Actual Amount.

How to Make a Household Budget in Excel

  • After that, use the following formula to find the difference in the expense budget:
=I7-J7

Here,
I7 = Projected expense in the Mortgage
J7 = Actual expense in the Mortgage

  • Hit ENTER to have a different result.

How to Make a Household Budget in Excel

  • Next, AutoFill the rest cells.

  • Now, calculate the total difference in the budget using the following formula:
=SUM(K7:K21)

Where the SUM function returns the value-adding cells K7:K21.

How to Make a Household Budget in Excel

  • Next, press ENTER.

  • You can modify the dataset as your wish.

How to Make a Household Budget in Excel


Step-3: Comparison between Budget and Reality

Here, I have tried to show the difference between the projected value with the actual value to summarize the total household budget.

Read more: How to Make a Family Budget in Excel (2 Effective Ways)


Similar Readings


2.  Using Template to Make a Household Budget

It is the easiest way to make a household budget is to use the default template from the Excel Budgets option. Making a household budget using template is explained in the following section.

Steps:

  • Go to the File tab first.

How to Make a Household Budget in Excel

  • Then, select the New tab.
  • From there, click on Budgets.

  • In the search section, write Household Budgets to have the template.
  • Next, select the template.

How to Make a Household Budget in Excel

  • Followingly, click on Create.

Finally, we will have the Household Budget format in Excel. You can customize the budget section depending on your case.

How to Make a Household Budget in Excel

Read more: How to Do Budgeting and Forecasting in Excel (2 Suitable Ways)


Conclusion

I have tried to simply explain the two smart ways how to make a household budget in Excel. It will be a matter of great pleasure for me if this article could help any Excel user even a little. For any further queries, comment below. You can visit our Exceldemy site for further information on Excel.


Related Articles

Naimul Hasan Arif

Naimul Hasan Arif

Hello, I am Arif. I am an Engineer who graduated from BUET. I want to pursue an enterprising career in a progressive environment where my skills & knowledge can be enhanced to their maximum potential to contribute to the overall success and growth of the organization.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo