Rounding in Vertec

How to round values in Vertec

Product line

Standard

|

Expert

Operating mode

CLOUD ABO

|

ON-PREMISES

Modules

Services & CRM

Budget & Phases

Purchases

Resource Planning

Business Intelligence

Created: 24.04.2009
Updated: 12.07.2024 | Updated screenshots of system settings.

Values in Vertec are rounded according to the system settings listed below.

There may be deviations in rounding: If the individual numbers are first rounded and then added up, the result is a different amount than if the individual numbers are added unrounded and then the final amount is rounded up. How the different deviations can occur is explained in the article Rounding differences explained.

The following system settings are available for the different rounding rules:

System setting project / case Significance
use rounding rules If you want to use commercial rounding rule instead of mathematical rounding, set this system setting to YES.
Do not round hourly rates Allows rates to be specified for services up to 4 decimal places (in the rate table and all other fields for hourly rates).
Expenses round up expenses and outlays This system setting allows you to specify whether or not to round the amounts (and VAT) on individual expenses and outlays.

How they have an effect is explained below by means of examples.

use rounding rules

The commercial rounding rule with the special case of rounding to 5 cents for monetary amounts has a high degree of distortion and the sum of the rounded individual values is higher than most mathematical rounding rules (see article on Wikipedia). Vertec therefore uses the undistorted or mathematical rounding (round-to-even rule) because it has the least mathematical distortion (see article on Wikipedia).

If you want to use commercial rounding rule instead of the mathematical rounding, set the system settings use rounding rules to YES.

System setting project / case Value
use rounding rules Yes

The mathematical rounding according to the round-to-even method rounds so that for example .425 is rounded to .42 but .435 is rounded up to .44. The commercial rounding or round-to-nearest always rounds up the 5, i.e. .425 -> .43 and .435 -> .44.

The setting is applied to the following monetary amounts (for display-only rounding or for time-specific rounding, mathematical rounding is always used):

  • All monetary amounts at the time of invoicing and invoice totals.
  • All monetary amounts on downpayments and invoiceAdvanceLink.
  • ValueProcessor and Value Cost on the service.
  • Calculation of salary and overhead in the operator specifications.

As well as the rounding of services from benefit recording, expense recording and outlays according to the following information.

Round hourly rates (Vertec default settings)

System setting project / case Value
Do not round hourly rates No.
use rounding rules No.

1.50 hours of 118.75 = 178.125

These 178.125 are rounded to 178.10 in Vertec. The sum of several such values results in differences:

2x 178.125 = 356.25 but 2x178.10 = 356.20

This can be seen especially in the case of service lists for invoices: for example, rounding up to the individual services results in deviations; the sum then no longer corresponds to the value when the individual items are added together.

In this example, there are nice amounts of fees, but the sum is no longer equal to the total: 6 hours of 118.75 equals 712.50, not 712.40 as shown. 8% VAT on this amount equals 56,992, whereas on the original amount it would equate to exactly 57.

According to commercial rounding rules

System setting project / case Value
Do not round hourly rates No.
use rounding rules Yes

Here in the example you can see that the amount of the fee is not rounded to 178.10 as above, but rounded up to 178.15. The sum is then 712.60 (instead of 712.50 as calculated directly). The VAT (8%) is then 57.008, i.e. 57.01.

Do not round hourly rates

The system settings Do not round hourly rates (when used as gross rates) allows the specification of rates with up to 4 decimal places (in the rate table and all other fields for hourly rates) and prevents the rounding of the value amounts (if, for example, you still see only two decimal places in the performance list, then set the renderer to dbmTim.Ansatzrenderer in the list settings).

System setting project / caseValue
Do not round hourly ratesYes

In this example, the fee amounts are not rounded. The sum does not match (4 x 178.12 = 712.48), but the total is correct and therefore the VAT (8%) is calculated correctly.

Expenses round up expenses and outlays

For expenses and outlays, you can specify whether or not the amounts (and VAT) should be rounded to the individual expenses and outlays. This is done using the system settings     Expenses round up expenses and outlays .

Option Enabled

Is this option on Ja , then Vertec rounds up based on the settings in the currency . If the system setting Use use commercial rounding rules to Ja , then these are applied. This means:

  • If the rounding step on the currency is set to 0.01 (default in Germany and Austria), this feature has NO INFLUENCE on the rounding behavior.

The amounts here look good, but there are minimal deviations in the penny or cent range for almost all entries. Therefore, the total is not quite correct: 7.7% VAT from 1761.55 = 132.17.

Option disabled

Is this option on Nein , then Vertec rounds to two decimal places. The system setting using commercial rounding rules is NOT taken into account, the rounding to two decimal places is done by mathematical rounding (round-to-even). This means:

  • If the rounding step on the currency is set to 0.01 (default in Germany and Austria), the system setting using commercial rounding rules is disabled.

Here, the amounts are correct, but are shown exactly on the pennies or cents. The total thus amounts to 1716.35, the 7.7% VAT to 132.17. If these amounts are rounded up afterwards, for example on the invoice, then the total on the list no longer corresponds to the final amount.

Bitte wählen Sie Ihren Standort