Import of guarantees

First look at the article Import from CSV general

Go to Integrations add a new integration called CSVGuaranteeDealImporter

If you both have Issued and Received Guarantees you need to set up two different Integrations.

The following fields are Mandatory for Issued Guarantees:

• Applicant
• Guarantor
• Deal date
• Begin date
• End date ( if there is no end date please write 9999-01-01)
• Currency 
• Amount
• External Identifier

Benficiary counterpart is also good to include but is not mandatory as this counterparty does not need to be set up in Master Data for an Issued guarantee.

Amount shall have negative signs in the file.

External Identifier must be unique for each imported guarantee. You can either include 1,2,3 or include another identification value that is unique for all guarantees imported. 

An example below on column mapping for issued guarantees.

Applicant is the same as Legal Entity (need to be set up before in Master Data)

Guarantor is Counterparty (need to be set up before in Master Data) 

Beneficiary (is a text field so do not need to be set up in Master Data to be able to import issued guarantees)

You can either have Applicant or Legal Entity and Guarantor or Counterpart in the file. Import what you name the headers in the file.

Culture means how the date format is and also the number format. If for example sv-SE, date is yyyy-MM-dd and 1 000,50

The following fields are Mandatory for Received Guarantees:

• Applicant
• Beneficiary
• Deal date
• Begin date
• End date ( if there is no end date please write 9999-01-01)
• Currency 
• Amount
• External Identifier

Applicant is the Applicant (is a text field so do not need to be set up in Master Data to be able to import received 

Beneficiary is the Legal Entity (need to be set up before in Master Data)

Guarantor is the Counterparty (need to be set up before in Master Data) 

Amount shall have positive signs in the file.

It is possible to import with the headers, Legal Entity and Counterpart instead of Beneficiary and Guarantor. Important is to map in Settings tab the correct File Header name in the file.

Culture fi-FI and nb-NO date format in the file shall be dd-MM-yyyy. 

Example of mapping for importing Received Guarantees:

If the same value is included in the file as set up in TS (Legal entity, counterpart, tags), then you can check Automatch and no further translation needs to be done. 

If other values than named in TS you need to map them in the lower section by Add rule.

 Note! Fees can not be imported

Note if there are fields included in the file which should not be imported. it is possible to choose Ignore, only needed if there are not headers in the file. 

Example files for Received guarantees and Issued guarantees.