Transaction Report Calculation Error?

Richard Lindgren rlindgren74 at gmail.com
Mon Apr 7 15:22:49 EDT 2014


Derek

I went to tools and Price editor and could only find 36.21 as the closet
price for that date as well as the number itself.

Richard




On Mon, Apr 7, 2014 at 3:08 PM, Derek Atkins <derek at ihtfp.com> wrote:

> 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