Vendor/Consignor Reports

Vendor performance is a vital part of inventory management, and PayGo has made it easy to find reports for your vendors and consignors. From daily reports to consignor reports to item performance, you can keep a weather eye on how your vendors are making (or breaking) your sales.

Big Picture Button – Sales by Vendor

Within the Big Picture button, you can view sales reports by vendor. To access this report, click the Big Picture button on your Menu Screen. This will take you to The Big Picture screen, where you will click the Sales by Vendor tab. This tab will bring up a graph detailing items sold grouped by the vendors you purchase from. This graph will show both your cost of goods (COG) and total sales for each vendor. You can set a date range by clicking the calendar buttons at the top of the screen.

For more information on the Big Picture button, see PayGo’s Big Picture Button

Reports Button – Vendor/Consignor Reports

You can also find vendor reports within the Reports section in your PayGo system. To access these reports, click the Reports button on your Menu Screen. This will take you to the Reports screen. Within this screen, you will see six boxes of reports. We’ll start with the Vendor/Consignor Reports box. There are four different reports in this box.

Vendor List: This is where you can see a list of all of your vendors. When this button is clicked, you will be taken to a Search Screen where you can set parameters for the search. Your report will show each vendor’s name, phone number and address.

Performance by Vendor: This is where you can see the performance statistics for your vendors. When this button is clicked, you will be taken to a Search Screen where you can set parameters for the search. A pop-up window will ask you to enter in a date range to view the report for. You will be given the option to sort by sales, margin or vendor name. The report will show each vendor’s name, the quantity of items from each  vendor sold, last and average cost of goods sold, last and average margin cost as well as the percentage of sales the items made up, the total sales for each vendor, and turns by last and average cost.

Sales by Vendor: This is where you can see sales reports per vendor. When this button is clicked, you will be taken to a Search Screen where you can set parameters for the search. The Detail view will break down by each vendor, and show the item’s name and ID, quantity sold, any discounts applied to the item, the pre-tax totals, last and average cost of goods sold, and the last and average margin on the item. The Summary view will break down by each vendor as well, and will show total quantity of items sold per vendor, any discounts to the vendor’s items, pre-tax totals, last and average cost of goods sold, and the last and average margin on total items from each vendor. Totals for each can be viewed at the end of the reports.

Consignor Report: This is where you can see sales reports per consignor. When this button is clicked, you will be taken to a Search Screen where you can set parameters for the search. A pop-up window will ask if you would like a page break for each consignor’s report. The report will be broken down by consignor, and will show each sold item’s name and ID, the invoice ID number and date it was sold on, the quantity of each item sold, any discounts that may have been applied, the pre-tax invoice total, the consignor amount to pay, the user amount collected, and the date the balance to the consignor was paid, along with the check’s number and date.

Reports Button – Other Sections

In addition to the Vendor/Consignor Reports box, you can find other vendor report information in a few different sections.

Sales by Manufacturer: Located in the Sales Reports box, this button will show your sales, broken down by manufacturer. When this button is clicked, you will be taken to a Search Screen where you can specify a set of dates to analyze (as well as any other search parameters you may choose). The Detail view will show all items sold broken down by manufacturer, as well as the item’s name and ID, and any applicable discounts that were applied to the item. The Summary view will show total quantities sold for each department, as well as discounts applied. Both reports show the total quantity of each item sold, as well as the totals before tax, percentage of total sales that each item brought in, the last cost of the goods sold as well as the average cost of goods sold, the last cost of all items margin sold (including the percentage of total sales) as well as the average cost of all of the items margin (including the percentage of total sales). Grand totals can be viewed at the end of the reports.

Items on Order – Vendor: Located in the Purchase Orders box, this is where you can view what items your stores have on order, broken down by vendor. When this button is clicked, you will be taken to a Search Screen where you can set parameters for the search. The report shows each vendor that has items on order from your store, each item’s name and ID, the Purchase Order number, the date the order was placed, the date the order is received, the estimated ship date, the date the order was cancelled (if applicable), how many items ordered, how many items were received, if there was any back order or cancelled items, the items in the order remaining, the cost per item, and the extended cost of the items. Totals can be found at the bottom of the report.

For more information on your Reports button, see Running Store Reports in PayGo’s Reports Screen.

Vendor Reports within the Vendor/Consignor/Manufacturer Entry Screen

You can also find information about your vendors within their screens within your PayGo system. To access these reports, locate the vendor you’d like to view by clicking the Find Vendor button on your Menu Screen, and select the vendor from the results. This will take you to the Vendor/Consignor/Manufacturer Entry screen. There are a few places within this screen where you can view reports.

For more information on your Vendor/Consignor Manufacturer Entry screen, see Adding New Vendors to PayGo

Sales Tab: Located in the top half of your screen, this is where you can see sales that have been made with this vendor’s inventory. Within this tab, you can select a date range to analyze, and be shown each sold item’s Item Name, the Invoice ID it was sold on, Qty (quantity) Sold, Extended price, Commish Amt (commission amount), Date Processed, and the Check # (number).

Performance Tab: Located in the bottom half of your screen, this tab is where you can view a report of the vendor’s product performance in your stores. When you enter a date range, your PayGo software will pull up the following information:

Qty Sold: This will tell you how many items from this vendor you’ve sold within the specified date range.

Total L Cost: This is the total last cost of the items purchased from the vendor.

Total A Cost: This is the total average cost of the items purchased from the vendor. This will show as both a dollar amount and a percentage.

Margin Last Cost: This is the margin from the last purchase order with the vendor. This will show as both a dollar amount and a percentage.

Margin Average Cost: This is the average margin from all purchase orders with the vendor. This will show as both a dollar amount and a percentage.

Total Sales: This will show a dollar amount of the total sales you have made from this vendor’s items.

Consignment Central

You can find specific information about your consignors within the Consignment Central button. To access this, click the Consignment Central button on your Menu Screen. This will take you to the Consignment Central screen. Within the Overview tab, you can set specific dates to analyze and see your consignor’s Total Sales, Total Qty (quantity) Sold, Total for Consignors that you have paid out, Total You Paid, Totals for You, and Total Payments Due to your consignors. You can also see what consignors you buy from in the Active Consignors box, along with their sales totals and contact information.

Enjoy this article? Remember sharing is caring!
RSS
Facebook
Google+
http://paygopos.com/knowledgebase/vendor-consignor-reports/
Twitter
Pinterest
LinkedIn

Search KnowledgeBase

Popular Articles