Consignment Report
The Consignment Report shows what consignment items were sold (and what you owe each vendor) plus what's currently in stock, for the store you're signed into.
For a full guide on setting up and managing consignment items, see Consignment Items.
Filters
Use the date range at the top of the report:
- From / — date fields — select start and end dates for the Sold/Returned section (defaults to the last 7 days)
- Click View to generate the report
Sold/Returned
Shows all consignment items sold or returned in the selected period, grouped by vendor with subtotals:
| Column | Description |
|---|---|
| PLU | Item number (links to item page) |
| Description | Item name and size |
| Sold Qty | Quantity sold in the period |
| Total Price | Total revenue from consignment sales, after any discounts |
| Reg Total Price | What the sales would have totaled at regular price |
| Avg Margin | Average margin percentage |
| Total Cost | Total cost owed to the vendor |
Vendor subtotals appear at the bottom of each vendor's group — use these to calculate payments owed to each consignor for the period. If nothing sold, the section shows "There were no consignment items sold/returned in the period."
On Hand Now
Shows all consignment items currently in stock (on-hand quantity is not zero):
| Column | Description |
|---|---|
| Vendor | The consignor who owns the stock |
| PLU | Item number (links to item page) |
| Description | Item name and size |
| On Hand | Current stock quantity |
| Price | Current retail price |
| Cost/Margin | The fixed cost % (shown in italics) or the average cost per unit |