Consignment Sales Tracker

For consignment and resale shops, booth malls and seasonal consignment sales that sell other people's clothing, kids' gear, accessories, home decor or furniture.

Set your default consignor share, consignment period, pickup window, minimum payout and markdown schedule once. Tag each item to a consignor with its category, intake date and price. As items age, the workbook steps the price down on your schedule, rounds it to your price step, and shows the status: On floor, Expiring soon, Expired: awaiting pickup, Past pickup, Sold, Returned to consignor or Donated. When something sells, type the sold date (and the price if you accepted an offer); the consignor's share and the shop's commission calculate. The Consignors sheet totals each consignor's items, earnings and payouts, shows the balance owed and who's ready to be paid. Pick a consignor and month on the Consignor Statement to print what sold, their share, payouts and balance. The Monthly Summary and Dashboard show intake, sales, commission, payouts, returns and donations, average days to sell, floor value, items to pull and results by category.

Included: worked-example and blank workbooks (8 sheets, 111,662 formulas; room for 400 consignors, 5,000 items and 2,000 payouts), plus a 7-page PDF in US Letter and A4 with the markdown, split and payout rules and a worked item, a weekly and monthly floor routine, a consignor agreement checklist, a blank and a filled intake sheet, and an example consignor statement.

General information, not legal, tax or accounting advice. Consignment rules vary by state.