Many analysis functions in Canopy are very insightful, especially topics like historical returns, performance of strategies or attribution of net value moves over certain time periods.
Please read on for the types of statements suitable for the first time and subsequent times to ensure your reports are processed accurately and in a timely manner.
In general, we are looking for:
Initial move-in holding positions
Cash Transactions (any transaction that impacts cash)
Security Transactions (any transaction that impacts asset holdings, for e.g. stock splits)
Ending Positions or periodic month-end holding positions for accurate reconciliation
Relevant Documentation that describes transaction types and performance impact
Initial Statement Upload
If you are uploading data to Canopy for the first time, please provide the following:
Month-end holdings summary for the month preceding account inception, and for the ending month in your chosen period (If account inception is 1 Jan 2021, please provide holdings summary as of 31 Dec 2020)
Transactions details from day of account inception (from 1 Jan 2021)
Current account transactions from day of account inception (from 1 Jan 2021)
A client wants to upload 6 months of investment data starting from 1 Jan 2021, he/she provides the following:
Open Positions for 30 Dec 2020 and 30 Jun 2021
Historical ledger (all transactions and cash account details) for period 1 Jan 2021 – 30 Jun 2021
Note: If you would like all Canopy historical month-end market values to match the statements exactly, please provide the month-end holdings summary for every month since account inception.
Ongoing Statement Upload
Once your initial data has been uploaded, please provide the following types of statements for subsequent data upload:
Month-end Holdings summary
Monthly Transactions details
Monthly Current Account transactions
Note: We have found that some “interim statements”, “summary reports” or “trade confirmations” are unreliable across level of information, level of detail and accuracy of information. For that reason, we seek your help to obtain “official month-end statements”.
Acceptable File Formats
Original electronic PDF (searchable text)
We do not accept scanned paper statements as we find that using Optical Character Recognition (OCR) leads to data errors.