How to move Mutual Fund past transactions into a Brokerage Account

Any ideas?
thanks
Comments
-
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.Quicken Mac Subscription; Quicken Mac user since the early 90s0
-
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!0 -
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.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!
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.Quicken Mac Subscription; Quicken Mac user since the early 90s0 -
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.
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.
(If you find this reply helpful, please be sure to click "Like", so others will know, thanks.)Have Questions? Help Guide for Quicken for Mac
FAQs: Quicken Mac • Quicken Windows • Quicken Mobile
Add your VOTE to Quicken for Mac Product Ideas
Object to Quicken's business model, using up 25% of your screen? Add your vote here:
Quicken should eliminate the LARGE Ad space when a subscription expires
(Canadian user since '92, STILL using QM2007)0 -
Sigh. That's what I was afraid of. QFX export isn't as flexible as the old QIF.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!0 -
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.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!
Be sure to add your VOTEs below.
(If you find this reply helpful, please be sure to click "Like", so others will know, thanks.)Have Questions? Help Guide for Quicken for Mac
FAQs: Quicken Mac • Quicken Windows • Quicken Mobile
Add your VOTE to Quicken for Mac Product Ideas
Object to Quicken's business model, using up 25% of your screen? Add your vote here:
Quicken should eliminate the LARGE Ad space when a subscription expires
(Canadian user since '92, STILL using QM2007)0 -
oh, that's really helpful, especially to us who have mild dyslexia, or is that listdexia ?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!0 -
:-)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!Have Questions? Help Guide for Quicken for Mac
FAQs: Quicken Mac • Quicken Windows • Quicken Mobile
Add your VOTE to Quicken for Mac Product Ideas
Object to Quicken's business model, using up 25% of your screen? Add your vote here:
Quicken should eliminate the LARGE Ad space when a subscription expires
(Canadian user since '92, STILL using QM2007)0 -
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.0