Reconciliation is used to check a securities account position or account balance. To this end, position data in an interface file supplied is compared with the positions in Infront Portfolio Manager and the result is written in the log.
Start the reconciliation with the "Reconcile…" button or with FILE, RECONCILE… and then select the file provided in the "Reconciliation" dialogue window. All other function work similar to the "Import" function. For more information, see Import files.
The positions and position deviations detected are noted in the log. To avoid storage or performance problems that can occur in case of large numbers of data records, we recommend to select the "Show only errors" checkbox in the settings for the reconciliation. The log then shows only problematic data records.
You also have the option to track the status of the work in the information bar at any time.
In addition to the log, the "Reconciliation result" tab appears. This contains all of the details.
Shown graphically on the overview page is the result of the reconciliation. Red bars denote erroneous data, green bars error-free data.
Use the buttons at the top to switch to the detailed tables for accounts and securities accounts. Green rows are OK, whereas blue text areas indicate errors in the negative reconciliation (position in Infront Portfolio Manager which is not available at the bank); red text stands for errors in the positive reconciliation.
For more information on how to change settings, see Bank-specific settings,"Reconciliation" tab
For more information about how to exclude securities accounts and accounts of other banks in the same default zone for the negative reconciliation of an interface, see Assign banks for negative reconciliation.
Examples
Tips
To also view the messages separately according to individual securities accounts, just drag the column header into the area at the very top of the table.
If you then open one of these tables using the appropriate command in the context menu or using the icon in the toolbar in another application, such as Excel or editor, the settings (sorting, grouping, filtering) are transferred and can also be printed. For more information on saving and opening tables in other programs, see the section on Open the table of missing securities in other programs, because the possibilities described there are available for all tables of this type.
Use the "Automatic column width" icon in the toolbar to optimise the table display via mouse click.
By using the "Show/hide columns" icon, you can adjust the table according to your needs in the "Select columns" dialogue window that appears, just as in Infront Portfolio Manager. Select the checkbox for the columns that you want to display and clear the checkboxes of the columns that you do not currently need.
Use the "Restore original columns" icon to undo changes to the layout.
Use the "Save column definitions and filter settings" icon on the far right of the toolbar to save your configuration of the table.
The "Positions OK" column shows the status of the relevant securities positions and can be used to filter the list accordingly.
The control messages in the log are displayed as warnings (orange).
These messages are divided into the following categories:
Positive position control All securities positions available to the bank are entered correctly in Infront Portfolio Manager.
Negative position control Some unexpected positions are available, that is, positions appear in Infront Portfolio Manager of which the bank is not aware.
