need a stock report for 1 fiscal year

[Les]

On 09/23/2012 09:25 PM, David Carlson wrote:
> On 9/23/2012 9:56 AM, Anna's unattended mail wrote:
>> How are people generating stock reports for tax purposes?  This is
>> potentially quite tricky, and gnucash does not appear to have an
>> obvious way to do this.  In fact, I looks like gnucash does not handle
>> the simple cases either.
>>
>> Suppose a stock has a history like this:
>>
>>   May 2005 buy  100 AAPL
>>   Aug 2005 buy   50 AAPL
>>   Feb 2006 sell  80 AAPL
>>   Mar 2006 sell  70 AAPL
>>   Nov 2010 buy   40 AAPL
>>   Nov 2010 buy   20 AAPL
>>   Jun 2011 sell  60 AAPL
>>
>> If I need a report for fiscal year 2011, the tool must see that there
>> was a sale in 2011, and then go back in history to find the relevant
>> buys.  It must be smart enough to neglect the first 4 transactions
>> because the balance goes back to zero in 2006.  In this case, the tool
>> should at least be good enough to realize that there is no choice
>> about which buys to associate with the sale.  And in cases where there
>> is a choice, the user should be able to designate whether to minimize
>> or maximize the declared profit.
>>
>> In the end, I expect to get a report that looks like this:
>>
>>   Nov 2010 buy   40 AAPL
>>   Nov 2010 buy   20 AAPL
>>   Jun 2011 sell  60 AAPL
>>
>> Of course, with the prices included.
>>
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
> In theory, GnuCash does have a lot tracking capability, but I personally
> have not tested it yet.  In my case I have other complications such as
> transfers from one brokerage firm to another to complicate matters.  If
> your real life is not too much more complicated than your example, it is
> probably easiest to just build a spreadsheet.
>
> However, according to this excerpt from the Wiki FAQ
>
>
>       *Q: How do I keep track of capital gains with stocks?*
>
> you can do the following:
>
> *Version 2.x* According to the thread
> https://lists.gnucash.org/pipermail/gnucash-user/2008-March/024501.html,
> it is possible to calculate capital gains on a lot basis in 2.x by
> following these steps:
>
>  1. Open the stock account's register.
>  2. Enter the sell transaction, with no splits for capital gains.
>  3. Select Actions->View Lots
>  4. Click Scrub Account.
>
> See these mailing list messages (and other messages in these threads)
> for further reference:
> https://lists.gnucash.org/pipermail/gnucash-user/2006-January/015605.html
> https://lists.gnucash.org/pipermail/gnucash-user/2006-January/015620.html
> https://lists.gnucash.org/pipermail/gnucash-user/2006-January/015396.html
> https://lists.gnucash.org/pipermail/gnucash-user/2005-July/014192.html
> https://lists.gnucash.org/pipermail/gnucash-user/2005-February/012863.html
> https://lists.gnucash.org/pipermail/gnucash-user/2005-January/012648.html
>
> David C
>
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
To keep it simple, I just use the reports generated by my broker.  I
have a choice of fifo, lifo or average cost for tax purposes.