Transaction Report Calculation Error?

Derek Atkins derek at ihtfp.com
Mon Apr 7 15:08:29 EDT 2014


Hi,

On Mon, April 7, 2014 2:47 pm, Richard Lindgren wrote:
> Derek
>
> I looked in the options and I do not see an option for choosing the quote
> source.
>
> Please direct me to the place for choosing the quote source.

Strange.  neither do I.

So, how about this -- let's go into the PriceDB and see if you have any
entries for your stock?  In particular, is there an entry for $36.2740?

> Thanks.
>
> Richard

-derek

>
> On Mon, Apr 7, 2014 at 2:42 PM, Derek Atkins <derek at ihtfp.com> wrote:
>
>> Hi,
>>
>> On Mon, April 7, 2014 2:22 pm, Richard Lindgren wrote:
>> > Derek
>> >
>> > I generated the report from:
>> > -Reports
>> > -Transaction Report
>> > - ( I chose the account to Report from my Asset Account )
>> > -Asset
>> > -Investment
>> > -The account SMVAX
>> >
>> > To further illustrate the transaction, I ignored the commission, and
>> that
>> > transaction is shown below:
>> >
>> > [image: Inline image 1]
>> >
>> > The amount of shares shown is correct and the money spent is correct.
>> > However, I apparently chose the wrong Transaction report???
>>
>> Well, there are two.  There's the "Transaction Report" and the "Account
>> Transaction Report".
>>
>> > That Transaction Report for the above transaction is shown below:
>> >
>> > [image: Inline image 2]
>> >
>> > What am I doing wrong?
>>
>> Check your report options -- what do you have set for your Quote Source?
>> My guess is that the report is pulling in a PriceDB entry and ignoring
>> your actual entry.  That's the only way I can think to explain the
>> 143.25.
>>
>> > I appreciate your help here.
>> >
>> > Thanks again.
>> >
>> > Richard
>>
>> -derek
>>
>> >
>> > On Mon, Apr 7, 2014 at 1:55 PM, Derek Atkins <derek at ihtfp.com> wrote:
>> >
>> >> Hi,
>> >>
>> >> On Mon, April 7, 2014 1:30 pm, Richard Lindgren wrote:
>> >> > Derek
>> >> >
>> >> > That's why I was asking if I have made an error in my entering the
>> >> stock
>> >> > purchase. I invested $150.00 total. $7.50 went toward the
>> commission
>> >> and
>> >> > $142.5 went toward the actual stock purchase.
>> >>
>> >> If you spent $150 on stock, and $7.50 went to commissions, then you
>> did
>> >> not get 3.9596 shares at $37.9171.  So yes, you have your data
>> entered
>> >> incorrectly.
>> >>
>> >> So...  how much money left your Bank account?
>> >> How much of that went to commissions?
>> >> The *rest* is your actual purchase..  Do you know how many shares you
>> >> got?
>> >>
>> >> > When I request a Transaction report showing no commission with the
>> >> total
>> >> > of
>> >> > $150.00 for the stock purchase, it is still incorrect.
>> >> >
>> >> > [image: Inline image 1]
>> >>
>> >> What report are you using to actually compute this?  You say
>> >> "transaction
>> >> report" but I don't understand how you are creating a transaction
>> report
>> >> but showing no commissions?  Exactly which report is it?
>> >>
>> >> It is possibel that the report is not showing the actual transaction
>> but
>> >> is, instead, applying a price quote from your PriceDB.  But that
>> would
>> >> depend on what report you're actually running.  I cannot tell from
>> your
>> >> picture.
>> >>
>> >> > Again, Maybe I'm doing something wrong, but I don't know what it
>> might
>> >> be.
>> >> >
>> >> > [image: Inline image 2]
>> >> >
>> >> > The above is the Transaction I show without any commission.
>> >> >
>> >> > Any help here will certainly be appreciated.
>> >> >
>> >> > Thank you in advance for your help.
>> >> >
>> >> > Richard
>> >>
>> >> I think your transaction input is incorrect.
>> >>
>> >> -derek
>> >>
>> >> >
>> >> > On Mon, Apr 7, 2014 at 12:54 PM, Derek Atkins <warlord at mit.edu>
>> wrote:
>> >> >
>> >> >> hi,
>> >> >>
>> >> >> Richard Lindgren <rlindgren74 at gmail.com> writes:
>> >> >>
>> >> >> > Here is copy of my actual transaction. Maybe I am in error?
>> >> >> >
>> >> >> > Inline image 1
>> >> >> >
>> >> >> > Thank you in advance for your help.
>> >> >>
>> >> >> The report and the transaction are different.  There appears to be
>> a
>> >> $1
>> >> >> split in the report that I don't see in the transaction.  I don't
>> >> know
>> >> >> where that is coming from?
>> >> >>
>> >> >> > Richard
>> >> >>
>> >> >> -derek
>> >> >>
>> >> >> --
>> >> >>        Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>> >> >>        Member, MIT Student Information Processing Board  (SIPB)
>> >> >>        URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
>> >> >>        warlord at MIT.EDU                        PGP key available
>> >> >>
>> >> >
>> >>
>> >>
>> >> --
>> >>        Derek Atkins                 617-623-3745
>> >>        derek at ihtfp.com             www.ihtfp.com
>> >>        Computer and Internet Security Consultant
>> >>
>> >>
>> >
>>
>>
>> --
>>        Derek Atkins                 617-623-3745
>>        derek at ihtfp.com             www.ihtfp.com
>>        Computer and Internet Security Consultant
>>
>>
>


-- 
       Derek Atkins                 617-623-3745
       derek at ihtfp.com             www.ihtfp.com
       Computer and Internet Security Consultant



More information about the gnucash-user mailing list