Result of the assessed reconciliation: Positions

From the result of the assessed reconciliation on the "Securities account" tab, you can find the following further information compared to the classic reconciliation:

Column	Meaning
Market value OK	The icon of this column indicates the status of the market values: The market values of the positions are okay. No target amounts delivered for the market values. The market values of the positions differ.
Accrued interest OK	The icon of this column shows the status of the accrued interest: The accrued interest of the positions is okay. No target amounts delivered for the accrued interest. The accrued interest of the positions differs.
Market value - target	Target positions of the market values.
Market value actual	Actual positions of the market values from the database.
Market value deviation	Absolute deviation between target and actual positions of the market values.
Market value in %	Percentage deviation between target and actual positions of the market values.
Accrued interest Target	Target positions of the accrued interest.
Accrued interest Actual	Actual positions of the accrued interest from the database.
Accrued interest Deviation	Absolute deviation between target and actual positions of the accrued interest.
Accrued interest in %	Percentage deviation between target and actual position of the accrued interest.

Regardless of whether a target position is delivered, your PSI determines an actual value from the database and calculates the deviation. If no target value is transmitted, the column entries of "Target", "Deviation" and "In %" are set to "n/a".

You can find the total amounts of the deviations for market values and accrued interest at the bottom of the table. Values that are not set ("n/a") are calculated as zero. Use the "Grouping" function, for example, to group by securities account numbers, to have the total deviation displayed for a securities account number.

Explanation of the colours in the table:

Colour	Meaning
Red	Position incorrect
Yellow	Only position correct
Green	All values correct

In detail:

Position	Market value	Accrued interest	Result
1	1	1	Green
1	-	1	Green
1	1	-	Green
1	-	-	Green
1	0	0	Yellow
1	0	1	Yellow
1	1	0	Yellow
1	-	0	Yellow
1	0	-	Yellow
0	0/1/-	0/1/-	Red

The following applies:

Value in the top table	Meaning
1	Target and actual values match
0	Target and actual values do not match
-	Target not specified