Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
 
Old 03-20-2007, 03:50 PM
W'
Guest
 
Posts: n/a
Default RE: Creating a report that tracks stock's life cycle (buy, transfer, s

Be very careful using Money to track your capital gains. I have lost quite a
bit of money doing so (too late to fix; but irksome nevertheless). Money
tends to report incorrect basis and purchase dates when transferring between
accounts. This is especially bad for mutual funds, where accounting for the
little itsy bitsy reinvestments drive you up the wall in time.

If you are trading a lot, use a different program. If you are 'investing'
use Excel.

Sorry to be so negative, but MS seems incapable of fixing the issues and the
mountain of overlapping bandaids isn't very helpful. (I've used Money since
the mid 90's, having switched from Quicken for numerous reasons, all of which
seem to still hold.)

"David Pelton" wrote:

- quote -

> Greetings and Salutations
> I purchase ABC stock, and it is held by my broker "Those Brothers". I
> purchase more ABC stock at different times. These transactions are recorded
> in Money.
> I move my investments from "Those Brothers" to the "Quiet Company" and I
> purchase more ABC stock at various times. The Transfer Out and the additional
> Buys are all recorded in Money.
> I decide to sell a lot of ABC stock (spanning multple purchases and multiple
> investment firms) and use the FIFO method. Somehow Money knows which shares
> it is selling, I would like to get a report that shows which stocks it
> removed.
> I envision a report that says something like:
> 10 shares ABC Stock
> bought on 1/1/2000
> purchase price $1
> split on 1/1/2001
> transferred to "The Quiet Company" on 1/1/2002
> sold on 6/1/2006
> sell price $4
> 10 shares ABC Stock
> bought on 12/1/2001
> purchase price $1.50
> transferred to "The Quiet Company" on 1/1/2002
> sold on 6/1/2006
> sell price $4
> 10 shares ABC Stock
> bought on 1/1/2005
> purchase price $3
> sold on 6/1/2006
> sell price $4
> Is this possible? Or even something that helps me trace the stock back to
> its original location?
> Thanks
> David

  #-1  
Old 03-19-2007, 08:28 PM
David Pelton
Guest
 
Posts: n/a
Default Creating a report that tracks stock's life cycle (buy, transfer, s

Greetings and Salutations

I purchase ABC stock, and it is held by my broker "Those Brothers". I
purchase more ABC stock at different times. These transactions are recorded
in Money.

I move my investments from "Those Brothers" to the "Quiet Company" and I
purchase more ABC stock at various times. The Transfer Out and the additional
Buys are all recorded in Money.

I decide to sell a lot of ABC stock (spanning multple purchases and multiple
investment firms) and use the FIFO method. Somehow Money knows which shares
it is selling, I would like to get a report that shows which stocks it
removed.

I envision a report that says something like:

10 shares ABC Stock
bought on 1/1/2000
purchase price $1
split on 1/1/2001
transferred to "The Quiet Company" on 1/1/2002
sold on 6/1/2006
sell price $4

10 shares ABC Stock
bought on 12/1/2001
purchase price $1.50
transferred to "The Quiet Company" on 1/1/2002
sold on 6/1/2006
sell price $4

10 shares ABC Stock
bought on 1/1/2005
purchase price $3
sold on 6/1/2006
sell price $4

Is this possible? Or even something that helps me trace the stock back to
its original location?

Thanks

David
 

Tags
buy, creating, cycle, life, report, stock, tracks, transfer
Similar Threads
Thread Forum Replies Last Post
creating a report that looks like cash flow forecast (2007
owen: I like the cash flow forecast graph that show the individual accounts and their projected totals as well as the area chart for en tire net worth. ...
Microsoft Money 1 09-06-2006 01:52 PM
Creating customized report
sauce04: I am having a little trouble creating a customized report. I have Money Small Business 2006. I've gotten the reports to show slightly what I want...
Microsoft Money 1 09-15-2005 05:02 PM
Transfers between accounts Money tracks & Budget ???
RLM: I am trying out Money and would like to buy it except for one little thing... I am keeping track of two checking accounts, a savings account, and...
Microsoft Money 1 05-12-2004 02:20 AM
Help balancing SAVINGS account on 3 month cycle?
BoDEAN: My bank sometimes sends me a bank statement for my checking account, and the statement cycle is 92 days. How do i go about balancing this if they...
Microsoft Money 1 01-15-2004 01:18 AM



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:29 PM.