HOME

HOME

How to start and set items

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 and remove them and freely categorize them according to your life. In this article, you can learn how to start and use this tool, and setting.

Language: English Japanese

1. Let’s start

1-1. Open the File

This tool was created by programing 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 button. 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 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 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 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 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 automatically allocated by the system. They cannot be changed by the user.

b. Category (Required entry)

Enter the name of 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 automatically allocated by the system. They cannot be changed by the user.

b. Expense Item (Required entry)

Enter the name of 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 items.

a. No (Protected)

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

b. Expense Item (Required entry)

Enter the name of 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 in changing the name of the item. (e.g., V0202 Household → Household Supplies)

HOME

Best for budgeting and analysis!

There are three types of Kakeibo: Note, Light, and Pro. Here is for more information.

Also, each of them is available in four different colors. You can check the products on my SHOP.

Recent post
  1. Three solutions to try when you cannot save an Excel file

  2. How to format date to uppercase month in mail merge document

  3. [ Mail Merge in Word ] Print out documents in batch using Excel data

  4. How to find out if you have a 32-bit or 64-bit OS and applications

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

TOP