Transactions

The Transactions report displays all financial movements in a tabular overview. This view is available at tenant level and at the level of individual portfolios. It enables the management and analysis of all security and account transactions.

Accessing the Report

At tenant level, all transactions are displayed across all portfolios and accounts. At portfolio level, the view is limited to the transactions of the selected portfolio. This focused view facilitates the analysis of individual portfolio activities.

Transaction Types

The report shows various types of transactions. For securities, purchases, sales, dividends and finance costs for margin positions are recorded. For accounts, these include deposits, withdrawals, account interest and fees. Account transfers are transfers between two accounts within the tenant and are displayed as connected transactions.

Table Columns

The main columns of the report are Date for the time of the transaction, Cashaccount for the affected account and Transaction Type for the type of movement. For security transactions, Security, Quantity and Quotation/Dividend are additionally displayed. The Tax Cost and Transaction Cost columns show the corresponding costs. The Cashaccount Amount indicates the impact on the cash balance and is displayed in red when negative.

Filter and Sort Functions

The table offers extensive filtering and sorting options. Each column can be filtered individually, with different filter options available depending on the data type. For date columns, you can select a date and specify whether you want to search for an exact date or a date range. For text columns such as cashaccount, transaction type or security, a selection list is available. For numeric columns, you can define numeric ranges. Sorting is by default by date descending, but can be adjusted by clicking on the column headers. Multi-column sorting is also possible using the Ctrl key.

Edit Functions

Transactions can be edited or deleted via the context menu or the Edit menu. When editing, fields such as date, quantity, quotation, taxes or fees can be adjusted depending on the transaction type. The account and the security cannot be changed after creation. When deleting a transaction, the system requests confirmation as this process is permanent. For account transfers, both connected transactions are deleted together. A special function is the conversion to account transfer. A single deposit or withdrawal can be converted to an account transfer retrospectively. This is useful when a withdrawal was originally recorded as a normal withdrawal but was actually an internal transfer. The system automatically creates the connected counter-entry on the target account.

Special Features

For margin positions, separate transactions for finance costs are recorded which are linked to the opening transaction. These can be positive or negative. For dividends, an ex-date can be specified when the dividend is paid after the sale of the security. The security reference is retained. For account transfers with different currencies, the exchange rate is used for both transactions and the amount is converted accordingly.