Skip to content

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 clients 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:

ClassificationTransaction typeCash transactionSecurities transaction
Account transfersSECURITY_TRANSFER SECURITIES_TRANSFER_CANCELLATION✓
OrdersORDER_EXECUTION ORDER_EXECUTION_CANCELLATION✓✓
FeesFEE_COLLECTION FEE_COLLECTION_CANCELLATION✓
FeesDD_REFUND_REJECT_FEE DD_REFUND_REJECT_FEE_CANCELLATION
PaymentsCREDIT_FUNDING✓✓
PaymentsCREDIT_FUNDING_CHARGE_BACK✓✓
PaymentsSEPA_DIRECT_DEBIT SEPA_DIRECT_DEBIT_CHARGE_BACK✓
PaymentsTOPUP✓
PaymentsTOPUP_CANCELLATION✓
PaymentsVIRTUAL_CASH_DECREASE VIRTUAL_CASH_INCREASE✓✓
PaymentsVIRTUAL_CASH_CORRECTION✓✓
PaymentsWITHDRAWAL WITHDRAWAL_CANCELLATION✓
TaxTAX_PAYMENT✓✓
TaxTAX_PREPAYMENT_DE TAX_PREPAYMENT_DE_CANCELLATION✓✓
TaxTAX_REFUND✓✓
TreasuryTREASURY_PAYMENT✓✓
OtherBALANCE_CORRECTION BALANCE_CORRECTION_CANCELLATION✓✓
ClassificationTransaction typeCash transactionSecurities transaction
Corporate actionsBONUS_ISSUE BONUS_ISSUE_CANCELLATION✓✓
Corporate actionsCALL_ON_INTERMEDIATE_SECURITIES CALL_ON_INTERMEDIATE_SECURITIES_CANCELLATION✓✓
Corporate actionsCASH_DIVIDEND CASH_DIVIDEND_CANCELLATION✓✓
Corporate actionsCAPITAL_DISTRIBUTION CAPITAL_DISTRIBUTION_CANCELLATION✓✓
Corporate actionsCAPITAL_GAINS_DISTRIBUTION CAPITAL_GAINS_DISTRIBUTION_CANCELLATION✓✓
Corporate actionsCHANGE CHANGE_CANCELLATION✓✓
Corporate actionsCONVERSION CONVERSION_CANCELLATION✓✓
Corporate actionsDECREASE_IN_VALUE DECREASE_IN_VALUE_CANCELLATION✓✓
Corporate actionsDIVIDEND_OPTION DIVIDEND_OPTION_CANCELLATION✓✓
Corporate actionsDIVIDEND_REINVESTMENT DIVIDEND_REINVESTMENT_CANCELLATION✓✓
Corporate actionsDUTCH_AUCTION DUTCH_AUCTION_CANCELLATION✓✓
Corporate actionsINCREASE_IN_VALUE INCREASE_IN_VALUE_CANCELLATION✓✓
Corporate actionsINTERMEDIATE_SECURITIES_DISTRIBUTION INTERMEDIATE_SECURITIES_DISTRIBUTION_CANCELLATION✓✓
Corporate actionsLIQUIDATION_PAYMENT LIQUIDATION_PAYMENT_CANCELLATION✓✓
Corporate actionsMERGER MERGER_CANCELLATION✓✓
Corporate actionsNON_OFFICIAL_OFFER NON_OFFICIAL_OFFER_CANCELLATION✓✓
Corporate actionsODD_LOT_SALE ODD_LOT_SALE_CANCELLATION✓✓
Corporate actionsOTHER_EVENT OTHER_EVENT_CANCELLATION✓✓
Corporate actionsPARI_PASSU PARI_PASSU_CANCELLATION✓✓
Corporate actionsPRIORITY_ISSUE PRIORITY_ISSUE_CANCELLATION✓✓
Corporate actionsREPURCHASE_OFFER REPURCHASE_OFFER_CANCELLATION✓✓
Corporate actionsREVERSE_STOCK_SPLIT REVERSE_STOCK_SPLIT_CANCELLATION✓✓
Corporate actionsRIGHTS_ISSUE RIGHTS_ISSUE_CANCELLATION✓✓
Corporate actionsSHARES_PREMIUM_DIVIDEND SHARES_PREMIUM_DIVIDEND_CANCELLATION✓✓
Corporate actionsSPIN_OFF SPIN_OFF_CANCELLATION✓✓
Corporate actionsSTOCK_DIVIDEND STOCK_DIVIDEND_CANCELLATION✓✓
Corporate actionsSTOCK_SPLIT STOCK_SPLIT_CANCELLATION✓✓
Corporate actionsTENDER TENDER_CANCELLATION✓✓
Corporate actionsWORTHLESS WORTHLESS_CANCELLATION✓✓