VAT Inclusive Exclusive Back Calculation Tool

Net amount backed out of a single-rate VAT-inclusive total with independently applicable caller rate; exemptions/rounding and tax liability omitted.

Description

VAT Inclusive Exclusive Back Calculation Tool: return exclusive amount.

Removing VAT from an inclusive total requires dividing by one plus the rate. Subtracting the same percentage of the gross amount gives a different result.

This tool returns exclusive amount. Use the stated units and model convention when interpreting these fields.

When to use this tool

Use this tool when the supplied inputs match the specific operation described above and you need a repeatable result under its stated convention.

  • Check the supported input and output contract against an existing calculation or observation.
  • Use the complete example to confirm units, selector spelling and result interpretation.

How to use the tool and how it works

  1. Enter every field in the input table using the stated units and the exact supported selector spelling where applicable.
  2. Run the tool. Correct input errors before interpreting an output.
  3. Read the result fields below; use accompanying flags and the stated sign, boundary or model convention when interpreting a number.

Divide inclusiveAmount by one plus callerVatRateFraction.1

Input fieldMeaning and unitsAccepted input
inclusiveAmountInclusive amount.Finite number; zero or greater
callerVatRateFractionCaller vat rate fraction. Fractional units; 0.2 means 20%.Finite number; zero or greater
Output fieldInterpretation
resultObject containing the following named result fields.
result.exclusiveAmountExclusive amount; use the stated units and sign convention.
json
{
  "input": {
    "inclusiveAmount": 120,
    "callerVatRateFraction": 0.2
  },
  "output": {
    "result": {
      "exclusiveAmount": 100
    }
  }
}

Limitations and assumptions

  • The caller supplies the applicable rate. Exemptions, multiple rates and invoice-rounding rules are not evaluated.
  • Every declared field is required and unexpected fields are rejected. Numeric inputs must be finite; input errors are distinct from a valid false result or an explicitly qualified output.
  • Extremely large inputs and nonfinite or excessively large outputs are rejected. List positions reported by the tool use zero-based indices unless stated otherwise.

Alternative or Complementary methods

Check the underlying observations, units and conventions independently before using the result in a larger workflow. The tools listed below address nearby tasks; compare their inputs and scope before substituting one for this operation.

References

  1. Tool behavior and example: VAT Inclusive Exclusive Back Calculation Tool — tool.io

Similar or alternative tools

Don't forget to set a bookmark for tool.io!
Privacy | Imprint | Cookies