[GNC] Stock transaction: how to record "buy amount" being more or less than product of "shares * price"?
G.W.
grgwmsm at protonmail.com
Wed Mar 12 10:25:07 EDT 2025
Can you advise if I have a setting error?
For example,
I sell -0.005 shares at $115 for $0.58 and this keeps resulting in price $116 with sell amount of $0.58 (actual is price $115 and sell amount precisely come to $0.575). Why isn't gnucash keeping the price of $115 and just rounding up the amount of $0.575?
In the Security Editor I have set Fraction Traded 1/1000
In the account editor I have "Smallest Fraction" set to 1/1000
Is there some setting I'm missing? Why can't gnucash get the example above correct?
On Wednesday, March 12th, 2025 at 10:11 AM, Murugan Mariappan <m.muruganandam at hotmail.com> wrote:
> If you are particular about the price to be the same then you can do split of the .04 and pass it to a "rounding off" expenses account
>
> Saludos Cordiales
>
> Murugan
>
> ---------------------------------------------------------------
>
> From: G.W. <grgwmsm at protonmail.com>
> Sent: 12 March 2025 10:14
> To: Murugan Mariappan <m.muruganandam at hotmail.com>
> Cc: gnucash-user at gnucash.org <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Stock transaction: how to record "buy amount" being more or less than product of "shares * price"?
>
> So there's no way to have the price reflect accurately in the price column for this scenario? (I already have set 1/1000).
>
> On Wednesday, March 12th, 2025 at 8:56 AM, Murugan Mariappan <m.muruganandam at hotmail.com> wrote:
>
>> Check the fraction traded field in your security and adjust it to 1/1000. Ensure your account uses the commodity value under the smallest fraction field. Enter the debit value as $1.04; the system will calculate the price as $130 due to rounding. Your bank should update correctly with the $1.04.
>>
>> Saludos Cordiales
>>
>> Murugan
>>
>> ---------------------------------------------------------------
>>
>> From: gnucash-user <gnucash-user-bounces+m.muruganandam=hotmail.com at gnucash.org> on behalf of G.W. via gnucash-user <gnucash-user at gnucash.org>
>> Sent: 12 March 2025 08:50
>> To: gnucash-user at gnucash.org <gnucash-user at gnucash.org>
>> Subject: [GNC] Stock transaction: how to record "buy amount" being more or less than product of "shares * price"?
>>
>> My investment firm (Fidelity) allows the buying of fractional shares. I purchased some shares of stock with the following details:
>>
>> Purchase-1: shares: 0.008 | price per share: $124.42 | total amount I paid to get the 0.008 shares = $1.04
>>
>> Purchase-2: shares: 10 shares | price per share: $111.25 | total amount I paid to get the 10 shares = $1,112.45
>>
>> As you can compute by doing the math, the total amount paid does NOT equal shares*price. Purchase-1 should have only costed $1 and Purchase-2 should have costed $1,112.50.
>>
>> How do I account for this in Gnucash because it will not let me input the actual money I spent on the shares. Is there a way to override Gnucash's automatic calculation?
>>
>> (I phoned Fidelity and they explained this discrepancy is normal, a result of fractional share buys).
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> [https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7C%7Cd60dad1a0e5c4024200a08dd615c406f%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638773771054183031%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=KEw%2F7g2TZ3eT6rmCYLNRh1DpL1uCX7MyNBbHkoyXXM0%3D&reserved=0](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.
More information about the gnucash-user
mailing list