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.

Fetch reconciliation file in FA

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

  • Use FA standard integrations. Currently, only DNB Bank and custody connection works with FA Operations out of the box. For details, see Bank and custody connections.

  • Upload the file yourself. To do this, you need to consider the following:

    • File format. If the files you receive from your counterparty are in one of the supported formats, FA system reads them as is. If the file format is unsupported, you need to create a mapping. Supported formats are:

    • File upload. To import the data in FA, you need to upload it in the respective FA folder manually or build a Camel route that fetches the file automatically.

    For details about file mapping and file upload, see Import custom CSV files to FA.

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/.

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". If you want to switch from carrying out reconciliation in FA Back from FA Operations, enter "default" as the data source code.

    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.