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**.

**Table of Contents**hide

## 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.

- 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.

- After that, use
**Fill Handle**to**AutoFill**the rests.

- 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**.

- Followingly, press the
**ENTERÂ**button.

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

- 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**.

- Press
**ENTER**to have the result.

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

- 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.

- 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**.

- Next, press
**ENTER**.

- You can modify the dataset as your wish.

__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**

**How to Make a College Budget in Excel****Make a Budget in Excel for College Students (with Quick Steps)****How to Make a Wedding Budget in Excel (2 Suitable Methods)**

### 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.

- 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.

- Followingly, click on
**Create**.

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

**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.