|
Stock basis calculation software (nightmare...)
03-20-2009, 05:59 AM
|
#1
|
Full time employment: Posting here.
Join Date: Dec 2004
Posts: 699
|
Stock basis calculation software (nightmare...)
I'm helping a person who has a nightmare of back tax filings, poor documentation, and tons of trades.
Question: is there any software you've found helpful for stock basis, gain/loss calculations ?
Looking for something where I can post all the transactions and hopefully the software "make sense of it".
I know value of CPA and I will be getting end product reviewed by one - but this person is broke and we gotta "DIY" most of this.
Thanks !
|
|
|
|
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!
Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that Early-Retirement.org is a great community to join. Best of all it's totally FREE!
You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!
|
03-20-2009, 06:36 AM
|
#2
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jun 2005
Posts: 10,252
|
Certainly MS Money can do this. You enter all the transactions and create reports. You can download a free trial to use. Intuit Quicken does the same. You can also create an Excel spreadsheet to help.
Also even with TurboTax you have to enter the trades and it will calculate gains/losses.
I use MSMoney and some Excel for special situations (buyouts, company splitting into 2 or 3 companies with new stock ticker symbols).
Unfortunately, unless you stay on top of it, you sometimes can't remember what you did. For example, I give away stock to charity. Years later, I need to remember/find/document which lot I gave away, so I have to go find my 'letter of instruction" or look at my old tax returns. Nevertheless, it's just busy work if you have a record of all your transactions which are usually found in the annual-statements.
|
|
|
03-20-2009, 07:35 AM
|
#3
|
Full time employment: Posting here.
Join Date: Dec 2004
Posts: 699
|
Quote:
Originally Posted by LOL!
Certainly MS Money can do this. You enter all the transactions and create reports. You can download a free trial to use. Intuit Quicken does the same. You can also create an Excel spreadsheet to help.
Also even with TurboTax you have to enter the trades and it will calculate gains/losses.
I use MSMoney and some Excel for special situations (buyouts, company splitting into 2 or 3 companies with new stock ticker symbols).
|
Thanks for post - I have Turbotax and Quicken.
Will these softwares handle the "specific shares sold" decisions ? There's hundreds of trades. There's a bunch of "buy 100, sell 25 later, then buy 150 more, then sell 80, etc" trades in same stock.
I don't understand rules around "average costing", specific share, LIFO, FIFO ,etc.
Thanks !
|
|
|
03-20-2009, 08:55 AM
|
#4
|
Recycles dryer sheets
Join Date: Dec 2006
Posts: 191
|
I realize I am probably not helping at all, but it is important to know... Has this person previously sold any of this stock/MF?
If so, he/she is already locked in whatever cost-basis mechanism they used at that time. You will not be able to switch between ways of computing cost basis unless you get specific permission by IRS.
|
|
|
03-20-2009, 11:51 AM
|
#6
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jun 2005
Posts: 10,252
|
Quote:
Originally Posted by Delawaredave5
Thanks for post - I have Turbotax and Quicken.
Will these softwares handle the "specific shares sold" decisions ? There's hundreds of trades. There's a bunch of "buy 100, sell 25 later, then buy 150 more, then sell 80, etc" trades in same stock.
I don't understand rules around "average costing", specific share, LIFO, FIFO ,etc.
Thanks !
|
Yes, they will handle specific shares sold ... but that decision had to be made when sold and documented at that time. For stocks, the rule is FIFO unless you use specific share identification which some online trading platforms do not support. "Average cost" is a mutual fund thing and I would not use it myself (I would use FIFO), but some folks like it because their mutual fund company will tell them the average cost, but there is no way to really know if the fund company did the calculation correctly.
So I think I've just simplified everything for you because with stocks there is no LIFO and no average cost basis. You have only FIFO or specific lot identification. And if the records are a mess, there was probably no specific lot identification going on (other than wishful thinking). That leaves you with FIFO. Simple.
|
|
|
03-20-2009, 07:29 PM
|
#7
|
Recycles dryer sheets
Join Date: Feb 2006
Posts: 146
|
I had to purchase some software for 2008 taxes and ended up picking this one. It's pretty good.
Portfolio Management Software - Fund Manager
__________________
The inherent vice of capitalism is the unequal sharing of blessings; the inherent virtue of socialism is the equal sharing of misery.
Winston Churchill
|
|
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
Thread Tools |
|
Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
» Recent Threads
|
|
|
|
|
|
|
|
|
|
|
|
|
» Quick Links
|
|
|