Investment transfers break Portfolio by Investment Type

[Sussex Pete]

Hi all, new member here!  I'm Pete, and I've been very happy running my life on MS Money since Windows 98.  I'm presently running Money version 14.0.120.1105 which has been stable for a long time.  But now I have a problem that led me via a lot of Googling to you fine folk! Here's what's happened. 

In the real world, I moved all my fund holdings from Fidelity to AJ Bell last August.  This all went well (in the end - long story).  I then used Transfer transactions to move the holdings from the Fidelity account to the AJ Bell account in Money.  

This also seemed to go ok, the account holdings look good and appear in my Portfolio when grouped by Position, Currency or Account Name all looking good.  Importantly, the performance data is intact as there are a dozen years of transactions and prices across those accounts.  

But when I select "Group By Investment Type" in Portfolio, the portfolio display is seriously broken with invesment names repeated with different value entries and multiple Cash lines that flicker oddly when my mouse passes over them.  If I choose the portfolio "As of" date to be the day before the transfers, it's completely fine, but the day of the transfers or later, it's bust.  So I figure there's something odd here!  

I've looked at alternatives to Transfer transactions without success.  Remove Shares and Add Shares moves the holdings but loses the performance info and Capital Gains information.  I've also tried several routes through export investment transactions and recover account but that seems to make a real mess of the associated cash accounts. I have also tried repairing the Money file and re-entering the Transfers but it's still broken.

Has anyone else seen this problem with Transfers and Portfolio?  Any insights or ideas would be greatly appreciated!  

 

Best wishes --Pete

[Cal Learner]

Pete, when  I moved everything from one broker to another, I renamed the existing account to the name of the new broker. That would mean deleting all of the transactions that you had already done.

If you wanted to consider this, there could be some additional tricks that could be helpful. 

I don't know about the anomalies you are encountering, but this could be a way to help work around them.

[Michael Wylde]

Pete, I’m using the same version, in UK. When I moved all the contents of an account to a different provider, from the accounts list page I used more account tasks/record a special activity/transfer an account. That worked perfectly.

I’m not sure if that’s what you mean you did – I can’t find “transfer transactions.”

Mike

--
You received this message because you are subscribed to the Google Groups "Microsoft Money" group.
To unsubscribe from this group and stop receiving emails from it, send an email to microsoft-mon...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/microsoft-money/e75b19ea-3fec-4695-abea-21a96b0ae900n%40googlegroups.com.

[Michael Wylde]

Correction that should say from the account register page (summary or investment transactions, not cash transactions), not the accounts list page, sorry.

Mike

To view this discussion visit https://groups.google.com/d/msgid/microsoft-money/DB9PR08MB7037B059D7DEDD611532B72E85262%40DB9PR08MB7037.eurprd08.prod.outlook.com.

[Cal Learner]

How to do QIF import and export with Microsoft Money:

Work with a copy of your *.mny file until you are sure you want to adopt the revised file.

If you want to do the QIF export/import, first export all accounts to Loose QIF  files, one at a time.  I would suggest this: start the name of the QIF file for the investment  accounts with the number 1 (or at-sign '@'), and start the name of QIF files for the cash  accounts associated with the investments with a letter.  Thus you might have  1BrownInvestment.qif and BrownInvestmentCash.qif.  This would cause the  investment account to be processed prior to the associated cash account.  When  the BrownInvestment got created, you would specify that you want to track the  cash transactions.  Then specify that the cash transactions account for  BrownInvestment was where the BrownInvestmentCash.qif transactions get sent.  

Create a new Money file with
File->New->NewFile.
Name it something like Try2005.mny.

Click Next.

Select (*) I don't want to use a password.
Next.
On page titled "Add your accounts", click "Skip account setup." if you want to wait until the QIF import to create the accounts. Alternatively you could create empty accounts at this point, and then you will have those to choose from during the QIF import.
On page titled "Congratulations" click Finish.

Then you could try your same import. Money should then ask about an account. Let Money create an account, and see what shows up.

To switch back to your regular file, Click File and select your real file from the list at the bottom of the drop-down list.

Then  File->Import->RecoverAccounts using Ctrl+<click> to select each and all of the QIF files that you made. Make sure that you understand and follow this step. The reason for importing all at once is that lets Money figure out transfers. Then click Import.

Money should then ask about an account as the files are processed. Let Money create an account that you will provide the name for. Since you gave the QIF files meaningful names, you should know what to name the account. Since you started the filename for any investment accounts with a '1', I expect them to come in first.  

           ---------------Advanced Topic---------

It is possible produce the QIF files with Money 2005 and to make the new file Money Sunset or Money 2004.  Sunset has some improvements and bug fixes, my favorite of which is multiple versions of backups. Sunset does need the patch, so do that if you ever install Sunset.

It is possible to have both Money 2005 and Sunset coexist on the same computer. I have not done that, but I have some notes on what that would take. Using separate computers would be an easy way. It is the last-installed version that gets the file associations for QIF, OFX, MBF, MNY etc.

[Ameridan (microsoftmoneyoffline.wordpress.com)]

Nice!  I merged into my Reference article https://microsoftmoneyoffline.wordpress.com/merging-money-files/

[Michael Wylde]

@Sussex Pete - my apologies, I didn't re-read and fully take in your post before my comments. My account transfer worked perfectly from my point of view BUT I've never made use of "type" - since it doesn't have categories for investment trust or ETF it doesn't have much relevance for me. When I added a type column to portfolio it displayed rubbish and when I fiddled with it, it totally crashed the program which wouldn't restart. That'll teach me! Fortunately I had a backup. So no, type doesn't work.

(Sussex as it happens) Mike

To view this discussion visit https://groups.google.com/d/msgid/microsoft-money/DB9PR08MB703717222312DBEA74AFA0B785262%40DB9PR08MB7037.eurprd08.prod.outlook.com.

[Pete Newman]

Wow!  Thanks to all of you for the ideas! 

Peter (who wrote to me separately): Nice crazy idea!  Unfortunately both accounts had many transactions before the transfers, but renaming might still be the best starting point as Fidelity had many more years of transactions than AJB.  

Mike: Really good to learn it's not just me! I can stop trying to figure out what I did wrong and work-arounds it will be. I am also on the UK edition and used Transfer Account, apologies for the confusion.  I also tried using Transfer Out (in the Investment Transaction entry form pull-down list) but the resulting transactions are the same.  I've updated my login to my real name, the Sussex bit (Northiam, almost in Kent!) was a hang-over from other Google groups.  

Cal: Big thanks for the detailed procedure, I will look hard at that.  I made life harder for myself years ago by putting Buys and Sells sometimes through associated cash accounts and sometimes bank accounts.   The base idea of renaming the now-closed Fidelity account may be best, then re-enter (or QIF, edit, load, fix) the AJ Bell transactions.  I think the move everything to a new file idea is probably more work as I have 10 investment accounts running, another 10 non-investment and many closed.  But at least it would be methodical and could be a good excuse to clear out the old closed accounts.  I did something similar in 2008 (when I had fewer of everything!) and managed it in order to clear up historical closed accounts.  

I'll get back to a playing in a "Sandpit" copy with these ideas and start digging an escape.  

More anon --Pete

[Pete Newman]

Thanks Ameridan your blog is on my reading list!  Always new things to learn :)  --Pete

[Pete Newman]

ps to Cal - Huge thanks for that one point about recovering all the QIFs at once so Money can handle transfers was new to me and might be the key to escaping my mess!