Problem importing cash account transactions from CSV files generated by PP

English Import/export
1

I’ve been using PP for some time now. The currency for my cash account is GBP and the securities I hold are priced in a number of currencies including GBX.

Recently I set up a new XML file with the idea that this replicates most of the contents of my existing PP file. Using the CSV Export Routine (as is available from the drop-down menu) I was able to generate a CSV file for each securities and cash account.

I had no problem importing the CSV file for the securities account into the new XML file. However I’m unable to perform the import process for the cash account, since some of the transactions that feature in this aren’t priced in my base currency (GBP) – as a result the import routine is aborted and the message ‘Exchange Rate of Gross Vale is missing’ is displayed.

I’ve referred to the manual which features a very useful section on importing dividends from a csv file, highlighting that a number of details are needed to import foreign dividends: the currency gross amount (the type of foreign currency), the gross Amount (of the foreign currency), and the exchange rate. Yet, none of this information is contained in the cash account csv files generated by PP.

I had hoped that I could get this information from the main pane instead, but no joy – it isn’t provided here.

I’m hoping someone can help with this - any thoughts and/or suggestions will be appreciated :grinning:

2

Dear Rich28,
couple of points to csv -import/export function of PP.
Exporting a cash account will only export the bookings in the reference currency of the account - in your case GBP.
The information you see in the booking section (if you have bought in a different currency, eg USD) will NOT be exported. That is a weakness of PP.
A common problem with trades in the UK is that the shares are listed in GPX and the account is in GBP. To solve the problem you have to add to your excel/csv file the information you found in the dividend example you mentioned.
Let’s say you have the amount of a trade in in GBX - you need to add 3 columns to your csv-file: the symbol of the other currency (eg GBX), the amount in GBX, the exchange rate 0,01. With this information the import normally works.

2 Likes
3

Many thanks for getting back to me @Carsten. :crossed_fingers: this weakness will be addressed! It was bit of a farce, but as things transpired adding the three columns was relatively straight forward - I used a vlookup in Excel.