Consignment Shop Tracker | Inventory, Splits, Payouts (Excel/Google Sheets)

Consignment Spreadsheet — a complete Excel workbook for consignment shops, resale boutiques and booth sellers to track inventory, consignor splits, payouts, statements and profit in one file.

Log an item once. When it sells, mark it Sold and enter the price — the consignor's share, your share, days on floor and the payout balance all calculate themselves.

WHAT'S INSIDE — 12 TABS

1. Start Here — five-minute setup guide and colour legend
2. Dashboard — 26 live metrics: floor stock, sales, balances owed, profit, 3. top categories and top consignors
4. Setup — your default split, consignment period, markdown schedule, minimum payout and category lists
5. Consignors — 100 consignors with contact details, individual split % and payout method
6. Inventory — 500 items with automatic consignor share, shop share, days on floor, suggested markdown price and expiry flags
7. Payouts — one row per consignor: items sold, share earned, paid to date, balance owed, ready-to-pay flag
8. Payout Log — every payment you make, linked back to the balances
9. Statement — pick a consignor ID from a dropdown and get a printable statement of their items, sales and balance
10. Expenses — 300 rows of shop costs by category
11. Monthly Summary — items in, items sold, gross sales, commission, expenses and net profit for every month
12. Aging Report — how long stock has sat on the floor, and sell-through by category

WHAT IT DOES FOR YOU

✅ Consignor share and shop share calculate on every sale, using each consignor's own split
✅ Balance owed per consignor updates the moment you log a sale or a payment
✅ Items flag automatically when they hit your first markdown, second markdown, or are about to expire
✅ Consignor statements are ready to print — no more hand-typing what you owe
✅ Monthly P&L and sell-through by category, with no formulas to write

HOW IT WORKS

Enter your shop details and consignment terms on the Setup tab
Add your consignors, each with an ID like C001
Log items on Inventory as they come in
Mark items Sold with the date and price
Check Payouts, pay what's owed, record it on Payout Log

WHAT YOU RECEIVE

One .xlsx file, available to download the moment your payment clears. Sample data is included in grey italics so you can see the expected format — delete it or type straight over it.

COMPATIBILITY

Works in Microsoft Excel (Windows, Mac and 365). Also opens in Apple Numbers and LibreOffice. To use it in Google Sheets, upload the file to Google Drive and open it with Google Sheets.

PLEASE NOTE

This is a digital download — nothing will be shipped. Because the file is delivered instantly, all sales are final. For your own shop's use only; please don't resell or redistribute the file.

This workbook is a record-keeping tool, not accounting or tax advice.

Questions before you buy? Send me a message — happy to help.