Mutual Fund Conversion - change Mutual Fund symbol/class AND retain original history
Options
Ps56k2
SuperUser ✭✭✭✭✭
I ran into this with the recent T.Rowe mutual funds and their migration to lower ER funds, but with different symbols. The download merely had the usual REMOVE Shares for ALL the old symbol, and ADD Shares for the new symbol.... pricing is slightly different.
But just doing that looses all the prior history related to the "old" symbol...
But just doing that looses all the prior history related to the "old" symbol...
SO, any suggestions on how to change the "holdings" with the new symbol,
but still somehow retain all the old history and prior transactions cost basis -
but still somehow retain all the old history and prior transactions cost basis -
QWin - R54.16 - Win10
0
Comments
-
I suggest you delete the downloaded Removed and Added transactions and use the Mutual Fund Conversion wizard instead: open the account, press Ctrl + N, select Mutual Fund Conversion in the Enter transaction: pull-down menu, ...1
-
Sherlock said:press Ctrl + N, select Mutual Fund Conversion in the Enter transaction: pull-down menu, ...Running Win10 - R38.30 - and I don't see the Mutual Fund Conversion in the pull down for transactions type ?The T.Rowe funds are "single mutual fund" per account.... if that matters.
QWin - R54.16 - Win10
0 -
Since these are SMF accounts ... you CAN'T do the conversion in the existing account, or even change the symbol of the security for the account. ONLY the original security can be held in an SMF account.You need to create new accounts for each such conversion and, probably, sell/buy to get the funds moved.
Q user since February, 1990. DOS Version 4
Now running Quicken Windows Subscription, Business & Personal
Retired "Certified Information Systems Auditor" & Bank Audit VP0 -
Ps56k2 said:Sherlock said:press Ctrl + N, select Mutual Fund Conversion in the Enter transaction: pull-down menu, ...Running Win10 - R38.30 - and I don't see the Mutual Fund Conversion in the pull down for transactions type ?The T.Rowe funds are "single mutual fund" per account.... if that matters.
If you're using single mutual fund account registers, you should have two registers. Deactivate the Online Services of the register that held the original mutual fund, set the register to support multiple securities, perform the Mutual Fund Conversion, and move the Added transactions to the new register.1 -
tnx for the pointers - I've been restoring back to the ADD/REMOVE date to get a pre-change file....
and had tried a bunch of things - but nothing worked.....
Will try the latest suggestions offered....
QWin - R54.16 - Win10
0 -
@sherlock, digging back into the deep dark recesses of my memory ... I'm not sure that TRP supports other than SMF accounts.
Q user since February, 1990. DOS Version 4
Now running Quicken Windows Subscription, Business & Personal
Retired "Certified Information Systems Auditor" & Bank Audit VP0 -
@sherlock, I'm missing something.Doesn't the MF Conversion create the new, converted security in the same account? And how can that new converted security, with a new symbol, exist in a previously used SMF account that was created for a different security with a different symbol?
Q user since February, 1990. DOS Version 4
Now running Quicken Windows Subscription, Business & Personal
Retired "Certified Information Systems Auditor" & Bank Audit VP0 -
@NotACPA, After you have deactivated the Online Services of the register that used to hold the original mutual fund, you should be able to set the register so that it is no longer a SMF account register. If you don't want to do that, you could move all the transactions to a intermediate register that isn't SMF, run the wizard there, and then move the transactions to their appropriate registers.NotACPA said:@sherlock, I'm missing something.Doesn't the MF Conversion create the new, converted security in the same account? And how can that new converted security, with a new symbol, exist in an SMF account?0 -
@Sherlock AHHHH, this is the 1st time that you mentioned the CRITICAL deactivate step. No wonder I was confused and @Ps56k2 couldn't find that wizard.
Q user since February, 1990. DOS Version 4
Now running Quicken Windows Subscription, Business & Personal
Retired "Certified Information Systems Auditor" & Bank Audit VP0 -
ok... at a stopping point - for anyone following along -Did the Edit Account - Deactivate Online Services and also turn off Single Mutual Fund.Next, perform the Mutual Fund Conversion menu item ....
BUT .... this entry is only found in what I call the "Account Level" [Enter Transactions] menu at the top left of account.
It is not in what I call the "Line Item" transactions pull down menu of the Register.
Did that function - and it entered a REMOVE for all old shares -
and created new ADDED line items for each older transaction.That's where I'm at now.....
SO - what are the next steps ....
Do the Add Account - and let TRP create and download the newly existing holdings and recreate new SMF accounts?
Then - select and copy over all the newly created ADDED transactions for each account?
Lastly - what to do with the now orphaned old TRP accounts ?[EDIT] - updated topic title to better reflect the Mutual Fund Conversion discussion - for future searchingQWin - R54.16 - Win10
0 -
The next step is to move the Added transactions introduced by the Mutual Fund Conversion wizard over to the new account register: open the source register, press Ctrl + Shift + N, and select Move transactionsPs56k2 said:ok... at a stopping point - for anyone following along -Did the Edit Account - Deactivate Online Services and also turn off Single Mutual Fund.Next, perform the Mutual Fund Conversion menu item ....
BUT .... this entry is only found in what I call the "Account Level" [Enter Transactions] menu at the top left of account.
It is not in what I call the "Line Item" transactions pull down menu of the Register.
Did that function - and it entered a REMOVE for all old shares -
and created new ADDED line items for each older transaction.That's where I'm at now.....
SO - what are the next steps ....
Do the Add Account - and let TRP create and download the newly existing holdings and recreate new SMF accounts?
Then - select and copy over all the newly created ADDED transactions for each account?
Lastly - what to do with the now orphaned old TRP accounts ?[EDIT] - updated topic title to better reflect the Mutual Fund Conversion discussion - for future searching
As to what to do with orphaned TRP account registers, that is up to you. My preference is to maintain the orphaned account's registers as hidden and eventually move them to Separate when they are no longer needed for my tax reports. You may move the orphaned TRP account register transactions into an appropriate common TRP register to reduce the clutter and free up the register slots for reuse.0 -
A couple of nits .....1 - On the ADD ACCOUNT - since these must be NEW Quicken accounts to hold the newly created transactions,
You must choose "Add to Quicken" vs the usual "Link to existing account"..... to create a totally new account.2 - on the Move Transaction, when you click the checkbox to Select, all of the current/new entries will be auto highlighted.3 - when you actually click on the [Move] at the bottom of the screen,
it will move the transactions AND also invoke a Validate to run....
took about 3mins - and it does this for EACH time you use [Move Transactions]4 - lastly, in the newly created Register -
you need to obviously go and Delete the "Bought Shares" else you get double accounting.Also, edit the old accounts to [x] them in the Separate world,
along with other Separate accts - closed, 529, converted, merged, zero bal, etcI think we are done - thanks to all - not sure how mere mortals could walk this gauntletQWin - R54.16 - Win10
0
This discussion has been closed.