Import of Bank acc transactions/adjustments in CSV format

Created by Erik Åkerlund, Modified on Tue, 12 Dec, 2023 at 9:48 AM by Teuvo Suoraniemi

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 BankaccoutCSVDealImporter 
  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 what different deal IDs was received-


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. 

Currencypair only needed if FX spot rate will be included. 


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article