Transaction Report Calculation Error?

Derek Atkins derek at ihtfp.com
Mon Apr 7 14:42:54 EDT 2014


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



More information about the gnucash-user mailing list