Taxable amount for VAT category Z

Error BR-Z-08 EN 16931

In a VAT breakdown (BG-23) where VAT category code (BT-118) is "Zero rated" the VAT category taxable amount (BT-116) shall equal the sum of Invoice line net amount (BT-131) minus the sum of Document level allowance amounts (BT-92) plus the sum of Document level charge amounts (BT-99) where the VAT category codes (BT-151, BT-95, BT-102) are "Zero rated".

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

The ram:BasisAmount in the VAT breakdown with ram:CategoryCode Z does not equal the sum of the net amounts of invoice lines with category Z, plus the matching document-level charges and minus the matching document-level allowances. The sums are rounded to two decimal places.

What the rule means

The taxable amount for category Z must be formed from the net amounts of the related invoice lines and the document-level charges and allowances assigned to this category. This keeps the amount in the VAT breakdown consistent with the underlying invoice amounts.

Please reconcile the taxable amount for category `Z`

The amount in the VAT breakdown for Z does not match the related invoice lines and document-level allowances or charges. You can reconcile the amounts and their VAT category.

What to do
  1. Check whether the affected invoice lines are assigned to category Z in TradeLineItem.TaxCategoryCode.
  2. Compare their TradeLineItem.LineTotalAmount amounts with the ram:BasisAmount in the VAT breakdown.
  3. Include the assigned allowances and charges using AbstractTradeAllowanceCharge.ActualAmount and check their category using TaxCategoryCodes.
  4. Generate the invoice again and validate it once more.
Check in FactoorSharp
  • TaxCategoryCodes (BT-151; BT-95; BT-102; BT-118)
  • AbstractTradeAllowanceCharge.ActualAmount (Document level allowance: BT-92; Document level charge: BT-99)
  • TradeLineItem.LineTotalAmount (BT-131)
  • TradeLineItem.TaxCategoryCode (BT-151)
  • TradeLineItem.TaxType (BT-151-0)
Technical details

The test compares ram:BasisAmount with the sums rounded to two decimal places of ram:LineTotalAmount for invoice lines in category Z, plus the correspondingly categorized document-level charges and minus allowances.

Where the rule applies

The rule applies to the VAT breakdown ram:ApplicableTradeTax with ram:CategoryCode Z in ram:ApplicableHeaderTradeSettlement.

Context (rule/@context)
//ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax/ram:CategoryCode[. = 'Z']
Test expression (assert/@test)
(../ram:BasisAmount -1 <= (round(sum(/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeSettlement[ram:ApplicableTradeTax/ ram:CategoryCode = 'Z']/ram:SpecifiedTradeSettlementLineMonetarySummation/ xs:decimal(ram:LineTotalAmount))*10*10)div 100) + (round(sum(/rsm:CrossIndustryInvoice/ rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ ram:SpecifiedTradeAllowanceCharge[ (ram:ChargeIndicator/udt:Indicator cast as xs:boolean)=true() and ram:CategoryTradeTax/ram:CategoryCode='Z' ]/xs:decimal(ram:ActualAmount[1]))*10*10)div 100) - (round(sum(/rsm:CrossIndustryInvoice/ rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ ram:SpecifiedTradeAllowanceCharge[ (ram:ChargeIndicator/udt:Indicator cast as xs:boolean)=false() and ram:CategoryTradeTax/ram:CategoryCode='Z' ]/xs:decimal(ram:ActualAmount[1]))*10*10)div 100)) and (../ram:BasisAmount +1 > (round(sum(/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeSettlement[ram:ApplicableTradeTax/ ram:CategoryCode = 'Z']/ram:SpecifiedTradeSettlementLineMonetarySummation/ xs:decimal(ram:LineTotalAmount))*10*10)div 100) + (round(sum(/rsm:CrossIndustryInvoice/ rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ ram:SpecifiedTradeAllowanceCharge[ (ram:ChargeIndicator/udt:Indicator cast as xs:boolean)=true() and ram:CategoryTradeTax/ram:CategoryCode='Z' ]/xs:decimal(ram:ActualAmount[1]))*10*10)div 100) - (round(sum(/rsm:CrossIndustryInvoice/ rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ ram:SpecifiedTradeAllowanceCharge[ (ram:ChargeIndicator/udt:Indicator cast as xs:boolean)=false() and ram:CategoryTradeTax/ram:CategoryCode='Z' ]/xs:decimal(ram:ActualAmount[1]))*10*10)div 100))