VRBL: Line-Level Totals

Read about how totals are modeled and calculated at the line level.

Line-level totals generally apply to a specific line item. These are aggregated for some Document-level totals

Item Net Price

If a gross price and discount exist, the Item net price has to be equal to the item gross price less the item price discount.

Calculation details

The following details are used to calculate an item's net price:

DetailValue
Line Calculation NameItem Net Price (Invoice/InvoiceLine/Price/PriceAmount)
Element Reference TopicPriceDetails
Modeling Guide TopicVRBL: Price Details
DescriptionPrice of the item is the difference between the amount and base amount for an item.
CalculationInvoice Line Allowances and Charges (Invoice/InvoiceLine /AllowanceCharge) ÷ Invoice Line Base Amount (Invoice/InvoiceLine/AllowanceCharge/BaseAmount) - Invoice Line Allowances and Charges (Invoice/InvoiceLine/AllowanceCharge) ÷ Invoice Line Amount (Invoice/InvoiceLine/AllowanceCharge/Amount)

Example

Here is an example:

<Invoice>
    <!-- code omitted for clarity -->
    <cac:InvoiceLine>
        <!-- code omitted for clarity -->
        <cac:Price>
            <cbc:PriceAmount currencyID="EUR">410</cbc:PriceAmount>
            <cbc:BaseQuantity unitCode="C62">1</cbc:BaseQuantity>
            <cac:AllowanceCharge>
                <cbc:ChargeIndicator>false</cbc:ChargeIndicator>
                <cbc:Amount currencyID="EUR">40</cbc:Amount>
                <cbc:BaseAmount currencyID="EUR">450</cbc:BaseAmount>
            </cac:AllowanceCharge>
        </cac:Price>
    <cac:InvoiceLine>
    <!-- code omitted for clarity -->
</Invoice>

Invoice-line net amounts

The invoice line net amount is, as the name implies, the net amount without tax, and includes the line level allowance and charges.

Calculation details

DetailValue
Line Total Calculation NameItem Net Price without Allowance or Charge
Element Reference TopicPriceDetails and InvoicedQuantity
Modeling Guide TopicVRBL: Prices
DescriptionThe Item's net price divided by the item's base quantity multiplied by the invoiced quantity plus the Invoice line charge amount minus the Invoice line allowance amount.
CalculationItem Net Price (Invoice/InvoiceLine/Price/PriceAmount) ÷ Item Price Base Quantity (Invoice/InvoiceLine/Price/BaseQuantity) x Invoiced Quantity (Invoice/InvoiceLine/InvoicedQuantity) + Invoice line charge amount (AllowanceCharge[ChargeIndicator='true']/Amount) - Invoice line allowance amount (AllowanceCharge[ChargeIndicator='false']/Amount)

Example

No allowances or charges

This is an example of an invoice line with no allowances or charges:

<Invoice>
    <!-- code omitted for clarity -->
    <cac:InvoiceLine>
        <cbc:InvoicedQuantity unitCode="C62">10</cbc:InvoicedQuantity>
        <cbc:LineExtensionAmount currencyID="EUR">1000.00</cbc:LineExtensionAmount>
        <!-- code omitted for clarity-->
        <cac:Price>
            <cbc:PriceAmount currencyID="EUR">200</cbc:PriceAmount>
            <cbc:BaseQuantity unitCode="C62">2</cbc:BaseQuantity>
        </cac:Price>
    </cac:InvoiceLine>
</Invoice>

Including allowance and charge

The following example includes an example Allowance and Charge:

<Invoice>
    <!-- code omitted for clarity -->
    <cac:InvoiceLine>
        <cbc:InvoicedQuantity unitCode="C62">10</cbc:InvoicedQuantity>
        <cbc:LineExtensionAmount currencyID="EUR">900.00</cbc:LineExtensionAmount>
        <!-- code omitted for clarity-->
         <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>
            <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>
        </cac:AllowanceCharge>
        <!-- code omitted for clarity-->
        <cac:Price>
            <cbc:PriceAmount currencyID="EUR">100</cbc:PriceAmount>
        </cac:Price>
    </cac:InvoiceLine>
</Invoice>

Line-level allowances and charges

Allowance and charge on line level (and on document level) consists of elements carrying information on the allowance/charge base amount and the allowance/charge percentage.

Allowances and Charges can be documented at the line level using the InvoiceLine/AllowanceCharge element.

Base amounts and percentages can be used.

You use the Amount element to specify the total amount. You can use this alone, or you can also add a percentage and a base amount.

To model a percentage and base amount, you specify the percentage in the MultiplierFactorNumeric element and the base amount in the BaseAmount element.

Calculation details

The following calculation is used for line-level Allowances and Charges:

DetailValue
Line Total Calculation NameLine-level Alowances and Charges
Element Reference TopicInvoiceLine/AllowanceCharge
Modeling Guide TopicVRBL: Allowances and VRBL: Charges
DescriptionAllowance/charge amount = Base amount x (Percentage ÷ 100)
CalculationInvoice Line Base Amount (Invoice/InvoiceLine/AllowanceCharge/BaseAmount)(BaseAmount) x Invoice Line - Percentage (Invoice/InvoiceLine/AllowanceCharge/MultiplierFactorNumeric) ÷ 100)

Examples

Base Amount

This example uses a base amount and percentage:

<Invoice>
    <!-- code omitted for clarity -->
    <cac:InvoiceLine>
        <!-- code omitted for clarity -->
        <cac:AllowanceCharge>
            <cbc:ChargeIndicator>true</cbc:ChargeIndicator>
            <cbc:AllowanceChargeReasonCode>CG</cbc:AllowanceChargeReasonCode>
            <cbc:AllowanceChargeReason>Cleaning</cbc:AllowanceChargeReason>
            <cbc:MultiplierFactorNumeric>20</cbc:MultiplierFactorNumeric>
            <cbc:Amount currencyID="EUR">200</cbc:Amount> 
            <cbc:BaseAmount currencyID="EUR">1000</cbc:BaseAmount>
            <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>
        <!-- code omitted for clarity -->
    <cac:InvoiceLine>
<Invoice>

No Base Amount

This example doe not use the base amount or percentages:

<Invoice>
    <!-- code omitted for clarity -->
    <cac:InvoiceLine>
        <!-- code omitted for clarity -->
        <cac:AllowanceCharge>
            <cbc:ChargeIndicator>false</cbc:ChargeIndicator>
            <cbc:AllowanceChargeReasonCode>95</cbc:AllowanceChargeReasonCode>
            <cbc:AllowanceChargeReason>Discount</cbc:AllowanceChargeReason>
            <cbc:Amount currencyID="EUR">200</cbc:Amount>
            <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>
        <!-- code omitted for clarity -->
    <cac:InvoiceLine>
<Invoice>