HOME

HOME

PAYMENT | Original features make it easy to manage credit cards and bank accounts

Kakeibo Pro, an Excel household budgeting tool, has two useful features to manage your payments. This article shows you how to use these functions.

The first feature is the credit card reconciliation. 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, which saves a lot of time and work.

The other feature is the bank account debit inquiry. It tallies up the amount of money auto-debited from your bank account and your debit payments, and it displays the details and the total amount on the screen. This feature helps you grasp how much money it debits from your bank account for a month.

Language: English Japanese

1. 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 with 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 charged by the credit card company.

d. Note

Enter any notes you wish.

2. 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 them with the amount charged by the credit card company.

2-1. Simple reconciliation

It tallies the expenditure data entered in each sheet and reconciles it with the amount charged by the credit card company. A 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.

3 The process will be executed, and the result will be displayed.

2-2. 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 is highlighted.

2-3. Check the reconciled data

After the reconciliation 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 enter [ 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 enter [ 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, there is likely 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, your credit card has likely 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.

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

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