Report this item to Etsy

Consignment Tracker | Consignor Payout & Inventory Spreadsheet for Resale Shops, Boutiques (Google Sheets)

NowPrice:$12.35

Original Price: $19.00

Loading

35% off

•

Sale ends in 3 days

Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

  • Designed by Lexetto
  • Digital download
  • Digital file type(s): 1 PDF

CONSIGNMENT TRACKER — the Google Sheets workbook that knows exactly what you owe every consignor. Built for resale shops, thrift and vintage stores, boutiques, antique booths and anyone who sells other people's things for a commission.

Type your items and your rules once. The sheet applies the markdowns, flags what is expiring, splits every sale between consignor and shop, tracks every payout and shows the balance owed, per consignor, at all times. A Quick-entry sidebar records a sale at the counter in seconds.

★ WHAT YOU GET (instant download)
• PDF with your MAKE-A-COPY link → the tracker lands in your own Google Drive in seconds
• 3-page setup guide (5-minute start, how splits and markdowns work, tips)
• Two designs in one file: BOUTIQUE (soft pastels, emoji tabs) and CLEAN (gray canvas, white cards). Switch from the menu.

★ THE "CONSIGNMENT" MENU (automation inside the sheet)
• ➕ Quick-entry sidebar: record a sale, add an item, record a payout. Picks the item, fills today's price, writes the row.
• 🖨️ Export consignor statement to PDF: pick a consignor, one click, a one-page statement lands in your Drive (sold items, earnings, payouts, balance, what is still on the shelf).
• 🎨 Switch design: Boutique ↔ Clean. Same formulas.
• 🧹 Clear sample data: explore with the sample shop, then start fresh.

★ 8 CONNECTED TABS
1. Start Here: tour of the workbook
2. Settings: default split, consignment period, markdown schedule, grace days, minimum payout
3. Dashboard: items on shelf, items sold, sales, shop commission, owed to consignors, expiring soon, avg days to sell, sell-through, balance by consignor, needs-attention list
4. Consignors: one row per consignor → items received, on shelf, sold, sales total, earned, commission, paid out, balance owed, status (Payout due)
5. Inventory: price + date received → days on shelf, markdown %, current price, expiry date, status (On shelf · Expiring soon · Expired · Pick up now · Sold · Returned)
6. Sales: one row per sale → consignor share, consignor earns, shop earns (custom split per consignor supported)
7. Payouts: every payment by check, transfer or cash; the balance updates by itself
8. Statement: one clean printable page per consignor (or PDF via the menu)

★ WHY SHOPS LOVE IT
• Zero formulas to write. White cells = you type; tinted cells = calculated and protected.
• Markdowns that apply themselves: after 30 and 60 days (you choose) the current price drops on its own, so the tag is never wrong.
• Expiry and pick-up flags tell you exactly which items to call about.
• Fair splits: set one default (for example 50/50) and override it for any consignor.
• Room for 200 consignors · 500 items · 1,500 sales · 500 payouts.
• Works on Chromebook, Mac and Windows in any browser. The Google Sheets mobile app shows all tabs and charts.

★ HOW IT WORKS
1. Download the PDF → click MAKE A COPY (sign in to your Google account).
2. Open the menu once and click Allow (30 seconds; it's your own copy's script, explained step by step in the guide).
3. Fill Settings, add consignors, then items. Record sales and payouts as they happen. Done.

★ GOOD TO KNOW
• Digital download. Nothing is shipped. The link never expires.
• Google Sheets required (free). Not an Excel file.
• If you are signed in to several Google accounts in the same browser window, Google's sidebars can show "PERMISSION_DENIED". Open your copy in a window with only one account (Google limitation, covered in the guide).
• Sample data (a fictional shop) is included so you can see everything working. Clear it from the menu.
• This is a bookkeeping tool, not tax or legal advice. Check your local consignment rules.
• Personal use by the purchasing shop. Not for resale or redistribution.
• Designed by a seller with the help of AI tools; every formula and layout is hand-checked.

Questions? Message us. We answer within 24 hours.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 22, 2026