The Ranked Sales Report is an extremely useful tool when trying to increase the size of your basket sales. Through this report you will see your top selling items so you can start to identify similar stock lines that may sell well. This report will also help you identify product not selling as well as it could.

Generating the Report

  1. On the top menu bar of Retailer, click on Reports -> Sales Reports -> Ranked Sales Report.
  2. In Date Range, select the Start Date and End Date for the report.
  3. In Stock to Include, choose between:
    • Include All Stock Items
    • Only Include Stock From A Particular Supplier / Group Source - Select the supplier(s) from the right. Tick the suppliers you want to appear on the report. Under Itemise Instore/External Source you can tick the sources you wish to appear on the report (eg. webstore).
    • Only Include Stock From A Particular Dept. / Category  / Group Source - Select the department/category(s) from the right. Tick the departments / categories you want to appear on the report. Under Itemise Instore/External Source you can tick the sources you wish to appear on the report (eg. webstore).
  4. In Stock Quantity On Hand, choose between:
    • Include All Stock Regardless Of Their Current Quantity On Hand - Use this to include stock that has sold in the time frame select but that has a QOH of 0. Example stock that has sold out.
    • Only Include Stock With A Quantity On Hand Greater Than 0 - Only shows sales of stock currently on hand.
    • Only Include Stock With A Quantity On Hand Less Than Or Equal To 0 - Use this to only show stock that has sold out. This option can be handy to see stock that has sold well in the past but is currently out of stock.
  5. In Report Order, choose between:
    • Rank On Quantity Sold
    • Rank On Total Sales Amount ($)
    • Rank On Gross Profit ($)
    • Rank On Gross Profit (%)
      NOTE: You can sometimes get very different top sellers when you change between Qty sold and Gross Profit, this can be very helpful to see the difference between low margin, high turnover product and high margin product. 
  6. In Sales Options, choose between:
    • Include All Stock Regardless Of Their Sales
    • Only Include Stock That Has Been Sold
    • Only Include Stock That Has Not Been Sold
      NOTE: Only Include Stock That Has Not Been Sold allows you to view stock that hasn't sold in the selected time frame, allowing you to find dead stock. Click HERE for information on how you turn that dead stock into cash.
  7. In Other Options:
    • Exclude Home Delivery & Subagent Orders - Is turned on by default. Prevents sales from delivery orders appearing on report.
    • Show Quantity On Hand Summary - Shows Total Quantity, Total Cost Ex GST, Total GST Pay and Total Cost Inc GST at end of report.
    • Hide GP information - Removes Gross Profit % and Gross Profit $ from report.
    • Hide Total Value - Removes total value column from report.
  8. In Page Orientation, choose between:
    • Landscape (includes SSC) - Displays/Prints the report in landscape mode and includes the Supplier Stock Code, Supplier, Date Last Sold (DD/MM/YY) and Date Last Arrived (DD/MM/YY)
    • Portrait - Displays/Prints the report in portrait mode.
  9. Click Preview or Print.
  10. You will then be prompted to enter the ranking number of the items for the report. Set the numbers and click Close.

Reading The Report

You will see the following columns in the report:

  • Ranking – The ranking of item based on the settings you chose.
  • Barcode, Supplier Stock Code, Supplier, Description – Identifies the actual item sold. Supplier and Supplier Stock Code only show when report is in Landscape
  • Quantity Sold – The amount of that item sold in the time frame selected
  • Total Value - The total Retail value of items sold in the time frame selected. Note this is Retail Excluding GST
  • Gross Profit – Gives you the gross profit in dollar value and percentage
  • Date Last Sold – This is the month and year the item was last sold. Complete Date shows when report is in Landscape.
  • Date Last Arrived - This is the date the item was last arrived. (Landscape only)
  • Date Added – This is the month and year the item was added into the system.
  • Quantity On Hand - The current quantity on hand when the report was run.