Advanced Portfolio and basis calculation - errors in calculations or errors in data entry?
jpconstantineau at gmail.com
Thu Mar 26 19:07:42 EDT 2009
Thanks for the input. I did as you indicated and even dug up my tax
statements to figure out my actual dates, costs and income
implications. I updated the transactions to the following (updated
dates and price amounts):
2006-08-03 Purchase Stock XYZ Shares 1700 Price 3.31
2008-01-31 Incentive Stock XYZ Shares 823 Price 3.31
2008-06-19 Options Purch. Stock XYZ Shares 1500 Price 4.62 Buy 6930.00
This now make probably more sense from an accounting perspective.
However, on the report side, I still get pretty odd answers...
Basis:15280.96 (eh??? WTF)
Value: 8046.00 (no surprise)
Money In: 11843.00 (Adds up to all the cash I put in -
Money Out: 0.00 (no surprise - I haven't sold anything yet)
Realized Gain: 3437.96 (eh??? WTF shouln't this be 2724.13 +
765.00 - 51.00 = 3438.13)
Total Gain: (3797.00) (no surprise)
Return: -32.06% (ouch but no surprise)
Brokerage Fees: 51.00 (no surprise)
Where are those few pennies coming from? I tried to find an odd
transaction but that is all the transactions I have in that one file.
Is there something in my entry or is there something else?
On Thu, Mar 26, 2009 at 8:55 AM, Frank H. Ellenberger
<f.ellenberger at online.de> wrote:
> Am Donnerstag 26. März 2009 08:23:10 schrieb Pierre Constantineau:
>>________ 2006-08-03 Purchase Stock XYZ Shares 1700 Price 3.31 Buy
>> 5627.00 Commissions
>> Buy 51.00
>> Sell 5678.00
>>________ 2008-06-20 Add Shares Stock XYZ Shares 823 Price 0 Buy
>>________ 2008-06-21 Purchase Stock XYZ Shares 1500 Price 4.11 Buy
>> 6165.00 Cash
>> Sell 6165.00
>> As far as I know, the above is how I think it should be coded. I only
>> have a commission on one transaction and the 823 shares didn't cost me
>> anything - they were given to me by my employer as a stock purchase
> Also the incentives should have a price. The transaction should be done
> against something like income:wages:incentives instead of cash.
>> I obtain the following information from the Advanced Portfolio report:
>> Shares: 4023
>> Basis : 11792.23
>> Value: 8026 (current price is 2$)
>> Money In 11843
>> Money out 0
>> Realized Gain (50.77)
>> Unrealized Gain (3746.23)
>> Total Gain (3797)
>> Total return -32.06% (ouch!)
>> Brokerage Fees 51
> 0.23 instead of 823[.00]
> some typo?
More information about the gnucash-user