Bank Transaction Import Main

Overview

This screen is used for reconciling bank accounts by importing .csv files supplied by the bank/payment provider, which are then matched to the transactions recorded in Khaos Control. The screen is accessed by typing BI, BX or bankimport in the Command Window prompt. For how to use this screen to automatically reconcile payments, see How To: Reconcile Bank Accounts by Importing .csv Files.
Note: This functionality is currently available for the following bank accounts;

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

Actions and Information Area

Actions Button

• Import Transactions: opens a dialog to navigate to the downloaded .csv file from the bank.
• Match: attempts to match payments from the bank transactions grid in Khaos Control to payments that also exist in the bank import file.
• Create Transactions: saves any transactions imported and marks entries as reconciled where matches exist.

Imported Bank Transactions Grid - these directly match your statement

• Imported Transaction:
  • Date: the transaction date.
  • Type: TBC
  • Description: description of the transaction.
  • Credit: the amount in the credit column in the bank import file.
  • Debit: the amount in the credit column in the bank import file.
  • Company: the payer/payee's name.
  • Email: the payer/payee's email address.
  • Transaction ID: TBC
• Status:
  • Has Setup: indicates if the setup tab has been used to automatically create a S/P journal entry for the transaction.
  • Skipped: TBC.
  • Journal ID: the journal ID of the matched transaction in Khaos Control.
  • Match Result: TBC

Context Menu

The imported bank transactions grid context menu contains the following options:

• Auto Focus Bank Grid: TBC
• Toggle Hidden: hides/unhides selected transactions. When hidden, transactions are ineligible for matching.
• Toggle Skipped: TBC
• Manually Match: allows the user to manually match imported transactions to bank transactions in the lower grid.
• Clear Matches: removes matches from selected transactions if they have been matched incorrectly.
• Apply Value Range: allows the user to specify a value that is to be applied to all of the currently selected rows/items for the current column.
• Clear Selection: deselects the currently selected line(s).

Bank Account Transactions Grid - these have been recorded within the system already

• Date: the payment date for the transaction.
• Amount: the transaction amount.
• Company: the payer/payee's name.
• References:
  • Code: the payment code from the bank screen in Khaos Control.
  • Email: the payer/payee's email address.
  • Additional references: any entry in the reference column in the bank screen in Khaos Control.
  • Auth Code: the authorisation code for credit card transactions.
• Status:
  • Reconciled: indicates if the transaction has already been reconciled.
  • Banked: indicates if the transaction has been marked as banked in Khaos Control.
  • Journal ID: the journal ID for the transaction in Khaos Control.

Context Menu

The bank account transactions grid context menu contains the following options:

• Goto Company...: opens the [ Customer | Detail | General ] screen for the customer linked to the transaction.
• Apply Value Range: allows the user to specify a value that is to be applied to all of the currently selected rows/items for the current column.
• Clear Selection: deselects the currently selected line(s).

See Also

• Accounts overview