Invoice total including VAT

Error BR-CO-15 EN 16931

Invoice total amount with VAT (BT-112) = Invoice total amount without VAT (BT-109) + Invoice total VAT amount (BT-110).

Mandatory rule: As long as it is violated, the invoice is invalid and will be rejected by validators.
What is wrong

GrandTotalAmount does not equal the sum of TaxBasisTotalAmount and the corresponding TaxTotalAmount. Exactly one matching VAT amount must be present for the invoice currency. If there is no TaxTotalAmount for that currency, GrandTotalAmount must equal TaxBasisTotalAmount.

What the rule means

The invoice total including VAT is the amount excluding VAT plus the corresponding VAT amount. Matching the invoice currency ensures that only the relevant tax amount is included in the invoice total.

Affected fields BT-112 BT-109 BT-110
Please reconcile the invoice total including VAT

The total including VAT does not match the amount excluding VAT and the VAT amount in the invoice currency. You can adjust the totals so that they match.

What to do
  1. Compare GrandTotalAmount with TaxBasisTotalAmount plus the TaxTotalAmount for the invoice currency.
  2. Check that the tax amount’s currencyID matches the InvoiceCurrencyCode.
  3. Check the GrandTotalAmount, TaxBasisAmount and TaxTotalAmount properties.
  4. Generate the invoice again and validate it again.
What it looks like
✗ Triggers the message
<ram:SpecifiedTradeSettlementHeaderMonetarySummation>
  <ram:TaxBasisTotalAmount>100.00</ram:TaxBasisTotalAmount>
  <ram:TaxTotalAmount currencyID="EUR">20.00</ram:TaxTotalAmount>
  <ram:GrandTotalAmount>121.00</ram:GrandTotalAmount>
</ram:SpecifiedTradeSettlementHeaderMonetarySummation>
✓ Correct
<ram:SpecifiedTradeSettlementHeaderMonetarySummation>
  <ram:TaxBasisTotalAmount>100.00</ram:TaxBasisTotalAmount>
  <ram:TaxTotalAmount currencyID="EUR">20.00</ram:TaxTotalAmount>
  <ram:GrandTotalAmount>120.00</ram:GrandTotalAmount>
</ram:SpecifiedTradeSettlementHeaderMonetarySummation>
Check in FactoorSharp
  • FacturXInvoice.GrandTotalAmount (BT-112)
  • FacturXInvoice.TaxBasisAmount (BT-109)
  • FacturXInvoice.TaxTotalAmount (BT-110)
Technical details

The XPath check requires exactly one TaxTotalAmount with a matching currencyID for the InvoiceCurrencyCode and compares GrandTotalAmount with the sum of TaxBasisTotalAmount and that tax amount, rounded to two decimal places. Without a matching tax amount, it compares GrandTotalAmount with TaxBasisTotalAmount.

Where the rule applies

The rule applies to GrandTotalAmount, TaxBasisTotalAmount and TaxTotalAmount in SpecifiedTradeSettlementHeaderMonetarySummation. VAT amounts are matched to the invoice’s InvoiceCurrencyCode.

Context (rule/@context)
//ram:SpecifiedTradeSettlementHeaderMonetarySummation
Test expression (assert/@test)
every $Currency in /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ ram:ApplicableHeaderTradeSettlement/ram:InvoiceCurrencyCode satisfies ( ( count(/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ ram:SpecifiedTradeSettlementHeaderMonetarySummation/ram:TaxTotalAmount[@currencyID = $Currency]) = 1 and xs:decimal((/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeSettlementHeaderMonetarySummation/ ram:GrandTotalAmount)[1]) = round( ( xs:decimal((/rsm:CrossIndustryInvoice/ rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ ram:SpecifiedTradeSettlementHeaderMonetarySummation/ram:TaxBasisTotalAmount)[1]) + xs:decimal((/ rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ ram:SpecifiedTradeSettlementHeaderMonetarySummation/ram:TaxTotalAmount[@currencyID = $Currency])[1]) ) * 100 ) div 100 ) or ( xs:decimal((/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeSettlementHeaderMonetarySummation/ ram:GrandTotalAmount)[1]) = xs:decimal((/rsm:CrossIndustryInvoice/ rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ ram:SpecifiedTradeSettlementHeaderMonetarySummation/ram:TaxBasisTotalAmount)[1]) ) )
Changes in the KoSIT validation rules
  • 2022-07-152022-07-15 · AddedTests for BR-53 and BR-CO-15 in CII with same BT-5 and BT-6
  • 2021-07-312021-07-31 · ChangedUsing [CEN Schematron Rules 1.3.6a](https://github.com/phax/eInvoicing-EN16931/releases/tag/validation-1.3.6a) from a fork fixing Rule BR-CO-15