Download the official Canopy Pro Tool for Trustees workbook [attached below]
Open the official Canopy workbook in Excel
Install the Canopy Excel Add-In from the Microsoft Office Add-In Store
Open the installed Canopy Add-In and
Enter your credentials (Username and password)
Make sure to select the correct server [Mainline, Credit Suisse, Bank of Singapore]
Click <Login>
Once logged in, click on the <Pro-Trust> button in the task pane of the Add-In
Note:
Pro-Trust can only be used on Canopy’s official worksheet associated with Pro-Trust.
You will receive a warning and won’t be able to access any Pro-Trust functionality otherwise
Steps to load transactions and account information (information can be entered in the appropriate fields directly within the spreadsheet or in the task-pane):
Enter the parent username [Optional]
Enter child username(s) separated by commas [Optional]
Enter the name of the ledger tab [Required]
Enter the name of column to use in the ledger tab [Required]
Enter a “From Date” to filter transactions after the entered date [Optional]
Enter a “To Date” to filter transactions before the entered date [Optional]
Enter the maximum number of transactions to load per page under “Max Per Page” [Optional]
Enter which page of transactions to load under “Page No” number to load [Optional]
Click <Load Transactions>
This should set the active worksheet to the Extract Accounts tab where all of the appropriate information and transactions will be loaded. Single line transactions can be found on the left table and accounting entries/statements can be found on the right table.
The Extract_Accounts sheet can be cleared at anytime by clicking on the “Clear Sheet” button in the task-pane of the add-in
Notes:
Don’t add any extraneous columns to any of the user defined tables in the Transaction_Details, Account_Mapping and Employee tabs
Don’t edit any of the predefined column headers
Don’t move any of the predefined tables and ensure that each table in the Transaction_Details, Account_Mapping and Employee tabs begins in cell “C7”
Don’t enter any values in to the cells past the last column of each table in the Transaction_Details, Account_Mapping and Employee tabs
For further issues or troubleshooting please reach out via email at connect@canopy.cloud.