Skip to content

IB Flex: can't import dividend with currency different than security #4978

@lmb

Description

@lmb

Describe the bug

  • I have an account with interactive brokers, in GBP as base currency.
  • That account contains a security (VWRL) which I bought in EUR on a German exchange a long time ago. This was transferred to IB. The security is denominated in EUR both in the IB interface as well as in PP.
  • VWRL is denominated in USD. Dividends paid by the fund are therefore in USD.
  • IB does not automatically convert the USD dividend into either EUR or GBP.
  • Importing such a USD dividend for VWRL gives an error message "Foreign currency of gross value USD does not match currency of security EUR: 30 Dec 2024 Dividend GBP XXX.YY Vanguard FTSE All-World".
  • Manually changing the transaction Cash Account to a USD deposit account changes the error message to "Transaction currency GBP does not match account currency USD: 30 Dec 2024 Dividend GBP XXX.YY Vanguard FTSE All-World"

To Reproduce
Steps to reproduce the behavior:

  1. File -> Import -> IB Active Flex Query
  2. Import .xml containing a transaction as describe above

Expected behavior

In the best case the importer would automatically assign the transaction with a deposit account in USD (probably the one selectable at the top of the dialog?). The UI would show that transaction in USD, while performance calculations would use the base currency of the security.

The second best case would be to be able to manually override the Cash Account as described.

Screenshots
If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

  • OS: macOS
  • Version 0.79.1

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    Status

    In Progress

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions