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

Setup 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
    The 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

    • Related Articles

    • Stock by Age Report

      Grouped by supplier, this report will list departments, categories and stock, showing what is remaining on hand, from stock arrived during a period. It will give a quick overview of aged stock in the system. Generating The Report On the top menu bar ...

    • Stock Turn Report

      This report will list departments and categories, showing what has been arrived and sold during a period. Generating The Report On the top menu bar of Retailer, click on Reports -> Sales Reports -> Fast Sellers Report -> Stock Turn Report. Select the ...

    • Ranked Sales Report

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

    • Putaway Report

      This is for Newsagencies Only The Putaway Report can be used to generate a report for all your customer putaways on a given day or week. From the Main Screen of Retailer, click on Reports > Newsagency > Putaway Report Options: Select the date you ...

    • Subscription Report

      This is for Newsagencies Only The subscription report gives you a list of customers on subscriptions and can also be used to identify customers whose subscriptions have ended or are about to end. You can also use this report to check against reports ...