Cash reconciliation
...
Instrument Reconciliation
Positions exists in accounts and are the result of transactions being made for certain assets.
- Positions > Instrument (in this example Mutual Funds)
Balance Dimension: Settlement
Balance Date: the day before
Click Search and Export to CSV (bottom of the right corner) When the export is made to Excel we can make a Pivotable (Insert > Pivo table).
Columns: Asset.ISIN
Rows: Account.AccountType.Label
Values: Amount
We can now compare the positions of custody and customer with counterparty accounts.