A rebate year, worked throughOne supplier contract from signature to statement

Every name and figure in this article is invented: the five-hospital system, the supplier, the product, the dates and the dollar amounts. The arithmetic is the point. It is what a rebate analyst does, or should do, every quarter, and it is the same in a spreadsheet as in software.

The contract

A five-hospital system (North, West, Main, East and South Campus) signs a one-year agreement with Vantrell Surgical for its VantraSeal surgical sealant line, running January 1 to December 31. Three rebate terms and the payment clause matter here.

Term	What the clause says
Volume rebate	A retrospective ladder on each quarter’s invoiced purchases: 2% from $1,000,000, 3% from $1,500,000, 4% from $2,000,000, nothing below. The rate earned applies to every dollar in the quarter, back to the first. Each quarter stands alone.
Share rebate	A further 1.5% on the quarter’s purchases, provided VantraSeal holds at least 75% of the system’s spend on surgical sealants, all makers, measured each quarter.
Conversion rebate	3% on VantraSeal purchases at South Campus, acquired last year and converting from another maker’s sealant, for the contract year.
Payment	Quarterly, within 45 days of quarter end: May 15, August 14, November 14 and February 14.

Before the first invoice loads, write down the three figures you will keep apart all year.

• Earned is contract math applied to your own purchase data. It exists the moment the period’s purchases are known, whether or not anyone has paid.
• Received is cash that arrived, with the remittance that explains it.
• Owed is earned minus received, carried line by line with a reason: not yet due, past due, paid short, under claim. The reason decides what to do about it.

A fourth figure, lost, is money the contract made available and the quarter did not win, for instance a share rebate behind a share that fell short. It is not owed, and it is never netted into earned.

First quarter: the payment is late

Purchases invoiced January to March total $1,640,000, which lands on the 3% rung: $49,200. VantraSeal’s share of sealant spend across the five hospitals reads 79% ($1,640,000 of $2,080,000), so the share rebate pays too: 1.5% of $1,640,000 is $24,600. Earned for the quarter, $73,800.

The conversion rebate reads $0. It looks like a quiet start, and nobody looks further.

May 15 passes with no payment. The $73,800 changes reason from “not yet due” to “past due” and sits there until a check for $73,800 arrives on June 20, 36 days late. Received now matches earned. Keep the lateness on the record, though. One late payment is an accident; two is a pattern to raise at the business review.

Second quarter: paid at the wrong tier

April to June purchases total $2,040,000, which crosses the 4% rung: $81,600. The share reads 78% ($2,040,000 of $2,615,000), so the share rebate is $30,600. Earned, $112,200.

The supplier’s remittance arrives on August 10, four days early, for $91,800, in two lines: volume rebate $61,200, share rebate $30,600.

Here is the method for reading a remittance against contract math. Divide first: $61,200 by $2,040,000 is exactly 3.0%, so the supplier used the same purchase total you did and a lower rung. Had the division produced an odd figure, the disagreement would be about the base (which invoices count, and in which quarter), and the next step a line-by-line comparison of purchases. It did not. This is a tier dispute, and it takes one email: the quarter’s total, the ladder as signed, the rung. The supplier’s system held the 4% threshold at $2,100,000, the figure from an earlier draft of the agreement. The missing $20,400 is owed, reason “paid short”, until it arrives with the next remittance on October 5.

Had the remittance been a single line, the same division would still have found it: $91,800 against $112,200 is short by exactly 1% of the base, one rung of the ladder.

Third quarter: the share falls, and a zero gets questioned

July to September purchases total $1,780,000: 3%, $53,400. The share reads 73% ($1,780,000 of $2,440,000), because West Campus trialed another maker’s sealant for the quarter. The quarter’s share rebate, $26,700, is lost. That is the clause working as written, and it goes on the year’s statement as lost, not as owed.

In September the analyst runs the check every rebate program should run: list every term that read $0 in two or more consecutive closed periods. The conversion rebate is the only one. Its scope is a single facility, and a facility scope works only through the mapping between the hospital named in the agreement and the ship-to codes on invoices. South Campus’s codes were mapped to nothing: the schedule to the agreement listed the hospital under the name it carried before the acquisition. The ladder never noticed, because it has no facility filter and counted every invoice. The one term that filters on the facility found nothing.

The supplier’s remittances had shown the conversion rebate at $0 as well, from the same cause on their side. A zero both sides agree on draws less attention than one they dispute.

Fix the mapping, recalculate the closed quarters, and the term reads $3,300 for the first quarter, $3,750 for the second and $4,200 for the third. The three go on an October claim, $11,250 in total, owed with the reason “under claim”. The November 12 remittance covers the ladder, $53,400, and lists the claim as under review.

Fourth quarter: owed, but not yet due

October to December purchases total $2,150,000: 4%, $86,000. The share reads 80% ($2,150,000 of $2,690,000), so the share rebate is $32,250, and South Campus, now mapped, earns $4,500. Earned, $122,750. On December 31 all of it is owed with the reason “not yet due”, and that reason keeps it off the past-due list until February 14. Money that is not yet late is a different line from money that is.

The statement at December 31

Quarter	Purchases	Ladder	Share	Conversion	Earned	Received	Note
Q1	$1,640,000	$49,200	$24,600	$3,300	$77,100	$73,800	Paid 36 days late
Q2	$2,040,000	$81,600	$30,600	$3,750	$115,950	$112,200	Paid at 3%; $20,400 recovered
Q3	$1,780,000	$53,400	lost	$4,200	$57,600	$53,400	Share 73%
Q4	$2,150,000	$86,000	$32,250	$4,500	$122,750	$0	Due February 14
Year	$7,610,000	$270,200	$87,450	$15,750	$373,400	$239,400

Earned includes the conversion rebate as recalculated in September; for the first two quarters it read $0 on both sides.

Statement line	Amount
Earned, four quarters	$373,400
Received	$239,400
Owed, under claim: conversion rebate, Q1 to Q3	$11,250
Owed, not yet due: Q4, payable by February 14	$122,750
Lost: Q3 share rebate	$26,700

Earned equals received plus the two owed lines. That is the check to run before anyone signs the statement, and lost sits outside the sum.

Still open before the year closed: the $11,250 claim, waiting on the supplier’s review; the Q4 payment, not due for six weeks; and one question to put to the agreement rather than to the supplier. The share clause says “measured each quarter”. Had it said “over the contract year”, the year’s share would read $7,610,000 against $9,825,000 of sealant spend, 77%, above the line, and the $26,700 would move from lost to owed. One word in a clause. Read it before you concede a loss.

What the method comes to

Three habits carried this year. Earned was computed from the system’s own purchase data before any remittance arrived, so each remittance had something to be read against. Every remittance was divided by the base before it was banked, which turns “the number looks low” into “the rate is one rung short” or “the base is $40,000 light”. And every zero in two consecutive closed periods was questioned, including the one the supplier agreed with. None of it needed the supplier to have done anything wrong. A late check, a threshold from an old draft and a hospital under its former name are ordinary. Noticing all three in the year they happen is not.