Transactions Report
The Transactions Report is a key report in the CRM that provides you with a comprehensive view of all funding activities processed through the CRM. This includes deposits, withdrawals, transfers, credits, and IB commission payouts.
Using this report, you can quickly view all funding activities associated with a client’s account, helping you monitor transactional activity and ensure that funds are properly managed. The report also allows you to identify any issues or discrepancies related to funding, enabling you to take prompt action to resolve them.
1. Report Functions
You can use several functions to refine or filter the Transactions Report for better analysis, monitoring, and tracking. These functions include:
Date Range
You can filter transaction data based on a specific time frame.
Manually select the time frame – Choose the exact start and end dates.
Pre-set periods – Select from commonly used ranges (e.g., Today, Last 7 Days, This Month).
Filter
Filter transactions based on specific criteria to narrow down your view.
To view explanations on the different filter criteria, please refer to: 2. Filter Criteria
Click the "Filter" icon.
Configure your filter criteria and click "Search".
Use the "And/Or" option to define how multiple filters combine.
Selecting "And" means all filter conditions must be met.
Selecting "Or" means any one of the filter conditions can be met.
Click "Add Filter Field" to select additional filter criteria.
To clear filters, click the "Reset" to clear all, or use the individual "Reset" icon next to each filter set to clear specific filters.
Field Display Settings
Customize the columns shown in the report by selecting which fields to display or hide.
Click the "..." icon and select "Field Display Settings".
Choose the fields you want to display and click "Confirm".
Download
You can export the data into an Excel file for easier analysis.
Click the "..." icon and select "Download".
Confirm the date range for the report.
A popup will notify you that the data is being generated. Click "Confirm" to proceed to the Download Center.
You will be redirected to the Download Center. For more details, refer to: Download Center
Click "Download" to save the file.
Summation of Data
You will see the number of records and number of distinct clients, helping you quickly understand whether the transactions are spread across many clients or concentrated among a few.
You can view the total of all transactions data at the bottom of the report by clicking "Total".
You can view the total amounts deposited and withdrawn from accounts, as well as the original transaction amounts in their respective currencies. This gives you clearer insight into client funding preferences—such as whether they are transacting in USDT, ETH, or other currencies.
Sort Report
You can sort the transactions report by the following criteria:
Amount
Time
Click on the column header to toggle the sort order:
A down arrow indicates descending order (highest values first).
An up arrow indicates ascending order (lowest values first).
2. Filter Criteria
Below are the available filter options you can use to narrow down your report results:
User ID
Filter by the client's User ID.
Partial match is not supported.
Name
Filter by client name.
Partial match is supported.
Filter by email address of the client.
Partial match is supported.
Phone Number
Filter by country code, phone number, or both.
Neither is mandatory— you can search using just the country code or just part of the phone number.
Partial match is supported.
Transaction ID
Filter by the transaction ID.
Partial match is not supported.
Platform
Filter by the trading platform server or CRM wallet.
Multiple selection allowed.
Type
Filter based on the transaction type: Deposit, Withdrawal, Transfer In, Transfer Out, Credit In, Credit Out, Add Bonus, Withdraw Bonus, Commission Payout, etc.
Multiple selections are allowed.
Trading Account
Filter based on trading account.
Partial match is not supported.
Wallet
Filter based on the wallet ID.
Partial match is not supported.
Owner
Filter by account owner using predefined options:
Clients assigned to me
Clients assigned to subordinates
Clients with no owner
You can also click "Select Other Owners" and choose from a dropdown with three tabs: Users, Teams, and Roles.
Multiple selections allowed.
Associated Order Number
Filter based on the associated order number of the transaction.
Partial match is not supported.
Referrer
Filter by the client’s referrer using:
Is — Select from dropdown (multiple selections allowed) or choose via the Referral Tree view
Is empty — No referrer assigned
Not empty — Referrer exists
Additional options when selecting referrers:
All Downlines — Includes every downline of the selected referrer(s)
All Uplines — Includes all uplines
Custom Downline — Set a range starting from 0 or 1 (0 = selected referrer, 1 = direct downline). Maximum downline depth: 100 levels.
Currency
Filter by the trading account’s base currency.
Multiple selection is allowed.
Amount
Filter based on the amount of the transaction.
Enter minimum and maximum values to define the range.
Payment Method
Filter based on payment method of the transaction.
Multiple selection is allowed.
Withdrawal Method
Filter based on the withdrawal method of the transaction.
Multiple selection is allowed.
Payment Amount
Filter based on the payment amount of the transaction.
Enter minimum and maximum values to define the range.
Withdrawal Amount
Filter based on the withdrawal amount of the transaction.
Enter minimum and maximum values to define the range.
Previous Balance
Filter based on the previous balance of the account.
Enter minimum and maximum values to define the range.
New Balance
Filter based on the new balance of the account.
Enter minimum and maximum values to define the range.
Registration Information - Nationality
Filter based on the nationality filled in during the registration process.
Select the nationalities from the dropdown menu.
Multiple selection is allowed.
Client Group
Filter based on the client group of the client.
For more details, refer to: Client Portal - Client Group Settings
Multiple selection is accepted.
Client Type
Filter based on the client type of the client: Trader or IB
Multiple selection is accepted.
Last updated