Autopilot - Activities

With the Autopilot you can schedule different activities in the system e.g. Plugins (integrations to and from other systems), Autofixing, FX rate update, bank accoun reconciliation or Export Reports (data from the system) and emailing of reports.

• A Plugin can be different types of imports and exports to and from the system. For example, Deal import from Trading stations, Market data import, Accounting file exports etc.
• Autofixing refers to the possibility to schedule fixing of interest for floating rate loans, bonds, IRS and bank accounts. 
• Update FX rates: update fx rates on all deals in foreign currency both for accounting and calculating FX gain loss in reports. 
• The autopilot also has the possibility to Export Reports (data in CSV format) from the system to other systems through a SFTP.
• Automatically send distribution report in a email. Payment reminder, List of todays deals, Intercompany statement, In house bank statement
• Preform reconciliaiton on Treasury bank accounts
• Price subsidiary request automatically from imported market data

We are constantly adding activities to the autopilot to minimaze the manual work for our customers. 

How to set up an Activity - Plugin:

The first step to set up the Autopilot is to add the plugin to an activity.

Choose Settings:

Then Activities:

Click on Add to set up a new activity:

Choose Plugin:

Give the Plugin activity a name and description.

Choose which plugin that should be set up and save.

Select the Scheduler tab, Add a new schedule, enter start date etc. and save.

Scheduled runs are displayed in the Overview.

It is also possible to run the activity manually, for example if there is a need to run the activity inbetween the predefined schedule. 

To run manually, choose which Activity you want to run, and press Run:

Under Time Stamp Local you can see when the Autopilot ran the activity, and if it was a success run or not. In the below example 15:57 was run manually, and 15:00 was a scheduled activity.

How to set up an Activity - Autofixing:

Follow the same procedure as above but choose Autofixing in the setup:

In the tab Selection there is a possibility to narrow down the selection of the deals that should have autofixing. For example, narrow down on value dates (if lots of historical transactions should not be dealt with), deal type, legal entity and so on.

To set up the schedule for Autofixing, please see Plugin activity schedule above .

How to set up an Activity - Export Reports:

Follow the same procedure as above but choose Export Report in the setup: 

Choose which report that should be exported:

Note the report needs to be shared with user Autopilot for it to be shown in the list in activities. If it is not shown go back to the report and click in icon shareing and choose autopilot.

The report is exported to Treasury Systems Azure Blob Storage. From there it can be scheduled to be exported to an SFTP hosted at Treasury Systems or with the client.

File format is CSV, and there is possibility to export headers, add file name and choose language in the culture section.

To set up the schedule for Autofixing, please see Plugin activity schedule above.