I have a really hard time understanding how the” CSV import” works; especially with transactions in foreign currency securities. I’ve searched for documentation but found not very much help. Maybe I’m searching in the wrong places.
Here are some of my basic questions:
- What exactly are the differences between the 4 types of CSV import, named Securities, Securities Account, Account Transactions and Portfolio Transactions. They are associated with different input-fields; e.g. name of the cash account, number of shares, … The first one (securities) seems obvious: creating a list of portfolios. Creating that list, however, is also possible with the other three. Also, the difference between Portfolio and Account transactions type is ONE input field (Offset Account versus Offset Securities Account). Difference? What is an Offset account?
- There seems to be multiple ways to specify a foreign currency in a transaction. Suppose I want to buy a Alibaba share (listed in the securities panel as USD currency). The transaction, however, should be paid with a EUR cash account. So, I need an exchange rate. But what about the other fields: Transaction currency, Offset account (or Offset Securities account?), Currency Gross Amount? The Gross Amount field itself does not seem to have any effect. Most of the time I get an error message “Transaction Currency USD does not account currency EUR”; even though I haven’t set the Transaction Currency field explicitly.