Reconcile Consignment Proceeds After Refunds and Commission — Free
Gross consignment sales are not the amount a maker receives. Separate refunded sales, the commission base and the remaining proceeds before querying a settlement.
The proof surface
Royalty audits apply licensing statements and rates. This models consignment commission charged on sales after refunds, with no inference about contract entitlement.
Why the flat version breaks
Charging commission on the wrong base
A gross-sales contract will not match this net-sales model.
Treating refunds as a second deduction
Subtract them once when forming net sales, not again after commission.
Calling the result the bank deposit
Other agreed charges and timing differences may still change the payout.
How to work the consignment settlement stub
Use this only when your agreement charges commission on gross sales less refunds. Agreements that retain commission on refunds need a different calculation.
Record sales and refunds for the same settlement basis. If refunds exceed this period’s sales, reconcile across periods outside this model instead of forcing a negative net base.
Due = (gross − refunds) × (1 − commission percent ÷ 100). March’s 900 net sales at 30 percent commission leave 630; April leaves 350.
The output excludes tax, card fees, shipping, reserves and prior balances. Flagged refund rows invite checking, not an accusation of underpayment.
What the consignment settlement stub replaces
| Question | Before | Visible working |
|---|---|---|
| Charging commission on the wrong base | A gross-sales contract will not match this net-sales model. | Use consistent period totals |
| Treating refunds as a second deduction | Subtract them once when forming net sales, not again after commission. | Subtract commission from net sales |
| Calling the result the bank deposit | Other agreed charges and timing differences may still change the payout. | Reconcile the rest of the statement |
A local arithmetic aid replaces hand calculation, not expert review. No paid AI service is needed.
Run it on the samples, right here
FIRST-LOAD
Research prototype — checkout unavailable. Input is processed locally and a draft is saved automatically in this browser profile when storage is available. Reset to sample clears that draft; Pro history has its own clear button. A state link encodes your inputs in its URL: share only non-sensitive rows. Browser history, clipboard and anyone receiving the link may retain it. Optional AI use below leaves this device; it is not required.
Illustrative settlement arithmetic, not legal, tax or accounting advice. Read the agreement and consult an appropriate professional about disputed deductions.
Data note: Everything runs in this browser tab on the consignment settlement stub: your sales period | gross sales units | refunded sales units stays on this device, nothing is uploaded, and the reading is rebuilt only when you press run.
Go deeper: the companion app files the same reading as a punched ticket stubs
The article demo above runs without limits. The companion app keeps a local history, exports the rows as CSV, prints the consignment settlement stub reading, and holds your drafts on this device — one complete free run; the proposed $4 one-time filing layer is not currently for sale.
The consignment settlement stub reading is complete for free. The optional $4 layer adds print, row CSV and the last five local reading summaries; it does not add hidden answers. Checkout is not configured yet; the article demo remains unlimited.
Open the reconcile consignment proceeds after refunds and commission companionBoundary
Illustrative settlement arithmetic, not legal, tax or accounting advice. Read the agreement and consult an appropriate professional about disputed deductions.
What this is built on
- Method: Due = (gross − refunds) × (1 − commission percent ÷ 100). March’s 900 net sales at 30 percent commission leave 630; April leaves 350.
- All sample records are invented examples. The app does not fetch measurements, policies, files or personal records.
- Google’s official pricing page, fetched 2026-09-29, lists free-tier access including AI Studio. Optional formatting only; limits and availability can change. Free-tier content may be used to improve products. Never paste private records there.
Before: A gross-sales contract will not match this net-sales model. After: the consignment settlement stub shows the working beside each named row so the reader can change the assumption and inspect the consequence.
Optional AI formatting, not calculation
For this consignment settlement stub, use the free AI Studio interface only if available to you, with no paid API key. Manual entry completes the same workflow for free. Supply only fictional or non-sensitive notes. Review its output against the source; never paste unresolved questions into the numeric rows.
Format my non-sensitive notes for a consignment settlement stub. Return plain rows only: sales period | gross sales units | refunded sales units. Preserve supplied quantities exactly. Do not guess missing values; list questions separately. Do not calculate or add advice. I will check every row before pasting into the local tool.
Accepted schema: sales period | gross sales units | refunded sales units. No AI response is executed as code.