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.