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 properties.
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 .
- 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 in the System portfolios section.
- Security
The security of the portfolio position in the FA system. Security details include System security code, System security ISIN, System security name, Trade code, Update codes.
and the details of the matching security in the FA system:
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.