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

reconciliation_reconciliation_items.png
reconciliation_item_details.png

Reconciliation items

The following fields provide general information about the reconciliation item:

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.

Reconciliation item details

Click the item in the table to open the reconciliation item details.

Values

You can view the reconciled position or cash account values:

  • For a 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.

  • For a cash account: Amount (account balance). If a cash account is used in multiple portfolios in the FA system, the amounts from all portfolios are summed up.

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.

System accounts

The list of system accounts for cash balance items. If a cash account is used in multiple portfolios in the FA system, you can view the amounts per portfolio.

System portfolios

The System portfolios section is shown for a position item. It provides the list of portfolios in the FA system that contain the position. If you set up the data source to include subportfolios in reconciliation, this list shows the subportfolios that contain the security.

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

System security

Information about the position's security in the FA system.