Kakeibo, an Excel household budgeting tool, has four sheets for tracking your data: Income, Expenses, Special Expenses, and Excluded Expenses.
You can enter detailed income and expenditure data into each sheet. After completing the initial setup, you can choose the income or expense item that you set from the drop-down list. When entering expense data, you can choose the payment method (Debit/Credit/Cash/Other) from the drop-down list, which helps you grasp what you paid for them.
If you use Excel’s shortcut key or the automatic posting function of this tool, you can save your time and work to enter data. This article shows you how to enter data for income and expenses.
Language: English Japanese
1. 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.
2. 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 any items as you want.
Sample of Expense Entry
You can learn how to enter the data for the purchase of multiple items at M. Supermarket and paid with A credit card.
Enter Household Supplies
Enter your purchase for household supplies with the following steps.
a. Date: Enter the date of purchase.
b. Expense Item: Select [ V0202. Household Supplies ] from the drop-down list.
c. Description: Enter [ Daily necessities], your purchase.
d. Store: Enter [ M.Supermarket ], store name.
e. 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.
f. Sum: Select [ Y1 ] from the drop-down list. Pro
g. Method: Select [ Credit ] from the drop-down list.
h. Payment: Select [ C01. A credit card ] from the drop-down list.
i. Pay Date: Enter the payment date of A credit card.
j. Note: Enter any data that you wish.
k. Item1, Item2: Enter any data that you wish.
Enter Staple Food
Follow the same procedure for entering data as for Household Supplies.
b. Expense Item: Select [ V0101. Staple Food ] from the drop-down list.
e. 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
Follow the same procedure for entering data as for Household Supplies.
b. Expense Item: Select [ V0102. Groceries ] from the drop-down list.
e. 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.
TIPS
You can copy information in an Excel worksheet easily by using the shortcut key. You can learn the two ways to copy information.
Ctrl + C
Select the cell or cell range you want to copy, and press Ctrl + C. Select the cell where you want to paste your data, and press Ctrl + V.
Ctrl + D
You can copy one cell above to the active cell by pressing Ctrl + D. You can also select the cell range and press Ctrl + D to copy multiple cells at once.
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.
3. 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.
4. 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.
5. Automatic posting expense data
You can automatically post your regular expenses such as utility bills and monthly membership fees to the expenses sheet. In Kakiebo Pro and Light, click on Required Expenses or Required from the main menu or tab. In Kakeibo Note, click on Subscriptions. The steps are as below.
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. If you select a lot of items, it will take some time to post them into the sheet.
TIPS
To use the automatic 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. You can also modify the date posted on the expenses sheet later.