How to move Mutual Fund past transactions into a Brokerage Account

Joe Guthart

Using the Mac edition I want to move all the transactions from a Mutual Fund over to my brokerage account which has multiple mutual funds, etas, etc in them.  The brokerage account recently accepted this mutual fund and now I want to move over over 10 plus years of cost data for that mutual fund.  

Any ideas?

thanks

RickO

It isn't possible in QMac to move transactions from one investment account to another. My suggestion would be to use a Remove Shares transaction in the Mutual Fund account to zero out the shares there. Then use an Add Shares in the Brokerage, entering the total cost there. Then go to Accounts > Hide & Show Accounts and hide the Mutual Fund account (rather than delete it) which will preserve the history in case you need it later.

John Burgess

RickO’s method is the easiest. You just need one transaction to record the sum of everything older than one year, since everything they are all long term gains.


If you really want to preserve the entire transaction history, you could try this, which is a lot trickier, and I’m not really sure you can do it this way anymore in QM2018.



0. Make a complete backup, in case you need to start over!


1. Export the transactions from the mutual fund account to a QIF file.


2.use a text editor (I use TextWrangler) to edit that file, changing the account name to match your Brokerage account and save it as text, but still with the .qif extension. I’d use a different name for this modified file.


3. With your brokerage account open, Import the modified transactions. Do they all show up in the right place?


4.when you’re confident every transaction has been moved, delete the now redundant mutual fund account.



Good luck!

RickO

John Burgess said:

RickO’s method is the easiest. You just need one transaction to record the sum of everything older than one year, since everything they are all long term gains.


If you really want to preserve the entire transaction history, you could try this, which is a lot trickier, and I’m not really sure you can do it this way anymore in QM2018.



0. Make a complete backup, in case you need to start over!


1. Export the transactions from the mutual fund account to a QIF file.


2.use a text editor (I use TextWrangler) to edit that file, changing the account name to match your Brokerage account and save it as text, but still with the .qif extension. I’d use a different name for this modified file.


3. With your brokerage account open, Import the modified transactions. Do they all show up in the right place?


4.when you’re confident every transaction has been moved, delete the now redundant mutual fund account.



Good luck!

John, I'm all for clever workarounds, but unfortunately, there isn't QIF export/import in QM18. Doing the analogous thing with QXF doesn't work because Quicken detects the duplicate account name and creates a copy.

There may be a way to accomplish this with QFX by "hacking" the QFX file or exporting to CSV and using a CSV to QXF converter. Joe would have to research those options.

smayer97

Meanwhile, you can add your VOTE to 

• Add Ability to Transfer Shares between Investment Accounts and 
• Add Ability to Select Content of QXF File for Export.

First, click on the underlined link above to go there, then click VOTE at the top of THAT page, so your will vote count for THIS feature and increase its visibility to the developers by seeking to have the features you need or desire end up in the latest version.

While you are at it, you may want to add your VOTE to related IDEAS found on the 

• List of Requests Related to Investments and the 
• List of Requests for Data and File Management Features respectively. 
  

Click on the underlined link, then follow the instructions to add your vote to more related ideas. Your VOTES matter!

(If you find this reply helpful, please be sure to click "Like", so others will know, thanks.)

John Burgess

John Burgess said:

RickO’s method is the easiest. You just need one transaction to record the sum of everything older than one year, since everything they are all long term gains.


If you really want to preserve the entire transaction history, you could try this, which is a lot trickier, and I’m not really sure you can do it this way anymore in QM2018.



0. Make a complete backup, in case you need to start over!


1. Export the transactions from the mutual fund account to a QIF file.


2.use a text editor (I use TextWrangler) to edit that file, changing the account name to match your Brokerage account and save it as text, but still with the .qif extension. I’d use a different name for this modified file.


3. With your brokerage account open, Import the modified transactions. Do they all show up in the right place?


4.when you’re confident every transaction has been moved, delete the now redundant mutual fund account.



Good luck!

Sigh. That's what I was afraid of.  QFX export isn't as flexible as the old QIF.

smayer97

John Burgess said:

RickO’s method is the easiest. You just need one transaction to record the sum of everything older than one year, since everything they are all long term gains.


If you really want to preserve the entire transaction history, you could try this, which is a lot trickier, and I’m not really sure you can do it this way anymore in QM2018.



0. Make a complete backup, in case you need to start over!


1. Export the transactions from the mutual fund account to a QIF file.


2.use a text editor (I use TextWrangler) to edit that file, changing the account name to match your Brokerage account and save it as text, but still with the .qif extension. I’d use a different name for this modified file.


3. With your brokerage account open, Import the modified transactions. Do they all show up in the right place?


4.when you’re confident every transaction has been moved, delete the now redundant mutual fund account.



Good luck!

Just for clarification, QFX is the file format used to import transactions from FI/Banks, QXF is the file format used to transfer data from QUicken data file to Quicken Data file, including Windows to Mac conversion. 

Be sure to add your VOTEs below.

(If you find this reply helpful, please be sure to click "Like", so others will know, thanks.)

John Burgess

John Burgess said:

RickO’s method is the easiest. You just need one transaction to record the sum of everything older than one year, since everything they are all long term gains.


If you really want to preserve the entire transaction history, you could try this, which is a lot trickier, and I’m not really sure you can do it this way anymore in QM2018.



0. Make a complete backup, in case you need to start over!


1. Export the transactions from the mutual fund account to a QIF file.


2.use a text editor (I use TextWrangler) to edit that file, changing the account name to match your Brokerage account and save it as text, but still with the .qif extension. I’d use a different name for this modified file.


3. With your brokerage account open, Import the modified transactions. Do they all show up in the right place?


4.when you’re confident every transaction has been moved, delete the now redundant mutual fund account.



Good luck!

oh, that's really helpful, especially to us who have mild dyslexia, or is that listdexia ?

smayer97

John Burgess said:

RickO’s method is the easiest. You just need one transaction to record the sum of everything older than one year, since everything they are all long term gains.


If you really want to preserve the entire transaction history, you could try this, which is a lot trickier, and I’m not really sure you can do it this way anymore in QM2018.



0. Make a complete backup, in case you need to start over!


1. Export the transactions from the mutual fund account to a QIF file.


2.use a text editor (I use TextWrangler) to edit that file, changing the account name to match your Brokerage account and save it as text, but still with the .qif extension. I’d use a different name for this modified file.


3. With your brokerage account open, Import the modified transactions. Do they all show up in the right place?


4.when you’re confident every transaction has been moved, delete the now redundant mutual fund account.



Good luck!

:-)

Joe Guthart

Thanks all for the responses -- great resource to call on when assistance is needed.

I went with the RickO suggestion above and all is good.