TOOLS

Kakeibo allows you to set up expense items that fit your life

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

Ⅰ. Let’s start

Save the Kakiebo file to your PC. You can change the name of the file without any problem.

Open the File

These tools are 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.

The Kakeibo 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. Click here to see the sample.

How to command

You can switch the screen by clicking on a tab. You can also execute the process by clicking a button.

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

Ⅱ-1

Step1. Set Bank Accounts

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.

Ⅱ-2

Step2. Set Credit Cards

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.

Ⅱ-3

Step3. Set Income Items

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.

Ⅱ-4

Step4. Set Categories (Pro, Light)

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 expenses that occur every month, such as housing and utilities, while Variable are expenses that vary from time to time, such as food and transportation.

In Kakeibo Pro and Light, you can manage many expense items by grouping them into categories. You can also set your budget for each category.

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 a monthly budget amount.

d. Note

Enter any notes you wish.

Ⅱ-5

Step5. Set Expense Items

To set your expense items, click on [Expense Items] in the main menu or tab. This step will help you learn how to set up your expense items in Kakeibo Pro, Light and Kakeibo Note.

Kakeibo Pro, Light

In Kakeibo Pro and Light, you can set up your expense items for each category. Follow the steps below to add or remove expense an item.

1 Select the relevant category from the drop-down list.

2 Click the [Add] or [Delete] button.

3 The command will be executed.

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

In Kakeibo Note, you can set up your expense items in the sheet below, and set your budget for each expense item.

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 a monthly budget amount.

d. Note

Enter any notes you wish.

Ⅱ-6

Step6. Set Required Expenses / Subscriptions

For Kakiebo Pro and Light, click on [Required Expenses / Required], and for Kakeibo Note, click on [Subscriptions] from the main menu or tab. In the following sheet, enter information about your regularly paid expenses. Kakeibo Note doesn’t have F that is the expense items of the fixed category.

Using the posting function, data entered in this sheet will be automatically posted to the [Expenses] sheet, which saves your work.

a. Expense Item

F The expense item in the Fixed category is displayed. Protected. Pro, Light
V Select the relevant expense item from the drop-down list.

b. Description

F The expense item name in the Fixed category is displayed. Protected. Pro, Light
V 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.

Posting

The data that you enter in this sheet will be automatically posted to the [Expenses] sheet.

1 Enter [Yes] in the [Posting] field of the relevant expense.

2 Click the [POSTING] button.

3 The selected expense data will be posted to the [Expenses] sheet.
Depending on the number of data selected, it takes some time such as a few tens of seconds.

TIPS

To use the posting function, the cycle, month, and day are required to enter. If you select a month that is not this month, a warning message will appear. If you select [] for month or day, the date of posting will be entered in the date column of the [Expenses] sheet.

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

Three solutions to try when you cannot save an Excel filePrev

Enter text and click a button, easy to use Excel household account book!Next

ARCHIVES

  1. MS EXCEL

    Basic knowledge of Excel
  2. TOOLS

    How to fix “######” in cells…
  3. TEMPLATES

    Enjoy Saving money by imagining what you…
  4. MS WORD

    How to format a date to uppercase month …
  5. TOOLS

    Learn how to use WoEmail, an email compo…
PAGE TOP