Skip to main content

View reconciliations

You can view reconciled positions and cash accounts in the Reconciliation overview:

  • Assigned to me – The list of reconciliation items assigned to you.

  • Open reconciliations – The list of all reconciliation items.

  • Latest finished and closed reconciliations – The list of recent reconciliations that have Finished or Closed status. A finished or closed reconciliation is shown if there is no open reconciliation from the same data source.

  • Upcoming reconciliations – Upcoming reconciliation data that is going to be received by the system according to the schedule.

reconciliation_overview_fa_operations.png

Open reconciliations and view items

To view the reconciliation details, click Open reconciliation. The reconciliation details include:

  • Statistics of matches, mismatches and fixed items.

  • The date for which the reconciliation is carried out.

  • Assignee, comment, and reconciliation attachments.

  • Reconciliation status (open, closed or finished).

You can filter the reconciliation items in the list, and then sort the content by clicking on column titles. To save the view you created and open it again later, click Save view Operations. To manage saved views, click Saved views – tuning icon.

To open a reconciliation item, click Details - double-ended arrow. For the field descriptions, see Reconciliation item properties.

reconciliation_reconciliation_items.png
reconciliation_item_details.png

Reconciliation item properties

You can see the reconciliation item properties in the list of items and in the item details pane that opens on the right.

Reconciliation information

Reconciliation information includes the details of the reconciliation process:

Type

The type of the reconciliation item: position or cash account.

Status

The reconciliation result:

  • Match – The data in the source and in the system are the same.

  • Mismatch – The data in the source differs from the data in the system: the item is missing in the source or in the system or one of the amounts doesn't match.

  • Fixed – The reconciliation item was fixed by correcting the system value or marked as solved.

  • Not processed – The item reconciliation is in progress.

Errors

The mismatch details. The list of errors: Missing source data, Missing system data, Mismatch in amount, Mismatch in market trade amount in security currency, Mismatch in market trade amount in portfolio currency, Mismatch in purchase trade amount in security currency, Mismatch in purchase trade amount in portfolio currency.

Assignee

The assignee of the mismatch.

Comment

Comment on the mismatch.

Attachments

Documents you or other users attached to the reconciliation item.

Position or cash account details

Position and cash account details show the system information about portfolios, securities, and transactions related to the item in the FA system.

Account

Account information for cash balance items. Account details include Source account ID and the details of the matching account in the FA system: System account ID, System account number, System account number 2 (secondary), System account name and Balance.

The item details show all accounts with the matching number found in the FA system. To open the account portfolio in FA Back, click Open in other app - Arrow up-right.

Portfolio

The portfolio that contains the position or cash account in the FA system. Portfolio details include Source portfolio ID and the details of the matching portfolio in the FA system: System portfolio ID, System portfolio external IDs, System portfolio name, Short name, Book entry.

If a cash account is used in multiple portfolios in the FA system, you can view the list of portfolios in the item details. The amounts from all portfolios are summed up.

To open the portfolio in FA Back, open the item details and click Open in other app - Arrow up-right in the System portfolios section.

Security

The security of the portfolio position in the FA system. Security details include Source security ID and the details of the matching security in the FA system: System security code, System security ISIN, System security name, Trade code, Update codes.

Values

You can view the reconciled position or cash account values:

  • Position: amount, market trade amount in security currency, market trade amount in portfolio currency, purchase trade amount in security currency, purchase trade amount in portfolio currency.

  • Cash account: amount (account balance).

FA Operations shows the following information about the reconciled values:

System value

Position amount or account balance in the system.

Source value

Position amount or account balance in the external source.

Difference

The difference between the source and system value (amount).

Difference (%)

The difference between the source and system in percent.