Executive Comparison Crosstab

Executive Comparison Crosstab

Executive Comparison Crosstab Report Summary Overview

The Executive Comparison Crosstab Report combines data from various areas such as sales, cycle counts, and the time clock to show an overview of a given location by weekly period.

1. Reaching the Executive Comparison Crosstab Report Summary

To reach the "Executive Comparison Crosstab," follow the below steps (See Figure A):
  1. Step 1: Log into Control Center
  2. Step 2: Choose Point of Sale
  3. Step 3: Choose Reports
  4. Step 4: Choose Sales Report
  5. Step 5: Choose Executive Comparison Crosstab
See Figure A. You will see many types of inventory reports that will be useful to your retail business. By clicking the "Choose Report" drop-down selection, you will see the different types of sales reports.


                                                                          Figure A

You will see the "Report Data is Empty" message initially. You need to select the date range to check the "Executive Comparison Crosstab Report." See Figure B.

                                                                               Figure B

2. Generating the Executive Comparison Crosstab Report 

To generate the Executive Comparison Crosstab Report, follow the steps below: (See Figure B above.)
  1. From the "Executive Comparison Crosstab" page, you will see the "Choose Reports" drop-down selection.
  2. By clicking the drop-down selection, you will see different types of sales reports in alphabetical order.
  3. Search for "Executive Comparison Crosstab" from the list and click on it.
Select the number of weeks to display the executive comparison crosstab for that number of weeks.
The following data gets fetched in report format when you click on the "Generate Report" button in the top right corner; the "Executive Comparison Crosstab" will be displayed as highlighted in Figure C.


                                                                                    Figure C
Fields:
  1. Customer Count: This is the count of transactions made at the store during that week.
  2. Inventory Shrink: To determine inventory shrinkage according to cost, evaluate the manual count of inventory and subtract it from the inventory cost listed in your books. This data comes from cycle counts.
  3. Labor Hours: This column utilizes the time clock to display the working hours of the employee working that shift.
  4. Profit: The Profit value is calculated as: Profit = Revenue – Cost of Items Sold.
  5. Sales Dollars: This column displays the total dollar amount for which the sales have been successfully conducted.
  6. Total: This column displays the overall total sales amount.

    • Related Articles

    • CrossTab Sales

      CrossTab Sales Report Overview CrossTab Sales Report will display a report with quantities of different products that are sold in different regions and their sales totals within a specific date range. You can use the drop-down filter labeled ...

    • Sales Trend/Comparison

      Sales Trend/Comparison Report The Sales Trend/Comparison Report is a compilation of multiple reports in one, showing different trends and plots based on quantity sold, amounts sold, and profit made on items in a specific date range. It uses consumer ...

    • Transfer Cost Comparison

      Transfer Cost Comparison Overview The Transfer Cost Comparison report will display the product transfer data for all the store locations of your company. The primary purpose of this report type is to compare the value of the cost and quantity of each ...

    • Department Sales Comparison

      Department Sales Comparison Overview Reports -> Sales Reports -> "Department Sales Comparison" A sales data comparison report will help the retail business owner or sales manager check when the sales were at their peak or lowest between the specific ...

    • Uplift Sales

      Uplift Sales Report Overview Uplift Sales Report will display the list of employees who won or lost a spiff commission. The spiff is set up from the Commission Campaign (Pricebook -> Commissions) and the employee will earn the commission selling the ...