How to create a report
To create and configure a report:
Navigate to Finance > Reports.
Click +Create in the upper-right page corner.
On the Create report page, fill in the following fields:
In the Interval dropdown, schedule the report delivery:
Daily — the report is run and sent every day
Weekly — the report is run and sent once a week
Monthly — the report is run and sent once a month
In Data slice dropdown, select the period for which data is included in the report, as per the Back Office server time:
Day — the previous day, from 00:00 to 23:59
Week — the previous week, from Monday 00:00 to Sunday 23:59
Month — the previous month, from the first day of the month 00:00 to the last day 23:59
Curweek — the previous 7 days, from the first day 00:00 to yesterday 23:59
Overall — from the beginning of track record to yesterday 23:59
Curmonth — from the first day of the current month 00:00 to yesterday 23:59
In the File format dropdown, select HTML, XLSX, or CSV.
In the Active dropdown, select the report status:
Active — to run and send the report on schedule
Inactive — to disable the report
In the Name field, enter the report name.
In the Class dropdown, select one or several report types that you want to generate:
Client Finance Report — shows the amount of deposits, withdrawals and net deposits (the difference between total deposits and total withdrawals) made by each client over a specified time period, in corresponding currencies and in conversion to USD. The report includes the following fields: Email, Verification Level, Currency, Deposit, Withdraw, (D - W), (Deposit, USD), (Withdraw, USD) and (Deposit - Withdrawal, USD).
Transaction Finance Report — contains detailed information on all transactions executed over a specified time period. The report includes various fields, such as ID, Account ID, Operation ID, Email, Transaction Type, Method, Source Currency, Source Amount, Type Commission, Final Amount, Target Amount, Target Currency, Transaction Exchange Rate, % Markup, Profit Markup, Markup Currency and others.
Method Finance Report — contains detailed information on methods used for execution of deposit and withdrawal operations over a specified time period. The data is grouped by currencies (such as fiat and crypto) and includes information about the commissions and profit earned from each operation. The report includes various fields, such as Method, Currency, Deposit, Withdraw, Source Commission, Final Deposit amount, Final Withdrawal amount, Profit Markup, Counterparty Commission, Profit (Counterparty commission) and others.
Currency Finance Report — shows the amount of deposits, withdrawals and net deposits (the difference between total deposits and total withdrawals) made over a specified time period in a particular currency and in conversion to USD. The report includes the following fields: Currency, Deposit, Withdraw, (D - W), (Deposit, USD), (Withdraw, USD) and (Deposit - Withdrawal, USD).
Balances Report — shows balance changes on client accounts over a specified time period. The data is grouped by each currency and also includes the total balance change on all client accounts in conversion to USD. The report includes the following fields: ID, Email, Client Name, Internal Client Type, Verification Level, Company Name, Currency, Balance, Hold, Rate, (Balance, USD), Previous Balance and (Previous Balance, USD).
User In Out — this report is similar to the Client Finance Report, while also containing additional fields, such as Transfers (D-W) and Manual (D-W).
IB Balances Report — shows the reward amounts earned by IB partners over a specified time period, as well as the total reward amount in conversion to USD. The report includes the following fields: ID (the identifier assigned to an IB partner), Email, Client Name, Internal Client Type, Verification Level, Company Name, Currency, Balance, Rate and (Balance, USD).
Balances Simplified Report — shows balances on client accounts in each currency along with the total balance on all client accounts in conversion to USD. The report includes the following fields: Email, Internal Client Type, Currency and Balance.
LegalEntityBalancesReport — shows balances on all live accounts of the clients that are served by a specific legal entity.
In the Mail to field, enter the email address to which a link to download the report is sent.
In the Start hour field, enter the hour at which you want run the report and send it to the specified email, as per the Back Office server time. The value must be in the 0 — 23 range.
In GMT offset dropdown, select the GMT offset of your local time zone to send the report at the specified hour in your local time zone.
The Back Office server time may differ from the time in your local time zone. The current server date and time are displayed in the topbar.
Click Save to create the report.
Last updated