Consignment Inventory Tracker, Consignor Payout Template, Resale Shop Sales Log, Thrift Store Spreadsheet (Google Sheets)

CONSIGNMENT INVENTORY TRACKER — Google Sheets Template

Run your consignment or resale shop the easy way. Track every item, every consignor, and every payout in one beautiful spreadsheet — and always know exactly who you owe. Enter an item once and the sheet does the math: both shares, days on the floor, expiration alerts, and consignor balances update themselves.

Perfect for consignment stores, thrift shops, resale boutiques, vintage sellers, and anyone selling items on behalf of others.

━━━━━━━━━━━━━━━━━━━━
✦ WHAT'S INCLUDED (5 tabs + hidden auto-calc engine) ✦
━━━━━━━━━━━━━━━━━━━━
📋 Instructions + Setup — 3-step quick start, full guide, and your editable settings: split %, consignment period, markdown reminders, and all dropdown lists.
📊 Dashboard — your whole shop at a glance: sales trend, floor value, what's expiring, who you owe, and top consignors. It fills itself.
🏷️ Item Inventory — the main log. One row per item; both shares, days in shop, and auto expiration dates calculate instantly (1,000+ rows).
👥 Consignors — every consignor's split, total sales, and live balance owed — no more adding it up by hand.
💵 Payouts + Statements — pick a consignor and get a printable, itemized statement of every unpaid item and the exact total due.

━━━━━━━━━━━━━━━━━━━━
✦ WHY YOU'LL LOVE IT ✦
━━━━━━━━━━━━━━━━━━━━
✔ Know exactly who you owe — balances stay current automatically
✔ Write consignment checks in seconds with print-ready statements
✔ Set a different split % for each consignor (or override any single item)
✔ Never miss an expiring item — automatic markdown & end-of-period alerts
✔ Real resale fields: condition grades (NWT, NWOT, EUC…), categories, brands, sizes
✔ A clean, modern dashboard you'll actually want to open
✔ Fully editable dropdowns, friendly instructions, and warning-only guardrails so nothing breaks

━━━━━━━━━━━━━━━━━━━━
✦ HOW IT WORKS ✦
━━━━━━━━━━━━━━━━━━━━
1. Add your consignors and their split %
2. Log items as they come in — price it, pick the consignor, done
3. Mark items Sold; both shares and payouts calculate automatically
4. Pay out from the Statements tab and check them off

━━━━━━━━━━━━━━━━━━━━
✦ WHAT YOU RECEIVE ✦
━━━━━━━━━━━━━━━━━━━━
• Instant digital download (PDF with your private "make a copy" link)
• A Google Sheets template — works on desktop, tablet, and the Google Sheets mobile app
• Pre-set to US date format; includes sample data you can delete in one click

━━━━━━━━━━━━━━━━━━━━
✦ PLEASE NOTE ✦
━━━━━━━━━━━━━━━━━━━━
• This is a digital template for Google Sheets — a free Google account is required. Nothing is mailed.
• For personal/business use only; please don't resell or redistribute the file.
• Colors and fields are fully customizable to match your shop.

Questions or a custom request? Send us a message — we're happy to help. Thank you for supporting our shop!