Dividends and interest

The Dividends and Interest report provides a year-by-year overview of all dividend and interest income as well as associated costs and taxes. It is available exclusively at tenant level and analyzes all transactions across all portfolios. All values are automatically converted to the main currency.

Report Structure

The report is structured in three levels. The main table shows a summary per year with aggregated values for dividends, interest, costs and taxes. Expanding a row reveals two detail views: the securities view shows all dividend payments per security for the selected year, the cash account view shows all interest income and fees per account. This hierarchical structure enables both a quick overview over the years and detailed analysis at security and account level. The main table shows the following columns for each year: Year, Account interest for the sum of all interest income from cash accounts in main currency, Tax cost transaction for all taxes incurred on transactions, Paid transactions for the number of cost-incurring transactions, Average transaction cost for the average costs per transaction, Transaction cost for the total sum of all order fees, Fee for account and custody fees, Auto paid tax for withholding taxes automatically deducted on dividends, Taxable amount for the taxable portion of income, and Real received for the dividends and interest actually received after deduction of all taxes. The Value at end of year column shows the total value of all securities at year end. The footer shows the totals across all years.

Securities Detail View

The first detail view lists all securities that paid dividends in the selected year. The columns include Name and ISIN of the security, Currency of the security, Exchange rate at year end, Units at year end, Close price at year end, Tax free income for tax-exempt dividend portions, Auto paid tax for deducted withholding taxes, Taxable amount for the taxable portion, Real received for the dividends actually received, and Value at end of year for the total position value. Expanding a security row further displays all individual dividend transactions of that security for the year. These can be edited directly.

Cash Accounts Detail View

The second detail view lists all cash accounts that generated interest or incurred fees in the selected year. The columns include Name and Currency of the account, Close as balance at year end, Fee cashaccount and Fee security account each in account currency and in main currency, Auto paid tax for deducted taxes, Taxable amount for the taxable portion, Real received for the interest actually received, Cash balance as current account balance, and Cash balance in main currency. Expanding an account row further displays all interest and fee transactions of that account for the year. These can be edited directly.

Functions

The main table can be sorted by all columns. Sorting is by default by year ascending. In the detail views, securities and accounts can also be sorted by all columns. Via the View menu and the Evaluation of depots option, a dialog can be opened to restrict the evaluation to specific security accounts and cash accounts. In this dialog you can select which security accounts should be considered for dividend evaluation and which cash accounts for interest evaluation. The settings are saved and reused the next time the report is opened. The table header shows how many accounts are currently selected. In the detail views, individual transactions of a security or account can be displayed and edited by expanding. The editing functions correspond to those in the Transactions report. After each change, the report is automatically reloaded to display current values.