Executive Comparison Crosstab Report

Executive Comparison Crosstab Report 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" 

To reach the "Executive Comparison Crosstab Report," follow the steps below (see Figure 1.0):

1. Step 1: Log into Control Center
   
2. Step 2: Choose Point of Sale
   
3. Step 3: Choose Reports
   
4. Step 4: Choose Sales Reports
   
5. Step 5: Choose Executive Comparison Crosstab
   

                                                                                          Figure 1.0

1. See Figure 1.1. You will see many types of sales reports that will be useful to your retail business.
   
2. By clicking the "Choose Report" drop-down selection, you will see the different types of sales reports.

                                                                         Figure 1.1

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

                                                                               Figure 1.2

2. Generating the "Executive Comparison Crosstab Report" 

To generate the "Executive Comparison Crosstab Report," follow the steps below (see Figure 2.1): 

1. Select the number of weeks to display the executive comparison crosstab for that number of weeks.

                                                                                    Figure 2.1

The following data gets fetched in report format when you click on the "Generate Report" button in the top right corner; "Executive Comparison Crosstab" will be displayed as highlighted in Figure 2.2.

                                                                                   Figure 2.2

Fields:

1. Customer Count: It represents the total number of transactions completed at the store during the week.
2. Inventory Shrink: It is calculated by subtracting the manual inventory count from the recorded inventory cost in the system. This data is sourced from cycle counts and reflects inventory shrinkage in terms of cost.
3. Labor Hours: It displays the total hours worked by employees during their shifts, based on time clock records.
4. Profit: It is determined using the formula: Profit = Revenue - Cost of Items Sold.
5. Sales Dollars: It represents the total revenue generated from completed sales transactions.
   
6. Total: It displays the overall total sales amount.

• Related Articles

• Crosstab Sales Report

  Crosstab Sales Report Overview The "Crosstab Sales Report" shows sales across different regions within a specified date range. FTx Cloud POS provides the flexibility to generate reports using combinations like Sales by Day of the Week and Store, ...

• Crosstab Sales Report - Store Employee

  Crosstab Sales Report Overview The "Crosstab Sales Report" in FTx Cloud POS summarizes and compares sales data across multiple dimensions. It lets you analyze your sales patterns by parameters such as the day of the week, hours of operation, and ...

• Transfer Cost Comparison Report

  Transfer Cost Comparison Overview The "Transfer Cost Comparison Report" provides detailed insights into product transfers across all store locations within your company. It is designed to help you compare the cost and quantity of products moved ...

• Sales Trend/Comparison Report

  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, dollar value sold, and profit made on items in a specific date range. It uses ...

• Department Sales Comparison Report

  Department Sales Comparison Report Overview A "Department Sales Comparison Report" takes the sales data from two defined date ranges and provides the information. FTx Cloud POS provides the department's specific comparison sales report with custom ...