Set up data sources
Reconciliation data is uploaded in FA Operations in a file. In addition to fetching the data, you need to:
Set up a data source in FA Operations. You can use multiple data sources for reconciliation, for example, if you reconcile positions and cash accounts, or if you receive position information from different custodians.
(Optional) Exclude positions in FA system from reconciliationYou can set up reconciliation to ignore 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.
Set up a data source in FA Operations
To set up a data source:
Open the Data sources view in FA Operations and click Add data source.
Fill in the fields to define the data matching options. For field descriptions, see Data source settings).
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.
Data source settings
- 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, Custom ID (Portfolio window, IDs tab).
- 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.
- Use settled balance for cash
Compare settled account balances. If disabled, cash account balances are compared based on the transaction date.
- Use settled balance for positions
Compare settled positions. If disabled, positions are compared based on the transaction date.
- Include subportfolios
Include positions and cash accounts from subportfolios in the reconciliation.
Reconcile data missing in data source
Define which positions in FA system are included in the reconciliation and how mismatches are identified. You can choose to include:
Only data source positions: include only positions from the data source. Extra positions present in a portfolio in FA system are ignored. This option is useful, for example, if you receive position information from different custodians. For this option, turn off Reconcile positions missing in source data and Reconcile cash missing in source data options in the data source settings.
Portfolios referenced in the data source: include positions from the data source and all positions in portfolios referenced in the data source (even if not listed in it). If a portfolio referenced in the data source has more positions in the FA system, those positions are included in the reconciliation (the result is a mismatch). For this option, turn on Reconcile positions missing in source data and Reconcile cash missing in source data options in the data source settings.
Portfolios referenced in the data source and belonging to FA portfolio group: include positions from the data source, all positions in portfolios referenced in the data source, and all positions from portfolios belonging to selected portfolio groups in the FA system. Any positions in these FA portfolios not found in the source are marked as mismatches. This option is useful if positions are transferred out of the custodian and aren’t anymore included in the data source. For this option, turn on Reconcile positions missing in source data and Reconcile cash missing in source data and select the portfolio group in the Portfolio groups to reconcile field.
Note that you can also mark which positions and securitites in FA system to exclude from reconciliation. For details, see Exclude positions in FA system from reconciliation.
Schedule
Set 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.
- 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).
Exclude positions in FA system from reconciliation
Data source settings let you choose how to handle positions missing from the source data: you can either include them in the reconciliation or skip them. In addition to the data source serttings, y ou can use more granular approach to skip reconciliation of certain securities. To set it up, you need to go to FA Back:
Ignore all extra positions in the specified portfolio – for example, if the portfolio contains positions from multiple custodians, and the reconciliation is done custodian-by-custodian. To set up this option, open the Portfolio window, Basic info tab in FA Back and enable "Reconciliation: Ignore extra positions in FA".
Ignore extra positions in a certain security in all portfolios – for example, if the reconciled portfolios include unlisted assets that are missing from the reconciliation file provided by your custodian. To set up this option, open the Security window, Basic info tab in FA Back and enable "Reconciliation: Ignore extra positions in FA".