Two returns need different records
An owner pickup changes where an unsold item is held. A customer refund may change the sale, money collected, stock location and the amount owed to an owner. Treating both as one status can hide a financial follow-up.
Shopify’s consignment guidance explains the relationship between inventory held for an owner and payment after a sale. The actual agreement governs your shop’s commission, return period and settlement. The example here is an original recordkeeping tool, not accounting or legal advice, and does not assume every shop permits customer refunds.
| Event | Preserve | Add or verify |
|---|---|---|
| Unsold owner pickup | Intake ID; owner; original terms | Pickup date; quantity; condition; acknowledgment |
| Customer refund before owner payout | Item and original sale IDs | Refund proof; stock location; corrected payout basis |
| Customer refund after owner payout | Sale and paid payout references | Refund proof; agreement check; unresolved settlement note |
If you cannot find the original item, pause and resolve its identity first. Two similar jackets need separate IDs. A return note attached to the wrong owner can make an otherwise accurate amount misleading.
Worked example: refund after a payout
Item EX-J17 sold for an illustrative $100. The fictional agreement gives the owner 60% and the shop 40%; the $60 owner payout was already made. Later, the shop accepts a full $100 customer refund. Keep those three events distinct. Do not delete the sale and do not mark the owner’s $60 as recovered when no recovery occurred.
| Event | Reference | Money event | Remaining question |
|---|---|---|---|
| Sale | EX-S1 linked to EX-J17 | $100 received | Confirm agreement and split |
| Owner payout | EX-P1 linked to EX-S1 | $60 paid | Retain payment proof |
| Customer refund | EX-R1 linked to EX-S1 | $100 refunded | How does the agreement handle the paid owner share? |
| Settlement review | EX-C1 linked to EX-P1 | No new payment confirmed | Discuss recovery or adjustment; do not book an invented transfer |
The cash history includes $100 in, $60 out and $100 out: a net −$60 across these events. That arithmetic is not a profit calculation and does not establish a debt owed by the owner. Taxes, fees, inventory condition and your agreement can change how an accountant records the correction.
Close the physical trail too
Inspect the returned item and record its quantity, condition and actual destination. Is it back on the sales floor, in a review area, damaged or returned to the owner? Do not automatically reactivate it before checking the agreement and whether it can be sold again.
For an unsold owner pickup, use a simpler trail: retain intake EX-J18, add the pickup date and acknowledgment, and record that the item is no longer in shop custody. There is no sale or customer refund to invent. If a quantity of two was accepted and only one is collected, record the remaining quantity explicitly.
Before the next payout, reconcile the record with payment confirmations and the agreed settlement. A note saying “refund processed” should have a real refund reference. A note saying “owner settlement pending” stays pending until the actual resolution is documented. Keep names and payment details private; the downloadable examples use fictional identifiers.
Use the inventory app within its current limits
Consignment Tracker: Cue’s current listing describes consignors, item intake, inventory statuses, sale splits, payouts and closeout records. Those functions help keep each item connected to its owner. The listing does not establish a customer-refund transaction engine or an automatic reversal of a previously paid payout.
Use the app’s listed inventory and payout functions where appropriate, and keep a separate correction trail when the workflow you need is not supported. Do not use a returned item status as evidence that a card refund or payout reversal occurred. The listing says Premium unlocks unlimited consignors and items, advanced payout workflows, full daily report history and export-ready summaries. Check current subscription terms before relying on a workflow; this CSV works independently of the app.
If the method fits your task, explore Consignment Tracker: Cue’s listed features on an iPhone. Check current features and plans before downloading.
See Consignment Tracker: Cue for iOSDownload the free worksheet
Use the CSV in Numbers, Excel or a spreadsheet editor. Amounts, IDs and terms are fictional; the CSV has no formulas and is not an accounting system. Replace them with your own observations. The CSV is separate from the app and no email is required.
Questions answered
Does marking an item returned refund the customer?
No. A stock status does not prove a payment action. Verify the actual payment system and retain its confirmation.
Should I delete the original sale?
Preserve its reference and add the dated refund or correction, so the money and item trail remain understandable.
Can I deduct an already paid share automatically?
Do not assume that. Check your agreement and appropriate professional guidance, then document the actual settlement.
Continue with Consignment Tracker: Cue on iOS
Use the App Store listing to check compatibility, privacy information and current plan terms. A free download may offer paid features.
Download Consignment Tracker: Cue for iOSSources and product details
- Shopify: consignment inventoryExplains owner-held inventory, sales and payment relationships. It does not prescribe this example’s commission or refund terms.
- Consignment Tracker: Cue on the App StoreCurrent US App Store product description; checked October 10, 2026.
Editorial method: primary guidance, a current Apple listing, an original worked example and an independent critique. No search ranking, install or outcome result is claimed.