Tax-inclusive invoice rounding reconciliation · Calculation guide

Compare tax rounded on each gross line with tax rounded after aggregation.

Calculation guide

Round half up to the entered minor-unit precision. One tax rate across all lines; compare two arithmetic conventions, not invoice compliance.

raw included tax = gross × rate / (100 + rate); compare Σ round(raw line) with round(Σ raw line)

Inputs

Included tax rate

Example entry 20 %. Allowed range 0 to 100.

Rounding decimal places

Example entry 2. Allowed range 0.0 to 4.0. Use whole numbers.

Tax-inclusive line total

Example entry 0.04 (in the selected currency).

Worked example

InputValue
Included tax rate20%
Rounding decimal places2

Gross invoice lines

Tax-inclusive line total
0.04
0.04
0.04
ResultValue
Line total less invoice method0.01
Sum of rounded line tax0.03
Rounded invoice tax0.02

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Included tax rate20%10%Line total less invoice method0.01-0.01
Rounding decimal places23Line total less invoice method0.010.001
Tax-inclusive line total (row 1)0.041.04Line total less invoice method0.010
Tax-inclusive invoice rounding reconciliation →

Sources