Client Profit & Loss Report

The report allows the broker to analyze clients' profits and losses (realized PL) by transactions on client accounts and operation types.

The Account IDs filter allows you to select the accounts for which the report should be generated.

The Account groups filter allows you to generate the report for all accounts belonging to one account group.

To generate the report, select the required period in the Period filter.

After the parameters are selected, the report data is displayed on the page and grouped by the currencies in which profits, losses, and commissions were generated.

To save the report in .xlsx format, click Download report.

Report composition

The following data is displayed in the report header on the first tab of the downloaded file:

Report data is grouped by currency. In the downloaded .xlsx file, a separate tab is used for each currency.

Trading table

The Trading table displays the amounts of Daily PL transactions - daily profits and losses for each instrument category, except for the CASH and options categories.

The Daily PL TOTAL indicator displays the sum of Daily PL values for all instrument categories.

The Settlement block displays the profit or loss for each instrument category resulting from trade settlement transactions, except for the CASH, options, and Forex categories.

The Settlement TOTAL indicator displays the sum of Settlement values for all instrument categories.

Trading commissions table

The Trading commissions table displays the amounts of internal commissions by instrument category. In the Transactions section, they are represented by transactions with the Daily PL type and the Commission subtype.

The TOTAL indicator displays the sum of such commissions for all categories.

Other commissions table

The Other commissions table displays other commissions and fees charged on client accounts.

Each commission or fee type whose total amount for the selected period is not zero is displayed separately. If a transaction has a subtype, it is specified in parentheses after the transaction type.

For example, the table may contain the following indicators:

• External trade commissions - external trade commission amounts. In the Transactions section, they are represented by transactions with the External commission and Asset transfer types;
• Custody fees - custody fees. The indicator includes transactions with the Custody fee type, as well as External commission transactions with the Minimum custody fee subtype;
• Swaps (rollover commissions) - swaps charged for rolling over positions. The indicator includes transactions with the Daily PL type and the Rollover commission subtype;
• Service fee - transactions with the Service fee type;
• Funding fee - transactions with the Funding fee type;
• Cash in (Commission) - deposit commissions: transactions with the Deposit type and the Commission subtype;
• Cash out (Commission) - withdrawal commissions: transactions with the Withdrawal type and the Commission subtype.

Other combinations of transaction types and subtypes, including commissions and other fees related to deposits, withdrawals, and transfers, can be displayed as separate indicators in the same way.

Indicators whose total amount for the selected period is zero are not displayed in the Other commissions table.

In the interface, the Other commissions value displays the sum of all indicators in this section.

In the downloaded file, the TOTAL (with trading) indicator displays the sum of all Other commissions values including the TOTAL value from the Trading commissions table.

Investing table

The Investing table displays the following indicators:

• Dividends - dividend income. Transactions with the Dividend type;
• Coupons - coupon income. Transactions with the Coupon type;
• Bond redemption - bond redemption. Transactions with the Transfer type and the Redemption subtype.

The TOTAL indicator displays the sum of the values in the Investing table.

Taxes table

The Taxes table displays the amount of taxes withheld for transactions with the Tax type as the TOTAL indicator.