TOOLS

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

It has four sheets: Income, Expenses, Special Expenses, Excluded Expenses. You can enter detailed income and expenditure data into each sheet.

You can use the tool with just typing of letters and numbers and clicking of buttons, there is no problem if you don’t have Excel skills. You can easily add, delete, and sort data by just clicking a button. In this article, you can learn how to enter data for income and expenses.

Ⅰ. Enter income data

Click on [Income] in the main menu or tab. Enter the detailed income data in the sheet below. The parts of Item1 and Item2 are editable, and you can set the items as you wish.

a. Date (Required entry)

Enter the date for income.

b. Income Item (Required entry)

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

c. Description

Enter the description for the income.

d. Amount

Enter the income amount.

e. Note

Enter any notes you wish.

f. Item1, Item2

You can set the items as you want.

Ⅱ. Enter expense data

Click on [Expenses] in the main menu or tab. Enter your daily expenses in the sheet below. The parts of Item1 and Item2 are editable, and you can set the items as you wish.

a. Date (Required entry)

Enter the date of purchase.

b. Expense Item (Required entry)

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

c. Description

Enter your purchases.

d. Store

Enter the name of the store where you made the purchase.

e. Amount

Enter the purchase amount.

f. Sum Pro

When paying by credit card, if there are multiple expense items in one payment, select [Y*] from the drop-down list to sum up for reconciling.

g. Method

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

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

i. Pay Date

If you select Credit in Method, enter the payment date of your credit card (the date when your bank account will be debited).

j. Note

Enter any notes you wish.

k. Item1, Item2

You can set the items as you want.

Sample of Expense Entry

You can learn how to enter the data for a purchase of multiple items at M. Supermarket and paid with A credit card.

Enter Household Supplies

1 Date: Enter the date of purchase.

2 Expense Item: Select [V0202. Household Supplies] from the drop-down list.

3 Description, Store: Enter the item you purchased in Description and the store name in Store.

4 Amount: Enter the formula [=(1.48+3.98)*1.1] for products x tax (10%) included.
To round to the second decimal place, enter [=ROUND((1.48+3.98)*1.1, 2)].
Copy this cell and paste the value.

5 Sum: Select [Y1] from the drop-down list. Pro

6 Method: Select [Credit] from the drop-down list.

7 Payment: Select [C01. A credit card] from the drop-down list.

8 Pay Date: Enter the payment date of A credit card.

9 Note, Item1, Item2: Enter any data that you wish.

Enter Staple Food

10 Follow the same procedure for entering data as for Household Supplies.

Expense Item: Select [V0101. Staple Food] from the drop-down list.

Amount: Enter the formula [=1.98*1.08] for products x tax (8%) included.
To round to the second decimal place, enter [=ROUND(1.98*1.08, 2)].
Copy this cell and paste the value.

Enter Grocery Food

11 Follow the same procedure for entering data as for Household Supplies.

Expense Item: Select [V0102. Groceries] from the drop-down list.

Amount: Enter the formula [=15.61-(N1056+N1057)] for Total – (Household Supplies + Staple Food). N1056 and N1057 are the cell numbers where the amounts for Household Supplies and Staple Food are entered.
Copy this cell and paste the value.

About Sum

Kakeibo Pro has the [Sum] field. This is a required field for the credit card reconciliation function. As shown above, by specifying the total amount [Y1], when the credit card payment is reconciled, the amounts [6.01, 2.14, 7.46] of the items purchased on the date [12/31/2021] and the store [M. Supermarket] will be added up and reconciled with the billing statement from the credit card company.

Kakeibo Note and Kakeibo Light do not have a credit card reconciliation function, so there is no [Sum] field on the expense data entry sheet.

Ⅲ. Enter special expenses

Click on [Special] in the main menu or tab. Here you can input special or once off expenses, such as holiday/travel expenses or the purchase of a vehicle or property. This sheet is almost the same as the [Expenses] sheet, but you do not need to enter any expense item.

Ⅳ. Enter excluded expenses

Click on [Excluded] in the main menu or tab. Here you can input expenses that you don’t want to be included in your monthly and annual totals. This sheet is almost the same as the [Expenses] sheet, but you do not need to enter any expense item.

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

Display monthly and annual income and expenses in easy-to-read tables and graphsNext

ARCHIVES

PICKUP PRODUCT

Kakeibo makes budgeting, payment management, and household budget analysis easy! What does this tool provide you?

  • ・Customize the menu screen
  • ・Easy input data
  • ・Set items for your lifestyle
  • ・Automatic Posting
  • ・Budget Management
  • ・Total of income and expenses
  • ・Analyze your household with graphs
  • ・Reconcile credit card payments
  • ・Bank account debit inquiry

There are three types of Kakeibo: Note, Light, and Pro. Each tool is provided in four different colors. You can find more information here.

You can see the items on the netshop Etsy or Base.

  1. MS WORD

    [ Mail Merge in Microsoft Word ] Print o…
  2. TOOLS

    Display monthly and annual income and ex…
  3. TOOLS

    Original functions make it easy to manag…
  4. TOOLS

    Email Marketing & Communications wi…
  5. MS EXCEL

    Basic knowledge of Excel
PAGE TOP