How do I settle sold consignment units and identify unexplained movement in the stock count?
The supplier is paid on recorded sales. A positive unexplained count is short stock; it is not automatically billable.
Open Consignment settlementTry the worked example
These are the example inputs from Consignment settlement. Replace them in the tool to run your own case.
| Opening stock (units) | New receipts (units) | Recorded sales (units) | Closing count (units) | Supplier share each (€/unit) |
|---|---|---|---|---|
| 250 | 120 | 196 | 168 | 4.5 |
Example result
Settlement on recorded sales · €882.00
Who uses this?
Trade concession manager. The free online tool runs the calculation in your browser. To edit the files and use the tools offline in one business, see the €49 offline edition.
Where the idea came from
A person reviews the output and handles exceptions before buying. This independent application adapts that idea to settle sold consignment units and identify unexplained movement in the stock count.
Original video