Why can I not change the Action XFR to Sell in the source account? With locked I mean the Action field is greyed out and cannot be changed. Maybe the QIF import from Quicken locked the field?
It seems that I have to create a new Sell transaction for each transfer-in-kind and then XFR the total amount of all transfers to the destination account, is that correct?
OK, I now understand... Investment txns are special and complex (as many other splits / securities hang off the parent record). When you do an Xfr between investment accounts, then the 'other side' (whether its to or from ) is locked as an Xfr.
It makes no sense that you would want to 'unlock' the other side and change it to something else. For example if you wanted the other side to become a Sell instead of an Xfr, then you would need to delete the source txn first and create a new txn..
The security field is locked as you are transferring cash not a security.
You cannot have a SellXfr and also a BuyXfr as I think that’s what you are trying to do..? This is wrong
I remember now what happens with QIF imports and what happened to me many years ago. I seem to remember that a quicken QIF does this
- Sell - Txfr cash to a fake category (called the security name)
- Txfr cash from the fake category (called the security name) - Buy
Or it might have been
- SellXfr to the fake category - BuyXfr from the fake category.
You actually need:
Source: SellXfr to investment account
I remember I had to change all my QIIF Xfrs until the fake category account caused by shares in/out from the qif import was empty.
I also remember that the qif transfers were wrong as they used the wrong cost basis to sell and txfr. I had to change everyone to sell and buy using the correct cost basis and also clear out the fake category as mentioned above.
Yes that makes sense now: in my case for stock transfers, the QIF Quicken import placed the security name in the transfer field of the source and destination account. The action was correct - BuyXfer, the Checking# was ShrsIn and the Description and Memo fields correctly showed the "other side" in both accounts. The source account showed the wrong share price (1 or close to it) resulting in the wrong amount.
What I need to do is to replace the wrong security name in the Transfer field with the source account name in the destination account (and not in the source acc otherwise I would use the wrong 1$ share price). I also copied the security name into the memo field of the destination acc to identify the security whose amount was transferred from in the source acc. The Action is correct - BuyXfer in the destination acc, but I need to change the Action in the source acc from SellXfer to Sell and also correct the $1 share price in that acc.
The alternative would have been to change the BuyXfer Action that is also listed in the source account (with correct share amount and price) into Sell and to replace the wrong security name with the transfer acc but that field is locked so it is not an option.
Now the cash amounts and shares are correct, how is that for a mental gymnastic?
This is a consistent pattern in my file for stock transfers, so maybe Sean can make use of this observation and make some adjustments to the QIF import from Quicken. Thank you!