If you run a consignment shop, or sell even a few items on consignment, consider running the “Consignment Sales Report.”
This report breaks down each consignment sale you’ve had during a specific time period, including the quantity sold, date the sale occurred, amount the product sold for, the amount you owe that consignor, and other relevant information. This is a great way to see which consignment vendors perform well and which items are being sold. It’s also nice to have for your accounting records.
The report is generated based on the item(s) sold and the Consignment Cost Model and Consignment Split set in each consignment vendor’s account. Click here to learn how to set that up for your consignors.
Accessing the Report
There are two ways you can access this report.
From the “Reports” tab, click on “Accounting Reports and Statements,” then “Consignment Sales Report.”
Or, from the “Main Menu,” click on “Reports.”
Select “Accounting Reports.”
Choose “Consignment Sales Report.”
Report Fields
Sales Location: Choose if you want to pull sales data from just one store location, or all.
Date Range From: Sales made between these dates will show up on the report. Remember, sales must be posted in a Day End before they’ll show up on the report.
Consignment Vendor: If you want to only focus on one vendor, or a few specific vendors, enter their Vendor Code here. The Vendor Code is found in the vendor record. Separate multiple vendors with commas.
Show Individual Sales?: If “yes” is selected, Artisan will include relevant sales data for each sale (quantity, date, slip number, description, SKU, retail price, amount sold, and amount due.). If “no” is selected, Artisan will just show the quantity, description, and SKU, as well as the retail price, amount sold for, and amount due. If the item has a vendor product number, it will display on the report. Refer to the examples for more information.
Report Examples
In this report, we chose to show consignment sales from all locations and didn’t limit our search to just one (or a few specific) vendors. We also showed individual sales.
Notice how the “Sold For” amount is different than the “Retail” amount in these two examples:
a) We sold two of this item on sales slip 502, so the “Sold For” amount is $800 instead of $400.
b) On sales slip 501, the item was discounted, resulting in a different “Sold For” amount than its “Retail” amount.
Here is the same report without individual sales shown:
The report counted the total quantity of each item across multiple sales (ex. a quantity of 4 for Item OP0001). Notice that the individual dates and slip numbers are not included. The report also grouped the sales for each item instead of listing each sale individually, like the other report.