[GNC] Additional check for out of balance 'Trial Balance' and 'Balance Sheet'
Michael or Penny Novack
stepbystepfarm at comcast.net
Sun Mar 19 21:56:45 EDT 2023
> Further investigation found that in the 'Edit Account' panel, the 'Smallest
> fraction' was set at '1' on this particular account, and the amount was
> being rounded up on one side, causing the mismatch. Setting the 'Smallest
> fraction' to 'Use Commodity Value' and running 'Repair All' sorted the
> problem.
>
> I hope the above may be a solution for someone and save them time, if not
> hair.
It bears repeating, as soon as rounding is involved, exactly in balance
goes out the window. It is simply a reality of mathematics that rounded
A + rounded B is not necessarily equal to rounded (A + B). Your problem
could exist even if both sides were rounded/
LOL -- in my working days, one of the things I did a number of times was
calculate the value of the "fuzz" (the maximum discrepancy between
calculations done in different order as a result of limits in
precision/rounding --- so the computer program would consider the two
equal if the difference were less than "fuzz"). And those of us doing
calculations in science/engineering know that the order in which we do
them can have a great effect on the possible "error" << so we choose the
order of calculations that minimizes that >>
In its original form. double entry bookkeeping could demand exact
balance because the only operation was addition/subtraction and no
rounding involved.
Michael D Novack
More information about the gnucash-user
mailing list