[GNC] Stock transaction: how to record "buy amount" being more or less than product of "shares * price"?

[R Losey]

It's not a setting thing.

The lowest amount of US currency is the cent... $0.01 - while there may be
times when an artificial price records fractions of cents, any "real"
transaction cannot be lower than a cent... for example, we don't see
groceries for sale at 59.3 cents for <something>.

When you sold your shares, it was a "real" transaction, and Fidelity
rounded the 57.5 cents to 58 cents. Yes, this causes the calculated price
to be off, but it is important that the number of shares is correct, and
the transaction vanlue is correct, so the price gets adjusted.


On Wed, Mar 12, 2025 at 9:25 AM G.W. via gnucash-user <
gnucash-user at gnucash.org> wrote:

> 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.
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>


-- 
_________________________________
Richard Losey
rlosey at gmail.com
Micah 6:8