Consignment Inventory Tracker Google Sheets Template | Resale Shop Stock, Seller Payouts & Expiry Alerts Sheet

Run your whole consignment shop from one simple spreadsheet.

The Consignment Inventory Tracker is a fully automated Google Sheets template for consignment
stores, resale boutiques and anyone selling on behalf of others. Add each item once and the
tracker works out how long it's been in stock, when its consignment term expires, what the
seller has earned and exactly what you still owe them.

★ NEVER MISS AN EXPIRY OR A PAYOUT (what makes this different)

Two built-in automations do the work most trackers leave to you:

• Automatic aging & expiry alerts — every item shows its days in stock, its consignment expiry
date, and flips from "Active" to "Expiring Soon" to "Expired" on its own, so nothing sits
past its term unnoticed.
• A live payout ledger — set each seller's split once and the tracker calculates what they've
earned on every sale, what you've paid, and the balance still owed, per consignor.

WHAT'S INSIDE

• Dashboard — total items, in stock, revenue, stock value, sell-through %, payouts owed,
expiry alerts, plus category and status charts and a "Payouts Due" list
• Inventory — one row per item: dates, consignor, category, size, color, cost, price and
status, with days in stock, expiry date, alert, seller earnings and owed all automatic
• Consignors — every seller with their own split %, items consigned and sold, revenue,
earned, paid and still owed
• Settings — default seller split, consignment term length, alert window and dropdown lists

WHY YOU'LL LOVE IT

• 100% automated formulas — no math, no manual chasing
• Give any seller their own split % — it overrides the default automatically
• Color-coded status and alerts so problems jump out instantly
• Premium navy-and-mauve design that's easy to read all day
• Works on any device with Google Sheets — desktop, tablet or phone

PERFECT FOR

Consignment stores, resale and thrift boutiques, vintage sellers, kids' resale shops, antique
malls, booth renters and anyone who sells items on behalf of other people.


CORE DETAILS
------------
• Format: Google Sheets template (instant digital download — copy link provided)
• 5 tabs: Start Here, Dashboard, Inventory, Consignors, Settings
• Capacity: up to 300 items and 100 consignors
• Includes realistic sample data you can clear and replace in seconds
• Fully editable — customize categories, sizes, statuses, splits and terms
• Requirements: a free Google account. Built for Google Sheets (not Microsoft Excel)
• Digital product: nothing is shipped