need a stock report for 1 fiscal year

[David T.]

There are known troubles with using the scrub lots option--specifically, Gnucash doesn't always handle fees and commissions correctly, resulting in erroneous figures being generated as capital gains. 

However, the technique of tracking capital gains and losses is valid, and generates accurate results, even if it is not the clearest. I believe the Tutorial covers this...

David




________________________________
 From: David Carlson <carlson.dl at sbcglobal.net>
To: gnucash-user at gnucash.org 
Sent: Sunday, September 23, 2012 7:25 PM
Subject: Re: need a stock report for 1 fiscal year
 
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.