Nothing leaves your browser. The worksheet uses only the numbers you enter. There is nothing to submit, and the page does not store or send them.
Tools Worksheet
Rebate tier pace worksheet
Enter one tiered rebate the way your contract writes it. You get three figures, kept apart: what is owed now, where the period lands at its current pace, and what the next tier would take and pay.
Every field starts empty. To see how the worksheet reads a contract, load a fictional one.
Illustrative contract, synthetic numbers. A fictional Supplier A pays an annual wound closure rebate: 2% from $2,000,000, 4% from $3,000,000 and 6% from $4,000,000 of purchases, retrospective. It pays each quarter at the tier reached so far. The spend covers the first nine months, and the third-quarter payment date has passed.
These started as the illustrative contract and have been edited. The figures use your changes.
Your three figures
Each needs different work, so they stay on separate lines and are never added together.
Earned so far, less received
To see this figure, add the spend so far, at least one tier and how the ladder pays.
How this is calculated
- Earned: find the highest tier the spend has reached. Retrospective pays that tier’s rate on all of the spend. Stepped pays each tier’s rate on the spend inside that tier.
- Then earned minus received. It is owed now once the payment date has passed.
Full period at the current pace
Pace arithmetic, not a forecast
To see this figure, add the spend so far, at least one tier and how the ladder pays.
How this is calculated
- Monthly pace: spend so far ÷ months of purchasing.
- Full period: monthly pace × months in the period.
- Then the rebate the ladder pays at that spend.
Still within reach this period
To see this figure, add the spend so far, at least one tier and how the ladder pays.
How this is calculated
- Next tier: the tier above the one the pace lands in, or above the spend so far when there is no pace yet.
- Still needed: where that tier starts, minus the pace figure.
- Its value: the rebate with spend exactly at that tier’s threshold.
The pace is a straight line through the months so far. Rebate Recovery paces the same way, day by day, on the purchases each contract’s own rules admit, and labels the result as pace, not a forecast.
What this worksheet leaves out
Enter what it can take. Read the clause for the rest.
- Unit ladders, and per-unit or fixed-amount rates. Enter dollars and percent rates.
- Caps, floors, growth over a baseline, year-to-date cumulative tiers and per-product rate tables.
- Commitments that gate the rebate. The market-share worksheet covers those.
- Thresholds pro-rated for a partial year, and thresholds that rise each contract year.
- Stepped ladders where tier 1’s rate reaches back to the first dollar once tier 1 is reached. Contracts are worded both ways, so read yours.
- Seasonality. A straight line treats every month alike.
How Rebate Recovery does it
Rebate Recovery runs this arithmetic on every tiered rebate as purchase data loads. It counts only the purchases each contract’s own rules admit, and every result carries a sentence that explains it, including a $0. A rebate whose tier is set by market share or by the contract year is not projected period by period; the screen says so rather than guessing.
Three figures for every rebate, on one page: owed today, expected on current pace, and still open before the period closes. That page, the Recovery Center, is released to administrators first.
Run this contract against your purchases
Bring it to a working session and we load it as written: every tier, rule and commitment, checked against your purchase data. You see what it has earned, what has arrived and what is still open before the period closes.