Market rate export to Accounting system (CSV file)

Created by Erik Åkerlund, Modified on Mon, 10 Jun 2024 at 10:09 AM by Anna Norfjell

This article explains how to set up a CSV file with market rates from TS that can be manually created and saved at Your own preferences. The CSV file can be set up as an export of rates for accounting purposes (ERP) as well as for information. All settings and actions described below are made in the “Integrations” tab at the autopilot. 

 

Please note that an activity needs to be set up for automatic exports of the report, this article does not include instructions for that procedure. 

 

    1) Mark “Rate export” in the column with integrations and click at “+ Add integration”. Then a new window opens up. 


    2) Choose (mark) “FX rates flat file Exporter” in the roll down list and click “Ok”. The integration is then created, and tab             “overview” opens up at Your screen. You can give it a name and a short description. Then click “Save” in the menu bar.             Refresh the autopilot (via the bread crumb at the bottom) to activate tab for “settings” in integration. 

 

A screenshot of a computer

Description automatically generated

 

A screenshot of a computer

Description automatically generated

 

A screenshot of a computer

Description automatically generated


    3) Register the settings You like to get data for, format and filename etc. Please note that “culture” is country-specific                   formatting. In this example we have chosen data the previous business/bank day with settings from -1 BD and to -1BD,           price currency: SEK, selection for base currencies (if no selection is done all currencies that has a rate/data will be                     included in the file) and tenors (period) SPOT and file name as "FX rate{Year, Month, Day, Hours, minutes and seconds} and         file format CSV. TS will add a unique reference for each file to keep them separated. Click “Apply” to save settings and             update the page (click on the bread crumb at the bottom) to refresh the table with the settings. 

 

A screenshot of a computer

Description automatically generated

 

    4) In tab “mappings” You simply set the name of (Field) and what data to be presented in each column (Expression) in the          file to be created. This is done by using the expression editor within TS. Click plus to add a new row (one per column)              and then “Save”. In the example we have chosen columns to show the dates, base currency and mid prices. Click on the          “pen” to the very right at the row to open expression editor and add or change instructions for the data to be shown in           the column. If you have further questions about the settings, we recommend that You contact TS Support.  

 

 

    5) Press “Run” to create the file. Click on link the window that comes up to view and save the report manually to your                 computer/network. When clicking on “OK” the window will close down, and the file will be exported to TS file storage.             Depending on Your set up for file exports a file transfer to Your SFTP might need to be set up with the help of the TS              support (this article does not cover instructions for this). 

 

A screenshot of a computer

Description automatically generated

 

 

Please note! 

If You prefer a report presenting rates for whole previous month You can copy the integration created above. Then change settings for first day of previous month (FDOPM) to last day of previous month (LDOPM) instead of from -1bd and to -1bd as in the example above. Click “apply” to save and then exit and enter to continue activate changes and “run”. 


 

Permissions needed:

  • Set up Integration
  • Update System setting
  • Update Rate Integrations mapping



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 atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article