How to import transfers from one deposit account to another

[leandot]

Hi,

I have started using Portfolio Performance lately and I am very happy with what I can do with it, adding data manually works fine. What I want to do is to import everything I need as csv. I’ve managed to do almost everything - deposits, withdrawals, trades, dividends but I can’t seem to make an import, which has the transfers from one deposit account to the other. For example:

I have 2 deposit accounts, let’s say IBKR CHF and IBKR USD. A transfer from one to the other is basically converting CHF to USD and this is how PP records it. For example a json export for this transaction looks like this:

{“version”:1,“transactions”:[{“type”:“CASH_TRANSFER”,“account”:“IBKR CHF”,“otherAccount”:“IBKR USD”,“date”:“2023-05-18”,“currency”:“CHF”,“amount”:1200.0,“units”:[{“type”:“GROSS_VALUE”,“amount”:1200.0,“fxCurrency”:“USD”,“fxAmount”:1332.88,“fxRateToBase”:0.9003051882}]}]}

When I export as CSV it looks like this:

Date;Type;Security;Shares;Quote;Amount;Fees;Taxes;Net Transaction Value;Cash Account;Offset Account;Note
2023-05-18 00:00:00;Transfer (Outbound);;;;CHF 1’200.00;;;CHF 1’200.00;IBKR CHF;IBKR USD;

As you can see some of the information in the JSON is not in the CSV? I also cannot import back the same CSV export I just did:

1. Complains there is no Value (I can assign Amount to Value)
2. It complains the currency does not match "Transaction currency EUR does not match account currency CHF: 18 May 2023 Transfer (Outbound) EUR 1’200.00 ". I have tried to use currency - EUR, CHF, USD etc. but nothing works.

How do you guys deal with this? Is there a way to access the local database that PP uses directly - is it a file or sqlite or something else?

Thanks,
Leandot

[chirlu]

CSV import for currency conversion

Hi, I try to use a CSV file to put all my currency conversions but I can’t figure out how to setup my file. Using the GIU is pretty simple, but I can’t replicate that using a csv file. Any help would be great. Thank you [Screenshot 2024-09-26 at 20.03.45]

@leandot

Is there a way to access the local database that PP uses directly - is it a file or sqlite or something else?

Yes, it is a file.

[keep3r]

It’s a missing feature. Many people already mentioned this problem but it’s still not solved.

I have to manually book many transfers each month because I do a lot of currency conversions. It’s the only missing feature so I could auto import all transactions.