How the Netherlands btw (vat) calculator is verified

Inputs

InputFieldType
Amountamountnumber
Directiondirectionstring
What is being suppliedcategorystring
Turnover this calendar yearannualTurnovernumber
B2B reverse charge appliesreverseChargeboolean
Turnover last yearpriorYearTurnovernumber

The formula

Each derived value below is computed by the Valem engine from the expression shown, in this order. Nothing else runs — there is no hidden code path.

Derived valueFieldFormula (JSONata)
Rateratecategory = 'reduced1' ? $const.reducedRate1 : $const.standardRate
Effective RateeffectiveRatereverseCharge ? 0 : rate
Net AmountnetAmountdirection = 'remove' ? $round(amount / (1 + effectiveRate), 2) : $round(amount, 2)
Vat AmountvatAmount$round(netAmount * effectiveRate, 2)
Gross AmountgrossAmount$round(netAmount + vatAmount, 2)
Must RegistermustRegisterpriorYearTurnover > $const.registrationThreshold or annualTurnover > $const.registrationThreshold

Rates and thresholds

The expressions above read these as $const. They are the figures the annual refresh replaces, so they live as data rather than being written into the formulas — which is what makes a year-on-year change a one-line diff instead of an edit to arithmetic.

ConstantValue
standardRate0.21
reducedRate10.09
registrationThreshold20000

Test vectors (6)

Every case is executed against this model on each build, by the Java engine and independently by a JavaScript one. A mismatch of a single cent fails the build, so the page cannot ship advertising a figure the model no longer produces.

Case 1 — S1 100.00 EUR net at the algemeen tarief

given amount100
given directionadd
given categorystandard
given reverseChargeno
given annualTurnover0
given priorYearTurnover0
expect vatAmount21
expect grossAmount121
expect netAmount100

Case 2 — S2 121.00 EUR gross back to net at 21%

given amount121
given directionremove
given categorystandard
given reverseChargeno
given annualTurnover0
given priorYearTurnover0
expect netAmount100
expect vatAmount21

Case 3 — S3 100.00 EUR net at the 9% verlaagd tarief

given amount100
given directionadd
given categoryreduced1
given reverseChargeno
given annualTurnover0
given priorYearTurnover0
expect vatAmount9
expect grossAmount109

Case 4 — S4 reverse charge: the supplier charges no btw

given amount100
given directionadd
given categorystandard
given reverseChargeyes
given annualTurnover0
given priorYearTurnover0
expect vatAmount0
expect grossAmount100

Case 5 — S5 either year over 20 000 EUR: the KOR is not available

given amount100
given directionadd
given categorystandard
given reverseChargeno
given annualTurnover5000
given priorYearTurnover25000
expect mustRegistertrue

Case 6 — S6 both years under the limit: the KOR is available

given amount100
given directionadd
given categorystandard
given reverseChargeno
given annualTurnover15000
given priorYearTurnover15000
expect mustRegisterfalse

Sources

Check it yourself — and reuse it

The whole model as JSON — inputs, outputs, formulas, vectors and sources in one re-runnable document.

This model is published under CC BY 4.0: use it, adapt it, build on it, with attribution. The licence covers the model — the expression of each rule and the arrangement of the catalog. The rates and thresholds are law, and nobody licenses those; the sources above are where they come from.

← Back to the Netherlands btw (vat) calculator

Built with Valem — a live, verifiable calculator you can fork and embed.