HOME

HOME

INPUT | Easy operation to input income and expense data

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.

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