Versions Compared

Version Old Version 4 New Version 5
Changes made by

Martin Zahner

Martin Zahner

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

To use the functionality a subscription from Canoe is required.

Setup Entities

Where to find it?

System Management - Canoe Entities

How to use it?

...

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 support

Load and Map Canoe Entities with Apliqo

Management of Canoe Entities with Apliqo Investment Vehicles

further suppor

...

Account Configuration

...

Entities configuration

...

Investment configuration

...

image-20240110-094103.pngImage Added

Investment - Entity Allocation

...

Setup in Apliqo

Setup Entities

Info

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?

  1. Load Canoe Entities by pressing the load button
    Apliqo will sync all the entities from the organisations on Canoe.

  2. 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 structure

  3. Copy/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

Info

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

...

  1. Load Canoe funds by pressing the load button
    Apliqo will sync all the funds from the organisation on Canoe as a list in the “Canoe funds” widget

  2. Copy/Paste the Canoe Fund Id from the “Canoe Funds” Widget to the CanoeAPI_id in the “Apliqo LP PM Funds” Widget

  3. Pick from drill down “Canoe Data Type” the reporting type of the fund

    1. YTD - Year to date

    2. QTD - Quarter to date

    3. ITD - Inception to date

...

Account Statement Data Load

Info

Displays all documents regardless of category and type for the selected fund and date range. Value fields to display can be filtered by selecting the value type (BAL, QTD, YTD, ITD).

Where to find it?

System Management - Canoe Data Load

How to use it?

Check the data already loaded

...

  1. Choose a fund and data filter from Filter Bar

  2. Choose Value Type in filter bar to see the raw data

  3. Check documents and data in Canoe Documents Widgets

  4. Select the type with filter

  5. jump to the Canoe document in the hyperlink “link to document”

image-20240109-161347.pngImage Added

Load new documents from Canoe

...

  1. Press “Load documents from Canoe” in the filter bar

  2. Configure the “Fetch Canoe Documents” Wizard

    1. Fund: optional to choose fund

    2. Start date: optional

    3. End date: optional

Canoe Data Transfer

Source Data

...

Choose a fund and quarter in the filter bar

...

Account Statement Check

Info

This screen is designed as a check so that for a selected quarter you can immediately identify and funds which have no available call notices and see a count of documents by fund by investment vehicle where documents are available. Clicking on the 'Fund' field in the table on the left will filter the table on the right which lists all documents and provides a link directly to each document in the Canoe Inteligent Document Center.

...

Capital Call Notice Check

Info

This screen is designed as a check so that for a selected quarter you can immediately identify and funds which have no available distribution notices and see a count of documents by fund by investment vehicle where documents are available. Clicking on the 'Fund' field in the table on the left will filter the table on the right which lists all documents and provides a link directly to each document in the Canoe Inteligent Document Center.

...

Current vs. Automated Load - Account Statements

Info

This screen displays the variance for each fund with Canoe Load enabled between the data processed from Canoe versus the current state of the Apliqo LPPM Fund Input cube for the selected quarter. By clicking on the hyperlink in the 'Fund' field you will be navigated directly to the mapping screen for the selected fund where you could troubleshoot errors and correct mapping. In any cell in the table itself if you right-click and select 'drill' you can navigate directly to the mapping in the Canoe Intelligent Document Center.

image-20240109-161941.pngImage Added

Current vs. Automated Load - Capital Notices

Info

This screen displays the variance for each fund with Canoe Load enabled between the data processed from Canoe versus the current state of the Apliqo LPPM Fund Input cube for the selected quarter. By clicking on the hyperlink in the 'Fund' field you will be navigated directly to the mapping screen for the selected fund where you could troubleshoot errors and correct mapping. In any cell in the table itself if you right-click and select 'drill' you can navigate directly to the mapping in the Canoe Intelligent Document Center.

...

Data Transformation

Once you have established connectivity between Canoe and Apliqo you can begin transmitting
your documents.

Info

Workflow from loading Canoe account statements, processing the data and loading to the Apliqo LP PM data model. You can use the screen

  1. to perform ad-hoc loads from Canoe,

  2. adjust custom mapping at the fund level,

  3. copy mapping and load data to the Fund Input cube in Aplipq LP PM.

  1. Optional: Press “Process Account Statements” button to process the newly loaded documents

  2. Check if the data is properly transformed
    NB: e.g. the management fees Entity are displayed as negative numbers, the load to the LP PM model will transform them to positive numbers.

image-20240109-162849.pngImage Added

Standard Transformation

All loaded data, nightly batch are automatically transformed according to the defined mappings per fund.

...

  • Contributions

    • Capital

    • Periode

    • Current notice

  • Distributions

  • NAV

  1. Optional: Press “Process Account Statements” button to process the newly loaded documents

  2. Check if the data is properly transformed
    NB: e.g. the management fees Entity are displayed as negative numbers, the load to the LP PM model will transform them to positive numbers.

Info

You can toggle this view between the Fund Input sums or the native Canoe fields. You can also toggle between value types and drill down on different combinations of columns. For most funds 'standard mapping' works in most cases. However some funds report with different definitions and in extra detail which can result in double-counting of components of some Fund Input measures and an incorrect sum. In such cases use the table bwlow to create a custom mapping.

...

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

  1. Delete the entire data in the table by selecting them and press delete

  2. Press “Load to LP PM” button

  3. complete wizard

    1. Mode

      1. load preview: will only display in the table, the stored data remains unchanged

    2. Check in Data Management - Fund Data Input - Infidem Input
      Difference NAV to Value Bridge in historic quarter - the difference should lower then 1%

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 /wiki/spaces/AISD/pages/2436530565

image-20240108-104857.pngImage Added

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

  1. click on “Edit” icon in Measure row. The Measures are the LP PM input Measures, in other words the target measures.

  2. Complete the “Create custom mapping” wizard

    1. Choose single fund or add multiple funds

    2. Select from drilldown “Mapped Canoe Components” the measure from the Canoe Source data model

    3. Press “create mapping” button

  3. Optional: Change “Canoe Data Type 1” to YTD, QTD, ITD

  4. Optional: flip operator from positiv to negative in “Operation 1”

  5. Optional: change weighting to adjust the '000 format

  6. Load to “LP PM” button to start the load and transformation from the Canoe Source data model to the LP PM model

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

  1. Delete the entire data in the table by selecting them and press delete

  2. Press “Load to LP PM” button

  3. complete wizard

    1. Mode

      1. load preview: will only display in the table, the stored data remains unchanged

    2. Check in Data Management - Fund Data Input - Infidem Input
      Difference NAV to Value Bridge in historic quarter - the difference should lower then 1%

Manual data entry

...

...

Measure

Canoe Data Type Default

Manual Input

Map Check 1

Canoe Data Type 1

Operation 1

Canoe Staging Transform Measure 1

Edit

Map Check 2

Canoe Data Type 2

Operation 2

Canoe Staging Transform Measure 2

Edit

...

Source Data

Info

Displays the available account statements and mapped value fields for the selected fund and quarter. Clicking 'reload documents' will perform a manual live refresh from Canoe for the selected fund and quarter only.

...