> For the complete documentation index, see [llms.txt](https://reference-guide.gitbook.io/crm-back-office-user-guide-full/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://reference-guide.gitbook.io/crm-back-office-user-guide-full/6.-trading-accounts/trading-account-report.md).

# Trading Account Report

### <mark style="color:red;">1. Report Functions</mark>

You can use several functions to refine and filter your trading accounts data for better analysis, monitoring, and tracking. These functions include:

<details>

<summary>Trading Platform Dropdown List</summary>

1. Trading accounts from different trading platforms are segregated into separate reports.
2. You can switch between trading platforms by using the dropdown list and selecting the desired platform.<br>

   <figure><img src="/files/G2jg5I0Icg4SZuME9UkZ" alt=""><figcaption></figcaption></figure>

</details>

<details>

<summary>Search Bar</summary>

1. Search for trading accounts by Name or Trading Account ID. <br>

   <figure><img src="/files/ngEVlmotm5zvhOkA4L4D" alt=""><figcaption></figcaption></figure>

</details>

<details>

<summary>Refresh</summary>

1. Click the **"Refresh"** button to update the data and view the most current information.<br>

   <figure><img src="/files/UkY2ufrvIzn6XsTBTsQq" alt=""><figcaption></figcaption></figure>

</details>

<details>

<summary>Filter</summary>

1. Filter trading accounts based on specific criteria to narrow down your view.
2. To view explanations on the different filter criteria, please refer to: [#id-2.-filter-criteria](#id-2.-filter-criteria "mention")
3. Click the **"Filter"** icon. <br>

   <figure><img src="/files/iyLhbE6FunMCUFscGSyz" alt=""><figcaption></figcaption></figure>
4. Configure your filter criteria and click **"Search"**.\
   \
   ![](/files/3hNDElphX0hCpPjY8EFQ)<br>
5. Use the **"And/Or"** option to define how multiple filters combine.
   1. Selecting **"And"** means all filter conditions must be met.
   2. Selecting **"Or"** means any one of the filter conditions can be met.\
      \
      ![](/files/T63700RyUavJBvuQ9vIs)<br>
6. Click **"Add Filter Field"** to select additional filter criteria.<br>

   <figure><img src="/files/P6GnjOd3dS0FyIwYq4lI" alt=""><figcaption></figcaption></figure>
7. To clear filters, click the **"Reset"** to clear all, or use the individual **"Reset"** icon next to each filter set to clear specific filters.\
   \
   ![](/files/kjxfpfkrVLaaMgG3c6kk)

</details>

<details>

<summary>Field Display Settings</summary>

1. Customize the columns shown in the report by selecting which fields to display or hide.
2. Click the **"..."** icon and select **"Field Display Settings"**. <br>

   <figure><img src="/files/b6NcGQb5wQc0Q2MhTbLw" alt=""><figcaption></figcaption></figure>
3. Choose the fields you want to display and click **"Confirm"**.\
   \
   ![](/files/Fo5U9PeWqMcjspEoN0Ji)<br>

</details>

<details>

<summary>Download</summary>

1. You can export the data into an Excel file for easier analysis.
2. Click the **"..."** icon and select **"Download"**. <br>

   <figure><img src="/files/pcg9kFFDZg6UcclB80rv" alt=""><figcaption></figcaption></figure>
3. A popup will notify you that the data is being generated. Click **"Confirm"** to proceed to the Download Center.\
   \
   ![](/files/S5haImTqg5bYpJczL9HJ)<br>
4. You will be redirected to the Download Center. For more details, refer to: [Download Center](/crm-back-office-user-guide-full/18.-other-functionalities/download-center.md)
5. Click **"Download"** to save the file.<br>

   <figure><img src="/files/qB2vpf3FryNC7XMb68qa" alt=""><figcaption></figcaption></figure>

</details>

<details>

<summary>Summation of Data</summary>

1. You can view the total of all trading account data at the bottom of the report by clicking **"Total"**.<br>

   <figure><img src="/files/R8yxBCX4MyG5n197VFEM" alt=""><figcaption></figcaption></figure>
2. The following data is included in the summation:

   1. **Balance**
   2. **Equity**
   3. **Credit**
   4. **Free Margin**

   <figure><img src="/files/vzVFJwFGXrKhgaGjzro6" alt=""><figcaption></figcaption></figure>

</details>

<details>

<summary>Sort Report</summary>

1. You can sort the trading accounts report by the following criteria:
   1. **Balance**
   2. **Equity**
   3. **Margin**
   4. **Free Margin**
   5. **Credit**
   6. **Create Time**
2. Click on the column header to toggle the sort order:
   1. A down arrow indicates descending order (highest values first).<br>

      <figure><img src="/files/zwmtVWlLbdOp3ijrws57" alt=""><figcaption></figcaption></figure>
   2. An up arrow indicates ascending order (lowest values first).<br>

      <figure><img src="/files/LHho8SRMPCPXJWf36a4F" alt=""><figcaption></figcaption></figure>

</details>

### <mark style="color:red;">2. Filter Criteria</mark>

Below are the available filter options you can use to narrow down your report results:

<table data-view="cards"><thead><tr><th></th><th></th></tr></thead><tbody><tr><td><strong>ID</strong></td><td><ul><li>Filter by the trading account ID. </li><li>You can enter a minimum and maximum value to set a range of account IDs.</li></ul></td></tr><tr><td><strong>Name</strong></td><td><ul><li>Filter by client name. </li><li>You don’t need to enter the full name—partial matches will also be shown.</li></ul></td></tr><tr><td><strong>Leverage</strong></td><td><ul><li>Filter by the leverage of the trading accounts.</li><li>You can select more than one leverage.</li></ul></td></tr><tr><td><strong>Currency</strong> </td><td><ul><li>Filter by the trading account’s base currency. </li><li>You can select more than one currency.</li></ul></td></tr><tr><td><strong>Owner</strong></td><td><ul><li><p>Filter by account owner using predefined options:</p><ul><li><em>Clients assigned to me</em></li><li><em>Clients assigned to subordinates</em></li><li><em>Clients with no owner</em></li></ul></li><li>You can also click <strong>"Select Other Owners"</strong> and choose from a dropdown with three tabs: <em>Users</em>, <em>Teams</em>, and <em>Roles</em>. </li><li>Multiple selections allowed.</li></ul></td></tr><tr><td><strong>Referrer</strong></td><td><p>Filter by the client’s referrer using:</p><ul><li><strong>Is</strong> — Select from dropdown (multiple selections allowed) or choose via the Referral Tree view</li><li><strong>Is empty</strong> — No referrer assigned</li><li><strong>Not empty</strong> — Referrer exists</li></ul><p><br>Additional options when selecting referrers:</p><ul><li><em>All Downlines</em> — Includes every downline of the selected referrer(s)</li><li><em>All Uplines</em> — Includes all uplines</li><li><em>Custom Downline</em> — Set a range starting from 0 or 1 (0 = selected referrer, 1 = direct downline). Maximum downline depth: 100 levels.</li></ul></td></tr><tr><td><strong>Group</strong></td><td><ul><li>Filter based on the trading platform group assigned to the trading account. </li><li>Use the dropdown menu to select one or multiple groups.</li></ul></td></tr><tr><td><strong>Balance</strong></td><td><ul><li>Filter based on the balance of the trading account. </li><li>Enter minimum and maximum values to define the range.</li></ul></td></tr><tr><td><strong>Equity</strong></td><td><ul><li>Filter based on the equity of the trading account. </li><li>Enter minimum and maximum values to define the range.</li></ul></td></tr><tr><td><strong>Free Margin</strong></td><td><ul><li>Filter based on the free margin of the trading account. </li><li>Enter minimum and maximum values to define the range.</li></ul></td></tr><tr><td><strong>Credit</strong></td><td><ul><li>Filter based on the credit of the trading account. </li><li>Enter minimum and maximum values to define the range.</li></ul></td></tr><tr><td><strong>Create Time</strong></td><td><ul><li>Filter based on the create time of the trading accounts. </li><li>Filter based on preset time ranges: <em>Today</em>, <em>Yesterday</em>, <em>This Week</em>, <em>Last Week</em>, <em>This Month</em>, <em>Last Month</em>, <em>This Quarter</em>, <em>Last Quarter</em>, <em>Last 7 Days</em>, <em>Last 14 Days</em>—or choose a custom date range.</li></ul></td></tr><tr><td><strong>Name in Trading Platform</strong></td><td><ul><li>Filter by name in trading platform. </li><li>You don’t need to enter the full name—partial matches will also be shown.</li></ul></td></tr><tr><td><strong>Email in Trading Platform</strong></td><td><ul><li>Filter by email in trading platform. </li><li>You don’t need to enter the full name—partial matches will also be shown.</li></ul></td></tr><tr><td><strong>Margin</strong></td><td><ul><li>Filter based on the margin of the trading account. </li><li>Enter minimum and maximum values to define the range.</li></ul></td></tr><tr><td><strong>Margin Level</strong></td><td><ul><li>Filter based on the margin level of the trading account. </li><li>Enter minimum and maximum values to define the range.</li></ul></td></tr><tr><td><strong>Comment</strong></td><td><ul><li>Filter based on the comment of the trading account. </li><li>You can choose “Contains” or “Begins With” and enter the comment text. </li><li>Partial matches are supported; a full match is not required.</li></ul></td></tr><tr><td><strong>Agent Account</strong></td><td><ul><li>Filter based on the agent account of the trading account. </li><li>Enter the account number. </li><li>Partial matches are supported.</li></ul></td></tr><tr><td><strong>Lead Source</strong></td><td><ul><li>Filter based on the lead source of the trading account. </li><li>Partial matches are supported.</li></ul></td></tr><tr><td><strong>Send Report</strong></td><td><ul><li>Filter based on whether trading accounts have send reports enabled or disabled. </li><li>Select Enabled, Disabled, or Both.</li></ul></td></tr><tr><td><strong>Login Status</strong></td><td><ul><li>Filter based on whether trading accounts have login status enabled or disabled. </li><li>Select Enabled, Disabled, or Both.</li></ul></td></tr><tr><td><strong>Trading Status</strong></td><td><ul><li>Filter based on whether trading accounts have trading status enabled or disabled. </li><li>Select Enabled, Disabled, or Both.</li></ul></td></tr><tr><td><strong>Allow Password Change</strong></td><td><ul><li>Filter based on whether trading accounts have password change enabled or disabled. </li><li>Select Enabled, Disabled, or Both.</li></ul></td></tr><tr><td><strong>System Tags</strong></td><td><ul><li>Filter by predefined system tags: Deposited, Account Opened, Traded, Prop Trading. </li><li>For each tag, select Yes or No. </li><li>Multiple selection allowed.</li></ul></td></tr></tbody></table>
