Peppol BIS Billing 3.0 - Rounding and calculations

French translation of chapters 9 and 10 of the official documentation

Source: https://docs.peppol.eu/poacc/billing/3.0/bis/

9. Rounding

To minimize the risks of differences due to rounding, the following rules apply:

  • All document-level amounts must be rounded to two decimals for accounting purposes
  • The invoice line net amount must be rounded to two decimals
  • The results of calculations involving already-rounded amounts are not subject to rounding, such as payable amounts and total VAT-inclusive amounts.

See also chapter Calculations for details on the calculation of the various amounts.

10. Calculations

10.1. Total calculations

The total calculation formulas are as follows:

Business term ID Term name Calculation
BT-106 Sum of invoice line net amounts sum(BT-131: Invoice line net amount)
BT-107 Sum of document-level allowances sum(BT-92: Document-level allowance amount)
BT-108 Sum of document-level charges sum(BT-99: Document-level charge amount)
BT-109 Invoice total net amount BT-106 - BT-107 + BT-108
BT-110 Invoice total VAT amount sum(BT-117: VAT amount by category)
BT-112 Invoice total VAT-inclusive amount BT-109 + BT-110
BT-115 Amount due BT-112 - BT-113 (Paid amount) + BT-114 (Rounding amount)

10.1.1. Calculation formulas in UBL syntax

The following elements represent the legal monetary totals for an invoice or credit note:

Element Formula
<cbc:LineExtensionAmount> sum(cac:InvoiceLine/cbc:LineExtensionAmount)
<cbc:AllowanceTotalAmount> sum(cac:AllowanceCharge[ChargeIndicator='false']/cbc:Amount)
<cbc:ChargeTotalAmount> sum(cac:AllowanceCharge[ChargeIndicator='true']/cbc:Amount)
<cbc:TaxExclusiveAmount> cac:LegalMonetaryTotal/cbc:LineExtensionAmount - cac:LegalMonetaryTotal/cbc:AllowanceTotalAmount + cac:LegalMonetaryTotal/cbc:ChargeTotalAmount
<cbc:TaxInclusiveAmount> cac:LegalMonetaryTotal/cbc:TaxExclusiveAmount + cac:TaxTotal/cbc:TaxAmount
<cbc:PrepaidAmount> Not applicable
<cbc:PayableRoundingAmount> Not applicable
<cbc:PayableAmount> cac:LegalMonetaryTotal/cbc:TaxInclusiveAmount - cac:LegalMonetaryTotal/cbc:PrepaidAmount + cac:LegalMonetaryTotal/cbc:PayableRoundingAmount

10.1.2. Element for the rounding amount: PayableRoundingAmount

It is possible to round the expected payable amount.

The element cac:LegalMonetaryTotal/cbc:PayableRoundingAmount is used for this purpose and is specified at header level. This value must be added to the value of cac:LegalMonetaryTotal/cbc:PayableAmount.

Example: Amount 999.81 rounded to 1000. PayableRoundingAmount = 0.19

10.2. Line-level calculation

10.2.1. Item net price (BT-146)

If the gross price and the allowance exist, the item net price must be equal to the item gross price minus the allowance on the item price.

Calculation formula:

Prix net de l'article = Prix brut de l'article (BT-148) - Remise sur prix de l'article (BT-147)

UBL example of item net price:

<cac:Price>
    <cbc:PriceAmount currencyID="EUR">410</cbc:PriceAmount>           <!-- (3) -->
    <cbc:BaseQuantity unitCode="C62">1</cbc:BaseQuantity>
    <cac:AllowanceCharge>
        <cbc:ChargeIndicator>false</cbc:ChargeIndicator>
        <cbc:Amount currencyID="EUR">40</cbc:Amount>                  <!-- (2) -->
        <cbc:BaseAmount currencyID="EUR">450</cbc:BaseAmount>         <!-- (1) -->
    </cac:AllowanceCharge>
</cac:Price>
Ref Description
(1) Item gross price
(2) Allowance on item price
(3) Item net price = Gross price - Allowance

10.2.2. Invoice line net amount (BT-131)

The invoice line net amount (BT-131) is, as its name indicates, the net amount excluding VAT, and including line-level allowances and charges.

The calculation formula for the invoice line net amount is:

Montant net de ligne = ((Prix net de l'article (BT-146) / Quantité de base du prix (BT-149))
                        x Quantité facturée (BT-129))
                        + Montant de frais de ligne (BT-141)
                        - Montant de remise de ligne (BT-136)

Note: Since the line net amount must be rounded to two decimals, please note that the different parts of the calculation must be rounded separately.

That is, the result of (Item net price / Price base quantity) x Invoiced quantity must be rounded to two decimals, and the allowance/charge amounts are also rounded separately.

UBL example of line net amount without line allowance/charge:

<cbc:InvoicedQuantity unitCode="C62">10</cbc:InvoicedQuantity>              <!-- (3) -->
<cbc:LineExtensionAmount currencyID="EUR">1000.00</cbc:LineExtensionAmount> <!-- (4) -->

<!-- Code omis pour clarté -->

<cac:Price>
    <cbc:PriceAmount currencyID="EUR">200</cbc:PriceAmount>                 <!-- (1) -->
    <cbc:BaseQuantity unitCode="C62">2</cbc:BaseQuantity>                   <!-- (2) -->
</cac:Price>
Ref Description
(1) Item net price
(2) Price base quantity
(3) Invoiced quantity
(4) Line net amount = (Net price / Base quantity) x Invoiced quantity

UBL example of line net amount with line allowance and charge:

<cbc:InvoicedQuantity unitCode="C62">10</cbc:InvoicedQuantity>             <!-- (4) -->
<cbc:LineExtensionAmount currencyID="EUR">900.00</cbc:LineExtensionAmount> <!-- (5) -->

<!-- Code omis pour clarté -->

<cac:AllowanceCharge>
    <cbc:ChargeIndicator>true</cbc:ChargeIndicator>
    <cbc:AllowanceChargeReasonCode>CG</cbc:AllowanceChargeReasonCode>
    <cbc:AllowanceChargeReason>Charge</cbc:AllowanceChargeReason>
    <cbc:MultiplierFactorNumeric>1</cbc:MultiplierFactorNumeric>
    <cbc:Amount currencyID="EUR">1</cbc:Amount>                            <!-- (2) -->
    <cbc:BaseAmount currencyID="EUR">100</cbc:BaseAmount>
</cac:AllowanceCharge>
<cac:AllowanceCharge>
    <cbc:ChargeIndicator>false</cbc:ChargeIndicator>
    <cbc:AllowanceChargeReasonCode>95</cbc:AllowanceChargeReasonCode>
    <cbc:AllowanceChargeReason>Discount</cbc:AllowanceChargeReason>
    <cbc:Amount currencyID="EUR">101</cbc:Amount>                          <!-- (3) -->
</cac:AllowanceCharge>

<!-- Code omis pour clarté -->

<cac:Price>
    <cbc:PriceAmount currencyID="EUR">100</cbc:PriceAmount>                <!-- (1) -->
</cac:Price>
Ref Description
(1) Item net price
(2) Line charge amounts
(3) Line allowance amount
(4) Invoiced quantity
(5) Line net amount = (Net price x Invoiced quantity) + Line charges - Line allowance

10.3. Allowance/charge amount calculation

Document-level and line-level allowances and charges include elements containing information about the base amount and the allowance/charge percentage. These, if present in the invoice instance, are used to calculate the allowance/charge amount.

If the base amount is present, the percentage must also be present, and if the percentage is present, the base amount must also be present, and the amount calculation must be:

Montant = Montant de base x (Pourcentage / 100)

UBL example of allowance and charge calculations with base amount and percentage:

<cac:AllowanceCharge>
    <cbc:ChargeIndicator>true</cbc:ChargeIndicator>
    <cbc:AllowanceChargeReasonCode>CG</cbc:AllowanceChargeReasonCode>
    <cbc:AllowanceChargeReason>Nettoyage</cbc:AllowanceChargeReason>
    <cbc:MultiplierFactorNumeric>20</cbc:MultiplierFactorNumeric>          <!-- (2) -->
    <cbc:Amount currencyID="EUR">200</cbc:Amount>                          <!-- (3) -->
    <cbc:BaseAmount currencyID="EUR">1000</cbc:BaseAmount>                 <!-- (1) -->
    <cac:TaxCategory>
        <cbc:ID>S</cbc:ID>
        <cbc:Percent>25</cbc:Percent>
        <cac:TaxScheme>
            <cbc:ID>VAT</cbc:ID>
        </cac:TaxScheme>
    </cac:TaxCategory>
</cac:AllowanceCharge>
Ref Description
(1) Base amount, to be used with the percentage to calculate the amount
(2) Charge percentage
(3) Base amount x (Percentage / 100) = Amount

UBL example of allowance and charge calculations without base amount or percentage:

<cac:AllowanceCharge>
    <cbc:ChargeIndicator>false</cbc:ChargeIndicator>
    <cbc:AllowanceChargeReasonCode>95</cbc:AllowanceChargeReasonCode>
    <cbc:AllowanceChargeReason>Remise</cbc:AllowanceChargeReason>
    <cbc:Amount currencyID="EUR">200</cbc:Amount>                          <!-- (1) -->
    <cac:TaxCategory>
        <cbc:ID>S</cbc:ID>
        <cbc:Percent>25</cbc:Percent>
        <cac:TaxScheme>
            <cbc:ID>VAT</cbc:ID>
        </cac:TaxScheme>
    </cac:TaxCategory>
</cac:AllowanceCharge>
Ref Description
(1) Allowance amount without calculations based on base amount and percentage

10.4. VAT calculation

A VAT breakdown must be provided for each distinct combination of VAT category code and VAT rate found either in the line VAT information or in the document-level allowances or charges.

For each distinct combination of VAT category code and VAT rate, the calculations are:

Base imposable de catégorie TVA (BT-116) = somme(Montants nets de ligne de facture (BT-131))
                                           + Montant de frais au niveau document (BT-99)
                                           - Montant de remise au niveau document (BT-92)

Montant de TVA de catégorie (BT-117) = Base imposable de catégorie TVA (BT-116)
                                        x (Taux de TVA (BT-119) / 100)

Note: For VAT breakdowns where the VAT category is "Not subject to VAT" (O), the VAT category tax amount must be zero.

UBL example of VAT breakdown calculations:

<cac:AllowanceCharge>
    <cbc:ChargeIndicator>true</cbc:ChargeIndicator>
    <cbc:AllowanceChargeReason>Nettoyage</cbc:AllowanceChargeReason>
    <cbc:Amount currencyID="EUR">200</cbc:Amount>                          <!-- (1) -->
    <cac:TaxCategory>
        <cbc:ID>S</cbc:ID>
        <cbc:Percent>25</cbc:Percent>
        <cac:TaxScheme>
            <cbc:ID>VAT</cbc:ID>
        </cac:TaxScheme>
    </cac:TaxCategory>
</cac:AllowanceCharge>

<cac:AllowanceCharge>
    <cbc:ChargeIndicator>false</cbc:ChargeIndicator>
    <cbc:AllowanceChargeReason>Remise</cbc:AllowanceChargeReason>
    <cbc:Amount currencyID="EUR">100</cbc:Amount>                          <!-- (2) -->
    <cac:TaxCategory>
        <cbc:ID>S</cbc:ID>
        <cbc:Percent>25</cbc:Percent>
        <cac:TaxScheme>
            <cbc:ID>VAT</cbc:ID>
        </cac:TaxScheme>
    </cac:TaxCategory>
</cac:AllowanceCharge>

<cac:TaxTotal>
    <cbc:TaxAmount currencyID="EUR">1250.00</cbc:TaxAmount>

    <cac:TaxSubtotal>                                                      <!-- (3) -->
        <cbc:TaxableAmount currencyID="EUR">5000.0</cbc:TaxableAmount>     <!-- (4) -->
        <cbc:TaxAmount currencyID="EUR">1250</cbc:TaxAmount>               <!-- (5) -->
        <cac:TaxCategory>
            <cbc:ID>S</cbc:ID>
            <cbc:Percent>25</cbc:Percent>
            <cac:TaxScheme>
                <cbc:ID>VAT</cbc:ID>
            </cac:TaxScheme>
        </cac:TaxCategory>
    </cac:TaxSubtotal>

    <cac:TaxSubtotal>                                                      <!-- (6) -->
        <cbc:TaxableAmount currencyID="EUR">2000.0</cbc:TaxableAmount>
        <cbc:TaxAmount currencyID="EUR">0</cbc:TaxAmount>
        <cac:TaxCategory>
            <cbc:ID>E</cbc:ID>
            <cbc:Percent>0</cbc:Percent>
            <cbc:TaxExemptionReason>Motif d'exonération de taxe</cbc:TaxExemptionReason>
            <cac:TaxScheme>
                <cbc:ID>VAT</cbc:ID>
            </cac:TaxScheme>
        </cac:TaxCategory>
    </cac:TaxSubtotal>
</cac:TaxTotal>

<cac:InvoiceLine>
    <cbc:ID>1</cbc:ID>
    <cbc:Note>Note de test au niveau ligne</cbc:Note>
    <cbc:InvoicedQuantity unitCode="C62">10</cbc:InvoicedQuantity>
    <cbc:LineExtensionAmount currencyID="EUR">4000.00</cbc:LineExtensionAmount>
    <!-- code omis pour clarté -->
    <cac:ClassifiedTaxCategory>
        <cbc:ID>S</cbc:ID>
        <cbc:Percent>25.0</cbc:Percent>
        <cac:TaxScheme>
            <cbc:ID>VAT</cbc:ID>
        </cac:TaxScheme>
    </cac:ClassifiedTaxCategory>
</cac:InvoiceLine>

<cac:InvoiceLine>
    <cbc:ID>2</cbc:ID>
    <cbc:InvoicedQuantity unitCode="C62">10</cbc:InvoicedQuantity>
    <cbc:LineExtensionAmount currencyID="EUR">2000.00</cbc:LineExtensionAmount>
    <!-- code omis pour clarté -->
    <cac:ClassifiedTaxCategory>
        <cbc:ID>E</cbc:ID>
        <cbc:Percent>0.0</cbc:Percent>
        <cac:TaxScheme>
            <cbc:ID>VAT</cbc:ID>
        </cac:TaxScheme>
    </cac:ClassifiedTaxCategory>
</cac:InvoiceLine>

<cac:InvoiceLine>
    <cbc:ID>3</cbc:ID>
    <cbc:InvoicedQuantity unitCode="C62">10</cbc:InvoicedQuantity>
    <cbc:LineExtensionAmount currencyID="EUR">900.00</cbc:LineExtensionAmount>
    <!-- code omis pour clarté -->
    <cac:ClassifiedTaxCategory>
        <cbc:ID>S</cbc:ID>
        <cbc:Percent>25.0</cbc:Percent>
        <cac:TaxScheme>
            <cbc:ID>VAT</cbc:ID>
        </cac:TaxScheme>
    </cac:ClassifiedTaxCategory>
</cac:InvoiceLine>
Ref Description
(1) Document-level charge amount for category S and rate 25%
(2) Document-level allowance amount for category S and rate 25%
(3) VAT breakdown for category S and rate = 25%
(4) Taxable base = sum of line amounts (lines 1 and 3) + charge amount - allowance amount where category = S and rate = 25%
(5) VAT amount = Taxable base x (VAT rate / 100)
(6) VAT breakdown for category E and rate = 0%