Rounded

A1 proofreading not yet effective for this page. In the meantime, you can ask any questions on the forum.

The question of rounding, particularly in accounting, is a question which sometimes remains without a solution other than conventional.

Gestan presents the rounding of monetary amounts, but stores the entire figures.

For example, an amount of 137.3083333333333 will be displayed as 137.31, if you handle amounts with two decimal places.

It is possible to manage the prices of your product catalog either from an excluding tax base, or from an inclusive tax base, via the general settings.

Often, companies working in BtoB will prefer to use a tax-exclusive basis, while BtoC companies will prefer an tax-inclusive basis.

Let's take a real-life example to understand the difference.

Or a company (hello Mylène ) which sells parts at 6.92 excluding VAT and 4% VAT, therefore 7.20 including VAT.

• In prices excluding tax, we have: 6.92 excluding tax and (6.92*1.04), therefore 7.1968 including tax
• In prices including tax, we have: 7.20 including tax and (7.20/1.04), therefore 6.9230769231 excluding tax

On a sale of 494 pieces, we have:

Depending on your settings:

• if you are in the basis excluding tax (or if you enter in the invoice file, a PU at 6.92 excluding tax), Gestan will record an amount excluding tax of 3418.48 and an amount including tax of 3555.22
• if you are in a tax-inclusive basis (or if you enter in the invoice file, a PU at 7.20 incl. tax), Gestan will record an amount excluding tax of 3420.00 and an amount including tax of 3556.80

It is recommended to always use the same practice, so that your documents are consistent.

For example, a seller who sells bottles at 16.97 with VAT of 5.5%. A good friend places an order for 5 bottles, and he gives her a very friendly discount of 39.30%.

This gives us:

If we round these amounts to two decimal places, we have:

There is therefore a difference of 1 cent since the results are presented with only two decimal places.

In this case, Gestan will force the VAT amount to be the difference between the two amounts, excluding tax and including tax. We will therefore have:

(Thank you @GaëtanGF for this example)

In certain cases, notably non-homogeneous entries, it is possible to notice a rounding discrepancy on a part.

To adjust it, the easiest way is to re-enter the amounts including VAT or excluding VAT as appropriate, directly in the list of items for the part concerned, as below.

Other “Technical” articles