Help Center
Our products knowledge base for customers
Transaction report with running balance
Transaction report with runnıng balance
This report provides a detailed overview of all account transactions, calculating and displaying the current balance after each transaction. The balance is calculated separately for each currency and security (equities and bonds).
After selecting a specific Account and range in the Report interval filter, you can download the report by clicking the Generate report button.
Please note! The maximum report generation period is 365 days.
Mechanism details:
- The report is generated only for closed days;
- Transactions are selected by the
Transaction datefield (including the first and last dates of the report); - After a transactions by currency/asset is completed, the report displays the
Current balanceof the account for them.
Validation mechanism:
- For each date in the report, the balance at the end of the current day for each currency/asset is validated against the balance after the last transaction in the platform for the account;
- If they do not match, the report will display a
Problemblock with a description detailing the discrepancy between the balance indicators for the asset on a specific date.
Report contents
The top block displays general information about the report and the account:
| Name | Description |
|---|---|
| Report Period | The report generation period (including the first and last dates of the selected interval). |
| Generated | The date the report was actually generated. |
| Account Name | Account name in the platform. |
| Account ID | Account ID in the platform. |
| Account Type | Account type: personal, real, nominal |
| Account Relation | Account relation: client, provider, internal |
| Base сurrency | The account's base currency, as set in Netting Settings |
Each subsequent block contains information on specific currencies/assets for which transactions were made during the time interval.
The Asset field displays the name of the asset/currency for which data is displayed in the block. For equities and bonds, the ISIN is also displayed.
The Opening Balance field displays the current balance at the end of the day preceding the first report date.
The Closing Balance field displays the current balance at the end of the last report date.
Between the Opening Balance and Closing Balance indicators, all transactions made on the account are displayed, with the following information provided for each:
| Name | Description |
|---|---|
| Transaction Date | Date of the transaction executed on the account. |
| Transaction ID | Transaction ID in the platform. |
| Trade ID | ID of the trade that resulted in the transaction. Some transaction types are generated independently of trades. |
| Instrument | The Instrument with which the trade was executed (if applicable). |
| Instrument Category | Instrument category (e.g., EQ): not displayed for currencies. |
| Transaction Type | Type of the generated transaction (e.g., daily pnl, funding fee). |
| Transaction Subtype | Subtype of the generated transaction. |
| Transaction Sum | Transaction sum - currency received/debited, showing the sign, rounded to the netting scale of the used asset. |
| Transaction Amount | Transaction amount. For stocks - the number of equities; for bonds - the nominal value. |
| Running Balance | Current balance of the account after transaction is made. For stocks - the number of equities; for bonds - the nominal value. |
| Comment | Transaction comment. |
At the end of an individual asset's block, its cumulative indicators are displayed:
| Name | Description |
|---|---|
| Total Income | Total amount credited to the account for the period. |
| Total Outcome | Total amount debited from the account for the period. |
| Net Change | The difference between the Total Income and Total Outcome indicators. |