Import currency exchange transactions with CSV

Hey!

I have spent three evenings with preparing the data, learning the program and it has been a lot of fun. Very useful and good application!

I have been able to test and figure everything else out but I cannot seem to find a way to import currency exchange with CSV. Manually it is really easy to create ta transfer out and in between two cash accounts and I ended up doing it manyally, it was about 50 transactions. Now my partner is very excited about the app and wants her portfolio in there too. The problem is that when it is about accounting, transactions, and statistics then I am the one that does these things to her and it took me hours and hours so I would not want to do it again.

What I figured out was:
With transfers I could make the in and out separately and import then but there are few problems:

  • There is no exchange rate attached
  • The transactions are separate and not connected like the manual transfer is
  • I have not found a way to import all currencies in one go, they have to be imported separately
  • It’s not easy to make connection between two transactions

Is there a way of actually import same kind of transactions like the manual transactions are?

Of course they can just be imported in one go if they are deposits and removals but that would mean that there is no way of making any difference between deposits, removal and currency exchange.

5 Likes

Hello! I need help like you.
I need to import cash transactions (with Fees and Taxes ), from one account in BRL to another one in USD or EUR.
Is there a way to do this?
Thanks a lot.

1 Like

Hi, you can find more info in the manual
File > Import - Portfolio Performance Manual (portfolio-performance.info)

1 Like

I have the same issue here. I could not find an answer in the manual in the above link.

I have some ‘buy’ transactions in GBX that I want to import in a GBP account.

The import complains the “Echange rate” is missing. Although I did add a column identified as “Exchange Rate”.

Any pointers?