Can any of the solid users here post a (English & German) video on IMPORTS. I mean a good detailed one not like the fluffy stuff most youtubers do that only present the very basic. We need to be able to utilize large file and plenty of historic data.
Remember, this is the best software for portfolio management, not for being free, but it is the only one that allow you to keep your data private on a local drive.
What exactly are you expecting? What knowledge are you lacking?
And did you had a look at:
When importing using csv there are plenty of field types that does not work with “account transaction” for example:
DRIP/Dividend-Reinvest/Dividend-cash/Transfer-as-is-in(out)/Bank-Interest
Even when solving those issues manually, my bank does not put the ticker for all transaction lines, it sometimes use the ticker name rather than symbol (specially if the symbol was on the prior line).
In all cases, once I finish the transfer, some transactions are ignored by PP leading to higher balance than it really is (sometimes double or triple the actual balance).
A detailed video clarifying the underlying meaning of each PP action would be very helpful.
Alternatively, a video clarifying how PP understands the basic building blocks (Deposit Acct, Sec. Acct, Securities) and how PP understand the relation between them. Where should different types of transactions go. That would make the life much easier.
And thank you for responding.
The manual contains the answer to thise questions.
Video is probably not what you need. You obviously know how to import. The problem is your data source.
There is a topic about CSV import. When you import data, you see which lines are imported and which not. You also see error description there.
Find and attach few examples.
I may try to help. If you check my profile, I published some conversion scripts here to be able to import data from various sources. You will probably need one too because exports usually don’t have correct structure.
That’s very nice of you. And, yes, I can see the green vs yellow records, but in my case, I have a few thousand records. Should I split the file into smaller files and repeat import? Should I split based on the transaction type? And still, I don’t know how to handle DRIP/Dividend-Reinvest/Dividend-cash/Transfer-as-is-in(out)/Bank-Interest/Split-Share, …
Another option, I can clean up the file from personal information and email it to you, just let me know.
Which company is the source of that data? Which bank or broker? Haven’t you found any topic here? Just add anonymized data here.
First you have to find which transaction types are problematic. From my experience dividends can cause a lot of trouble. Then you need to convert it somehow (you can use Claude or Copilot).. “Vibe coding” is not that difficult.
This is how it looked like in my case. Original from broker
Source data
Action,Time,ISIN,Ticker,Name,Notes,ID,No. of shares,Price / share,Currency (Price / share),Exchange rate,Result,Currency (Result),Total,Total (CCY),Currency (Total),Withholding tax,Currency (Withholding tax),Currency conversion from amount,Currency (Currency conversion from amount),Currency conversion to amount,Currency (Currency conversion to amount),Currency conversion fee,Currency (Currency conversion fee),Merchant name,Merchant category,Record Date
Dividend (Dividend),2025-01-01 00:00:00,ISIN,TICKER,“Name”,4.0000000000,1.198500,USD,22.11514400,106.02,“CZK”,0.85,USD,
And this is best format for Performance Portfolio
Result data
“ID”;“Type”;“DateTime”;“ISIN”;“Ticker symbol”;“Name”;“Note”;“Shares”;“Gross amount”;“Currency Gross Amount”;“Exchange rate”;“Result”;“Currency (Result)”;“Value”;“Transaction Currency”;“Fees”;“Currency (Currency conversion fee)”;“Taxes”;“Currency (Withholding tax)”;“Date”;“Time”;“Cash Account”;“Securities Account”;“Offset Account”;“Currency conversion from amount”;“Currency (Currency conversion from amount)”;“Currency conversion to amount”;“Currency (Currency conversion to amount)”;“Price / share”
“”;“Dividend (Dividend)”;“2025-01-01 00:00:00”;“ISIN”;“TICKER”;“Name”;“”;“4”;“5,6400”;“USD”;“22,1152”;“”;“”;“106,02”;“CZK”;“0”;“”;“18,71”;“USD”;“2025-05-20”;“11:10:54”;“CZK deposit account”;“USD security account”;“”;“0”;“”;“0”;“”;“1,1985”
If you use these columns, then PP will automatically load the CSV and you won’t need to configure it. Your conversion just needs to bind all the values. Note that not all colums are needed.
The conversion script needs to calculate some fields.
So I had 4 dividens * 1.1985$ + 0,85$ fee = 5,64$ gross value into PP.
Original tax amount was 0,85$. But broker does not pay it in original currency so I had to multiply it with exchange rate. Then I applied some rounding to make it correct.
And you see few new columns, like “Cash account” and “Securities account”. This was the only way I found if need to handle multiple currencies. Default import can’t handle that with original data source.
I can’t make the script for you. It take a lot of time in the beginning to make it work. But eventually you can get correct format and import all lines correctly.
This is a very detailed answer and it took me a while to actually go through it and understand it. I am importing from TIAA and Schwab, the csv files are not ready for PP. I did the porting on multiple cycles on the same file, once importing as Security Account, another from the same file as Portfolio, and a third to balance the account. Each time I pick different transactions from the same file.
To make myself clear, the problem is not in describing columns, its about rows (transactions). I couldn’t solve a share SPLIT and had to do it manually. Dividends could be Dividend-Cash, or Reinvest, or Reinvest-Shares, or DRIP. PP does not provide rich options for those situations. There is also a transfer of shares as-is called SEC-TRANSFER. I am not clear how to do it on PP. Then there is the Journal transaction which is a cash transfer in or out. I am trying all as transfer-in and rely on the minus sign to signal the transfer out.
The generated numbers are still not matching my bank balances, not even close. I will review your answer again.
Another side question, does PP plan to have MONTE-CARLO anytime soon?
I don’t think that all the transaction types are relevant.
PP has everything you need. There is cash transfer in and out (deposit or removal).
I have no idea how to solve “split” operation. Never had such transaction.
There is only one dividend option needed - cash dividend.
Reinvest dividend should probably not be added as it is part of the security price. If you have accumulationg ETF, you don’t actually get dividend, it is reinvested and it is not in your transactions. Or I don’t understand the meaning …
DRIP is probably 2-in-1 operation. You get dividend and you buy stocks for that. So you have to add it as 2 operations.