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.
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:
- Go to [Accounts | Bank Importer | Main].
- Click the Edit button.
- Click the + button next to Bank Importer List.
- Select the type of bank this is for.
- Choose what type of mapping this is.
- Select continue.
- Add the Description of the Bank Import.
- Save Bank Importer.
Specification
Setup a Bank import
To setup Bank Imports:
- Go to [Accounts | Bank Importer | Setup].
- Click the Edit button.
- Click the + button at the top of the grid.
- Add the description for the matching of transactions e.g. GOOGLE ADS1234 14 SEP your matching text could be GOOGLE.
- Repeat step 3 and 4 until you have completed the matching.
- 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:
- Go to [Accounts | Bank Importer | Main].
- Click the Edit button.
- Go to the Actions menu.
- Select Import Transactions.
- Select or drag and drop the file that you want to import.
- Click the Save Bank Importer button.
Match a Bank import
This will match transactions looking at the data you have saved in setup.
This will match transactions looking at the data you have saved in setup.
To match a Bank Import:
- Go to [Accounts | Bank Importer | Main].
- Click the Edit button.
- Go to the Actions menu.
- Click Match.
- 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.
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:
- Go to [Accounts | Bank Importer | Main].
- Click the Edit button.
- Go to the Actions menu.
- Click Create Transactions.
- Select yes and continue.
Reconcile Transactions
Once everything has been matched and created, then you can reconcile your transactions.
Once everything has been matched and created, then you can reconcile your transactions.
To Reconcile Transactions:
- Go to [Accounts | Bank Importer | Main].
- Click the Edit button.
- Go to the Actions menu.
- Click Reconcile Transactions.
- 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.