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 data sources. 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) Set up handling positions that are missing from the data source. 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.
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 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, 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.
- 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).
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.
Handle positions missing in the data source
You can define how reconciliation handles positions that are present in FA Platform but missing in the custodian data. By default, position reconciliation shows a mismatch if it finds extra positions that are present in FA Platform but missing in your custodian's reconciliation file. You can change this behavior by excluding a portfolio or a security from reconciliation.
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".