Mixed-rate basket tax allocation · Calculation guide

Calculate the aggregate tax on net-priced lines at different rates.

Calculation guide

Each line amount is net of tax after discounts. Keep full precision until the basket sum. No statutory rounding policy is assumed.

tax = Σ net line × line rate / 100

Inputs

Net amount

Example entry 100 (in the selected currency).

Applicable rate

Example entry 20 %. Allowed range 0 to 100.

Worked example

Net basket lines

Net amountApplicable rate
10020%
405%
ResultValue
Basket tax22
Gross basket162

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Net amount (row 1)100110Basket tax2224
Applicable rate (row 1)20%22%Basket tax2224
Mixed-rate basket tax allocation →

Sources