TOOLS

Original functions make it easy to manage your credit cards and bank accounts

Kakeibo Pro has two useful features to manage your payments. The first is the credit card reconciliation feature. This tool reconciles the amount of credit card payment you enter in the expense data sheets with the amount charged by your credit card company. It takes a lot of time and effort to check the statements one by one. With this tool, the reconciliation of each statement is automated, saving you a lot of time and your work.

The other is the bank account debit inquiry feature. This function tallies up the amount of money that is automatically debited from your bank account and the amount of Debit payments, and displays the details and the total amount on the screen. This is useful for understanding how much money is debited from your bank account each month.

In this article, you can learn how to use these functions.

Ⅰ. Enter the credit card billing amount

Click on [Credit Amount] in the main menu or tab. In the sheet below, enter the amount of the charge and other information based on the statement you receive from your credit card company.

a. Pay Date (Required entry)

Enter the date you pay the credit card company.

b. Credit Card (Required entry)

Select the relevant credit card from the drop-down list.

c. Amount (Required entry)

Enter the amount to be paid to the credit card company.

d. Note

Enter any notes you wish.

Ⅱ. The credit card reconciliation feature

Click on [Credit Reconcile] in the main menu or tab. This tool tallies the credit card payment amounts that you enter in the Expenses, Special Expenses, and Excluded Expenses sheets and reconciles with the amount charged by the credit card company.

Simple reconciliation

It tallies the expenditure data entered in each sheet and reconciles it with the amount charged by the credit card company. The simple reconciliation is useful when your credit card usage is low.

1 Select the relevant month and credit card from the drop-down list.

2 Click the [START] button.

2 The process will be executed and the result will be displayed.

Detail reconciliation

This tool reconciles the total data one by one with the billing statement from the credit card company. Before starting the detailed reconciliation, download the statement data in CSV file format from the credit card company’s website. Follow the steps below to reconcile the details.

1 Select the relevant month and credit card from the drop-down list.

2 Check the [Detail] box.

3 Open the downloaded statement data file, extract Date, Description, and Amount, and copy and paste the data into the [Credit Card Statement] list field.

4 Click the [START] button.

5 The process will be executed and the result will be displayed as below.

A It shows ID for matching with the credit card statement.

B If the date and amount match, it shows OK. If only the amount matches, it shows Check. Also, if there are no matching statements, it shows Check. The data marked as Check is highlighted.

C If the data exists in the [Kakeibo] list, it shows Yes. If the data doesn’t exist, it shows No and highlighted.

Check the reconciled data

After the reconcile result is displayed, follow the steps below to check the data.

Check (A) and (a)

1 Search for data that is relevant to [T.Gas] in the credit card statement list.

2 Since ID [C012] applies to (A), and the total amount of (A) and the amount of (a) also match, it considers that (A) is the statement of C012.

3 Enter [OK] in the [Match] column of the [Kakeibo] list and [Yes] in the [Exist] column of the [Credit Card Statement] list. The data will be un-highlighted.

Check (B) and (b)

1 Look for [C025] shown in the [ID] column of the [Kakiebo] list in the [Credit Card Statement] list.

2 Since [E. Learning] entered in the [Store] column of the [Kakiebo] list is also entered in the [Description] column of the [Credit Card Statement] list, and the amount is the same, it considers that (B) is (b).

3 Enter [OK] in the [Match] column of the [Kakeibo] list and [Yes] in the [Exist] column of the [Credit Card Statement] list. The data will be un-highlighted.

Follow the steps above to check the data.

If there are any data inconsistencies, it is likely that there is an input error in the expense data, and you should check the expense data, payment date, etc. If you see an unfamiliar statement in your credit card statement list, it is likely that your credit card has been used fraudulently. In this case, please contact your credit card company for inquiries.

The reconciliation can help you to find data entry errors and fraudulent use of credit cards.

Ⅲ. The bank account debit inquiry feature

Click on [Debit Amount] in the main menu or tab. Here you can select and see the total auto-payment amount and debit payment amount transferred from any bank account and for any given month. The steps are as follows:

1 Select the relevant month and bank account from the drop-down list.

2 Click the [START] button.

3 The tallied total amount and data will be displayed.

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

Kakeibo makes budgeting, payment management, and household budget analysis easy!Next

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

    Learn how to use WoEmail, an email compo…
  2. MS WORD

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

    Kakeibo allows you to set up expense ite…
  4. MS WORD

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

    Display monthly and annual income and ex…
PAGE TOP