Kakeibo Template

How to set Special Expensenes in the household budget(Free Excel template available)

Sponser

Do you ever wonder why you spent so much money when you record it in your household budget and look back?

One of the reasons could be due to a large expense that does not normally occur, such as buying a new appliance.

By setting such large expenses as special expenses, you will not only be able to look back on them easily, but you will also be able to keep track of your annual budget.

What are special expenses?

High and special expenses that are not needed every month are called special expenses.

Examples include life insurance premiums paid annually, car inspections, and travel expenses.

How much is too much is up to each individual, so please feel free to set your own limits.

Advantages and disadvantages of setting special expenses

Advantages

  1. You can keep track of special expenses that occur throughout the year.
  2. You can know your annual budget in advance.
  3. If you have a fixed schedule, you can make an annual list and see how much you need to spend per month and per year.
  4. Household expense items are categorized and easy to understand.

In the past, when I didn't set up special expenses, it was difficult to find where large expenses came from when I reviewed my income and expenses.

When expenses were much higher than in other months, I would find the item with the largest amount, whether it was food or entertainment, and then find the special expense from that item.

And then I could finally figure out, "I bought a new washing machine this month.

By classifying these expenses as special expenses and graphing them, it becomes much easier to understand.

This is a sample of a "household budget sheet," but by categorizing normal expenses and special expenses, you can easily review your spending and see at a glance the changes in special expenses.

Disadvantages

  1. It is difficult to identify annual events and annual expenses.
  2. You are not sure if you should record it as a regular item or a special expense.

You need to know the events and set up the items to be purchased in advance, which makes the work more difficult.

You may be wondering whether it is better to set this item as a special expense or a regular expense.

A birthday party for a family member or a small gift for a friend is not something that occurs every month, but it is not expensive.

In such cases, Record as a special expense anything that does not occur every month but is over $100.

This can be solved by setting up criteria for special expenses.

How do you come up with a budget for special expenses?

Once you know your annual budget for special expenses, the next step is to figure out how to come up with that budget.
There are two ways to budget for special expenses

Make up for it from the bonus

This is a way to save the bonus amount and set aside it as a special expense.
In our family, we use the bonus to cover special expenses.

Set aside from monthly income for special expenses

You can allocate the total budget for the year in 12 months, or if your monthly income varies, you can change the amount to be paid each month.

This accumulation is different from savings.

It has a specific purpose of use, so keep it separate from your savings.

If you still can't make a budget

If you do not receive a bonus or are unable to set aside money every month, you must first work on improving your household budget.

There are two ways to improve your finances: increase your income or decrease your expenses.

Figure out your monthly income and expenses, and if your expenses are higher, improve your household budget.

The steps to improve your household budget

  1. Keep a household account book to keep track of your monthly income and expenses.
  2. Classify your expenses into fixed costs and variable costs.
  3. Check to see if the ratio of fixed expenses is too high, and consider whether fixed expenses can be reduced.
  4. Check if there are any unnecessary expenses in variable expenses.

Fixed expenses include rent, mortgage, utilities, communication costs, and life insurance premiums.

Variable expenses include food, daily necessities, clothing, entertainment, and transportation.

After making the above improvements to your household budget, you can set up special expenses.

If you want to increase your income, you need to change the amount of money you spend on consumption and waste to investment.

How to use the format

Set a budget

You can record special expenses by month and by category.

Please fill in the category name first.
Next, enter the special expense name and budget.
By entering your predetermined expenses, you can get a rough idea of your annual budget.

In the Amount column, enter the amount of the expense when it is actually incurred.

Change the currency unit

The default setting for the currency unit is dollars.

Press the "Select Currency" to select a range of currencies.

Select the currency unit for each sheet.

Click on the money symbol to select the currency unit.
(Home-Currency-Money symbol)

Click on the ”More Accounting Format” to see more unit information.

A sample sheet is included in this format.

Download Special Expenses Format

You can download the "Special Expenses Excel Format" for free.
The paper size is A4.
The download is in zip format, so please unzip it before use.

 

Free Download

 

If you want to print and handwrite, please download the PDF file.
The PDF file does not contain the sample sheets.

 

Excel DownloadPDF Download

 

PickUp

1

This kakeibo template allows you to record and analyze your assets in addition to daily records. Based on the "Free Template with Pipot Tables for ...

2

This digital kakeibo is a household account book that is recorded using an iPad or other tablet device. I am the writer of this article, ...

3

This Excel Household Budget is the 2023 version of the [2022] Excel Household Budget recommended for those who couldn't last. The [2023 version] has been ...

4

I want to keep track of my household finances in a Google Spreadsheet.I also want to do a thorough analysis. Do you have such a ...

5

I have set an asset goal, but I don't know what the next step is. I don't know how much I should set my asset ...

6

This Excel household account book is an Excel household account book that works in conjunction with the household account book to show daily asset movements. ...

7

Do you have such a problem? While an asset management application is sufficient to look back on your finances, anExcel household account book allows for ...

8

This household account book format is a handwritten household account book that you can print out and use. If you are looking for an Excel ...

-Kakeibo, Template