[GNC] Rounding & formulas

Michael or Penny Novack stepbystepfarm at comcast.net
Tue Dec 22 10:22:44 EST 2020


> Thomas
>
> Another perspective on this is that in practice what rounding procedure a
> bank or other external body may apply may depend on any  legislative
> requirements (usually by taxation bodies) and their internal accounting
> policies and these are not under GnuCash's control and may also vary between
> different legal jurisdictions.
>
> It is impossible for GnuCash to know apriori how  a particular amount will
> be rounded and appear in external statements (hopefully someone is not
> skimming off the fractions of  cents from the rounding) against which the
> GnuCash records will ultimately be reconciled, so no matter what rounding
> procedure was used by GnuCash in any internal calculations, it can end up
> being wrong because the bank chooses to or is required to round in a
> different manner.
>
> David Cousens

It can be MUCH worse than that, because the consequences of legislated 
rounding (in filling out filings) may be complicated. Thus for US 
non-profits, if they have to file a 990/990EZ this much not only be 
"whole dollar" but must match the previous year's filing. But rounded 
(A+B) does not necessarily equal rounded A + rounded B. In  other words, 
there is no way to do this by "formula" as will require human decision 
as to what "fudging" will result in minimal distortion << for example, 
if use truncate instead of rounding for THIS amount and round up on THAT 
one all will work out >>

So some years don't have to fudge any amounts, other years just one or 
two, still other years nasty and have to do many.

Same with banks. Some may use one method of rounding, others another. 
And sorry, but although many currencies integral to a specific decimal 
point they may sometimes use more << like the "mil" seen in tax rates. 
water rates, etc. >>

Michael D Novack




More information about the gnucash-user mailing list