Rebate Accrual Calculator
Work out rebate accrual instantly with clear inputs, formula shown and shareable results.
About Rebate Accrual Calculator
Rebates should be accrued through the year at the rate expected to be achieved on full-year volume, not at the rate currently earned. Accruing at the lower current-tier rate understates margin early in the year and creates a distorting catch-up at year end.
Formulas
Accrual to date
Accrual = Purchases to date x Rebate rate at forecast volume
Full-year rebate
Full year = Forecast purchases x Rebate rate
Worked example
With the default values below, Rebate Accrual Calculator returns Rebate accrued to date of $2,380,000.00. Change any input above and every figure here is recalculated in your browser.
Inputs used
- Purchases to date
- 68,000,000
- Forecast full-year purchases
- 96,000,000
- Rebate rate achieved at the forecast level
- 3.5
- Months elapsed
- 8
Results
- Rebate accrued to date
- $2,380,000.00
- Forecast full-year rebate
- $3,360,000.00
- Average monthly accrual
- $297,500.00
- Rebate still to accrue
- $980,000.00
Step by step
- 1Values used
- 2Accrual to date
- 3Full-year rebate
- 4Rebate accrued to date= 2,380,000.00
- 5Forecast full-year rebate= 3,360,000.00
- 6Average monthly accrual= 297,500.00
- 7Rebate still to accrue= 980,000.00
Assumptions and limits
- The result is derived only from the 4 inputs listed above. Anything not among them is not part of the calculation.
- In particular, this calculator does not take inflation, tax, fees or charges or compounding frequency into account.
- Figures are rounded for display to 2 decimal places, so totals built from several rounded parts can differ slightly from the unrounded arithmetic.
How these calculators are built and tested is described on the Methodology page. If a figure looks wrong, please report it.
Frequently Asked Questions
What if the forecast volume is not achieved?
The accrual must be reversed, which is why the forecast should be conservative and reviewed monthly against actual purchase pace.
Where does the rebate go in the accounts?
As a reduction in inventory cost, released to cost of sales as the goods are sold — not as other income.
Related Calculators
- Advance Payment Recovery Calculator
- Approval Cycle Time Calculator
- Asset Disposal Value Calculator
- Backhaul Revenue Calculator
- Bid Comparison Matrix Calculator
- Category Spend Analysis Calculator
- Change Order Impact Calculator
- Claim Evaluation Amount Calculator
- Consignment Stock Value Calculator
- Container Utilisation For Order Calculator
You might also need
- Backhaul Revenue CalculatorAlso in Procurement, Contracts & Vendor Management
- Vendor Scorecard CalculatorAlso in Procurement, Contracts & Vendor Management
- Advance Payment Recovery CalculatorAlso in Procurement, Contracts & Vendor Management
- Approval Cycle Time CalculatorAlso in Procurement, Contracts & Vendor Management
- Asset Disposal Value CalculatorAlso in Procurement, Contracts & Vendor Management
- Bid Comparison Matrix CalculatorAlso in Procurement, Contracts & Vendor Management
