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).

INFO

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:

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
TaxTAX_REFUND
TreasuryTREASURY_PAYMENT
OtherBALANCE_CORRECTION
BALANCE_CORRECTION_CANCELLATION

Corporate actions releated transactions

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 actionsCAPITALDISTRIBUTION
CAPITAL_DISTRIBUTION_CANCELLATION
Corporate actionsCHANGE
CHANGE_CANCELLATION
Corporate actionsCONVERSION
CONVERSION_CANCELLATION
Corporate actionsDECREASE_IN_VALUE
DECREASE_IN_VALUE_CANCELLATION
Corporate actionsDIVIDEND_OPTIO
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

Was this page helpful?