For the owner who builds the statements, and the rep who reads them
Rep commission on a spine case, without the spreadsheet.
One two-level fusion. One rep agreement. Three numbers before the statement is right. Spine reps are the best-compensated reps in the hospital, and they read their statements closely, so the number has to be right to the line and traceable to the case. This is how to build the statement so that it is: from the signed delivery order and the rep's own agreement, with nothing retyped and no monthly rebuild.
The short version
- Rep commission is a rate on a basis, and no two agreements are alike. A share of what the distributorship earns on the order, or a share of the sale after rebate and fees. The agreement can differ by manufacturer, hospital or surgeon, carry an override on cases the rep did not cover, set a fee for covering a colleague's case, and say what happens when two of its lines apply at once.
- The spreadsheet is rebuilt every month, and every rebuild drifts. A rate copied from last month, one manufacturer's rate on another manufacturer's order, a second rep missed.
- Calculate from the signed delivery order and the rep's own agreement, line by line. Nothing retyped, so nothing drifts.
- The rep can trace every line to the case it came from. That is what earns trust in the number.
- Earned is not paid. Show both. The gap is the purchase orders still being chased.
Why one case has three numbers on it
The numbers here are illustrative, not from any customer's books. A rep covers a two-level lumbar fusion: eight pedicle screws, two rods, two interbody cages, and a biologic on the same case. The signed delivery order bills the hospital $38,400: $30,900 of hardware and $7,500 of biologic. The manufacturer pays the distributorship 30 percent on the hardware and 20 percent on the biologic. The rep's agreement pays the rep 40 percent of what the distributorship earns on the order.
| Line | Billed | Distributorship earns | Rep earns |
|---|---|---|---|
| Implants: 8 pedicle screws, 2 rods, 2 cages | $30,900 | 30% · $9,270 | 40% of $10,770 |
| Biologic | $7,500 | 20% · $1,500 | |
| Case total | $38,400 | $10,770 | $4,308 |
Example figures only. Rates, bases and prices vary by manufacturer, hospital, contract and agreement.
Two manufacturer rates, one rep rate on one basis, one case, and the rep is owed $4,308. That is the simple case, and in a spine distributorship it is the exception.
The next rep is not paid 40 percent of the commission; she is paid 12 percent of the sale after rebates and fees, which on this order is a different number from a different column. The senior rep in the territory has an override: he is paid a share on every case at two of the hospitals whether or not he was in the room, and a different share at the third. One surgeon carries a rate of his own, because that is what it took to get the line in. On the day the first rep has two cases at once, a colleague covers one of them, and the agreement says what that costs: the covering rep's line drops to its assisted amount, or the assisting rep is owed a set fee from an à la carte chart that prices coverage by procedure at a junior and a senior level. One rep is salaried and still earns the coverage fee. When the hospital bought the biologic in bulk last quarter, the agreement says whether the rep is paid on that order or on its use in this case. And when two lines of the same agreement both apply to one order, the agreement says whether the most specific line pays or every line does.
Now carry all of that across a month of cases, several hospitals with their own contract sheets, two or three manufacturers with their own commission schedules, and every rep on an agreement of their own. That is the spreadsheet. Each rule in it is simple. There are just a great many of them, they interact, and the whole thing is rebuilt every month, by hand. No two rep agreements are the same lists every arrangement we have met.
Where the spreadsheet drifts
Nobody gets the arithmetic wrong. What goes wrong is everything around it, and each thing goes wrong quietly.
- The rate that changed. A rep's agreement moved from 40 to 42 percent in September. October's spreadsheet was copied from August's. Every line on the statement is 2 points short, and on this case that is $215, times every case.
- One manufacturer's rate on another's order. The rep is paid 40 percent on one manufacturer's orders and 35 on another's. A case with two manufacturers gets two delivery orders, and the second lands on the sheet under the first one's rate. On an order like this one that is $539 too much, and nobody notices until the margins do not reconcile.
- The line retyped. The signed order said $38,400. The spreadsheet says $34,800, because one cage line was typed from a photo of the sheet. Everything downstream of that number is wrong by the same amount, and the two records now disagree about what was sold.
- The second rep. An assisting rep covered half the case under a split. The sheet has one rep per row. The split gets handled by a note, and the note gets missed.
- The basis. One rep is paid a share of what the distributorship earns, another on the billed amount after rebates and fees. Same column header, different math. The sheet cannot tell.
Each of these is small. On a spine case that bills five figures, each is also real money, and a rep who is paid at this level reads the statement closely enough to find it. The next month is spent finding where the number came from instead of chasing purchase orders.
The agreement is a record, not a memory
The fix is not a better spreadsheet. It is to stop rebuilding. Write each rep's agreement down once, as a record, line by line: the rate and the basis for each line; the surgeon, hospital or manufacturer it names; whether it pays on every case or only the ones the rep covers; what an assisted case does to it; the coverage fee chart; whether the most specific line pays or all of them. Then calculate every statement from the signed delivery order and that agreement, one line per order. When a case is saved, the rate and basis in force are copied onto it, so a change to the agreement later never rewrites an old case: the old cases keep the old terms, the new cases get the new.
Done this way, the statement is never built. It is read off the signed orders. The case is signed on Tuesday and the rep's line for it exists on Tuesday, at the right rate, on the right basis, before anyone opens a spreadsheet. Several reps on one case is a record too: the covering rep and the assisting rep each have their own line, each under their own terms, and the split is fixed on the case the day it is saved.
What to hand the rep
A statement the rep can trace. For every line: the case number and date, the hospital, the delivery order it came from, the rate, the basis it was applied to, and the amount. The rep picks any line and finds the signed order behind it. That is the whole of what makes a statement trusted, and it is exactly what a rebuilt spreadsheet cannot offer, because the spreadsheet is the only record of itself.
One thing never goes on the statement: a patient identifier. The rep knows the case; the statement names it by case number. A money document never needs to know who the patient was, and the fewer places that identifier sits, the better for everyone.
Earned is not paid
The last number on the statement is really two. Earned is what the signed delivery orders say the rep is owed. Paid on collection is the part where the hospital's purchase order has landed and the money has come in. Which one the rep is actually paid on is a matter for the agreement. Show both on the statement either way, because the gap between them is the rep's own view of the purchase orders still being chased, and a rep with $4,308 pending on a case has an interest in that PO arriving. When a five-figure case sits unpaid for sixty days, the rep sees it on the statement instead of hearing about it. The PO that never came is the other half of this page.
Straight answers
How is rep commission calculated on a spine case?
From the signed delivery order and the rep's own agreement, one line per delivery order: one rate on one basis, copied onto the case when it was saved. See why one case has three numbers.
Why doesn't the statement match the spreadsheet?
Because the spreadsheet was rebuilt by hand and something drifted: a stale rate, one manufacturer's rate on another's order, the wrong basis, a missed split, a retyped line. See where the spreadsheet drifts.
Gross or net?
Whatever the rep's agreement says. The point is that the agreed basis is applied by the system every time, not remembered by a person. Keep the agreement as a record the statement is calculated from.
Can every rep have a different agreement?
Yes, and in most spine distributorships they do. One rep is paid on the sale and another on the commission; a senior rep has an override on cases at certain hospitals; a surgeon carries a rate of his own; covering a colleague's case pays a set fee from a chart by procedure and level; a salaried rep still earns that fee. The point of calculating from a record rather than a spreadsheet is that every one of those rules is written down once, per rep, and applied the same way every month.
What do I hand the rep?
A statement where every line traces to its case: case number, date, hospital, delivery order, rates, basis, amount, and whether it is earned, pending or paid. No patient identifier.
Paid on signing or on collection?
Per the agreement. Show both numbers either way. The gap is the purchase orders still being chased, and the rep can see it.
What this looks like in FieldRep Ops
FieldRep Ops is the financial system of record for independent spine distributorships, and this is how it pays reps. Each rep's agreement lives in the system, set up the way their contract reads: each line on the sale, on the commission or a flat amount; by surgeon, hospital or manufacturer; paid on every case or only when the rep covers it; assisted cases, à la carte coverage fees by procedure and level, salaried reps and hospital-owned stock each handled as the agreement says. The terms are copied onto the case when it is saved, so a later change never rewrites history. Every statement is calculated from the signed delivery order under those terms, one line per order, the moment the order is signed. Several people paid on one case each get their own line under their own terms, and the split is fixed per case. When leadership closes the month the statement is final; a change after that produces a version two with a reason, never a quiet rewrite. A rep signs in and sees the same lines leadership sees for their own cases, with every line traceable to the case it came from; leadership sees everyone's. No money surface in the system shows a patient identifier.
The statement shows what is earned, what is payable yet and what has been paid, so the rep sees the same open purchase orders the office is chasing. And because the statement is read off the signed orders rather than built, there is nothing to rebuild: every total in the system is reconciled back to the signed delivery orders before every release and every week in production, so the statement and the month end cannot quietly disagree.
Founding distributors
We are taking on a small number of founding spine distributors now, who use FieldRep Ops free while it proves itself on their books and know the price before they start. One private environment per distributorship; nothing shared with anyone.