Import of Bank acc transactions/adjustments in CSV format

This integration can be used to import bank acc transaction for currency exposure or automatic accounting on events on a real bank account or In house bank account.

To set up the integration :

1. Open Integration and add a new BankaccountCSVDealImporter 
2. Give the new integration a name and description
3. In setting select decimal delimiter and ad delimiter usually ; for CSV import
4. In tab mapping do the set up of all files Legalentity, Counterpart and tags
5. Choose Type transfer or adjustment

To run the import click Run from file and select the CSV file you want to import

Click refresh and look in tab history to see if the import was successfully and which different deal IDs that were created.

Mandatory fields

Legal entity 

Counterparty

Payment date

Currency

Amount

Optional fields

Deal date: if not included in file it will be set to same as value date

Tags: Optional

FX spot rate at value date: If not included in file it will be set to the FX rate applicable on value date. 

Currency pair only needed if FX spot rate will be included. 

The default account will be used, if specific account should be used EntityAccount needs to be mapped to entity account send and or entity account receive. If automatch is used (meaning no mapping needs to be done), then the file needs to contain the account number (account name will not work) and the header must be named EntityAccount.