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
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.
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):
As well as the rounding of services from benefit recording, expense recording and outlays according to the following information.
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.
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.
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 / case | Value |
---|---|
Do not round hourly rates | Yes |
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.
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 .
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:
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.
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:
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.