Transactions reports
Transactions can be triggered either by end user actions (e.g. order executions) or by market/back-office processes (e.g. cash dividends, fee collections).
The /transactions
endpoint of the Investment API serves as a source of truth for all money and securities movements that take place on an account.
While securities movements are defined at the account level, cash movements are on the level of the account group.
Via the /transactions
endpoint you get data on position updates, transaction types and additional transaction information.
Use cases
You can use transactions data for a variety of use cases:
- to display transactions to end users (e.g. in list form)
- to calculate various aggregated metrics
- to create the necessary graphics for the interfaces
- to reconcile bookings and related treasury transactions.
Transactions categories
Upvest distinguishes transactions into two main categories:
- Cash transactions
- Securities transactions
Some of the triggering events lead to both cash and securities transactions, while others lead to only one transaction. While cash and securities transactions have a similar structure, they differ in terms of content. The differences are illustrated in the following example.
Transactions types
Based on the cause of the cash or securities movement, Upvest classifies transactions into transaction types, giving our customers full transparency and a fine-grained list of transactions in their target UI.
Upvest currently supports the following transaction types. The following table shows which transaction types lead to the respective cash and/or securities movements:
Classification | Transaction type | Cash transaction | Securities transaction |
---|---|---|---|
Account transfers | SECURITY_TRANSFER SECURITIES_TRANSFER_CANCELLATION | ✓ | |
Orders | ORDER_EXECUTION ORDER_EXECUTION_CANCELLATION | ✓ | ✓ |
Fees | FEE_COLLECTION FEE_COLLECTION_CANCELLATION | ✓ | |
Fees | DD_REFUND_REJECT_FEE DD_REFUND_REJECT_FEE_CANCELLATION | ||
Payments | CREDIT_FUNDING | ✓ | ✓ |
Payments | CREDIT_FUNDING_CHARGE_BACK | ✓ | ✓ |
Payments | SEPA_DIRECT_DEBIT SEPA_DIRECT_DEBIT_CHARGE_BACK | ✓ | |
Payments | TOPUP | ✓ | |
Payments | TOPUP_CANCELLATION | ✓ | |
Payments | VIRTUAL_CASH_DECREASE VIRTUAL_CASH_INCREASE | ✓ | ✓ |
Payments | VIRTUAL_CASH_CORRECTION | ✓ | ✓ |
Payments | WITHDRAWAL WITHDRAWAL_CANCELLATION | ✓ | |
Tax | TAX_PAYMENT | ✓ | ✓ |
Tax | TAX_PREPAYMENT_DE | ✓ | ✓ |
Tax | TAX_REFUND | ✓ | ✓ |
Treasury | TREASURY_PAYMENT | ✓ | ✓ |
Other | BALANCE_CORRECTION BALANCE_CORRECTION_CANCELLATION | ✓ | ✓ |
Corporate actions releated transactions
Classification | Transaction type | Cash transaction | Securities transaction |
---|---|---|---|
Corporate actions | BONUS_ISSUE BONUS_ISSUE_CANCELLATION | ✓ | |
Corporate actions | CALL_ON_INTERMEDIATE_SECURITIES CALL_ON_INTERMEDIATE_SECURITIES_CANCELLATION | ✓ | ✓ |
Corporate actions | CASH_DIVIDEND CASH_DIVIDEND_CANCELLATION | ✓ | |
Corporate actions | CAPITALDISTRIBUTION CAPITAL_DISTRIBUTION_CANCELLATION | ✓ | |
Corporate actions | CHANGE CHANGE_CANCELLATION | ✓ | |
Corporate actions | CONVERSION CONVERSION_CANCELLATION | ✓ | ✓ |
Corporate actions | DECREASE_IN_VALUE DECREASE_IN_VALUE_CANCELLATION | ✓ | |
Corporate actions | DIVIDEND_OPTIO DIVIDEND_OPTION_CANCELLATION | ✓ | ✓ |
Corporate actions | DIVIDEND_REINVESTMENT DIVIDEND_REINVESTMENT_CANCELLATION | ✓ | ✓ |
Corporate actions | DUTCH_AUCTION DUTCH_AUCTION_CANCELLATION | ✓ | ✓ |
Corporate actions | INCREASE_IN_VALUE INCREASE_IN_VALUE_CANCELLATION | ✓ | |
Corporate actions | INTERMEDIATE_SECURITIES_DISTRIBUTION INTERMEDIATE_SECURITIES_DISTRIBUTION_CANCELLATION | ✓ | |
Corporate actions | LIQUIDATION_PAYMENT LIQUIDATION_PAYMENT_CANCELLATION | ✓ | |
Corporate actions | MERGER MERGER_CANCELLATION | ✓ | ✓ |
Corporate actions | NON_OFFICIAL_OFFER NON_OFFICIAL_OFFER_CANCELLATION | ✓ | ✓ |
Corporate actions | ODD_LOT_SALE ODD_LOT_SALE_CANCELLATION | ✓ | ✓ |
Corporate actions | OTHER_EVENT OTHER_EVENT_CANCELLATION | ✓ | ✓ |
Corporate actions | PARI_PASSU PARI_PASSU_CANCELLATION | ✓ | |
Corporate actions | PRIORITY_ISSUE PRIORITY_ISSUE_CANCELLATION | ✓ | |
Corporate actions | REPURCHASE_OFFER REPURCHASE_OFFER_CANCELLATION | ✓ | ✓ |
Corporate actions | REVERSE_STOCK_SPLIT REVERSE_STOCK_SPLIT_CANCELLATION | ✓ | ✓ |
Corporate actions | RIGHTS_ISSUE RIGHTS_ISSUE_CANCELLATION | ✓ | |
Corporate actions | SHARES_PREMIUM_DIVIDEND SHARES_PREMIUM_DIVIDEND_CANCELLATION | ✓ | |
Corporate actions | SPIN_OFF SPIN_OFF_CANCELLATION | ✓ | ✓ |
Corporate actions | STOCK_DIVIDEND STOCK_DIVIDEND_CANCELLATION | ✓ | |
Corporate actions | STOCK_SPLIT STOCK_SPLIT_CANCELLATION | ✓ | ✓ |
Corporate actions | TENDER TENDER_CANCELLATION | ✓ | ✓ |
Corporate actions | WORTHLESS WORTHLESS_CANCELLATION | ✓ |