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:
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.
Receive and 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 (see Reconciliation), FA system reads them as is. If the file format is unsupported, you need to create a mapping.
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, provided that the integration delivers the 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:
Open the Data sources view in FA Operations and click Add data source.
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. Define the frequency, date and time 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.
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.