Consignment Inventory Tracking Spreadsheet
When selling handmade products, consignment stores are a great way to get to test your products in retail stores, and test your profit margins.
Often, a consignment store will take a smaller percentage of your sales that if you sold the products upfront at wholesale prices.
*Here’s an article on consignment splits:What’s a Fair Consignment Percentage? (How To Negotiate an Increase)
One of the challenges with selling your products in retailers through a consignment deal is that you need to keep close track of your inventory.
*Read about the pros and cons of selling on consignment terms here: Consignment vs. Wholesale (Which is Better?)
More than once I had to deal with missing inventory when it was time to pick up my paycheque and my un-sold stock.
So you and the store owner should have a hard copy of what was dropped off so if an item isn’t there when it’s time to pickup, you can be sure you’re being paid for it (and there’s no question whether or not it was in the storeowner’s possession).
This is a simple form you can use to keep track of your inventory. But you can also use it as a template to create your own and add your logo/branding.
It’s a good idea to print one for yourself and one for the store so you both have records of your products in their store.
Depending on your relationship with the store owner, you may also want them to sign a copy of it each time you do a drop-off or pick up, acknowledging and agreeing to the list.
It should also be in your agreement that you’ll be paid for any products that are missing, stolen, or damaged.
*Here’s an article on what you might want to put in (or ensure is in) your consignment agreement: What to Include in a Consignment Agreement
This inventory tracking worksheet has a field for:
- Product name – accurately describe your product or use a SKU number so there’s no confusion for the store owner
- QTY – the number of that specific product/SKU you’re providing
- Retail Price – how much the consignment store should charge their customers for the item
- Consignment Price – how much the storeowner will pay you when the item sells
- Date Dropped Off – this is important as your agreement may require you to pick up items if they haven’t sold within a certain time period
- Sold (yes/no)
- Paid (yes/no)
- Date Picked Up
You can click the image or the link below to download your free copy:
>> Download your free inventory tracking spreadsheet here <<
Finally understand why your hard work isn't resulting in more sales
Join over 18,000 others and sign up for the
Made Urban newsletter
Hey, I’m Erin 🙂 I write about small business and craft show techniques I’ve learned from being a small business owner for almost 2 decades, selling at dozens of craft shows, and earning a diploma in Visual Communication Design. I hope you find my advice helpful!
One Comment