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	`ACCUMULATION` `ACCUMULATION_CANCELLATION`	✓	✓
Corporate actions	`ANNUAL_GENERAL_MEETING` `ANNUAL_GENERAL_MEETING_CANCELLATION`	✓	✓
Corporate actions	`ATTACHMENT` `ATTACHMENT_CANCELLATION`	✓	✓
Corporate actions	`BANKRUPTCY` `BANKRUPTCY_CANCELLATION`	✓	✓
Corporate actions	`BOND_DEFAULT` `BOND_DEFAULT_CANCELLATION`	✓	✓
Corporate actions	`BOND_HOLDER_MEETING` `BOND_HOLDER_MEETING_CANCELLATION`	✓	✓
Corporate actions	`BONUS_ISSUE` `BONUS_ISSUE_CANCELLATION`	✓	✓
Corporate actions	`CALL_ON_INTERMEDIATE_SECURITIES` `CALL_ON_INTERMEDIATE_SECURITIES_CANCELLATION`	✓	✓
Corporate actions	`CAPITAL_DISTRIBUTION` `CAPITAL_DISTRIBUTION_CANCELLATION`	✓	✓
Corporate actions	`CAPITAL_GAINS_DISTRIBUTION` `CAPITAL_GAINS_DISTRIBUTION_CANCELLATION`	✓	✓
Corporate actions	`CAPITALISATION` `CAPITALISATION_CANCELLATION`	✓	✓
Corporate actions	`CASH_DISTRIBUTION_FROM_NON_ELIGIBLE_SECURITIES_SALES` `CASH_DISTRIBUTION_FROM_NON_ELIGIBLE_SECURITIES_SALES_CANCELLATION`	✓	✓
Corporate actions	`CASH_DIVIDEND` `CASH_DIVIDEND_CANCELLATION`	✓	✓
Corporate actions	`CHANGE` `CHANGE_CANCELLATION`	✓	✓
Corporate actions	`CLASS_ACTION` `CLASS_ACTION_CANCELLATION`	✓	✓
Corporate actions	`COMPANY_OPTION` `COMPANY_OPTION_CANCELLATION`	✓	✓
Corporate actions	`CONSENT` `CONSENT_CANCELLATION`	✓	✓
Corporate actions	`CONVERSION` `CONVERSION_CANCELLATION`	✓	✓
Corporate actions	`COURT_MEETING` `COURT_MEETING_CANCELLATION`	✓	✓
Corporate actions	`CREDIT_EVENT` `CREDIT_EVENT_CANCELLATION`	✓	✓
Corporate actions	`DECREASE_IN_VALUE` `DECREASE_IN_VALUE_CANCELLATION`	✓	✓
Corporate actions	`DETACHMENT` `DETACHMENT_CANCELLATION`	✓	✓
Corporate actions	`DISCLOSURE` `DISCLOSURE_CANCELLATION`	✓	✓
Corporate actions	`DIVIDEND_OPTION` `DIVIDEND_OPTION_CANCELLATION`	✓	✓
Corporate actions	`DIVIDEND_REINVESTMENT` `DIVIDEND_REINVESTMENT_CANCELLATION`	✓	✓
Corporate actions	`DRAWING` `DRAWING_CANCELLATION`	✓	✓
Corporate actions	`DUTCH_AUCTION` `DUTCH_AUCTION_CANCELLATION`	✓	✓
Corporate actions	`EXCHANGE` `EXCHANGE_CANCELLATION`	✓	✓
Corporate actions	`EXTRAORDINARY_OR_SPECIAL_GENERAL_MEETING` `EXTRAORDINARY_OR_SPECIAL_GENERAL_MEETING_CANCELLATION`	✓	✓
Corporate actions	`FINAL_MATURITY` `FINAL_MATURITY_CANCELLATION`	✓	✓
Corporate actions	`FULL_CALL` `FULL_CALL_CANCELLATION`	✓	✓
Corporate actions	`INCREASE_IN_VALUE` `INCREASE_IN_VALUE_CANCELLATION`	✓	✓
Corporate actions	`INFORMATION` `INFORMATION_CANCELLATION`	✓	✓
Corporate actions	`INSTALMENT_CALL` `INSTALMENT_CALL_CANCELLATION`	✓	✓
Corporate actions	`INTEREST_PAYMENT` `INTEREST_PAYMENT_CANCELLATION`	✓	✓
Corporate actions	`INTERMEDIATE_SECURITIES_DISTRIBUTION` `INTERMEDIATE_SECURITIES_DISTRIBUTION_CANCELLATION`	✓	✓
Corporate actions	`LIQUIDATION_PAYMENT` `LIQUIDATION_PAYMENT_CANCELLATION`	✓	✓
Corporate actions	`MATURITY_EXTENSION` `MATURITY_EXTENSION_CANCELLATION`	✓	✓
Corporate actions	`MERGER` `MERGER_CANCELLATION`	✓	✓
Corporate actions	`NON_OFFICIAL_OFFER` `NON_OFFICIAL_OFFER_CANCELLATION`	✓	✓
Corporate actions	`NON_US_TEFRA_D_CERTIFICATION` `NON_US_TEFRA_D_CERTIFICATION_CANCELLATION`	✓	✓
Corporate actions	`ODD_LOT_SALE` `ODD_LOT_SALE_CANCELLATION`	✓	✓
Corporate actions	`ORDINARY_GENERAL_MEETING` `ORDINARY_GENERAL_MEETING_CANCELLATION`	✓	✓
Corporate actions	`OTHER_EVENT` `OTHER_EVENT_CANCELLATION`	✓	✓
Corporate actions	`PARI_PASSU` `PARI_PASSU_CANCELLATION`	✓	✓
Corporate actions	`PARTIAL_DEFEASANCE` `PARTIAL_DEFEASANCE_CANCELLATION`	✓	✓
Corporate actions	`PARTIAL_REDEMPTION_WITH_POOL_FACTOR_REDUCTION` `PARTIAL_REDEMPTION_WITH_POOL_FACTOR_REDUCTION_CANCELLATION`	✓	✓
Corporate actions	`PARTIAL_REDEMPTION_WITHOUT_POOL_FACTOR_REDUCTION` `PARTIAL_REDEMPTION_WITHOUT_POOL_FACTOR_REDUCTION_CANCELLATION`	✓	✓
Corporate actions	`PAY_IN_KIND` `PAY_IN_KIND_CANCELLATION`	✓	✓
Corporate actions	`PEAK_FRACTION_COMPENSATION`	✓	✓
Corporate actions	`PEAK_ORDER_ADJUSTMENT`	✓	✓
Corporate actions	`PLACE_OF_INCORPORATION` `PLACE_OF_INCORPORATION_CANCELLATION`	✓	✓
Corporate actions	`PRIORITY_ISSUE` `PRIORITY_ISSUE_CANCELLATION`	✓	✓
Corporate actions	`PUT_REDEMPTION` `PUT_REDEMPTION_CANCELLATION`	✓	✓
Corporate actions	`REDENOMINATION` `REDENOMINATION_CANCELLATION`	✓	✓
Corporate actions	`REMARKETING_AGREEMENT` `REMARKETING_AGREEMENT_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	`SCRIP_DIVIDEND` `SCRIP_DIVIDEND_CANCELLATION`	✓	✓
Corporate actions	`SHARES_PREMIUM_DIVIDEND` `SHARES_PREMIUM_DIVIDEND_CANCELLATION`	✓	✓
Corporate actions	`SMALLEST_NEGOTIABLE_UNIT` `SMALLEST_NEGOTIABLE_UNIT_CANCELLATION`	✓	✓
Corporate actions	`SPIN_OFF` `SPIN_OFF_CANCELLATION`	✓	✓
Corporate actions	`STOCK_DIVIDEND` `STOCK_DIVIDEND_CANCELLATION`	✓	✓
Corporate actions	`STOCK_SPLIT` `STOCK_SPLIT_CANCELLATION`	✓	✓
Corporate actions	`TAX_ON_NON_DISTRIBUTED_PROCEEDS` `TAX_ON_NON_DISTRIBUTED_PROCEEDS_CANCELLATION`	✓	✓
Corporate actions	`TAX_OPTIMISATION`	✓	✓
Corporate actions	`TAX_RECLAIM` `TAX_RECLAIM_CANCELLATION`	✓	✓
Corporate actions	`TENDER` `TENDER_CANCELLATION`	✓	✓
Corporate actions	`TRADING_STATUS_ACTIVE` `TRADING_STATUS_ACTIVE_CANCELLATION`	✓	✓
Corporate actions	`TRADING_STATUS_DELISTED` `TRADING_STATUS_DELISTED_CANCELLATION`	✓	✓
Corporate actions	`TRADING_STATUS_SUSPENDED` `TRADING_STATUS_SUSPENDED_CANCELLATION`	✓	✓
Corporate actions	`VIRTUAL_CASH_CORRECTION_CANCELLATION`	✓	✓
Corporate actions	`WARRANT_EXERCISE` `WARRANT_EXERCISE_CANCELLATION`	✓	✓
Corporate actions	`WITHHOLDING_TAX_RELIEF_CERTIFICATION` `WITHHOLDING_TAX_RELIEF_CERTIFICATION_CANCELLATION`	✓	✓
Corporate actions	`WORTHLESS` `WORTHLESS_CANCELLATION`	✓	✓