Volume rebate tier accrual · Calculation guide

Apply incremental rebates to eligible spend within each band.

Calculation guide

The higher tier applies only to the excess above its threshold. Subtract rebates already booked to find the current adjustment.

Total earned rebate = max(0,min(Cumulative eligible spend,Second threshold) − First threshold) × First rebate rate / 100 + max(0,Cumulative eligible spend − Second threshold) × Second rebate rate / 100. Current accrual adjustment = Total earned rebate − Previously accrued rebate

Inputs

Cumulative eligible spend

Example entry 15000 (in the selected currency).

First threshold

Example entry 5000 (in the selected currency).

Second threshold

Example entry 10000 (in the selected currency).

First rebate rate

Example entry 3 %. Allowed range 0 to 100.

Second rebate rate

Example entry 5 %. Allowed range 0 to 100.

Previously accrued rebate

Example entry 200 (in the selected currency).

Worked example

InputValue
Cumulative eligible spend15,000
First threshold5,000
Second threshold10,000
First rebate rate3%
Second rebate rate5%
Previously accrued rebate200
ResultValue
Total earned rebate400
Current accrual adjustment200

Calculation steps

Total earned rebate = (((max(0, (min(Cumulative eligible spend, Second threshold) − First threshold)) × First rebate rate) ÷ 100) + ((max(0, (Cumulative eligible spend − Second threshold)) × Second rebate rate) ÷ 100))

(((max(0, (min(15,000, 10,000) − 5,000)) × 3) ÷ 100) + ((max(0, (15,000 − 10,000)) × 5) ÷ 100)) = 400

Current accrual adjustment = (Total earned rebate − Previously accrued rebate)

(400 − 200) = 200

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Cumulative eligible spend15,00016,500Total earned rebate400475
First threshold5,0005,500Total earned rebate400385
Second threshold10,00011,000Total earned rebate400380
First rebate rate3%4%Total earned rebate400450
Second rebate rate5%6%Total earned rebate400450
Previously accrued rebate200220Current accrual adjustment200180
Volume rebate tier accrual →

Sources