Accruals and volume rebates

Summary

Any suggestion of how create accruals to calculate rebates using pricing

Content

The requirement is on the amount of sales per year as follow:

$10,000 - $14,999.99 = 2.0%
$15,000 - $19,999.99 = 2.5%
$20,000 - $24,999.99 = 3.0%
$25,000 + = 4.5%

So, I need to accumulate the sales of each customer and create an  accrual journal entry transaction. Is any functionality in cloud to achieve it?

 

 

Version

19D