How to calculate consignment payouts (with returns

Begin with the agreement, not the payout. “Ten percent commission” is incomplete until the business knows whether ten percent applies to the list price, the amount actually charged, or a value after specific fees. The agreement should also say who bears a discount and what happens when the buyer returns an item.

1. Write the agreement as a formula

A consignment agreement needs a handful of terms before any payout can be calculated:

Discount variant and commission base — one of two variants, never both: commission on the actual sale price (the amount charged, or the amount charged after entered card or platform fees), or commission on the original price with any discount shared by agreed shares.
Commission model — a percentage, a fixed amount per unit sold, or tiers. With tiers, decide explicitly whether each rate applies only to the part inside its band (marginal) or whether the rate reached applies to the whole base (retroactive). On a base of 1,500 with 10% up to 1,000 and 8% above, marginal tiers give 140 and retroactive tiers 120.
Discount authority and shares — the largest discount the shop may give without asking and, in the shared variant, what part of the discount each side carries.
Return window and holdback — how long a buyer can return an item, what is held back to cover that risk, and when it is released.
Lost or damaged items — what the consignor is credited if an item is lost or damaged in your care.

If terms change, start a new version with a new start date rather than editing the old one. Each sale should use the version in force on its sale date.

2. Keep item custody separate from money

Keep item custody separate from financial settlement. Received, available, reserved, sold, returned to owner, lost and damaged are inventory states. A consignor payable is a money balance. Changing an item to sold should create a sale line, not silently mark the consignor as already paid.

Consignment stock is not ordinary inventory: the item sits in your shop, but the consignor still owns it. A lost item is therefore not a sale; it is a custody event that may create a separate credit under the loss rule — say 50% of the list price.

3. Calculate the sale line, including discounts

For a simple sale of 100 with a 10% commission on the amount charged, commission is 10 and the consignor earning is 90. If a list-price 100 item is discounted to 90, the agreement decides — and it has to name one of two variants, never a mix of both.

Variant A — commission on the actual sale price. The discount already lowered the price, so it is not deducted a second time: 100 − 10 = 90 charged, commission 10% of 90 = 9 for the store, consignor earning 90 − 9 = 81.

Variant B — discount shared from the original agreed shares. The commission is agreed on the original price, and the discount is split by the agreed shares, here 50/50:

Component	Amount
Original price	100.00
Original commission: 10% of 100	10.00
Store share of the discount: 50% of 10	−5.00
Store keeps: 10 − 5	5.00
Consignor share of the discount: 50% of 10	−5.00
Consignor earning: 100 − 10 − 5	85.00

As formulas: store = original commission − discount × store share; consignor = original price − original commission − discount × consignor share. Both sides add up to the 90 the customer paid. Taking the commission from the reduced price and also deducting the consignor’s share of the discount would mix the two variants and count the discount twice.

A card or payment-platform fee the store pays comes out of the store’s side only. With a fee of 2 in variant B: consignor 85, store 5 − 2 = 3, payment provider 2 — check: 85 + 3 + 2 = 90.

4. Treat returns as linked reversals

Returns need a linked reversal. If the consignor was already paid, the reversal may create a negative balance carried into later earnings. Do not create a second invisible deduction and do not automatically debit an outside account.

The reversal is proportional and points to the original sale. If 45 of the 90 is refunded in variant B, the factor is 45 ÷ 90 = 0.5, and every price component of the original line is reversed by that share: the consignor earning by −42.50, the commission by −5.00 and the consignor’s discount share by −2.50. A payment fee the processor keeps is not restored automatically: the store’s side carries it, so its 3 becomes 0.50 after half the refund and −2.00 if the rest is refunded too — shown as it is, not set to zero. Each return is reversed once, and the refunds of one sale can never exceed what was charged. The original sale stays on record; the reversal sits in the period of the return date.

5. Hold back once, release once

A holdback can protect against return timing, but it must be a separate balance that is released once, not subtracted in every period. A common rule is “10% of earnings, at least 10”, released 30 days after the end of the period. On earnings of 89 that rule holds back 10; the statement shows the new holdback with its release date, and a later statement shows the same 10 coming back as a released holdback.

6. Check the ledger equation

A settlement ledger can be checked with one equation: opening payable plus new earnings plus released holdbacks, less new holdbacks and confirmed payouts, equals closing payable. If opening is 20, new earnings 89, a new holdback 10 and payout 50, the closing payable is 49. The statement should show that path and link each line to the sale, return or payment that created it.

Statement line	Amount
Opening payable	20.00
+ Earned this period (sale 85 + loss credit 4)	89.00
+ Released holdback	0.00
− New holdback	10.00
− Payouts confirmed	50.00
= Closing payable	49.00

If the closing payable is negative because a return arrived after a payout, it is carried forward and set against the next earnings. It is not collected from the consignor’s account.

7. Control payouts so nothing is paid twice

Payout records are evidence of a payment you made elsewhere, so the main risk is recording the same payment twice. Three controls help:

give every payout a unique ID that can never be reused;
make a retried command harmless — saving the same payout twice changes nothing;
flag a bank reference that already appears on another payout and ask for an explicit check before confirming.

Lock the period before review, so that nothing dated inside it can change while you check the statements, and post only after that review. A posted statement should be frozen; a correction is a reversal of the whole period, not an edit.

8. Reconcile quantities before you post

Finally, reconcile quantities. Opening stock plus intake and transfers in must equal available, reserved, sold, returned, lost, damaged and transfers out. A settlement should not post while the same serialized item appears sold twice. A physical count that differs from “available plus reserved” is a reason to stop and investigate, not to adjust the money quietly.

Doing it with a tool

Consignment Stock & Settlement Desk combines the custody check with the money statement. Every sale line shows its components, returns create linked reversals, holdbacks are their own balance, and duplicate payout IDs are stopped before they change the ledger twice. It is a control and settlement tool, not a point-of-sale system or payment service: it does not process cards, send money or decide tax questions.

Explore the fictional gallery and boutique examples to see how discount sharing, returns and payout controls work.

Explore the fictional demo · See the full tool