Client PL report

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

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

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

To generate reports the period for their generation in the Period filter must be selected.

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

Report composition

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

Each report tab displays profit and loss tables for the individual currency in which profits were generated on the accounts.

Trading table

The Trading table displays the Daily PL transaction amounts (daily profit/loss) for each instrument category (except for the CASH and options categories) and Settlement - profit/loss for each instrument category that arose as a result of settlement transactions for trades (except for the CASH, options and Forex categories).

The Daily PL TOTAL and Settlement TOTAL indicators display the sums of the values of the corresponding indicators for all categories.

Trading commissions table

The Trading commissions table displays the sum of internal commissions. In the Transactions section, they are presented with the Daily PL transaction 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 the following indicators:

• External trade commissions - external commission amounts. In the Transactions section, they are represented by the External commission and Asset transfer transaction types;
• Custody fees. The amount of transactions with the Custody fee type and External commission with the Minimum custody fee subtype;
• Swaps (rollover commissions) - swap amounts. Transactions with the Daily PL type and the Rollover commission subtype;
• Misc - other fees and charges, such as:
• Deposit and Withdrawal with the Commission, Correction and Adjustment subtypes;
• Transfer with the subtype Commission;
• Introducer fee;
• Service fee;
• Funding fee.

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

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.

Taxes table

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