Import currency exchange transactions with CSV

English Import/export
1

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.

6 Likes
2

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
3

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

1 Like
4

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?

5

Same issue, still. Looks like it is not yet possible, or at least it is not by importing.
If you inspect the XML, there is a special tag for connecting the transations, but you cannot specify this in the import CSVs. Someone is yet to implement this feature (or document it, if it is somehow supported)

7

Hi, PP is actually is able to perform a currency conversion during the import process. Thereā€™s a good write up that focuses on how this can be achieved for securities priced in pence (GBX) rather than pounds (GBP), but what it sets out should also work for different currencies: How to use the CSV Import functions for GBX priced securities? - Portfolio Performance Manual

8

Hi - I think there are two different scenarios being discussed in this thread. One is about cash transfers/ currency conversions between cash/desposit accounts.

I put the guide about GBX/GBP together which is mentioned above. That doesnā€™t help for cash currency exchange unfortunately.

It is still, as far as I can tell, a missing feature. Iā€™m currently trying to import a bunch more different cash, security and exchange transactions after a period abroad where I have a lot more than normal and manual entry is not practical.

I still have to prepare two import CSVs for each currency - one for the security transactions (buys and sells) and one for the cash transactions (i.e. deposits and removals). This is not so big a deal as I have already created the workbook which converts exports from my platform provider to CSV import format.

But I do now have to then manually enter any currency exchanges as transfers.

I did previously try creating the imports so that it had a Removal in one currency and a Deposit in the other instead of Transfers. I stopped doing that. I ā€œthinkā€ the reason I stopped was that this messes up measuring rates of return.