Bank Importer

Bank Importer

Overview  

The bank importer is used to import files which have been exported from your online banking system. Imported transactions can then create payments or journals and attempt reconciliations.
Alert
This feature is still in testing phase and should be used with caution

Configuration 

Bank Importer is found within Accounts from the left navigation bar.

Adding a new Bank Import

To add a new Bank Import:

  1. Go to [Accounts | Bank Importer | Main].
  2. Click the Edit button.
  3. Click the + button next to Bank Importer List.
  4. Select the type of bank this is for.
  5. Choose what type of mapping this is.
  6. Select continue.
  7. Add the Description of the Bank Import.
  8. Save Bank Importer.

Specification 

Setup a Bank import

To setup Bank Imports:

  1. Go to [Accounts | Bank Importer | Setup].
  2. Click the Edit button.
  3. Click the + button at the top of the grid.
  4. Add the description for the matching of transactions e.g. GOOGLE ADS1234 14 SEP your matching text could be GOOGLE.
  5. Repeat step 3 and 4 until you have completed the matching.
  6. Click the Save Bank Importer button.

Usage

Import Transactions

This is to import the file that you have exported from your bank.

To Import Transactions:

  1. Go to [Accounts | Bank Importer | Main].
  2. Click the Edit button.
  3. Go to the Actions menu.
  4. Select Import Transactions.
  5. Select or drag and drop the file that you want to import.
  6. Click the Save Bank Importer button.



Match a Bank import

This will match transactions looking at the data you have saved in setup.

To match a Bank Import:

  1. Go to [Accounts | Bank Importer | Main].
  2. Click the Edit button.
  3. Go to the Actions menu.
  4. Click Match.
  5. Select continue.

Create Transactions

For anything that was Matched as in the above steps, the system will create a payment or journal, and allocate if appropriate.

To Create Transactions:

  1. Go to [Accounts | Bank Importer | Main].
  2. Click the Edit button.
  3. Go to the Actions menu.
  4. Click Create Transactions.
  5. Select yes and continue.

Reconcile Transactions

Once everything has been matched and created, then you can reconcile your transactions.

To Reconcile Transactions:

  1. Go to [Accounts | Bank Importer | Main].
  2. Click the Edit button.
  3. Go to the Actions menu.
  4. Click Reconcile Transactions.
  5. Select yes and continue.

Video

The bank importer allows users to import real world bank transactions via csv. This video demonstrates how to set up and use the feature.


    • Related Articles

    • Unreconciled Bank Transactions

      Question/Problem How can I un-reconcile a bank transaction? Resolution/Solution It is not possible in KCC to unreconcile bank transactions. It is therefor essential that only items appearing on your bank statement are reconciled.

    • Perform a Bank Reconciliation

      Overview The method used to perform bank reconciliations is described in the following video. The step-by-step instructions are below the video. Steps Open the bank account. Use the filters to refine your entries and populate the grid. Click on the ...

    • Khaos Control Cloud Data Import Mapping - Customers / Suppliers

      Information This page contains the field mapping requirements for customer and supplier imports. This page is also available to download as a PDF from the attachments tab. An example Customer / Supplier import file is available on the attachments ...

    • Order payment in wrong bank account

      Overview Imported orders from a specific customer has their payments going in to the wrong bank account. Resolution/Solution There are three potential workarounds for this issue depending on the circumstances. Workaround 1 Journal between the two ...

    • Sales Order Data Import Mapping

      Information This page contains the field mapping requirements for importing existing sales orders into Khaos Control Cloud (KCC). MANDATORY FIELDS Mandatory fields vary depending on the complexity of the data you are intending to import. Notes A ...