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.
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 . To manage saved views, click .
To open a reconciliation item, click . For the field descriptions, see Reconciliation item details.
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 .
System security
Information about the position's security in the FA system.