Low in stock, only 5 left

Price: $24.00+

Consignment Tracking for Stores- Inventory Tracking, Consignment Sales Tracking

Name: Consignment Tracking for Stores- Inventory Tracking, Consignment Sales Tracking
Brand: TimeSavingTemplates
SKU: 158789647
Availability: InStock
Rating: 4.9 (695 reviews)

TimeSavingTemplates

Arrives soon! Get it by Apr 30 if you order today

Options

Please select an option

Add your personalization

Enter the name or business name you would like your template personalized with:

256

You can only make an offer when buying a single item

Handmade
Materials: PDF file, MS Excel spreadsheet

If you have a boutique or store where you accept items on consignment, this template will help you organize all your inventory, consignors and sales and payouts due to consignors. This excel spreadsheet consists of several different pages that are linked together, and in an easy to use format.

See a demo of how this template works right here - https://www.youtube.com/watch?v=YEW69S-7rdQ

All formulas and summaries are set up, all you have to do is enter your inventory and sales data-

1st worksheet – Inventory Details - includes a place to enter the item codes, item details, consignor, consignment start date. The grey columns contain formulas that will populate after information is entered in the other columns.

2nd worksheet – Sales Details - When a sale is made, you can enter the item code, sale date, sale price and the # sold. The rest of the grey columns will automatically populate.

3rd worksheet – Sales Summary - will include 3 tables to show the sales by month, by consigner, and by month and consignor. You will just have to click a refresh button anytime new information is added to the sales details worksheet, to get the tables to update.

4th worksheet – Consignor Information

UPGRADE Option ~ If you want to print price tag labels, based on the products/prices you enter in the inventory section, you can do so by adding on a word label template that comes with directions on how to print out your product labels. See an example of how it works here:

https://www.youtube.com/watch?v=_9RtNKmtAIc&t

You will receive this by email. You will receive an Excel Spreadsheet and PDF file with directions.

All templates are for your use and come personalized with your name or shop name. You do not have permission to distribute or resell.

If you consign your own items to different stores/venues, you may be interested in the simple consignment tracking template-

https://www.etsy.com/listing/176677839/simple-consignment-tracking-worksheet?ref=shop_home_active_8

Thanks!

Order today to get by Apr 30
Returns & exchanges not accepted
Free shipping

There was a problem calculating your shipping. Please try again.

Country

Zip code

Please enter a valid zip code.

Ships from Santa Fe, TX

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

Yes, most of my templates are designed in Microsoft Excel and are compatible with all versions of Excel. If you have a mac with 'Excel for macs' it will work.

Open office versions are available upon request. Open office is a free program you can download. If you have Excel 2003 or earlier, you might need to request a 2003 version which I can also send.

Most of my templates come with the cells with formulas protected, to prevent someone from accidentally deleting or writing over a formula, which could cause the template to not work as described.

If you want to be able to make changes to the formulas, there is a small fee to upgrade to the unprotected version. Most of my templates come personalized with your name or company name and that remains protected, even in the unprotected versions.

https://www.etsy.com/listing/485658671/make-my-template-formulas-editable?ref=shop_home_active_21

I can also make changes or customizations for you. See custom options here - https://www.etsy.com/shop/TimeSavingTemplates?ref=l2-shopheader-name§ion_id=22720650

Most of my templates are personalized with your name or business name. If you have a preference, please enter the name you'd like in the 'notes to seller' at checkout. Otherwise I will use the name listed on the account/order.

The excel templates are meant for use by the individual or business who purchases them, and the name cell remains protected in most of the templates, even with the unprotected formulas version upgrade.

If you would like to use the template for other people, such as your own clients, they can be used with a license if they are part of a service you provide. See license details here for more information-

https://www.etsy.com/listing/568804865/commercial-client-license-for-property?ref=shop_home_active_11

These videos will guide you through which template will work best for your situation:

Sales & Expenses tracking:
https://www.youtube.com/watch?v=c1WhC86xkQw

Rental Property Management:
https://www.youtube.com/watch?v=iTKz2sYywkQ&t

Inventory Tracking:
https://www.youtube.com/watch?v=JKVcrSX2Gow&t

Subscribe to my YouTube channel for more template demos and excel spreadsheet tips and shortcuts!

Erin J

Owner of TimeSavingTemplates

Following Follow shop

Message Erin

This seller usually responds within 24 hours.

695 reviews

Fabulous customer service as I had a question about the spreadsheet and was answered promptly.

jenbsampson Feb 7, 2024

This is perfect for my new shop! Thank you!

Jen Aug 25, 2016

Very helpful. Even went 'above, and beyond" to answer questions.

LaToya Stevens Jul 6, 2015

Disclaimer: Etsy assumes no responsibility for the accuracy, labeling, or content of sellers' listings and products. Electrical or electronic products may pose a risk of fire or electrocution. Vintage, handmade, refurbished, or modified electrical or electronic products may not meet current safety standards and may not be in safe working order. Inspect carefully before use and message the seller if you have concerns relating to the product. Do not use a vintage electrical or electronic item if its safety cannot be verified. To reduce the risk of fire, never leave vintage electrical or electronic products plugged in unattended. See Etsy's Terms of Use for more information.