Cost Basis on Portfolio

[Dat Data]

Copying the list

From: dat30 at hotmail.com
To: david.carlson.417 at gmail.com
Subject: RE: Cost Basis on Portfolio
Date: Wed, 18 Sep 2013 08:30:30 -0700




Hi David,

I followed that steps and yet the Cost Basis for FIFO isn't correct. Here is what I see.
































 
 
 
  Bought
  50.00
   $18.00 
  

  

   $900.00 
  

  

  

  

 
 
  Bought
  50.00
   $17.00 
  

  

   $850.00 
  

  

  

  

 
 
  Sold
  50.00
   $16.00 
  

  

    
  $800.00
  

  

  

 
 
  

  Shares
  Price
  Basis
  Value
  Money In
  Money Out
  Realized Gain
  Unrealized Gain
   Total Gain 
 
 
   FIFO 
   $50.00 
   $12.00 
   $50.00 
   $600.00 
   $1,750.00 
   $800.00 
   $(900.00)
   $550.00 
   $(350.00)
 
 
   Average  
   $50.00 
   $12.00 
   $875.00 
   $600.00 
   $1,750.00 
   $800.00 
   $75.00 
   $(275.00)
   $(200.00)
 














Thx,
Dat


> Date: Mon, 16 Sep 2013 18:38:20 -0500
> From: david.carlson.417 at gmail.com
> To: gnucash-user at gnucash.org
> Subject: Re: Cost Basis on Portfolio
> 
> On 9/16/2013 5:27 PM, dat30 dat30 wrote:
> > Hi,
> >
> > I have looked around the forum and played with GnuCash but I'm unable to make this work. So I thought I'd send an email.
> >
> > Bought 50 shares of ABC on 1/1/2013 for 18
> > Bought 50 shares of ABC on 2/2/2013 for 17
> > Sold 50 shares of ABC on 3/3/2013 for 16.
> >
> > A) The portfolio uses average cost basis by default. I changed that to FIFO, but it doesn't work correctly either.
> >
> > B) I thought, may be the I didn't specify the lot when I entered the Sell order. So, I did a Scrub Lot to identify which lot of 50 shares that I want to sell (the first one). That didn't help either.
> >
> > Finally on a separate note, there have been some funds sold as FIFO and some as average price. How do I reflect that on the basis?
> >
> > Thanks.
> > Dat
> >
> >
> >
> >  		 	   		  
> > _______________________________________________
> > 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.
> >
> Chapter 8 of the Tutorial covers the mechanics of entering sale
> transactions.  The gains or losses do not get automatically calculated
> and entered.  They must be calculated and entered manually.  This has
> been discussed frequently in the user maillist. 
> Your stockbroker should be able to give you the information that you
> need for your tax return.
>  You will find that the numbers will not exactly match what GnuCash does
> unless you also track commissions and expenses separately in a way that
> allows tracking the expenses by lots, which is not well documented in
> the manual.  I personally use a spreadsheet for that part, other users
> have their own favorite methods.
> 
> 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.