Fast Sellers Report

Fast Sellers Report

The Fast Sellers Report ranks stock items sold in a period based on the number of days between arriving and selling the item.

The possible rankings are:
New - Arrived but not sold in the Fast Ranking number of days before the report date.
Fast - Stock Sold within this many days before the report date. Default is 30 days
Medium - Stock Sold in more days than Fast Ranking but less than this many days before report date. Default is 60 days
Slow - Stock Sold in more days than Medium Ranking but less than this many days before Report Date. Default is 90 days
Dead - Stock Sold more than Slow Ranking number of days after arrival will be ranked as Dead. Default is 90 days

Set Up Fast Seller criteria

You can define the number of days between Arriving and Selling an item for each of the Rankings above. These can be customised monthly per Department and Category. For example, you may have a seasonal Department you wish to give more time between Arriving and Selling an item before the item is ranked as Slow in particular months.
  1. From the main screen of Retailer, click Reports -> Sales Reports -> Fast Sellers Reports -> Fast Sellers Report
  2. Click Setup
  3. Use magnifying glass next to Department and Category to choose a department then a category. Alternatively, use the Arrow buttons above to switch between Departments and Categories.
  4. Change the number in the Fast, Medium or Slow columns
  5. Click Update all Categories with these Fast Sellers Rules to copy the current Categories number of days rules to the other categories of the current department
  6. When finished, click Close. Changes are automatically saved

Generating The Report

  1. From the main screen of Retailer, click Reports -> Sales Reports -> Fast Sellers Reports -> Fast Sellers Report
  2. Enter a Date to run the report from.
  3. Select a Department, Category and/or Supplier if you only wish to see stock items from a particular Department, Category or Supplier
  4. Report Visual Options
    1. Show Markup
    2. Show GP
    3. Show Retail
    4. Show Cost
    5. Show Category Totals, Show Department Totals, Show Supplier Totals - Show Totals for Quantity Sold, Sales (inc GST), Discount ($), Quantity on Hand, Quantity Received, Quantity on Order at either a Category, Department or Supplier level
  5. Show on Report
    1. New
    2. Fast
    3. Medium
    4. Slow
    5. Dead
    6. Only Show items with a QOH > 0 - Filter Report to only show items currently in-stock
    AlertThe more Rankings you select, the slower the report will be to generate. Dead requires a significant time to calculate. See How to Quit Dead Stock and Free Up Cash for other ways to report on Dead Stock
  6. Click Preview or Print


Reading The Report

Supplier - Name of Supplier of Stock Item
Department - Name of Department of Stock Item
Category - Name of Category of Stock Item
Rank - Stock Item Ranking: New, Fast, Medium, Slow, Dead
Stock Description - Stock Item Description
Barcode - Barcode of the stock item
SSC - Supplier Stock Code
Stock Turn - This figure divides your cost of sales with the value of stock held and tells you how many times stock is being sold and purchased over the specified time period.
      Eg. You have 5 of an item on hand (cost=$15). 3 are sold and 5 arrive with a cost of $20. 3x15 รท 7x20 =0.32. A higher Stock Turn is better
Average Days Shelf Life - Average number of days between arrival and sale
Quantity Sold - Number of stock item sold.
Sales (Inc GST) - Sales Total per stock item.
Discount $ - Total discount per stock item
GP $ - Total Gross Profit ($) of stock items sold.
Markup % - Total Markup Percentage of stock items sold.
Cost Inc $ - Cost Price last time item was sold or its current Cost Price
Retail $ - Retail Price last time item was sold or its current Retail Price
Quantity on Hand - Current Quantity on Hand for Stock Item
Quantity Received - Quantity Received during Reporting period
Quantity on Order - Quantity on Sent Orders

Exporting the Report

You can export the report to either a PDF document or Excel spreadsheet by using the Preview button and following the below steps:

  1. PDF - Click on the red PDF button at the top of the report and choose your save destination.
  2. Excel spreadsheet - Click on the Print button at the top left. Tick 'Print to File' and select 'Xlsx Data File'. Click on the three dots button to choose your save destination. Click OK to save the file.

    • Related Articles

    • Supplier Sales Analysis Report

      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 ...

    • Sales by Month Report

      This report shows the sales totals for each month in the past year ending with the selected month/date. The report can be grouped three different ways, and can display cost and sell prices together with sale numbers. Generating the Report From the ...

    • Staff Comparison Report

      The purpose of this report is to compare the sales performance of staff members within a specified date range. For this report to be effective, you must be using staff initials when ending sales. Generating the Report On the top menu bar of Retailer, ...

    • Monthly Takings Report

      The Monthly Takings Report lists departments and their breakdown of each sale type per month for the date range specified, up to 12 months individually or 5 months if GST breakdown is included. The report is not suitable if looking at figures for ...

    • Daily Takings Report

      The Daily Takings Report lists departments and their breakdown of each sale type per day for the date range specified, up to 12 days individually or 5 days if GST breakdown is included. Generating the Report On the top menu bar of Retailer, click on ...