Executive Comparison Crosstab Report
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):
- Step 1: Log into Control Center
- Step 2: Choose Point of Sale
- Step 3: Choose Reports
- Step 4: Choose Sales Report
- 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.)
- From the "Executive Comparison Crosstab" page, you will see the "Choose Reports" drop-down selection.
- By clicking the drop-down selection, you will see different types of sales reports in alphabetical order.
- 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:
- Customer Count: This is the count of transactions made at the store during that week.
- 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.
- Labor Hours: This column utilizes the time clock to display the working hours of the employee working that shift.
- Profit: The Profit value is calculated as: Profit = Revenue – Cost of Items Sold.
- Sales Dollars: This column displays the total dollar amount for which the sales have been successfully conducted.
- Total: This column 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, ...Transfer Cost Comparison Report
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 ...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 ...Cycle Count Coverage Report
Cycle Count Coverage Report Overview Reports -> Inventory Reports -> "Cycle Count Coverage" The store admin/executive manages the inventory of the store using a POS system handheld device to count the inventory periodically. At the time of counting ...