Category and Segment Performance Report

Category and Segment Performance Report

The Category and Segment Performance Report will compare your sales by Category and Segment over a date range. The Report will Rank Categories, Segments and Stock Items by Quantity Sold, Gross Profit, Total Sales or Percentage of Returns.

Segments are an additional level of product categorisation under the Retailer Department and Category structure. The Hierarchy is Department -> Category -> Segment. They are used by Magazine and Card Suppliers for more detailed reporting of product sales by Sub-Category. This report is therefore not used outside of Newsagency businesses.
NotesIf you don't use Segments, this report should not be used. Try the Monthly Sales Comparison Report instead.

Segments are set by importing a Supplier Stock File from certain Suppliers. See the relevant article for steps for your Supplier.

Generating the Report

  1. In the top menu bar of the Retailer Main Screen, click Reports -> Sales Reports -> Category and Segment Performance Report.
  2. Under Select Date Range, choose between:
    1. Moving Annual Total - Select the end date here; the report will cover the year up until this date
    2. Year to Date - Either Calendar Year or Financial Year
    3. Quarter
      1. Mar = January to March
      2. Jun = April to June
      3. Sep = July to September
      4. Dec = October to December
    4. Date Range  - specify two date ranges to compare. 
  3. If you wish to show only a particular Department, select it from the list.
  4. The Report can be run in 2 modes:
    1. Supplier Category Segment Stock
      1. Choose between All Categories or a Selected Category
      2. Choose between All Suppliers or a Selected Supplier
    2. Title Comparisons (for Magazines)
      1. Add Groups to Include
      2. Add Individual Stock Items to Include
  5. Under Select the Visual Options for the Report, you can choose to Show:
    1. Show Segments under each Category
    2. Show Individual Stock Items under each Segment
    3. Exclude Home Delivery & Subagent Orders (newsagency only)
    4. Show Segment Total Sales as a percentage of Total
  6. Under Rank Report on, choose between
    1. Quantity Sold
    2. Gross Profit $
    3. Total Sales $
    4. Returns %
  7. Click Preview

Reading the Report

The Category and Segment Performance Report will show sales figures for two date ranges for comparison with a Variance between the two date ranges.
Click the Category or Segment Names to expand or collapse the report data under that Category or Segment.
The Following data points will show on the report:
  1. Units Sold - Total number of items sold in the date range
  2. Total Sales - Total ex tax retail value of items sold in the date range
  3. GP $
  4. % of Total Sales - Percentage of Total Sales each category makes up in the total sales in the report. Segments shows percentage of Sales within each Category. Stock Items show percentage of Sales within each Segment.
  5. Returns %

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. CSV - Click the Create CSV button at the top of the report and choose your save destination.
  3. 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

    • Category Performance Report

      The Category Performance Report allows you to view your top performing categories in each department based on their gross profit, it can be run for all departments or a specific department. Generating the Report On the top menu bar of Retailer, click ...

    • Detailed Performance Report

      The Detailed Performance Report allows you to assess your stock's performance using key retail indicators like gross profit, return on investment, and stock turn. It can display totals for individual stock items, categories, or departments. It's also ...

    • Detailed Performance Report by Supplier

      The detailed performance report by supplier allows you to see how your stock is performing based on some key retail indicators such as gross profit, return on investment and stock turn. Its also only 1 of 2 reports that include Price Breaks if they ...

    • Monthly Sales Comparison Report

      We have a video guide on how to use the Monthly Sales Comparison Report - ? Monthly Sales Comparison Report If you only look at one report regularly in your Retailer software, it should be the Monthly Sales Comparison report. This report is great ...

    • Price Changes Report

      The Price Changes Report shows details of price changes to stock items within the selected criteria. Generating the Report On the top menu bar of Retailer, click on Reports -> Stock Reports -> Price Changes Report. In Report date range: Select the ...