How to Calculate Consignment Commissions
The maths behind consignment commissions isn't complicated — until you add discounts, refunds, tiered rates, and multiple consignors with different terms. Getting the calculation right every time, on every item, is less a maths problem and more a data problem. Here's how it works, and where it tends to go wrong.
The basic calculation
A consignment split is a percentage of the sale price. If an item sells for $100 and your commission is 40%, you keep $40 and the consignor receives $60.
Written out:
- Store commission = sale price × commission rate
- Consignor payout = sale price − store commission
That's straightforward for a single item at a flat rate. The complexity builds when you have fifty consignors, some with 30% rates, some with 40%, items that were discounted, and a refund or two to account for.
When an item is discounted
Commission is almost always calculated on the actual sale price, not the original asking price. If an item was listed at $100 and sold at $70 after a markdown, the commission is calculated on $70. That means both the store and the consignor take less — and the consignor's payout statement needs to show the markdown clearly so they understand why.
Always calculate on the final sale price. Calculating on the original price and adjusting for the markdown separately is a common source of errors and disputes.
Tiered commission rates
Some stores use tiered rates — a higher consignor share on premium items, a lower share on lower-value items, or rates that vary by category. If you do this, each item's commission has to be calculated at the rate that applies to it, not a blanket store-wide rate. That's manageable in a spreadsheet with a few consignors; it becomes error-prone quickly as volume grows.
Handling refunds
When a customer returns an item, the sale reverses. If the consignor hasn't been paid out yet, their balance simply decreases. If they've already received the payout, you either need to deduct it from their next payout or address it separately. Either way, the refund has to flow through the commission calculation — you can't just zero out the sale without also reversing the commission.
Example: monthly payout calculation
| Item | Sale price | Rate | Store commission | Consignor share |
|---|---|---|---|---|
| Oak side table | $220 | 40% | $88 | $132 |
| Wool coat (marked down) | $65 | 35% | $22.75 | $42.25 |
| Ceramic lamp | $85 | 40% | $34 | $51 |
| Returned: belt | −$30 | 40% | −$12 | −$18 |
| Total | $340 | $132.75 | $207.25 |
That's what the statement should show — itemised, with the refund reversed, and a clear total. The consignor can check every line.
The tracking requirement
Accurate commission calculation depends entirely on accurate attribution. If a sale isn't tied to the right consignor at the right rate at the moment it happens, the commission is wrong before you've even started the calculation. That's the case for tracking systems that attribute sales automatically — not reconciled manually later from a receipt pile.