Skip to main content

Set up data sources

Reconciliation data is uploaded in FA Operations in a file. You can have multiple data sources for reconciliation, for example, if you reconcile positions and cash accounts, or if you receive position information from different custodians.

To make external data available in FA Operations, you need to complete the following steps:

You can set up reconciliation to ignore all or certain positions that are present in an FA portfolio but are missing in the external data. This can be useful, for example, if you have several custodians, or if you have positions in certain securities that you always want to skip. For details, in Skip extra positions in FA system in FA User guide.

Set up the data source in FA Operations

To set up the data source:

  1. Open the Data sources view in FA Operations and click Add data source.

  2. Fill in the fields and define the data fetching options:

    Data source name

    The name of the data source. The data source name is visible in the Reconciliation overview.

    Data source code

    The code used to identify the data source. The data source code must match the name of the FA folder where the reconciliation file is uploaded. For example, if your reconciliation folder is .../nordea, the code must be "nordea". For standard integrations, use the following codes:

    • Bloomberg AIM: aim_positions

    • DNB: default

    • M2 Wealth cash account reconciliation: m2_cash

    • M2 Wealth position reconciliation: m2_positions

    Match portfolios by

    The portfolio property used to match portfolios from FA with the external data source. Choose one of the options: Short name, External ID, Name, Book entry.

    Match securities by

    The security property used to match securities from FA with the external data source. Choose one of the options depending on the identifiers you use: ISIN code, Security code, Trade code, Update code 1-3, Name.

    Data delivery schedule

    The schedule for fetching the external data to FA Operations. Choose the parameters in the fileds or enter the Cron expression in the advanced mode.

    Use settled balances

    Compare only settled account balances.

    Include subportfolios

    Include positions and cash accounts from subportfolios in the reconciliation.

    Reconcile items not in the source data

    Identify mismatches if FA positions are missing in the external reconciliation file. If you receive position information from different custodians, turn off this setting to skip the positions missing in the custodian's file.

    Date adjustment for data delivery

    The delay in receiving the reconciliation data. For example, if the reconciliation file received today contains the data for the previous day, set the date adjustment as "1". If the file is received on the same day, set the date adjustment as "0".

    Time zone

    Time zone used in the data delivery schedule.

    Holiday calendar

    A holiday calendar to take into account in the data delivery schedule, for example, a weekend calendar with Saturday/Sunday weekends. The holiday calendar is used to calculate the dates for upcoming reconciliations and notify the users if the data is missing. The list of available holiday calendars is configured in FA Back (see Preference - Securities).

  3. Click Save.

After you set up the data source, it is shown in the Reconciliation overview, Upcoming reconciliations. You can view the reconciliation items when FA Operations receives external data.

Fetch reconciliation data to the FA system

To fetch reconciliation data to FA system, you have the following options, depending on the custodian and the data format they provide:

  • Use FA standard integrations. At the moment, the following connections work with FA Operations:

  • Upload the data yourself:

    • In MT535 format file: Upload the file manually or using a Camel route. See Upload MT535 file below.

    • In other formats: create a file in FA reconciliation format and upload it in FA Operations. see Upload data in other formats below.

  • If you already use the reconciliation feature in FA Back, you can use your existing integration. Make sure it delivers files to one of the standard file locations {{back.writable.dir}}/reconciliation/standard/ or {{back.writable.dir}}/reconciliation/settlementDate/.

Upload MT535 file

If your reconciliation data is in MT535 format, you can upload it in FA by placing the file manually in the respective folder or configure a Camel route that fetches the file automatically. For details about creating a Camel route, see Creating the Camel route.

Once the file is in the folder, you can track the upload status: open the Reconciliation overview and click queue.png in the upper-right corner.

Upload data in other formats

If your reconciliation data is in a format other than MT535, you need to:

  1. Create a file in the FA reconciliation format. For instructions, see Create a reconciliation file in FA User guide.

  2. Upload the the file in FA Operations:

    1. Open the Reconciliation overview and click upload.png in the upper-right corner.

    2. Select the file, choose the data source and click Upload.

You can track the upload status: open the Reconciliation overview and click queue.png in the upper-right corner.

In this section: