Canoe Intelligence Integration
- Martin Zahner
Apliqo can integrate with Canoe Intelligence (Canoe) API’s.
To use the functionality a subscription from Canoe is required.
System Integration
The integration between Canoe and Apliqo is setup and manged by Apliqo.
If any issues arise, the client can contact apliqoC3.helpdesk@cubewise.com for assistance.
Configuration in Canoe
Maintain the Entries (Benefical Owners and Legal entities) and the documents in Canoe UI.
https://client.canoesoftware.com/
Logins are provided by Canoe Intelligence.
Please consult the Canoe Intelligence documentation for further support
Account Configuration
Entities configuration
Investment configuration
Investment - Entity Allocation
Setup in Apliqo
Setup Entities
This screen allows you to compare the available Entities in Canoe with the Investment Vehicles in Apliqo LPPM and ensure all Investment Vehicles are mapped to an Entity.
Where to find it?
System Management - Canoe Entities
How to use it?
Load Canoe Entities by pressing the load button
Apliqo will sync all the entities from the organisations on Canoe.Maintain the Investment Vehicle structures in the “Apliqo Investment Vehicles” Widget
Add/Move/Delete the Vehicles (e.g. Legal Entities or Beneficial Owners) in the structureCopy/Paste the Canoe Entity API_id from the “Canoe Entities” Widget to the CanoeAPI_id in the “Apliqo Investment Vehicles” Widget in the correct Investment Vehicle
Setup Funds
This screen allows you to compare the available Funds in Canoe with the Funds in Apliqo LPPM and ensure all Funds are mapped to the correct unique ID code used in Canoe.
Where to find it?
System Management - Canoe Funds
How to use it?
Setup funds in Canoe Intelligence
Maintain the Funds and the map documents in Canoe UI.
https://client.canoesoftware.com/
Logins are provided by Canoe Intelligence.
Please consult the Canoe Intelligence documentation for support
Load and Map Canoe Funds with Apliqo
Management of Canoe Funds with Funds in Apliqo
Account Statement Data Load
Where to find it?
System Management - Canoe Data Load
How to use it?
Check the data already loaded
Apliqo loads nightly the data for the current quarter from Canoe
Load new documents from Canoe
If new document data on Canoe has been loaded the upload can be enforced
Account Statement Check
Capital Call Notice Check
Current vs. Automated Load - Account Statements
Current vs. Automated Load - Capital Notices
Data Transformation
Once you have established connectivity between Canoe and Apliqo you can begin transmitting
your documents.
Standard Transformation
All loaded data, nightly batch are automatically transformed according to the defined mappings per fund.
Shows the transformed data by the standard transformation, this is the basis for the custom mappings . Either from standard mappings or custom mappings.
Contributions
Capital
Periode
Current notice
Distributions
NAV
Apliqo LP PM Input (Canoe Load view)
Displays the data in the LP PM model.
Reload the data into LP PM model to test the adjusted mapping
Manual data entry
If data is required that is not reported by the GP in the account statement, e.g. un-/realized Carry, the input can be done in the Fund Data Input UI. see https://apliqoux.atlassian.net/wiki/spaces/AISD/pages/2436530565
Mapping Table
Use custom mappings if custom transformations for funds are required
Use this table to create custom mappings to individually select the native Canoe fields to include in each Fund Input data entry field. You can enter directly in the table for all fields except the 'Canoe Staging Transform Measure' where the 'Edit' button is used to select the components from the Canoe documents to sum into the Fund Input field.
Create custom mapping
The data load from the Canoe Source Data Model to the LP PM Model
Manual override of Canoe Values
In case values from Canoe needs to be overwritten, the values are entered in “fund data input” - “Direct/GmbH Manual override”
To change the load process check the “Manual Input” in the Mapping Table in the “Data Management” - “Canoe” - “Data Transformation Account Statement/Capital Calls/ Distributions”
Source Data