The Supplier Sales Analysis Report is used to list all items sold during a specified date range for selected Suppliers. You can choose multiple Suppliers, therefore allowing you to compare the sales totals by Supplier. You can also choose different departments and categories to target certain stock items.

Generating the Report

1. On the top menu bar of Retailer, click on Reports > Sales Reports > Supplier Sales Analysis Report
   
2. In Report Date Range:
   • Select the Start Date - This will be the Start Date of the report
   • Select the End Date - This will be the End Date of the report
   • Tick the 'This Shift Only' box if you only wish to analyse the sales made in the current shift or since the last End Of Shift
3. In Catalogue name:
   
   • If you want to only display items sold from a specific catalogue tick the 'Select A Catalogue' box and choose the relevant catalogue. If not leave this blank.
     
4. Options:
   • Show Individual Stock Item Sales – Tick this box if you wish to see individual item sales in the generated report. This will allow you to be specific with what shows on the report. It allows you to see:
     • Sell Price & GP / Date Last Arrived – This option chooses weather the report shows the sell price and gross profit, or the date stock was last arrived.
     • Quantity on Hand – This shows the amount of quantity on hand of stock currently in the system.
     • Show Full Description – This shows the full description of the product rather than shortening it to fit the report.
     • Cost Prices  – This shows the cost price of the items on the report.
     • Barcode / Supplier Stock Code / PLU – This chooses which data is shown respective to each item.
   • Exclude Home Delivery & Subagent Orders – This option will stop home deliveries and Subagent orders from being shown on the report. This applies to Newsagencies only. 
   • Exclude Agency– Excludes departments which have been ticked as Agency, from being shown on the report (Eg. Lotto)
     
   • Average Takings by Days - Adds 3 additional columns to the report, showing the average daily Cost, GP and Qty Sold for the date range entered.
     
   • Show Department Categories - Further separates sales by Category on the report.
   • Show by Supplier Invoice - Only available if you have selected a specific Supplier in the 'Select Suppliers' area. Ticking this adds an additional 'Select Supplier Invoices' tab, which allows you to choose which invoices' stock is included in the report.
   • Show Serial Numbers – This will show serial numbers for products that have this setting enabled.
   • Date Created/Date Completed – This chooses weather to display Laybys by the date they are created or the date they are completed.
5. In select Departments:
   • Select which departments to search. To select all departments, click the ‘All’ circle at the top, otherwise click Selected. If you want stock not in a category to be included in the report, tick Include Stock not in a Category.
     If you clicked Selected use the tick-boxes on the right to select which departments and categories to show in the report.
6. In Select Suppliers
   • Select which Supplies to search. To select all supplies, click the ‘All’ circle at the top, otherwise click Selected. If you clicked ‘Selected’, then click on the Suppliers that you want to show. If you want multiple supplies to appear, then click on each supplier you want.
     
7. Click Preview or Print.

Reading the Report

The Supplier Sales Analysis Report has a total of sales for the period broken down by Supplier, Department, and Category, The Supplier’s name will appear at the top, then all items from this Supplier will appear underneath. If there are multiple Suppliers selected, they will appear in alphabetical order. Totals are provided per Category, Department and Supplier.

1. Description – Shows the Supplier, Department, Category if "Show Department Categories" is selected and Stock Item Descriptions if "Show Individual Stock Item Sales" is selected. 
2. Barcode – Shows the barcode of the stock item sold. Only displays if the  "Show Individual Stock Item Sales" and "Barcode" options are selected.
3. No. Of Items – Shows the total number of stock items by Department, Category if "Show Department Categories" is selected and per stock item if "Show Individual Stock Item Sales" is selected.
4. QOH – Shows the current Quantity On Hand for the stock items sold. Only displays if the "Show Individual Stock Item Sales" and "Quantity On Hand" options are selected.
5. Unit Cost – Shows the current individual cost for the stock items sold. Only displays if the "Show Individual Stock Item Sales" and "Cost Prices" options are selected.
6. Total Cost – Shows the total cost price of all items sold by each Department, Category if "Show Department Categories" is selected and Supplier.
7. Unit Sell Price – Shows the current Sell (Retail) price for each item sold. Only displays if the "Show Individual Stock Item Sales" and "Sell Price & GP" options are selected.
8. Total Sales – Shows the total sales value of all items sold Department, Category if "Show Department Categories" is selected, individual Stock Items if "Show Individual Stock Item Sales" is selected and Supplier 
   
9. Total GP – Shows the total amount of profit dollars made for each Department, Category if "Show Department Categories" is selected, per stock item if "Show Individual Stock Item Sales" is selected and Supplier
10. Total GP % - Shows the amount of profit made as a percentage of the gross profit dollars to total sales  for each Department, Category if "Show Department Categories" is selected, per stock item if "Show Individual Stock Item Sales" is selected and Supplier.
11. The data at the bottom demonstrates totals for each respective column and includes information about GST and rounding.