Bank | Limitations | Description | Impact | Type of Limitation | Quality Rating | Ease of Setup |
|---|---|---|---|---|---|---|
BOS | No transactions for derivatives such as forwards, options, accumulators etc. | For example, holdings are reflected for security DXTRA2016XXXXXX on 30 July 2020. On 31 Jul 2020, the security is no longer reflected. Canopy has to do holdings adjustment to open and close these derivative positions. | Canopy to create the transactions for move in of derivatives | No client action required | ★★★★☆ | Easy |
BOS | Prices for corporate actions defaulted to zero | Results in Average Price mismatch- requires manual change of prices | Average price will be incorrect | Info required from client | ★★★★☆ | Easy |
BOS | Missing accrued interest | End-of-month accrued interest amount missing from time to time. This requires manual adjustment and recording | Dirty price may be inaccurate | For client's knowledge | ★★★★☆ | Easy |
Bitstamp | Cash breaks due to rounding | Cash breaks of very small amount (less than 0.05) due to rounding issues. | Nil | ★★★★☆ | Easy | |
CSZH/ CSSG (PsN) | Market Value for FX Forward / FX Options contracts | Market Value for FX forwards/ FX Options not found in the raw data | Market Value will be 0 for these derivatives | Info required from client | ★☆☆☆☆ | Difficult |
CSZH/ CSSG (PsN) | Time Lag | There is time lag between Transactions and Holdings which affects the reconciliation process, some holdings are found without a corresponding transaction in the same day. | Cash/Holdings will have a few days lag | For client's knowledge | ★☆☆☆☆ | Difficult |
CSZH/ CSSG (PsN) | Average Price not found | Average Price is not provided in holdings for reconciliation | Average price may be inaccurate | Info required from client | ★☆☆☆☆ | Difficult |
Fidelity | Trades in foreign (non-USD) currency | a. settlement amounts in foreign currencies are not provided in the data | i. Canopy to derive the settlement amount for non-USD trades using the given USD-equivalent amount and the exchange rate provided. | No client action required | ★★★★☆ | Easy |
Fidelity | Unable to match fidelity's average cost price | a. Security transfer-in prices are not provided | Canopy assumes all securities are transferred in at closing BBG price at transfer date | No client action required | ★★★★☆ | Easy |
GS | Missing Capital Call information for PE funds | PE Capital call amount may be inaccurate till it is updated | No client action required | ★★★★☆ | Easy | |
HSBC | Lag in Private Equity Capital Call | PE Capital call amount may be inaccurate till it is updated | No client action required | ★★★☆☆ | Moderate | |
JPM | Average Price not found in some formats | Some versions of the holdings file contain fewer fields, resulting in columns such as average cost price missing from the data in some instances | Average price will be incorrect | Info required from client | ★★★★☆ | Easy |
LGT | No transactions for derivatives such as forwards, options, accumulators etc. | Similar to BOS, when the FX forward contract expires, the security no longer appears in holdings with no supplement transaction to account for it. Likewise, when a new forward contract is established, there is no transaction to open the holdings. A holdings adjustment is made with such derivative positions. | Canopy to create the transactions for move in of derivatives | No client action required | ★★★★☆ | Easy |
SAXO | FXOption/ Futures expired/created not reflected | For derivatives, when it expires/created, there is no transaction to reflect. | Canopy to create the transactions for move in of derivatives | No client action required | ★★★★☆ | Easy |
SAXO | Average Price discrepancy | After including Purchase/ Sale transactions - there are some average price discrepancies for some stocks which could be due to different calculation methodology | Average price will be incorrect | Info required from client | ★★★★☆ | Easy |
UBS CH | Securities reflected as another CCY | For example, a Security is in PHP CCY, however it is reflected as another CCY due to the presentation shown in statement. In the EAMs/Clients database, they will still see it as PHP. Here, Canopy has to manually change the CCY and update the price to PHP accordingly. | Different securities ticker/ prices shown | No client action required | ★☆☆☆☆ | Difficult |
UBS SG UBS CH | FX Trades incomplete | UBS sends in FX Trades in ZAA_AI300. However, not all trades are reflected in it hence, causing cash breaks whenever FX Trades are required to be reflected. Ie. SpotIn/SpotOut Clients sends us daily transaction files for us to reconcile the missing FX trades. | There may be a lag in reflecting the SpotFX transactions | Info required from client | ★☆☆☆☆ | Difficult |
UBS SG UBS CH | Instrument type for positions not reflected | Instrument type for position file ZAH_AI535 does not include instrument type for the securities held. | Instrument type maybe inaccurate | For client's knowledge | ★☆☆☆☆ | Difficult |
UBS SG UBS CH | Derivatives expired/created not reflected | For FX Forwards, when it expires/created, there's no transaction to reflect. | Canopy to create the transactions for move in of derivatives | No client action required | ★☆☆☆☆ | Difficult |
