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

    • Related Articles

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

    • Layby Report

      The Layby Report lets you find all Laybys which are still outstanding, have been collected between a particular date range or for a specific customer. Generating the Report From the main screen of Retailer, click on Reports -> Sales Reports -> Layby ...

    • POS Tracking Report

      Before generating a POS Tracking Report, click HERE for instructions on how to add POS tracking to your sales. POS tracking must be enabled for the POS Tracking report to be generated. The POS Tracking Report shows sales data for information gathered ...

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

    • Weekly Takings Report

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