Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #1  
Old 11-13-2004, 11:07 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Transfer combined investment transactions to multiple new accounts

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......



 
Old 11-13-2004, 10:31 PM
Keefer
Guest
 
Posts: n/a
Default RE: Transfer combined investment transactions to multiple new accounts

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  
Old 11-09-2004, 01:09 AM
Keefer
Guest
 
Posts: n/a
Default Transfer combined investment transactions to multiple new accounts

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 09:23 PM.