|
#1
| |||
| |||
| This would be very easy if entered manually. I know that may not help. "Keefer" <Keefer[at]discussions.microsoft.com> wrote in message news:49336442-B2AD-4642-A94A-BE94E4D55776[at]microsoft.com... - quote - > I did not get a reply to my post yet so thought I would post my procedures > to > those of interest. I got a response from Microsoft that this is generally > the only way to split out a combined investment account. > ... > Whew! What a process. Makes me tired just writing down what I had to go > though...... |
| | |||
| |||
| I did not get a reply to my post yet so thought I would post my procedures to those of interest. I got a response from Microsoft that this is generally the only way to split out a combined investment account. Backgound: TR Price uses a separate account number for each mutual fund owned so that when Money 2005 downloads transactions it does so for each account number separately (and actually creates the new accounts in Money). I had all my TR Price funds in a single combined account. The only solution I came up with to get this combined account into separate accounts (about seven accounts)is as follows: 1) Set up each of the new separate accounts. 2) For each investment transactions in the old combined account I copied the transaction to the appropriate new account. This created a duplicate investment cash transaction in the old combined investment cash account since that copy was still looking to the old combined account for the offset cash account. 3) Edited each duplicate cash transaction in the combined account to change the account to the new sparate account. 4) Then for cash transfers out of the old combined investment cash account to a nonrelated checking account, I needed to copy each tranfer out from the combined account to each of the new accounts effected by this transfer. 5) Then I went into each of the new investment cash accounts and edited the amounts so that it they would agree with the amount edited into it from the old combined accounts. (With five years of transations involving the seven mutual funds it was very tedious and required balancing back to my statements from TR Price to ensure that I had not missed a transaction.) 6) When I was satisfied I had got all transactions in the appropriate account I then deleted the old combined account. 7) Lastly, I now had duplicate transactions in my checking accounts to which the funds were originally transfered to from the old combined investment cash account. I identified these by looking at all transactions categorized in the Transfer to (from) deleted accounts using the Money category lookup. I deleted these duplicates in the checking account and verified that my non-related checking accounts were in balance. Hint, watch for splits in the checking account deposit transaction and only delete the transactions within the split that came from the deleted combined account. Whew! What a process. Makes me tired just writing down what I had to go though...... "Keefer" wrote: - quote - > In Money 2005 Deluxe, I have an investment account (with related cash > account) with about two years of transactions. This mutual fund account (TRP) > uses a separate account number for each mutual fund holding so that when I > upgraded to Money 2005 and set up on line services for this account it > downloaded each mutual fund investment as a new account. I can't merge all > of these duplicate accounts in Money as it only allows you to merge one time > so I then transfered (using copy) all my investment transaction from the > combined existing account to each of the new individual investment accounts. > I then deleted all transactions in the old combined investment account. Now > I have a combined old cash account that I need to copy to the new investment > cash accounts but I don't know what impact this will have on my other > accounts. > Is there a good safe way to get the combined accounts (both investment and > related cash account) into the new separate accounts without messing up data > in all my other accounts? |
|
#-1
| |||
| |||
| In Money 2005 Deluxe, I have an investment account (with related cash account) with about two years of transactions. This mutual fund account (TRP) uses a separate account number for each mutual fund holding so that when I upgraded to Money 2005 and set up on line services for this account it downloaded each mutual fund investment as a new account. I can't merge all of these duplicate accounts in Money as it only allows you to merge one time so I then transfered (using copy) all my investment transaction from the combined existing account to each of the new individual investment accounts. I then deleted all transactions in the old combined investment account. Now I have a combined old cash account that I need to copy to the new investment cash accounts but I don't know what impact this will have on my other accounts. Is there a good safe way to get the combined accounts (both investment and related cash account) into the new separate accounts without messing up data in all my other accounts? |
| Tags |
| accounts, combined, investment, multiple, transactions, transfer |
Similar Threads | ||||
| Thread | Forum | Replies | Last Post | |
| How Can I Transfer Transactions Between Accounts? : I use Money 2004 Deluxe. Several months ago, in the installation process, two a brokerage accounts with the same number were established, one of... | Microsoft Money | 5 | 10-05-2004 01:02 PM | |
| Transfer transactions between accounts Jae: Can I trasfer a bunch of transactions between accounts? Because I want to split the transactions in one bank account into two business entities for... | Microsoft Money | 1 | 02-26-2004 08:29 AM | |
| multiple accounts Brandon: Hi, I have more than one account at Ameritrade, and would like to use online/direct services with Money 2004. I have successfully got one account... | Microsoft Money | 1 | 01-20-2004 11:23 PM | |
| Exporting *Multiple* Investment Accounts in M2003 to comma or tab delineated William L. Oppenheim, M.D.: Want to create comma delineated or QIF exoports. Is there anyway to accomplish this easily for multiple investment accounts. Export only does... | Microsoft Money | 2 | 10-05-2003 12:21 AM | |
| Multiple accounts Glenn: I have just installed Money 2003. Does anyone know how to set up multiple member accounts from one bank? My bank puts multiple type of accounts,... | Microsoft Money | 2 | 07-10-2003 04:48 PM | |
| Thread Tools | |
| Display Modes | |
| |