🎉 Black Friday Sale: 40% OFF everything with code BF40 · ends 1 Dec  Shop now →

Consignment Inventory Tracker in Excel and Google Sheets

Original price was: $12.99.Current price is: $6.99.
Details, requirements and demo below
Sale!

Consignment Inventory Tracker in Excel and Google Sheets

Original price was: $12.99.Current price is: $6.99.

  • 🔹 Inventory for up to 500 items: days on floor, automatic 2-step markdowns, current price and expiry date.
  • 🔹 Commission split to the cent: store commission and consignor share on every sale, with a per-consignor override.
  • 🔹 Consignors and payouts: up to 100 consignors, a payout log and the balance due for each.
  • 🔹 Printable consignor statement: pick an ID and print every item and payout.
  • 🔹 Dashboard: six tiles, three charts, the top 8 balances and the expired items to return.
  • 🔹 Two editions in one download: Google Sheets (PDF guide with Make a copy link) and Microsoft Excel (.xlsx, no macros).
  • 🔹 One-time payment: no subscription, instant download.
Customize this template for your business (optional)

Handled by email: we contact you within 1 business day. One revision round included. What is included

- +
, , ,

💡 Buy any 2 templates and save 20% automatically at checkout.

Included in All-Access Templates. Get this plus 7,000+ templates for $99.00 a year. Compare plans →
Pricing country
Prices follow your selected country; checkout uses your billing country.
Excel + AI Mastery: 100 Essential Formulas courseLaunch offer
🎓 NEXTGENTEMPLATES ACADEMY
Want to build templates like this yourself?
Excel + AI Mastery: 100 Essential Formulas

SUMIFS, XLOOKUP, FILTER, LAMBDA and checking AI-written formulas, with real business projects. 11h 47m of video by PK, with practice files, quizzes and a capstone.

Consignment Inventory Tracker in Excel and Google Sheets runs a consignment shop from one file. Log every consigned item, mark it sold, and see the store commission and the consignor share of every sale, what you owe each consignor after payouts, which items are on a markdown and which ones are past the consignment period. It ships in two editions, Google Sheets and Microsoft Excel, with the same tabs, the same formulas and the same sample data: a fictional boutique in Franklin, Tennessee.

Watch the Consignment Inventory Tracker in Excel and Google Sheets walkthrough

🌍 Join 10,000+ customers in 180+ countries using NextGenTemplates to replace paid SaaS tools with one-time-purchase Excel, Google Sheets, Power BI and HTML templates.

✅ Instant download · One-time payment · No subscription · No per-user fees · Lifetime access

This is a consignment tracker for consignment shops, resale boutiques, thrift stores and furniture consignment stores that need to know what is on the floor and who is owed what. It is a manual tracking workbook with formulas and charts, not a point of sale and not a macro tool: you type your items, sales and payouts yourself.

🔑 Key Features of the Consignment Inventory Tracker

🏷️ An Inventory tab for up to 500 items. Days on floor, automatic 2-step markdowns, current price, commission % and expiry date are worked out for you, and the markdown stage moves from New to 1st Markdown, 2nd Markdown and Expired by itself.

💸 Commission split to the cent. Each sale shows the store commission and the consignor share. Set a default store commission and override it for any consignor.

👥 A Consignors tab for up to 100 consignors. Items, in stock, sold, gross sales, store commission, their share, paid to date and balance due, all in one row.

🧾 A printable Consignor Statement. Pick a consignor ID and get totals, every item and every payout, ready to print or save as a PDF.

💳 A Payouts log. Record each payout by check, Zelle, ACH transfer, store credit or cash, and the balance due updates.

📊 A Dashboard. Six tiles, three charts, the top 8 balances due, the expired items to return or donate and the store details.

📈 Reports. Twelve months of sales, commission, consignor share and payouts, results by category with sell-through and days to sell, and stock by markdown stage.

📦 What is Inside the Consignment Inventory Tracker

The download is a ZIP with two files: the Excel edition (.xlsx, no macros) and a PDF guide that holds the “Make a copy” link to your own editable Google Sheet. Both editions have the tabs Dashboard, Inventory, Consignors, Payouts, Consignor Statement, Reports, Store Settings, Lists, How to Use and Explore More.

Page 1: Dashboard (Google Sheets)

The Dashboard opens with six tiles: Items in Stock, Stock Value, Sales This Month, Store Commission, Owed to Consignors and Expired Items. Below them sit three charts (Sales by Category, Monthly Sales split into Store Commission and Consignor Share, and Stock Value by Markdown Stage), then the top 8 consignors by balance due, the expired items to return or donate and the store details. Links under the title jump to every tab.

Consignment Inventory Tracker in Excel and Google Sheets - Dashboard tab with six tiles, three charts and the top 8 balances due

Page 2: Inventory (Google Sheets)

One row per consigned item, up to 500. Type the item ID, date received, consignor, category, description, condition and tag price, then set the status to In Stock, Sold, Returned or Donated. Days on floor, markdown, current price, commission %, store commission, consignor share, expiry date, markdown stage and a Row Check fill in for you.

Consignment Inventory Tracker in Excel and Google Sheets - Inventory tab with days on floor, markdowns and commission split

Page 3: Consignors (Google Sheets)

One row per consignor, up to 100, with contact details, agreement date and an optional commission override. Grey columns count items, in stock and sold, and add up gross sales, store commission, the consignor share, paid to date and balance due.

Consignment Inventory Tracker in Excel and Google Sheets - Consignors tab with items, sales, share and balance due

Page 4: Payouts (Google Sheets)

The payout log: date, consignor, amount, method (check, Zelle, ACH transfer, store credit or cash), reference and note. Each payout feeds the consignor paid to date and balance due.

Consignment Inventory Tracker in Excel and Google Sheets - Payouts tab logging money paid to consignors

Page 5: Consignor Statement (Google Sheets)

Pick a consignor ID and the statement fills in with totals, every item and every payout, ready to print or save as a PDF and send with the payment.

Consignment Inventory Tracker in Excel and Google Sheets - Consignor Statement tab with items sold and payouts

Page 6: Reports (Google Sheets)

Twelve months to the report date of items received and sold, sales, store commission, consignor share, payouts and average sale, then results by category with stock value, sell-through and average days to sell, and stock by markdown stage.

Consignment Inventory Tracker in Excel and Google Sheets - Reports tab with monthly sales, categories and markdown stages

Page 7: Store Settings (Google Sheets)

Type your store name, address, phone, email and owner in the yellow cells, then the report date, the default store commission, the consignment period and the two markdown steps. A Check cell says OK when the inputs are valid.

Consignment Inventory Tracker in Excel and Google Sheets - Store Settings tab with commission, consignment period and markdown schedule

Page 8: Lists (Google Sheets)

The dropdown lists for categories, conditions and payment methods. Add your own; the four status names stay fixed because the formulas use them.

Consignment Inventory Tracker in Excel and Google Sheets - Lists tab with category, condition and payment method dropdowns

Page 9: How to Use (Google Sheets)

Step by step instructions for settings, consignors, items, sales, markdowns, payouts and statements.

Consignment Inventory Tracker in Excel and Google Sheets - How to Use tab with step by step instructions

Page 10: Explore More (Google Sheets)

A welcome coupon and links to related retail, resale and inventory templates.

Consignment Inventory Tracker in Excel and Google Sheets - Explore More Templates tab with a welcome coupon

Page 11: Dashboard (Excel edition)

The same Dashboard in Microsoft Excel: six tiles, three charts, the top 8 balances, expired items and store details.

Consignment Inventory Tracker in Excel and Google Sheets - Dashboard tab in Microsoft Excel

Page 12: Inventory (Excel edition)

The Inventory tab in Excel with the same 500 item rows, automatic markdowns, commission split and expiry dates.

Consignment Inventory Tracker in Excel and Google Sheets - Inventory tab in Microsoft Excel

Page 13: Consignor Statement (Excel edition)

The printable consignor statement in Excel, with every item and payout for the selected consignor.

Consignment Inventory Tracker in Excel and Google Sheets - Consignor Statement tab in Microsoft Excel

Page 14: Reports (Excel edition)

The Reports tab in Excel with 12 months of sales and payouts, results by category and stock by markdown stage.

Consignment Inventory Tracker in Excel and Google Sheets - Reports tab in Microsoft Excel

Page 15: Consignors (Excel edition)

The Consignors tab in Excel with items, sales, store commission, consignor share, paid to date and balance due.

Consignment Inventory Tracker in Excel and Google Sheets - Consignors tab in Microsoft Excel

📊 Consignment Inventory Tracker vs. Blank Spreadsheet vs. Consignment Software: Where This Fits

FeatureConsignment Inventory Tracker (Google Sheets + Excel)Blank spreadsheetConsignment shop software
Cost✅ $6.99 one-timeFree to build, but your timeMonthly subscription per store
Platform✅ Google Sheets and Microsoft Excel, both includedOne platformWeb app
Commission split to the cent per item✅ Built in, with a per-consignor overrideYou write the formulas✅ Yes
Automatic 2-step markdowns and expiry✅ Yes, from days on floorBuild it yourself✅ Yes
Printable consignor statements✅ Yes, pick an IDCopy and paste by hand✅ Yes
Your data stays in your own file✅ Yes✅ YesStored with the vendor
Point of sale and barcode scanningNo, you type the saleNo✅ Often yes

For shop owners who want clear payouts and automatic markdowns without a monthly fee, this tracker sits in the sweet spot.

👥 Who This Template Is For, and Who It Is Not For

✅ This template is built for:

  • Consignment shops and resale boutiques that pay consignors a share of each sale
  • Thrift and furniture consignment stores with a fixed consignment period
  • Owners who send consignors a statement with each payout
  • Shops that mark items down on a schedule and return or donate what does not sell

❌ This template is NOT for:

  • Shops that need a point of sale, barcode scanning or online sales sync
  • Stores with more than 500 items or 100 consignors on the floor at once
  • Anyone who wants macros, because this version has none

⚙️ How to Use the Consignment Inventory Tracker

  1. Open the PDF guide and click the “Make a copy” link for Google Sheets, or open the Excel file.
  2. On Store Settings, type your store details, the report date, the default commission, the consignment period and the markdown schedule.
  3. On Consignors, add each consignor, with a commission override if they have a special split.
  4. On Inventory, clear the yellow sample columns and enter each item with its consignor and tag price.
  5. When an item sells, set its status to Sold and type the sale date and sale price.
  6. Log each payout on Payouts, print a Consignor Statement, and watch the Check cell turn OK.

💼 Real-World Use Cases

A boutique owner sells a pair of boots on the 2nd markdown for $21.60 and sees the store keep $8.64 and the consignor earn $12.96 without any extra typing.

A shop manager opens the Dashboard and sees 85 items in stock worth $10,842, $1,223 owed to 12 consignors and 9 items past the 90 day period.

A bookkeeper logs a payout by Zelle and prints the consignor statement to send with it.

❓ Frequently Asked Questions

What is a consignment inventory tracker?

It records every item a consignor leaves with your shop, its price, and when it sells. This tracker also works out the store commission and what you owe each consignor.

Does it work in Google Sheets and in Excel?

Yes. The ZIP holds an Excel edition (.xlsx, no macros) and a PDF guide with the Make a copy link for Google Sheets. Both have the same tabs, formulas and sample data.

How many items and consignors does it hold?

Up to 500 items and 100 consignors.

How are markdowns and expiry handled?

You set the consignment period (90 days by default) and two markdown steps (20% after 30 days and 40% after 60 days by default). The tracker uses the days on floor to show the current price, the markdown stage and the expiry date.

Can one consignor have a different split?

Yes. Type a commission override on the Consignors tab, for example 35% for one consignor. Everyone else uses the default store commission.

What does the sample data show?

A fictional boutique, Magnolia Lane Consignment in Franklin, Tennessee: 18 consignors, 346 items and 92 payouts, with the report date set to Nov 20, 2026. Replace it with your own data.

Does it track my sales at the register?

No. You enter the status, sale date and sale price of each item that sells, and the tracker does the rest.

Can I change the currency?

Yes. Currency is $ by default. Select the amount columns and change the number format.

👤 About the Author

Built by PK, Microsoft Certified Professional with 15+ years of Excel, Google Sheets and Power BI experience. Founder of NextGenTemplates. Every template is hand-built and tested before release. Watch the walkthroughs on @PKAnExcelExpert and @NextGenTemplates.

🔗 Explore Related Templates

📌 Reseller Profit and Fee Tracker in Excel and Google Sheets: track what each resale item earns after fees.

📌 Inventory and Reorder Point Tracker in Excel and Google Sheets: track stock levels for the goods you buy.

📌 Quotation and Invoice Template in Excel and Google Sheets: bill your customers.

Browse every Google Sheets template in the store.

🎥 Visit our YouTube channel for step-by-step video tutorials

👉 YouTube.com/@NextGenTemplates

📅 Last updated: November 2026

Frequently asked questions

How do I get my own copy?
After purchase you get a link to the Google Sheet. Open it while signed in to your Google account and use File > Make a copy - the copy in your Google Drive is fully yours and editable.
Do I need a paid Google account? Will it expire?
No. A free Google account is enough, and your copy lives in your own Google Drive - it never expires and there is nothing to renew.
Does it work on Mac, phone or tablet?
Yes - in any browser on Windows, Mac or Chromebook, and in the Google Sheets mobile app for viewing and quick entries.
Can I share it with my team?
Yes. Share your copy with colleagues using Google's normal sharing, with view or edit rights as you choose.
Can I change the design and formulas?
Yes, your copy is fully editable - colours, labels, logo, formulas and charts. If a range is protected, use Data > Protect sheets and ranges to remove it in your copy.
Are there macros or add-ons?
No macros or add-ons - it uses normal Google Sheets formulas and charts.
Is it a one-time payment or a subscription?
One-time payment. No subscription, no per-user fees and nothing to renew - the file is yours to keep.
How do I get the file after payment?
Instantly. The download link appears on screen after checkout, is emailed to you, and stays under My Account > Downloads on our website. If the email does not arrive within a few minutes, check your spam or promotions folder.
Is a user manual included?
Most of our newer products include a PDF user manual in the download. If yours does not have one, message us with your order number and we will send it.
Do I get free updates?
Bug fixes are always free - if something does not work as described, we fix it and send you the corrected file. New versions with new features are not included in the price, unless this product's description says otherwise.
Can you customise it for me?
Yes. Small changes to this template (your columns, categories, logo, colours, minor layout) cost the template price plus $40-80 (Rs 3,000-6,000 + GST), quoted once you send your list. A fully custom build is usually $100-200 (Rs 8,000-18,000 + GST) with two revision rounds. Email your requirements to [email protected] or message us on WhatsApp.
Can I use it for my business or my clients?
Yes, for your own personal or internal business use, for as long as you like. Reselling or redistributing the template is not allowed.
What is your refund policy?
Because these are digital downloads, they are non-refundable once delivered - except when the product does not match its description (report it within 48 hours of purchase) or there is a technical problem our team cannot fix within 72 hours. Email [email protected] with your order number.
How do I get help?
Email [email protected] (Mon-Fri, 10 AM-7 PM IST) or message us on WhatsApp +91 80770 90260 (chat only, no calls). Please include your order number.

Still have a question? Click Need help? at the bottom-left to ask our assistant, or message us on WhatsApp.

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

You may also like…

Consignment Inventory Tracker in Excel and Google SheetsConsignment Inventory Tracker in Excel and Google Sheets
Original price was: $12.99.Current price is: $6.99.
- +
Scroll to Top