Skip to main content
Skip table of contents

Export Fee Files

Introduction

The platform allows you to export detailed fee files after calculating fees for client portfolios. These exported files provide a comprehensive summary of fee data, including management, success, brokerage fees and more serving as official records for reporting, auditing and client communication. Each file contains portfolio information, fee rates, calculated amounts, relevant dates and other key transaction details, helping you track, analyze, and share fee data efficiently.

Key Terminologies

Term (A-Z)

Definition

Accounting Period

The time range for which the fee is calculated and reflected in the exported file.

Calculated Amount

The final fee value computed based on configured rules, portfolio data, and selected dates.

Fee Rate

The percentage or amount used to calculate a specific type of fee for a portfolio.

Management Fee File

A file that summarizes management fees applied to portfolios, including rates, amounts, dates, and portfolio identifiers.

Success Fee File

A file summarizing success fee calculations based on portfolio performance during a selected period.

👉 New to some terms? Check our full Platform Glossary for quick definitions.

Where to Export Fee Files

When you calculate fees on the platform, you can export detailed files summarizing the fee data by clicking the three dots menu (…) next to each fee entry in the table and selecting Download.

Exported Fee Files Overview

These exported files serve as official records of fee calculations and can be used for reporting, auditing or client communications.

  • Management Fee File: Contains details about management fees charged on portfolios during a specific accounting period. It includes portfolio information, fee rates, calculated amounts and relevant dates.

Exported File Fields Reference:

Field on Platform

Field on Template

Sample Data (Demo)

Description

Portfolio.name

PORTFOLIO

Venture PF Capital

The name of the portfolio for which the management fee is being calculated.

LastAccountingDate

ACCOUNTING PERIOD

Total period:

2025-01-01 - 2025-03-31

The accounting period for which the management fee is calculated, shown as a total period (start to end dates).

(Date rows)

2025-03-07, 2025-03-08,
2025-03-09, 2025-03-10...

Each individual date within the accounting period for which the portfolio’s value or AUM (Assets Under Management) is recorded. Used for daily average calculations.

AUM (in Portfolios)

AUM AT THE DATE $

20000

The value of assets under management on the given date. Daily AUM values are used to compute the average AUM for the fee calculation.

ManagementFeeRate

MANAGEMENT FEE RATE %

0.3

The annualized management fee rate applied to the portfolio value to calculate the management fee.

ManagementFee

MANAGEMENT FEE $

133

The calculated management fee amount for the portfolio for the specified accounting period or date range.

Min Amount (toggle button)

MANAGEMENT FEE MIN AMOUNT $

500

The minimum management fee payable. The client is charged either this minimum amount or the calculated fee, whichever is higher.

  • Success Fee File: Captures data related to success fees earned, reflecting portfolio performance between defined periods. It includes portfolio details, success fee calculation parameters and final fee amounts.

Exported File Fields Reference - General Info Tab:

Field on Platform

Field on Template

Sample Data (Demo)

Description

Portfolio.name

Portfolio

Venture PF Capital

The name of the portfolio for which the success fee is being calculated.

Name

Fee name

Q12025

A descriptive title or label assigned to a fee entry to identify and distinguish it within reports or records.

Type

Type

Success

The type of fee being reported. Here it indicates "Success" fee, differentiating it from other fee types like management fees, etc.

StartDate

Start date

2025-01-01

The starting date of the accounting period during which the success fee is being calculated.

EndDate

End date

2025-03-31

The ending date of the accounting period during which the success fee is calculated.

Sj

Sj

120000

The portfolio value at the end of the accounting period. Represents the current valuation of the portfolio.

LastSFDate

Last sf date

2024-12-31

The date when the success fee was last charged. This is used to determine the reference point for the current success fee calculation.

HighWaterMark

HWM

100000

The highest portfolio value at the end of any prior accounting period when a success fee was charged. Acts as the baseline that profits must exceed for success fee calculation.

OutFlow

Out flow

-3000

The total value of assets withdrawn or transferred out of the portfolio between the last success fee date and current period end. This reduces the portfolio value for fee calculation.

InFlow

In flow

2000

The total value of assets contributed or transferred into the portfolio between the last success fee date and current period end. This increases the portfolio value for fee calculation.

ManagementFeeRate

Management fee rate %

1

The percentage rate applied to calculate the management fee, which is deducted before calculating the success fee.

ManagementFee

Management fee

1000

The total management fee amount charged for the current accounting period, deducted from portfolio value before success fee calculation.

SafekeepingFeeRate

Safekeeping fee rate %

0

The annualized percentage rate applied to calculate the safekeeping fee, based on the value of assets held.

SafekeepingFee

Safekeeping fee

0

The total safekeeping fee amount charged for the accounting period. This fee covers the cost of securely holding and administering the portfolio assets.

SuccessFeeRate

Success fee rate %

10

The percentage rate used to calculate the success fee, applied on the profits exceeding the High Water Mark after adjustments.

SuccessFee

Success fee

1400

The monetary amount of success fee earned for the current accounting period, calculated only on profits above the High Water Mark and adjusted for management fee, inflows and outflows.

CreatedAt

Created at

2025-04-01T10:00:00.121754

The timestamp indicating when this success fee record or calculation was generated or finalized in the platform.

Exported File Fields Reference - AUM breakdown Tab:

Field on Platform

Field on Template

Sample Data (Demo)

Description

Fee Generated for

Portfolio

Indicates the entity for which the fee is being calculated.

AUM (Portfolios > Performance Chart)

Portfolio AUM Total (start date)

995 01537.68

The total value of assets under management at the beginning of the fee calculation period.

AUM (Portfolios > Performance Chart)

Portfolio AUM Total (end date)

2 005 71809.92

The total value of assets under management at the end of the fee calculation period.

Strategy Tab (On Positions)

Not available in case of NO strategy.

Strategies info

Portfolio has strategies in requested period
or
Portfolio has NO strategies in requested period

Indicates whether the portfolio contains any strategy-linked investments during the selected period.

Value

Strategies Value (starting)

1 68914.29

Value of strategy-linked AUM at the start of the period. Empty or 0 if no strategies present.

Value

Strategies Value (end date)

3 74451.21

Value of strategy-linked AUM at the end of the period. Empty or 0 if no strategies present.

AUM

Portfolio AUM excl. strategies (start date)

993 32623.39

AUM at the start of the period excluding strategy allocations.

AUM

Portfolio AUM excl. strategies (end date)

2 001 97358.71

AUM at the end of the period excluding strategy allocations.

Exported File Fields Reference - Outflow Info Tab:

Field on Platform

Field on Template

Sample Data (Demo)

Description

ID

id

ca7b8904-d8b7-4c29-9b1d-706ee1b6a41a

Internal unique identifier for the transaction. Used for tracking and audit.

Transaction Number

Transaction Number

6985623144915VCTRAN231201

External reference number for the transaction.

Instrument Name

Instrument Name

US Dollar Spot

Name of the traded instrument or asset.

Instrument

Instrument

US0378331005.UW

Code or ticker of the instrument. Often a currency or ISIN.

Product ID

Product Id

12345 / null

Product identifier (if linked). May be null.

Type

Type

SECURITY_TRANSFER

Types of transaction available on platform. Types listed below:

  • ADJUSTMENT

  • BLOCK

  • BOND_REDEMPTION

  • BOND_REDEMPTION_PARTIAL

  • BUY

  • CASH_TRANSFER

  • CORPORATE_ACTION

  • EXERCISE_OPTION

  • FEE

  • FX

  • INCOME

  • INFO

  • INTEREST

  • INTERNAL_CASH_MOVEMENT

  • INTERNAL_SECURITY_MOVEMENT

  • INTERNAL_TRANSFER

  • INVESTMENT

  • MARGIN

  • PAYMENT

  • PRODUCT_SUBSCRIPTION

  • PRODUCT_UNSUBSCRIPTION

  • REPO

  • REVENUE

  • REVERSAL

  • SECURITY_TRANSFER

  • SELL

  • TAX

  • TRANSFER

  • UNKNOWN

  • VIRTUAL_SECURITY_TRANSFER

  • WITHDRAWAL

Sub Type

Sub Type

INTERNAL

More specific subtype under the main type. Sub Types listed below:

  • ADMINISTRATION

  • ADR_FEE

  • AMENDMENT_FEE

  • ASSIMILATION

  • AUCTION_TENDER_OFFER

  • BLOCKING

  • BLOCKING_OF_CERTIFICATE

  • BOND_TAX

  • BUY

  • BUY_ISSUE_IPO

  • CALLED

  • CAPITAL_CALL

  • CAPITAL_INCREASE

  • CASH_TRANSFER_FEE

  • COMMISSION

  • COMPENSATION

  • CONSENT

  • CORP_ACTION

  • COUPON

  • CREDIT

  • CUSTODY

  • DEBIT

  • DEPOSIT

  • DEPOSITORY

  • DIVIDEND

  • DIVIDEND_TAX

  • DVP

  • EXCHANGE_FEE

  • EXCHANGE_OF_SECURITES

  • EXECUTION

  • EXPIRY_OF_SECURITY

  • EXPOSURE_FEE

  • FRACTIONAL_SHARE

  • FROM_SPIN_OFF

  • FULL

  • HANDLE_FEE

  • IN

  • INCENTIVE

  • INFO

  • INTEREST_CALCULATION

  • INTERNAL

  • INVOICE

  • ISIN_CHANGE

  • LEI

  • LIQUIDATION

  • LOAN

  • MANAGEMENT

  • MERGE

  • OPERATION

  • OPTIONAL_DIVIDEND

  • ORDER

  • OTHER

  • OTHER_TAX

  • OUT

  • OVERNIGHT_POSITION_FEE

  • PARTIAL

  • PAYMENT

  • PERSONAL_INCOME_TAX

  • PRODUCT_SUBSCRIPTION

  • PRODUCT_UNSUBSCRIBE

  • PUBLIC_OFFER

  • PURCHASE_OFFER

  • REIMBURSEMENT

  • REPO

  • RETRO

  • RETROCESSION

  • REVENUE

  • REVERSE_SPLIT

  • SAFEKEEPING

  • SALES_TAX

  • SECURITIES_LANDING

  • SECURITY_EXCHANGE

  • SELL

  • SERVICE_CHARGE_CALCULATION

  • SETTLEMENT_FEE

  • SPIN_OFF

  • SPLIT

  • SPLIT_ISIN_CHANGE

  • STOCK_TRANSFER_FEE

  • SUBSCRIPTION

  • SUCCESS

  • TAX_CORRECTION

  • TECHNICAL_CORRECTION

  • TICKER_CHANGE

  • TRADING

  • UNBLOCKING

  • UNBLOCKING_BLOCKING

  • VARIATION_MARGIN

  • WITHDRAWAL_FEE

  • WITHHOLDING_TAX

Transaction Date

Trade Date

2023-12-01

The date the transaction was executed.

TradeTime

Trade Time

2023-12-01D21:21:36.294000000

Exact timestamp of the trade, including milliseconds.

Value Date

Value Date

2023-12-01

Date the transaction is settled or becomes effective.

Quantity

Quantity

-30000 / 1 / -1

Number of units transacted. Negative indicates outflow.

MarketPrice

Market Price

1 / 226.84 / 1.04

Price per unit of the instrument.

Currency

Currency

USD / EUR

Currency in which the transaction was carried out.

Portfolio Ccy

Portfolio Currency

USD / EUR

Base currency of the portfolio.

Bank Account

Bank Account

BA_Client

The funding or receiving bank account.

Accrued

Accrued

0

Accrued interest or charges (if applicable). Usually 0.

Net Amount

Net Amount

-30000 / -0.5 / -1

Total cash movement in transaction currency.

Net Amount PF Ccy

Net Amount PF Ccy

-30000 / -0.5 / -1

Net amount converted to portfolio base currency.

FX Pair

USDUSD / EURUSD

Currency conversion pair used.

FX Rate

1 / 100

Rate used for converting to base currency.

Calculation (est.value)

-30000 / -0.5 / -10000

The estimated outflow value in Portfolio Currency. Calculated as: Quantity × Market Price × FX Rate. Always negative for outflows. Used in fee calculations, P&L and reporting.

Exported File Fields Reference - Inflow Info Tab:

Field on Platform

Field on Template

Sample Data (Demo)

Description

ID

id

ba9edbec-b791-447e-bf67-534b08f7

Internal platform-generated ID for each inflow transaction.

Transaction Number

Transaction Number

69856231441549S240904

External reference number for reconciliation and reporting.

Instrument Name

Instrument Name

US Dollar Spot

Full name of the traded or transferred instrument.

Instrument

Instrument

USD / EUR

Standard instrument code or currency code.

Product ID

product Id

1234567 / null

Related product ID (if any). Usually null for inflows.

Type

Type

INVESTMENT/ SELL

Type of transactions.

  • ADJUSTMENT

  • BLOCK

  • BOND_REDEMPTION

  • BOND_REDEMPTION_PARTIAL

  • BUY

  • CASH_TRANSFER

  • CORPORATE_ACTION

  • EXERCISE_OPTION

  • FEE

  • FX

  • INCOME

  • INFO

  • INTEREST

  • INTERNAL_CASH_MOVEMENT

  • INTERNAL_SECURITY_MOVEMENT

  • INTERNAL_TRANSFER

  • INVESTMENT

  • MARGIN

  • PAYMENT

  • PRODUCT_SUBSCRIPTION

  • PRODUCT_UNSUBSCRIPTION

  • REPO

  • REVENUE

  • REVERSAL

  • SECURITY_TRANSFER

  • SELL

  • TAX

  • TRANSFER

  • UNKNOWN

  • VIRTUAL_SECURITY_TRANSFER

  • WITHDRAWAL

Transaction Subtype

SubType

IN / FULL / LOAN

Specific subtype under the main transaction type.

  • ADMINISTRATION

  • ADR_FEE

  • AMENDMENT_FEE

  • ASSIMILATION

  • AUCTION_TENDER_OFFER

  • BLOCKING

  • BLOCKING_OF_CERTIFICATE

  • BOND_TAX

  • BUY

  • BUY_ISSUE_IPO

  • CALLED

  • CAPITAL_CALL

  • CAPITAL_INCREASE

  • CASH_TRANSFER_FEE

  • COMMISSION

  • COMPENSATION

  • CONSENT

  • CORP_ACTION

  • COUPON

  • CREDIT

  • CUSTODY

  • DEBIT

  • DEPOSIT

  • DEPOSITORY

  • DIVIDEND

  • DIVIDEND_TAX

  • DVP

  • EXCHANGE_FEE

  • EXCHANGE_OF_SECURITES

  • EXECUTION

  • EXPIRY_OF_SECURITY

  • EXPOSURE_FEE

  • FRACTIONAL_SHARE

  • FROM_SPIN_OFF

  • FULL

  • HANDLE_FEE

  • IN

  • INCENTIVE

  • INFO

  • INTEREST_CALCULATION

  • INTERNAL

  • INVOICE

  • ISIN_CHANGE

  • LEI

  • LIQUIDATION

  • LOAN

  • MANAGEMENT

  • MERGE

  • OPERATION

  • OPTIONAL_DIVIDEND

  • ORDER

  • OTHER

  • OTHER_TAX

  • OUT

  • OVERNIGHT_POSITION_FEE

  • PARTIAL

  • PAYMENT

  • PERSONAL_INCOME_TAX

  • PRODUCT_SUBSCRIPTION

  • PRODUCT_UNSUBSCRIBE

  • PUBLIC_OFFER

  • PURCHASE_OFFER

  • REIMBURSEMENT

  • REPO

  • RETRO

  • RETROCESSION

  • REVENUE

  • REVERSE_SPLIT

  • SAFEKEEPING

  • SALES_TAX

  • SECURITIES_LANDING

  • SECURITY_EXCHANGE

  • SELL

  • SERVICE_CHARGE_CALCULATION

  • SETTLEMENT_FEE

  • SPIN_OFF

  • SPLIT

  • SPLIT_ISIN_CHANGE

  • STOCK_TRANSFER_FEE

  • SUBSCRIPTION

  • SUCCESS

  • TAX_CORRECTION

  • TECHNICAL_CORRECTION

  • TICKER_CHANGE

  • TRADING

  • UNBLOCKING

  • UNBLOCKING_BLOCKING

  • VARIATION_MARGIN

  • WITHDRAWAL_FEE

  • WITHHOLDING_TAX

Transaction Date

Trade Date

2024-09-04

The date the inflow transaction was executed.

TradeTime

Trade Time

2024-09-04D18:02:33.871000000

Exact timestamp of trade execution.

Value Date

Value Date

2024-09-04

Settlement date when the cash or asset is booked.

Quantity

Quantity

5000, 8640000, 20000

Number of units received or transferred in.

MarketPrice

Market Price

1 / 1.04 / 110.88

Price per unit used for valuation.

Currency

Currency

USD, EUR

Currency of the transaction.

Portfolio Ccy

Portfolio Currency

USD, EUR

Base currency of the receiving portfolio.

Bank Account

Bank Account

BA_Client_1

Bank or broker account where inflow was received.

Accrued

accrued

0 / 2.01

Accrued interest (if applicable).

Net Amount

Net Amount

5000 / 1800000

Total received in transaction currency.

Net Amount PF Ccy

Net Amount PF Ccy

5000 / 1800000

Total received converted to portfolio currency.

FX Pair

USDUSD / EURUSD

Currency conversion pair used in the transaction.

FX Rate

1 / 100

Rate applied to convert currency if needed.

Calculation (est.value)

5000 / 210932.8 / 2000000

The estimated value of the inflow in Portfolio Currency. Calculated as: Quantity × Market Price × FX Rate. Always positive for inflows. Used in performance tracking and fee calculations.

🔗 Take a quick look at the Troubleshooting & FAQs section if you need help.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.