Get the agreement right first
- Commission % and when it's paid
- Who is responsible for damage or theft
- How often stock is counted together
- How and when unsold stock comes back
Free template · Excel & Google Sheets
Free consignment inventory template
Know what's on every partner's shelf and what you're owed. Log units placed, sold and returned — the sheet works out remaining stock and your payout.
The Excel file includes working formulas in the “Remaining” and “Amount owed” columns, filters and 50 ready-to-fill rows. Open it in Excel or upload it to Google Sheets.
| Partner / site | Product | SKU | Placed | Sold | Returned | Unit price | Commission % | Remaining | Amount owed |
|---|---|---|---|---|---|---|---|---|---|
| Corner Gift Shop | Soy candle 200 g | CND-200 | 24 | 15 | 0 | 18 | 30 | auto | auto |
| Corner Gift Shop | Ceramic mug | MUG-CER | 12 | 4 | 1 | 14 | 30 | auto | auto |
| Farm Market Stall | Soy candle 200 g | CND-200 | 20 | 18 | 0 | 18 | 20 | auto | auto |
Monthly reconciliation in 4 steps
- Get the partner's sales report.
- Update Sold and Returned.
- Count what's on the shelf and compare with Remaining.
- Invoice the Amount owed.
Treat every partner store as its own location
StockSimple tracks stock per location with transfers, stock counts and a full movement history, so consignment numbers always reconcile. From $6.99/month, 14-day free trial.
Try StockSimple freeFrequently asked questions
What is consignment inventory?
Stock you still own but that sits at someone else's location — a retailer, a client site or a partner store. You only get paid for what sells, so you need to know exactly what was placed, sold and returned.
How does the template calculate what I'm owed?
Remaining = placed − sold − returned. Amount owed = sold × unit price × (1 − the partner's commission %). Both are calculated automatically in the Excel file.
How often should consignment stock be reconciled?
Monthly is common. Count what's left on site, compare it with the Remaining column, and invoice for the units sold.
Who should use a consignment tracker?
Makers selling through shops, wholesalers placing stock with retailers, and suppliers keeping parts at customer sites.
Can StockSimple track stock at other people's sites?
Yes. Add each partner site as a location, transfer stock to it, and record sales as stock out — every movement is logged with who did it and when.
More free inventory tools
Free SKU generator
Clean, consistent product codes with CSV export.
QR code inventory labels
Printable QR label sheets for bins and products.
Asset tag generator
Numbered QR asset tags for tools and equipment.
Bin location generator
Zone-aisle-rack-shelf codes for every shelf.
Inventory spreadsheet template
Excel & Google Sheets stock sheet with formulas.
Van stock template
Truck parts list with minimums and reorder flags.
Formulas guide
Worked examples of every formula, in plain language.