BR-CO-10: Sum of invoice line net amounts (BT-106) does not match
Official message
[BR-CO-10] Sum of Invoice line net amount (BT-106) = Σ Invoice line net amount (BT-131).
[BR-CO-10] Sum of Invoice line net amount (BT-106) = Σ Invoice line net amount (BT-131).
[BR-CO-10] Sum of Invoice line net amount (BT-106) = Σ Invoice line net amount (BT-131).
- Severity
- Error The invoice is invalid and may be rejected by the recipient.
- Applies to
- EN 16931 (CII), EN 16931 (UBL), Factur-X / ZUGFeRD EN 16931
- Affected fields
- BT-106, BT-131
What does this mean?
The sum of invoice line net amounts (BT-106) shall equal the sum of the net amounts of the individual invoice lines (BT-131). The value in BT-106 deviates from it.
Checked: BT-106 = Σ BT-131, the sum rounded to two decimals. Example: 100.00 + 250.50 = 350.50.
Typical causes
A line was added, changed or removed without recalculating BT-106.
Document level allowances or charges (BT-107, BT-108) were included in BT-106.
BT-106 was built from unrounded intermediate values (quantity × price) instead of the stated line amounts BT-131.
How to fix the error
Calculate BT-106 as the sum of all BT-131 and round it to two decimals.
Do not include document level allowances and charges in BT-106; they go separately into BT-107 and BT-108.
Recalculate dependent totals (BT-109, BT-112, BT-115) with the corrected value.
CII: ram:SpecifiedTradeSettlementHeaderMonetarySummation/ram:LineTotalAmount, UBL: cac:LegalMonetaryTotal/cbc:LineExtensionAmount.
In E-Rechnungsfreund
In the invoice form, BT-106 is calculated from the invoice lines and the allowances and charges when the XML is generated, and rounded to two decimals; the value in the field "Summe Nettobeträge (BT-106)" in section "Belegsummen (BG-22)" (document totals) is not used for this. Check the lines in section "Rechnungspositionen (BG-25)" (invoice lines) and validate the invoice again.
Example
Wrong
<!-- Lines: BT-131 = 100.00 and 250.50 -->
<ram:SpecifiedTradeSettlementHeaderMonetarySummation>
<ram:LineTotalAmount>350.00</ram:LineTotalAmount>
...
</ram:SpecifiedTradeSettlementHeaderMonetarySummation>
Correct
<!-- Lines: BT-131 = 100.00 and 250.50 -->
<ram:SpecifiedTradeSettlementHeaderMonetarySummation>
<ram:LineTotalAmount>350.50</ram:LineTotalAmount>
...
</ram:SpecifiedTradeSettlementHeaderMonetarySummation>
For developers: test expression per syntax
EN 16931 (CII) (CII)
Context: //ram:SpecifiedTradeSettlementHeaderMonetarySummation
xs:decimal(ram:LineTotalAmount) = round(xs:decimal(sum(../../ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeSettlement/ram:SpecifiedTradeSettlementLineMonetarySummation/ram:LineTotalAmount)) * xs:decimal(100)) div xs:decimal(100)
EN 16931 (UBL) (UBL)
Context: cac:LegalMonetaryTotal
(xs:decimal(cbc:LineExtensionAmount) = xs:decimal(round(sum(//(cac:InvoiceLine|cac:CreditNoteLine)/xs:decimal(cbc:LineExtensionAmount)) * 10 * 10) div 100))
Factur-X / ZUGFeRD EN 16931 (CII)
Technical ID in the source: FX-SCH-A-000226
Context: //ram:SpecifiedTradeSettlementHeaderMonetarySummation
xs:decimal(ram:LineTotalAmount) = round(xs:decimal(sum(../../ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeSettlement/ram:SpecifiedTradeSettlementLineMonetarySummation/ram:LineTotalAmount)) * xs:decimal(100)) div xs:decimal(100)
Related validation rules
- BR-CO-03: Value added tax point date (BT-7) and tax point date code (BT-8) are mutually exclusive
- BR-CO-04: Invoiced item VAT category code (BT-151) is missing
- BR-CO-05: Document level allowance reason code (BT-98) and allowance reason (BT-97) must indicate the same type
- BR-CO-06: Document level charge reason code (BT-105) and charge reason (BT-104) must indicate the same type
- BR-CO-07: Invoice line allowance reason code (BT-140) and allowance reason (BT-139) must indicate the same type
- BR-CO-08: Invoice line charge reason code (BT-145) and charge reason (BT-144) must indicate the same type
Frequently asked questions
Do allowances and charges belong in BT-106?
Invoice line allowances and charges are already contained in the line net amount (BT-131) and therefore in BT-106. Document level allowances and charges do not belong in it; they are summed in BT-107 and BT-108 and only offset in the invoice total without VAT (BT-109) (BR-CO-13).
Last updated:
Explanation of the validation rule, not legal or tax advice.