Import Transfer between 2 Cash Accounts via CSV

Leo86 · October 13, 2024, 6:53pm

Hello,
I am trying to import from a broker the forex exchange the broker did before buy a stock. So basically my CSV file has a TRANSFER inputs where it convert CHF to USD with the exchange rate. So i have the broker account with CHF and then USD. When i buy i should take the CHF and convert to USD. The csv file has of course this transaction done by broker.
So i tried to import it but doesn’t recognize it. How to import the Transfer between 2 CASH Accounts of the same Security Account?
It recognize as USD but should be CHF. Which flag should i use?
The csv file has the CHF value, USD converted value and the Exchange rate.
Please let me know,

BR

Rafa · October 13, 2024, 7:03pm

This as feature is in consideration but actually, it is not possible.

github.com/portfolio-performance/portfolio

Create a AccountTransferItem (not a TransactionItem).

opened 09:33AM - 19 Sep 24 UTC

Nirus2000

enhancement help_wanted

@MonkeySon writes: > Bigbank offers overnight accounts and fixed-term account…s. This transaction was from the overnight to the fixed-term account, therefore "Interne Belastung". I replaced the Transaction Type with TRANSFER_OUT and expected a selection GUI which lets me choose accounts for the IN/OUT transaction. I intend to use two separate PP accounts for each Bigbank account. There UI has some (limited) support to import account transfers. As @Nirus2000 pointed out, you would need to create a AccountTransferItem (not a TransactionItem). And there are no check for matching currencies and other things. And there is no option to convert it to a deposit/withdrawal if one does not want it as a transfer. So far our strategy for the "cash transfers" was: * Create a cash deposit or removal (withdrawal) transaction Why not a transfer transactions? Because * the user might not want to maintain the other account in PP (let's say your regular payroll account) * the user might import the documents from the other account/bank as well (which will create the transaction again). But @Nirus2000 and me already discussed that it makes sense to provide more options *after* the import: * Right-click to convert any deposit/withdrawal to a transfer transaction * Select two transactions (a pair of deposit and withdrawal) and "join" them to a transfer * Run some kind of heuristic after the import to suggest a transfer (account at the same bank, same amount in a transaction). For this particular change, I propose to create a deposit/withdrawal transaction instead. _Originally posted by @buchen in https://github.com/portfolio-performance/portfolio/issues/3894#issuecomment-2036206552_