How To: Match and Create Payments in Bank Accounts by Importing .csv Files

Overview

You can reconcile bank accounts by importing .csv files supplied by the bank/payment provider, which are then matched to the transactions recorded in Khaos Control.
Note: This functionality is currently available for the following bank accounts;

1. Barclays
2. Natwest
3. Paypal
4. Lloyds
5. Klarna

Prerequisites

1. The .csv file must contain the following headings (although this also depends on the bank the import is for):
   • Number
   • Date: used for matching the transactions.
   • Account: either positive or negative depending on whether it is a debit or credit. This is used for matching the transactions.
   • Subcategory
   • Memo
2. The file must be saved as a .csv file and easily located.

Process

1. Type BX into the command window and press Enter.
2. Press Ctrl+N or click . (This is found in the Menu Bar at the top of the screen).
3. In the New Import popup:
   1. Select the bank account in Khaos Control that the reconciliation is for.
   2. Select the type of file to be mapped:
      .
   3. Click OK.
4. Update the following as appropriate:
   1. Description
   2. Swap Debit/Credit signs
5. Click on the button.
   1. Select Import Transactions.
   2. Navigate to and select the downloaded .csv file from the bank.
   3. Click Open, the information contained in the file will populate the upper grid.
6. Click on the button.
   1. Select Match.
   2. The system will attempt to match payments from the bank transactions grid in Khaos Control to payments that exist in the bank import file.
7. Click on the button.
   1. Select Create Transactions.
   2. The system will save any transactions imported and marks entries as reconciled where matches exist.
8. Close the screen, those reconciled entries can be seen in the [ Bank Account ] screen, see How To: View a previous reconciliation.

See Also

• Accounts overview