The Sales By Time report is a great way to detect any quiet or peak times in your business based on a time period (Hour, half hour etc). Its a great report for accessing whether you should adjust or opening or closing times

Generating the Report

  1. On the top menu bar of Retailer, click on Reports -> Sales Reports -> Sales By Time.
  2. Report Date Range
    1. Start Date - this will be the Start Date of the report.
    2. End Date - this will be the End Date of the report. 
  3. Time Range
    1. Time Interval In Minutes - Allows you to group sales amounts by minutes. Eg: 15 for 15 minutes, 60 for an hour, 120 for 2 hours.
    2. Daily Start Time - Allows you to select the start time the report gathers data for. If your business opens at 8am, you should set the start time to 7am.
    3. Daily End Time - Allows you to select the end time the report gathers data for. If your business closes at 5pm, you should set the end time to 6pm.
  4. Days to include allows you to specify what days of the week you want to report on, so you could assess weekdays, weekends or individual days.
  5. Options
    1. Exclude Home Delivery & Subagent Orders - Allows you exclude delivery charges and subagent charges from the report. Applies to Newsagencies.
    2. Exclude Payout Departments - Allows you to exclude payout departments. Applies to Newsagencies.
    3. Exclude Agency - Allows you to excluded Agency departments if enabled on the department.
    4. Hourly Totals or Hourly Averages - This will either give you a total of the number of sales for the period selected or give you an average number of sales for that time.
  6. Click on Preview or Print.

Reading The Report

There are 4 columns as well as a graph included at the bottom of the Report.
  1. From / To - The time range based on the interval that was selected in the report options.
  2. No. of Sales or Avg. Sales - The second column will show one of two options, depending on whether Hourly Totals or Hourly Averages was selected. It will therefore either show the total number of sales or the average number of sales for that period.
  3. Total Sales - Shows the total value of sales for the time range.
  4. Average Sale Amount - The average amount of each sale for the period.

Exporting the Report to Excel

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.