Consignment stock needs an owner as well as a quantity. A resale shop may hold a jacket, display it and sell it without having bought it for its own inventory. If the item record loses the consignor, agreed split or current status, the shop can sell the right piece and still pay the wrong amount. Track each item from agreement and intake to sale, adjustment, payout or unsold return. This guide is an operational recordkeeping example, not a determination of legal title, tax treatment or revenue recognition.
1. Record the agreement before accepting an item
Give each consignor a stable ID and record the agreement version, accepted date, selling period, price approval rule, commission split, fee treatment, markdown permission, return terms and payout timing. A shop may have different terms for two consignors. Do not apply a global percentage without checking the item’s actual agreement. Store the signed terms with the records under your own document process; a planning app does not replace the agreement.
For the example, owner C-014 consigns a vintage jacket on September 29. The agreed tag price is $180, the shop keeps 40% of the sale price and the owner receives 60%. The example assumes no taxes, channel fees, discounts or refunds. It is fictional, and the agreed terms control a real transaction.
2. Identify the physical item at intake
Assign a unique item ID, such as C-014-JKT-001. Record description, size, condition, intake photos, agreed tag price, agreement ID, intake date and return-by date. Print or write a tag that can be matched to the record without exposing private owner details to shoppers. Two similar jackets from different people need two IDs. A grouped count like “vintage jackets: 2” is not enough to settle ownership after one sells.
Set initial status to available only after inspection and acceptance. Use separate statuses for pending inspection, reserved, sold, returned, damaged and missing, with dated changes. If a customer merely asks about the jacket, the item remains available unless the shop’s written hold policy creates a timed reservation. Do not count a sold item as physically available while waiting for the payout.
| Field | Example value | Why it matters |
|---|---|---|
| Item ID | C-014-JKT-001 | Joins tag, sale and payout |
| Consignor / agreement | C-014 / AG-014-v2 | Locates applicable terms |
| Description / condition | Vintage jacket / good, cuff mark | Supports handoff and return |
| Price / split | $180 / owner 60%, shop 40% | Basis for settlement |
| Intake / return-by | Sep 29 / Nov 28 | Prompts review of unsold stock |
| Status / reference | Available / intake IN-0929 | Shows current custody |
This is a copyable field list, not a downloadable file. Add location, barcode or serial fields if they are useful for the goods you hold.
3. Connect the sale to the exact item
Suppose the jacket sells for $180 on October 10 with no discount or tax in this simplified case. Record the sales reference, item ID, sale date, actual merchandise amount, payment status and buyer-return window. On the agreed 60/40 split, the owner share is $180 × 0.60 = $108 and the shop share is $180 × 0.40 = $72. The $108 is an amount owed under the modeled terms, not $108 of free shop cash. The example does not determine formal accounting entries.
If a $12 channel fee applies and the agreement says the owner bears it, the owner amount would be $96 under that stated rule; if the shop bears it, the owner remains at $108 and the shop’s net amount falls to $60. Do not silently choose one treatment. Record the fee, who bears it and the exact agreement clause. A discount or partial refund also needs its own documented rule.
4. Hold adjustments and payouts as separate events
A sale creates a pending settlement; a payout is a later money movement. Keep the $108 payable pending until the owner-approved amount is confirmed against refunds, fees and return terms. If the buyer returns the jacket before payout, record the customer refund and physical condition separately. The return does not by itself prove it can go straight back to sellable stock, nor does it automatically prescribe how a previously paid consignor amount is recovered. Follow the agreement and applicable professional advice.
When the shop pays the fictional $108, record date, amount, method, payment reference and recipient confirmation. Preserve the sale and calculation history. Do not overwrite the original sale with a “paid” amount in the same field. Reconcile the list of unpaid owner balances to the payout queue and the actual bank payments. A pending balance is not proof the bank has sent money.
| Event | Item status | Owner amount in this example | Evidence to retain |
|---|---|---|---|
| Accepted intake | Available | $0 | Agreement, photos, tag |
| $180 sale | Sold | $108 pending | Receipt, split calculation |
| Owner payout | Sold / settled | $0 pending after $108 paid | Payment reference |
| Unsold return instead of sale | Returned to owner | $0 | Dated handoff acknowledgement |
The last row is an alternative path, not another event after the modeled sale. This distinction prevents an item from being both sold and returned unsold in a single history.
5. Review unsold items and exceptions weekly
Sort by return-by date, age, missing owner, missing agreement, price change awaiting approval and sold-but-unsettled status. A 60-day selling period starting September 29 should trigger a review before the agreed return date, not an assumption that all shops use a standard 60 days. Check the physical tag against the register for any item that has not moved. An untagged jacket or a sale with no item ID is an exception to resolve before a payout is calculated.
For a shop with 80 accepted items, imagine 9 sold, 6 returned unsold and 2 under inspection. Its statuses should reconcile to 63 available if there are no other movements: 80 − 9 − 6 − 2 = 63. If the register says 64, locate the missing event. A totals-only dashboard will not explain which owner’s item caused the difference.
6. Use the system that fits the ownership workflow
A simple sheet can work if item IDs, agreements, dated movements and settlement references are maintained consistently. The boutique inventory spreadsheet guide describes variant stock for goods the shop counts, but consignment adds item ownership and payout obligations. ConsignClear OS is a paid offline app with consignor records, intake, item statuses, split and payout reviews, and JSON backup. Its user guide describes the actual screens. The app helps organize decisions; it does not send payments or make legal or accounting judgments for the owner.
Common questions
Is consignment inventory the same as inventory I bought? Operationally both need stock and sales tracking, but consignment requires an owner, agreement and settlement trail. The formal accounting treatment depends on facts and professional guidance.
What if two owners bring the same product? Keep separate item IDs or otherwise unambiguous ownership records. A shared product name or SKU alone should not decide who gets paid.
Should I pay the consignor as soon as the item sells? Follow the actual agreement and return/refund policy. Separate the recorded sale, amount owed, owner approval and completed payment so timing is auditable.
Reconcile a refund after the owner has already been paid
Return to the fictional $180 jacket sale with a 60% owner share and 40% shop share. Suppose the shop paid the original $108 owner amount, then later approved a $30 merchandise refund while the buyer kept the jacket. Under this additional example's explicit agreement assumption, the refund reduces both shares proportionately: net merchandise is $150, owner share is $90 and shop share is $60. The $18 difference between the $108 already paid and the revised $90 owner amount needs a documented settlement action.
The item remains sold because this is a partial money refund with no physical return. Do not add a jacket to available stock. The $18 is also not proof that the shop can debit the owner or offset another payout. Record the adjustment for agreement review and follow the actual authorized recovery process. Fee, tax and return treatments are excluded from this simplified example.
| Record | Amount | Meaning |
|---|---|---|
| Original merchandise sale | $180 | Preserved sale history |
| Customer partial refund | $30 | Separate money event; no item return |
| Revised owner share | $90 | $150 × 60% |
| Owner already paid | $108 | Confirmed historical payment |
| Settlement difference for review | $18 | Recovery or offset subject to agreement and approval |
Retain the refund reference, reason, approval and calculation alongside the original sale and payment. If a later approved offset settles the $18, record its own date and reference. Do not rewrite the historical payout as $90; the bank actually paid $108. A settlement report should explain the difference.
Run two reconciliations at period end
First reconcile physical items: accepted, available, reserved, sold, held, returned to owner and any unexplained custody exceptions. Then reconcile money by consignor: opening pending settlement plus new agreed shares minus approved adjustments and completed payments. Label unsettled exceptions separately rather than netting them against unrelated owners. The order-tracking workflow helps keep the customer action and its evidence distinct from the consignor settlement.