HOME

HOME

SETTING | Things you do before household budgeting

Firstly, begin the setup process by adding essential information such as your bank and credit card accounts and income and expense items. You can easily add or delete items. It allows you to add up to 99 items.

In household accounting, item selection is the key. You can set up income or expense items and categories freely for your lifestyle, and create your household budget. This article shows you how to start, use, and set up in Kakeibo.

Language: English Japanese

1. Let’s start

1-1. Open the File

This tool was created by programming in VBA. Therefore, when you open the file, the following security warning message will appear. Please follow the step below to enable the macro.

Excel for Windows

For the Windows version of Excel, the following SECURITY WARNING message will appear. Click Enable Content to proceed and avoid the popup reappearing in the future.

Excel for Mac

For the Mac version of Excel, the following message will appear. Click Enable Macros to proceed.

1-2. The menu screen

When you open the file, the menu screen below will be displayed. Click on the menu on the left to display the relevant function screen. Here you can customize the initial main menu area by entering messages, memos, and pictures in the blank area to the right. For example, you can create a calendar and use it as a schedule manager.

1-3. How to use

This tool is a simple design and easy to use with data entry and clicking buttons. You can use it without Excel skills.

2. Set up the initial settings

Firstly, begin the setup process by adding essential information such as your bank and credit card accounts and income and expense items. Thereafter you can input your income and expenses. Complete the setup process with the following steps:

Step1. Set Bank Accounts

Register your bank accounts for your household budget. To set your bank accounts, click on Bank Accounts in the main menu or tab, and input data in the sheet below.

a. No (Protected)

Entry numbers are unique identifiers and are automatically allocated by the system. They cannot be changed by the user.

b. Bank Accounts (Required entry)

Enter the name of your bank account.

c. Note

Enter any notes you wish.

Step2. Set Credit Cards

Register your credit cards for your household budget. To set up your credit cards, click on Credit Cards in the main menu or tab, and input data in the sheet below.

a. No (Protected)

Entry numbers are unique identifiers and are automatically allocated by the system. They cannot be changed by the user.

b. Credit Card (Required entry)

Enter the name of your credit card.

c. Pay Date

Enter the date when the payment will be paid from your bank account.

d. Close

Enter the cutoff date of billing.

e. Bank Account (Required entry)

Select the relevant bank account from the drop-down list to allocate your credit card.

f. Note

Enter any notes you wish.

Step3. Set Income Items

Register your income items for your household budget. To set your income items, click on Income Items in the main menu or tab, and input data in the sheet below.

a. No (Protected)

Entry numbers are unique identifiers and are automatically allocated by the system. They cannot be changed by the user.

b. Income Item (Required entry)

Enter your income item.

c. Note

Enter any notes you wish.

Step4. Set Expense Items

Register your expense items for your household budget. This tool allows you to set up your expense items according to your life. You can manage your household budget in a rough or detailed manner.

Kakeibo Note allows you to manage your expenses simply, while Kakiebo Light and Pro allow you to group your expense items into categories.

Kakeibo Pro & Light

In Kakeibo Pro and Light, you can set up categories, which are major categories of items, and then set up expense items for each category. You can also set your budget for each category.

Set Categories

To set your categories, click on Categories in the main menu or tab. Set up your categories for each Fixed and Variable in the sheet below. Fixed are those expenses that occur every month, such as housing and utilities. Variable are those expenses that occur from time to time, such as food and transportation costs.

a. No (Protected)

Entry numbers are unique identifiers and are automatically allocated by the system. They cannot be changed by the user.

b. Category (Required entry)

Enter the name of the expense category.

c. Budget

Enter monthly budget amount.

d. Note

Enter any notes you wish.

Set Expense Items

To set your expense items, click on Expense Items in the main menu or tab. You can set up your expense items for each category in the sheet below. To add an item, select the relevant category from the drop-down list and click the ADD button. Clicking the DELETE button will delete the last data in the specified category.

a. No (Protected)

Entry numbers are unique identifiers and are automatically allocated by the system. They cannot be changed by the user.

b. Expense Item (Required entry)

Enter the name of the expense item.

c. Note

Enter any notes you wish.

Kakeibo Note

To set your expense items, click on Expense Items in the main menu or tab, and input data in the sheet below. In Kakeibo Note, you can set your budget for each expense item.

a. No (Protected)

Entry numbers are unique identifiers and are automatically allocated by the system. They cannot be changed by the user.

b. Expense Item (Required entry)

Enter the name of the expense item.

c. Budget

Enter monthly budget amount.

d. Note

Enter any notes you wish.

Step5. Set Required Expenses / Subscriptions

You can register your regular expenses such as utility bills, monthly membership fees, etc. in the following sheet and use the automatic posting function to automatically post the data to the expenses sheet.

In Kakeibo Pro and Light, click on Required Expenses in the menu or tab, and register your regular expenses in the sheet below. Expense items classified as Fixed category will be automatically entered as Required Expenses into F.

In Kakeibo Note, click on Subscriptions in the menu or tab, and register your regular expenses in the sheet below.

a. Expense Item – F

The expense item in the Fixed category is displayed. It is protected.

a. Expense Item – V, Note

Select the relevant expense item from the drop-down list.

b. Description – F

The expense item name in the Fixed category is displayed. It is protected.

b. Description – V, Note

Enter the description of the expense.

c. Store

Enter the store or payee.

d. Method

Select the method for the payment from the drop-down list.

e. Payment

Select the relevant bank account or credit card from the drop-down list if you select [ Debit ] or [ Credit ] in Method. Enter the payment such as electronic money if you select [ Other ] in Method.

f. Amount

Enter the payment amount.

g. Cycle

Select the relevant cycle from the drop-down list.

h. Month

Select the relevant month from the drop-down list. Select [ – ] for every month.

i. Day

Select the relevant day from the drop-down list. If the payment date is unspecified, select [ – ].

j. Post

Enter [ Yes ] for automatic posting to the Expenses sheet.

k. Note

Enter any notes you wish.

3. Things to keep in mind when setting items

The monthly and annual income and expense tables are based on codes (alphanumeric characters preceded by the name of the item), and the income and expense data are totaled.

For example, if you enter data for an expense and then change the item to something different from what you originally set (e.g., V0202 Household Supplies → Transportation), the total will not be correct. If you change V0202 to Transportation at some point, items that were previously entered as Household Supplies will be counted as Transportation expenses. However, there is no problem with changing the name of the item. (e.g., V0202 Household → Household Supplies)

Related Articles

HOME

Analyze your household with graph

* You can check the trend of up to four items in graphs.

* You can also compare an item for up to four different years.

Here is for more information.

Recent post
  1. How to highlight today’s date in Excel

  2. How to highlight cells or rows that match a condition

  3. Three solutions to try when you cannot save an Excel file

  4. How to format date to uppercase month in the mail merge document

To display the list of articles, please create at least 4 articles in the custom post Blog.

TOP