FREE · NO ACCOUNT NEEDED
Consignment Settlement Planner
Prepare a consignment payout worksheet from net sales, agreed store commission, consignor fees and amounts already paid. Review each settlement balance.
Updated October 16, 2026 · Free browser worksheet · CSV, backup & print
- 1Set up
- 2Add records
- 3Review & save
Set up your worksheet
Start with the fictional example. Replace the sample with your own records and review assumptions before acting on a result.
Your report
Wide tables: swipe sideways, or focus a table and use the arrow keys to see more columns.
Enter your details and records, then calculate to review the results.
Save or download your work
Work stays in this page until you choose Save on this device. Device saves belong to this browser and can be removed by clearing browser data. JSON keeps an editable backup; CSV and PDF keep a report.
Consignment Settlement Planner: guide and worked example
What this free planner does
- Separate store commission, post-split fees, consignor entitlement and prior payouts.
- Group settlement balances by consignor for review.
- Keep negative balances visible when previous payments or fees exceed entitlement.
- Up to 100 editable records, device save and restore, portable JSON backups, CSV reports and browser printing.
How to use the planner
- Enter a review label, date and one currency.
- Use a unique reference for each settlement line and identify the consignor consistently.
- Enter collected sales after discounts excluding tax, refunds, the agreed store share, post-split fees and prior payouts.
- Review balances with the signed consignment terms and payment records before paying anyone.
Inputs, units and field rules
| Field | What to enter |
|---|---|
| Worksheet label | Required. Up to 160 characters. |
| Review date | Required. Calendar date, 1900–2200. |
| Currency (no conversion) | Required. Choose USD, GBP, CAD, AUD, EUR, NZD, AED. |
| Settlement line reference (unique) | Required. Up to 160 characters. |
| Consignor / owner | Required. Up to 160 characters. |
| Sales collected after discounts (excluding tax) | Required. Up to two decimal places from 0 to 1000000. |
| Refunds on these sales (excluding tax) | Required. Up to two decimal places from 0 to 1000000. |
| Store commission (%) | Required. Up to two decimal places from 0 to 100. |
| Agreed consignor fees after split | Required. Up to two decimal places from 0 to 1000000. |
| Already paid to consignor | Required. Up to two decimal places from 0 to 1000000. |
Consignment Payout Calculator & Settlement Planner formulas
Net sales = sales − refunds. Store commission = net sales × store commission percentage, rounded to cents on each row. Consignor entitlement = net sales − commission − agreed fees. Remaining settlement balance = consignor entitlement − already paid.
Worked example with fictional data
For $200 of sales and $20 of refunds, net sales are $180. A 40% store commission is $72. After $8 in agreed consignor fees, entitlement is $100. With $50 already paid, the remaining settlement balance is $50. Store commission plus fees is $80 before the store’s own costs.
Choose Load fictional example above to reproduce these results. Sample records are illustrative and are not a recommended target or policy.
Review the result before acting
Confirm who bears refunds and fees before entering figures. Do not deduct the same discount or refund twice. Use separate references for returns from earlier periods and reconcile them under your agreement outside this simplified worksheet when the original sale is not in the same scope. A negative balance needs investigation, not an automatic collection action.
What the planner does not cover
This version supports commission on net sales with consignor fees deducted after the split. It does not implement fees before the split, tax-inclusive commission, item-level tiered rates or cross-currency conversion. Refunds cannot exceed entered sales on a line. Store commission plus fees is not store profit.
Save, restore and export
Add entry creates another record. Edit any field directly or use Remove entry to delete a row. Changing inputs clears the previous report so it cannot be mistaken for current results. Choose Calculate / review results again when your changes are ready.
Save on this device keeps an editable worksheet in this browser only. On a later visit in this browser, your saved worksheet loads automatically. Restore device save can also reload the last save after you confirm replacement. Saving drafts is allowed, but a report requires valid, complete inputs. Download backup creates a versioned JSON file for the same tool. Import backup shows the worksheet label and row count before replacing current work; it does not change the device save until you press Save.
Download CSV exports the settings, summary, row details and calculation notes. CSV is for spreadsheet review; it cannot restore this worksheet. Print / Save PDF recalculates the current entries and opens your browser’s print dialog. Choose Save as PDF where supported. The report excludes navigation, guides and product CTAs. Clear data removes the current worksheet and its device save after confirmation; keep a backup first if needed.
Use a personal browser for private records and keep important backups separately. Entered worksheet fields are not included in our planner-action analytics.
On Android Chrome, device save stays in the same browser. Keep a JSON backup for portability. For PDF, use the browser print dialog and choose Save as PDF when available; printer and share menus vary by device. Physical phone behavior depends on the device and is not certified by desktop browser tests.
Frequently asked questions
Is the percentage the store’s share?
Yes. Enter the store commission percentage. The consignor receives the remaining net sales before agreed post-split fees.
Can a remaining balance be negative?
Yes. Prior payouts or fees can exceed entitlement. The report preserves the signed balance and flags it for review.
Does this send a payout?
No. It prepares a manual report and does not connect to banking or accounting accounts.
Is it free, and where is my information saved?
The worksheet is free without an account. Save on this device uses this browser’s storage; clearing browser data can remove it. Download a JSON backup for editable recovery. There is no cloud sync or automatic monitoring. CSV and PDF are reports and cannot restore the worksheet.
Continue the workflow
WHEN YOU NEED A BROADER WORKFLOW
ConsignClear OS
Keep using this free worksheet for this focused task. For a broader workflow, read the full product guide and preview the planner to decide whether it fits. Free worksheet backups do not import into the paid application.