---
title: Consignment Reporting
description: imrchnt knowledge base
---
[Skip to content](https://help.imrchnt.com/s/17626/a/952765-consignment-reporting#main-content)
English
Show submenu for translations
Open main navigation
Close main navigation
- English
Show submenu for translations
- Contact us
Contact us
How can we help you?
- There are no suggestions because the search field is empty.
1. [imrchnt knowledge base](https://help.imrchnt.com/?hsLang=en)
2. [Legacy imrchnt](https://help.imrchnt.com/legacy-imrchnt?hsLang=en)
# Consignment Reporting
In order to report on Consignment Items
Go To:
*Reports \> Reports \> Sales Analysis \> Product Sales Report*
The product sales report query window will open up.
Here you create a new report.
Click on the ***New*** button on the Task Bar
Enter in a Report Name, I've entered a report name of Consignment Sales. Keep the Use Default Design box checked and click on the ***Apply*** button
A new window will appear where you will refine the design of your report. The name on the window header will be the name you entered as a report name. Mine reads Consignment Sales.
In the Detail section of the window click on the ***Design Detail Layout*** button
The Report Column Designer will appear.
Click on the ***Column Select*** button on the Task Bar
The Column Select window will appear
- Start by clicking on the ***In Use*** button, this will show you the columns that are currently on your new report.
- Since you are looking to report on Consignment Sales by Vendor (Consignor) there are a few columns here you don't need.
- In the Use Field check boxes uncheck Discount Retail and Cost of On-Hand. Uncheck any others that you don't think you need on the report as well.
Now we are going to add a column to the report.
- Click on the ***Product*** button
- Scroll down to the bottom and check the Use Field box next to Vendor Name
- Click on the ***Apply*** button
You will be brought back into the Report Column Designer
Here you will see Vendor Name on the far right of the report
- Click on the Column Header and drag the name to the far right.
- You will probably want to drag the Sales Cost column over to the left of Total Net as well.
Once you have the columns in the correct positions click on the ***Apply*** button
You are now back at the Consignment Sales window.
Within the Detail section click on the ***Sorts and Groupings*** button
Here you will want to add a Vendor grouping
- Click on the ***Add*** button just below the ***Apply*** button (it is pink with a yellow plus sign
- A new row under Group will appear
- Click on the dropdown bar and select Vendor Name
- Check the box under Header if you want the Vendor Name to be the Heading of the Group
- Check the box under Footer if you want the Vendor Name to be the Footing of the Group
- If you want a page break after every grouping, check that box as well.
- Choose whether you'd like the Sort Order to Descend or Ascend (A-Z or Z-A in the case of a Vendor Name)
- You can also choose to Group the Report by Store Number if you are running this report for multiple stores, if you choose to group by store, that ruler should be above the Vendor Name Grouping.
When you are done adding groupings click on the ***Apply*** button
You are brought back to the Consignment Sales window, click on the ***Save*** button
Now you are back in the Query - Product Sales Report
In the Select Using section of the window
- Click on the ***Manage Saved Queries*** button
- Select the Create a new query to save option
- Enter in a name for this query, call it Consignment and click the ***OK*** button
- Under Select Field click on the dropdown bar and choose New Used
- Under Select Operation click on the drop down bar and choose =
- Under Choose Value click on the drop down bar and choose Consignment Product
- Click on the ***Add*** button to the right
- Click on the ***Manage Saved Queries*** button again and now choose Save the current query, you see a quick message pop up once the query is saved.
From here you could select your type of Period (Week, Month, Day), choose your start and end dates and click on the ***Submit*** button in the task bar to run your report.
Or you can add another Query that will allow you to run the report based on Vendor Name.
In order to add another query to run the report by looking up a specific vendor
- Click on the ***Manage saved queries*** button and select Create a new query from this query
- You will be prompted to name the new query, lets call it Consignment Vendor
- Click on the ***OK*** button
- In Select Field click on the dropdown bar and choose Vendor Name
- In the Select Operation choose =
- in Choose Value you will enter the vendor name with quotations like "Mark Hochreiter"
- Again click on the ***Manage saved queries*** button and select Save the current query
- Fill out Period on Which to Report fields
- Click on the ***Submit*** button and you get your report for the specific vendor (consignor)
- [FAQs](https://help.imrchnt.com/faqs?hsLang=en#main-content)
- [Reports](https://help.imrchnt.com/faqs?hsLang=en#reports)
- [App](https://help.imrchnt.com/faqs?hsLang=en#app)
- [Getting started](https://help.imrchnt.com/getting-started?hsLang=en#main-content)
- [Store](https://help.imrchnt.com/getting-started?hsLang=en#store)
- [Card Processing](https://help.imrchnt.com/getting-started?hsLang=en#card-processing)
- [Imports](https://help.imrchnt.com/getting-started?hsLang=en#imports)
- [Exports](https://help.imrchnt.com/getting-started?hsLang=en#exports)
- [Troubleshooting](https://help.imrchnt.com/troubleshooting?hsLang=en#main-content)
- [Card Reader](https://help.imrchnt.com/troubleshooting?hsLang=en#card-reader)
- [Web App](https://help.imrchnt.com/troubleshooting?hsLang=en#web-app)
- [General](https://help.imrchnt.com/general?hsLang=en#main-content)
- [Users](https://help.imrchnt.com/general?hsLang=en#users)
- [Point of Sale](https://help.imrchnt.com/general?hsLang=en#point-of-sale)
- [Release Notes](https://help.imrchnt.com/general?hsLang=en#release-notes)
- [Legacy imrchnt](https://help.imrchnt.com/legacy-imrchnt?hsLang=en#main-content)
- [Releases](https://help.imrchnt.com/legacy-imrchnt?hsLang=en#releases)
- [Labels](https://help.imrchnt.com/legacy-imrchnt?hsLang=en#labels)
- [Gift Cards](https://help.imrchnt.com/legacy-imrchnt?hsLang=en#gift-cards)
- [Imports](https://help.imrchnt.com/legacy-imrchnt?hsLang=en#imports)
- [Credit Cards](https://help.imrchnt.com/legacy-imrchnt?hsLang=en#credit-cards)
- [Properties](https://help.imrchnt.com/legacy-imrchnt?hsLang=en#properties)
- [Internal](https://help.imrchnt.com/internal?hsLang=en#main-content)
- [AWS](https://help.imrchnt.com/internal?hsLang=en#aws)
- [iOS](https://help.imrchnt.com/internal?hsLang=en#ios)
- [Card Readers](https://help.imrchnt.com/card-readers?hsLang=en#main-content)
- [Tips](https://help.imrchnt.com/card-readers?hsLang=en#tips)
- [Maintenance](https://help.imrchnt.com/card-readers?hsLang=en#maintenance)
- [Newsletter](https://help.imrchnt.com/newsletter?hsLang=en#main-content)
- [2025](https://help.imrchnt.com/newsletter?hsLang=en#2025)
- [2026](https://help.imrchnt.com/newsletter?hsLang=en#2026)
- [Demo](https://help.imrchnt.com/demo?hsLang=en#main-content)
- [Card Reader](https://help.imrchnt.com/demo?hsLang=en#card-reader)
- [Releases](https://help.imrchnt.com/releases?hsLang=en)
[](https://help.imrchnt.com/?hsLang=en)
[mailto:email@email.com](mailto:email@email.com)
Copyright © 2026, Computac LLC