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

  1. From the main screen of Retailer, click on Reports -> Sales Reports ->Sales by Month.
  2. Select the date range for the report in Enter Date, and the report will run for the last 12 months ending with and including the entered month.
  3. There are 3 options here for grouping in the report.
    • Select Suppliers – Shows the report grouped by suppliers, and you can choose specific suppliers by clicking Selected (instead of Select All).
      Then, tick the boxes of suppliers to include in the report.
    • Select Departments – Shows the report grouped by departments and categories, and you can choose specific departments or categories by clicking Selected (instead of Select All)
      Then, tick the boxes of Departments or Categories to include in the report.
      Click the plus sign next to each Department to see Categories under it.
    • Select Stock Items – Report can be run for particular items by clicking Add Items.
      A box will appear for searching or entering stock items into the list.
      Add the items you want and click OK on the bottom left.
      NOTE: Click HERE for details on using this search screen.
      Back in the report screen, click Delete to remove selected items from the list, or click Clear to clear the whole list.

  4. There are various options at the bottom for showing / hiding information.
    • Include Stock Not in Category - will include stock items that have no category assigned.
      If unticked, will not include these item sales.
    • Show Individual Stock Item Sales - Show individual stock sold under each supplier/department/category.
      If unticked, will just show supplier/department/category totals.
    • Quantity on Hand - will show current stock on hand.
    • Date Last Arrived - will show date of last arrival for line item.
    • Sell Price - will show retail price of item.
    • Cost Price - will show cost price of item.
    • Show Full Description - will show long description of item. If unticked, will show short description.
    • Choose between displaying the Barcode or Supplier Stock Code or PLU of item.

Reading the Report

The report will be broken down into Suppliers or Departments and Categories depending on options selected. The date range will be shown at the top of the report.

  1. Barcode - This is the barcode or SKU of the product.
  2. QOH - The current quantity on hand for product.
  3. Sales total - Total number of product/department/category sold for the year
  4. Jan to Dec months - Number of product/department/category sold for each month
  5. Date Late Arrived - Date of last invoice arrival for product
  6. Cost Price - Current cost price of item
  7. Sell Price - Current sell price of item