What does BR-CO-14 mean?
The invoice total VAT amount must equal the sum of the VAT category tax amounts.
Common causes of BR-CO-14
- A tax rate block (ram:ApplicableTradeTax) was left out of the sum BT-110.
- Rounding: BT-110 was derived roughly from a gross value instead of summing the individual BT-117.
- The invoice carries several VAT rates, but BT-110 holds the amount of only one rate.
How to fix BR-CO-14
- Find the faulty spot in the XML. Open the XML of the invoice and go to field BT-110 along this XPath:
//ram:SpecifiedTradeSettlementHeaderMonetarySummation/ram:TaxTotalAmount - Apply the fix. The invoice total VAT amount (BT-110) must equal the sum of all VAT category tax amounts (BT-117): BT-110 = sum of BT-117. Correct ram:TaxTotalAmount so that it maps exactly to the sum of all ram:CalculatedAmount from the ram:ApplicableTradeTax blocks. Usually the total BT-110 is wrong or a tax rate block was not counted.
- Validate again. Save the file and validate it again to check that BR-CO-14 is no longer reported.
The invoice total VAT amount (BT-110) must equal the sum of all VAT category tax amounts (BT-117): BT-110 = sum of BT-117. Correct ram:TaxTotalAmount so that it maps exactly to the sum of all ram:CalculatedAmount from the ram:ApplicableTradeTax blocks. Usually the total BT-110 is wrong or a tax rate block was not counted.
//ram:SpecifiedTradeSettlementHeaderMonetarySummation/ram:TaxTotalAmountBefore / after: the XML example
This is the spot in question before and after the fix (Cross Industry Invoice, ZUGFeRD/Factur-X).
<ram:ApplicableTradeTax>
<ram:CalculatedAmount>19.00</ram:CalculatedAmount>
<ram:CategoryCode>S</ram:CategoryCode>
<ram:RateApplicablePercent>19</ram:RateApplicablePercent>
</ram:ApplicableTradeTax>
<ram:TaxTotalAmount currencyID="EUR">12.00</ram:TaxTotalAmount>
<ram:ApplicableTradeTax>
<ram:CalculatedAmount>19.00</ram:CalculatedAmount>
<ram:CategoryCode>S</ram:CategoryCode>
<ram:RateApplicablePercent>19</ram:RateApplicablePercent>
</ram:ApplicableTradeTax>
<ram:TaxTotalAmount currencyID="EUR">19.00</ram:TaxTotalAmount>
Frequent questions about BR-CO-14
How do I calculate BT-110 with several tax rates?
Must ram:TaxTotalAmount carry the currency?
Related error codes
Check BR-CO-14 automatically
Instead of digging through the XML by hand you can validate your ZUGFeRD or XRechnung file online – upload the PDF or the XML and you get every error with rule ID, affected field, fix and XPath, as a readable report or as JSON through the API.