This excel template was created to help a store owner keep track of various items that are consigned from different consignors, with varying payout percentages. The template consists of several different pages that are linked together, making it easy to enter your information and then the summaries and formulas are already set up to calculate the amounts due to each consignor.
See a demonstration of this template in use here:
This template was set up to be easy to use and color coded – with grey columns representing the formulas that will calculate or link to another page in the worksheet.
There are 3 main pages to enter your information –
- Inventory Details
- 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.
- Consignor Information – including the payout percent for each consignor
The Sales Summary page will summarize all the information entered in the other pages. There are 3 summary tables that will show –
- Total sales by month
- Total sales by consignor
- Total sales 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, however it is outlined in the directions.
UPGRADE option: Get this with the word labels template, where you can link all your inventory to a word document and then print out price labels. See an example here:
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 here.