Employee Threshold Exceptions
Summary report that shows employee transactions that exceed thresholds.
Description
The Employee Threshold Exceptions report is a summary report that consists of tables, multi-KPI tiles, and pie carts that show employee transactions that exceed specified thresholds. Thresholds are calculated as the average value over the past 12 weeks plus one standard deviation. This report can be used for loss prevention.
Permissions: Sales and Operations and Employee Performance.
Report Tags
Simphony, RES 3700, e7, Add On Tax, Inclusive Tax, Table Service, and Quick Service.
Checks Over Threshold by Employee, Metric, and Check Number
Visualization: Table.
Permissions: Sales and Operations and Employee Performance.
Table 2-117 Over Threshold Occurrences by Employee, Metric, and Check Number
| Category | Data Format | Description | Drill-Down Report |
|---|---|---|---|
|
Name |
String |
Employee name, metric, or check number |
Check number drills down to Check Detail |
|
Total Check Count |
Integer |
Total quantity of checks for the metric |
|
|
Total Amount |
Currency |
Total monetary amount of the metric |
|
|
Over Threshold Count |
Integer |
Quantity over the threshold |
|
|
Over Threshold Amount |
Currency |
Monetary amount of the metric over the threshold |
Past 12 Weeks Discounts Totals
Visualization: Multi-KPI tile.
Permission: Sales and Operations.
Table 2-118 Past 12 Weeks Discounts Totals
| Category | Data Format | Description |
|---|---|---|
|
Check Count |
Integer |
Quantity of checks with discounts in the last 12 weeks |
|
Percent of Total Checks |
Percent |
Percent of checks with discounts in the last 12 weeks |
|
Amount |
Currency |
Monetary amount of discounts in the last 12 weeks |
Past 12 Weeks Discounts Threshold
Visualization: Multi-KPI tile.
Permission: Sales and Operations.
Table 2-119 Past 12 Weeks Discounts Threshold
| Category | Data Format | Description |
|---|---|---|
|
Average Amount |
Currency |
Average monetary amount of discounts in the last 12 weeks |
|
Threshold Value |
Currency |
Monetary amount of discount threshold in the last 12 weeks |
Discounts Count Over vs. Under
Visualization: Pie chart.
Permission: Sales and Operations.
Table 2-120 Discounts Count Over vs. Under
| Category | Data Format | Description |
|---|---|---|
|
Over Threshold Count |
Percent |
Percent of discounts over threshold |
|
Under Threshold Count |
Percent |
Percent of discount under threshold |
Discounts Over Threshold Activity
Visualization: Table.
Permissions: Sales and Operations and Employee Performance.
Table 2-121 Discounts Over Threshold Activity
| Category | Data Format | Description |
|---|---|---|
|
Total Row |
The top row of the table shows totals for each category |
|
|
Name |
String |
Employee name or business date |
|
Total Check Count |
Integer |
Total quantity of all checks with discounts |
|
Total Amount |
Currency |
Total monetary amount of all discounts |
|
Over Threshold Check Count |
Integer |
Quantity of discounts over threshold |
|
Over Threshold Amount |
Currency |
Monetary amount of discounts over threshold |
Past 12 Weeks Void Totals
Visualization: Multi-KPI tile.
Permission: Sales and Operations.
Table 2-122 Past 12 Weeks Void Totals
| Category | Data Format | Description |
|---|---|---|
|
Check Count |
Integer |
Quantity of checks with voids in the last 12 weeks |
|
Percent of All Checks |
Percent |
Percent of checks with voids in the last 12 weeks |
|
Amount |
Currency |
Monetary amount of voids in the last 12 weeks |
Past 12 Weeks Void Threshold
Visualization: Multi-KPI tile.
Permission: Sales and Operations.
Table 2-123 Past 12 Weeks Void Threshold
| Category | Data Format | Description |
|---|---|---|
|
Average Amount |
Currency |
Average monetary amount of voids in the last 12 weeks |
|
Threshold Value |
Currency |
Monetary amount of void threshold in the last 12 weeks |
Voids Count Over vs. Under
Visualization: Pie chart.
Permission: Sales and Operations.
Table 2-124 Voids Count Over vs. Under
| Category | Data Format | Description |
|---|---|---|
|
Over Threshold Count |
Percent |
Percent of voids over threshold |
|
Under Threshold Count |
Percent |
Percent of voids under threshold |
Voids Over Threshold Activity
Visualization: Table.
Permissions: Sales and Operations and Employee Performance.
Table 2-125 Voids Over Threshold Activity
| Category | Data Format | Description |
|---|---|---|
|
Total Row |
The top row of the table shows totals for each category |
|
|
Name |
String |
Employee name or business date |
|
Total Check Count |
Integer |
Total quantity of all checks with voids |
|
Total Amount |
Currency |
Total monetary amount of all voids |
|
Over Threshold Check Count |
Integer |
Quantity of voids over threshold |
|
Over Threshold Amount |
Currency |
Monetary amount of voids over threshold |
Past 12 Weeks Error Correct Totals
Visualization: Multi-KPI tile.
Permission: Sales and Operations.
Table 2-126 Past 12 Weeks Error Correct Totals
| Category | Data Format | Description |
|---|---|---|
|
Check Count |
Integer |
Quantity of checks with error corrects in the last 12 weeks |
|
Percent of Total Checks |
Percent |
Percent of checks with error corrects in the last 12 weeks |
|
Amount |
Currency |
Monetary amount of error corrects in the last 12 weeks |
Past 12 Weeks Error Correct Threshold
Visualization: Multi-KPI tile.
Permission: Sales and Operations.
Table 2-127 Past 12 Weeks Error Correct Threshold
| Category | Data Format | Description |
|---|---|---|
|
Average Amount |
Currency |
Average monetary amount of error corrects in the last 12 weeks |
|
Threshold Value |
Currency |
Monetary amount of error corrects threshold in the last 12 weeks |
Error Corrects Count Over vs. Under
Visualization: Pie chart.
Permission: Sales and Operations.
Table 2-128 Error Corrects Count Over vs. Under
| Category | Data Format | Description |
|---|---|---|
|
Over Threshold Count |
Percent |
Percent of error corrects over threshold |
|
Under Threshold Count |
Percent |
Percent of error corrects under threshold |
Error Corrects Over Threshold Activity
Visualization: Table.
Permissions: Sales and Operations and Employee Performance.
Table 2-129 Error Corrects Over Threshold Activity
| Category | Data Format | Description |
|---|---|---|
|
Total Row |
The top row of the table shows totals for each category |
|
|
Name |
String |
Employee name or business date |
|
Total Check Count |
Integer |
Total quantity of all checks with error corrects |
|
Total Amount |
Currency |
Total monetary amount of all error corrects |
|
Over Threshold Check Count |
Integer |
Quantity of error corrects over threshold |
|
Over Threshold Amount |
Currency |
Monetary amount of error corrects over threshold |
Past 12 Weeks Return Totals
Visualization: Multi-KPI tile.
Permission: Sales and Operations.
Table 2-130 Past 12 Weeks Return Totals
| Category | Data Format | Description |
|---|---|---|
|
Check Count |
Integer |
Quantity of checks with returns in the last 12 weeks |
|
Percent of Total Checks |
Percent |
Percent of checks with returns in the last 12 weeks |
|
Amount |
Currency |
Monetary amount of returns in the last 12 weeks |
Past 12 Weeks Return Threshold
Visualization: Multi-KPI tile.
Permission: Sales and Operations.
Table 2-131 Past 12 Weeks Return Threshold
| Category | Data Format | Description |
|---|---|---|
|
Average Amount |
Currency |
Average monetary amount of returns in the last 12 weeks |
|
Threshold Value |
Currency |
Monetary amount of returns threshold in the last 12 weeks |
Returns Count Over vs. Under
Visualization: Pie chart.
Permission: Sales and Operations.
Table 2-132 Returns Count Over vs. Under
| Category | Data Format | Description |
|---|---|---|
|
Over Threshold Check Count |
Percent |
Percent of returns over threshold |
|
Under Threshold Check Count |
Percent |
Percent of returns under threshold |
Returns Over Threshold Activity
Visualization: Table.
Permissions: Sales and Operations and Employee Performance.
Table 2-133 Returns Over Threshold Activity
| Category | Data Format | Description |
|---|---|---|
|
Total Row |
The top row of the table shows totals for each category |
|
|
Name |
String |
Employee name or business date |
|
Total Check Count |
Integer |
Total quantity of all checks with returns |
|
Total Amount |
Currency |
Total monetary amount of all returns |
|
Over Threshold Check Count |
Integer |
Quantity of returns over threshold |
|
Over Threshold Amount |
Currency |
Monetary amount of returns over threshold |
Past 12 Weeks Transferred Checks Totals
Visualization: Multi-KPI tile.
Permission: Sales and Operations.
Table 2-134 Past 12 Weeks Transferred Checks Totals
| Category | Data Format | Description |
|---|---|---|
|
Check Count |
Integer |
Quantity of transferred checks in the last 12 weeks |
|
Percent of Total Checks |
Percent |
Percent of transferred checks in the last 12 weeks |
|
Amount |
Currency |
Monetary amount of transferred checks in the last 12 weeks |
All Transferred Checks Activity
Visualization: Table.
Permissions: Sales and Operations and Employee Performance.
Table 2-135 All Transferred Checks Activity
| Category | Data Format | Description |
|---|---|---|
|
Total Row |
The top row of the table shows totals for each category |
|
|
Name |
String |
Employee name or business date |
|
Total Check Count |
Integer |
Total quantity of all transferred checks |
|
Total Amount |
Currency |
Total monetary amount of all transferred checks |
Past 12 Weeks Canceled Transactions Totals
Visualization: Multi-KPI tile.
Permission: Sales and Operations.
Table 2-136 Past 12 Weeks Canceled Transactions Totals
| Category | Data Format | Description |
|---|---|---|
|
Transaction Count |
Integer |
Quantity of canceled transactions in the last 12 weeks |
|
Percent of Total Checks |
Percent |
Canceled transactions as a percent of all transactions in the last 12 weeks |
|
Amount |
Currency |
Monetary amount of canceled transactions in the last 12 weeks |
All Canceled Transactions Activity
Visualization: Table.
Permissions: Sales and Operations and Employee Performance.
Table 2-137 All Canceled Transactions Activity
| Category | Data Format | Description |
|---|---|---|
|
Total Row |
The top row of the table shows totals for each category |
|
|
Name |
String |
Employee name or business date |
|
Total Transaction Count |
Integer |
Total quantity of all canceled transactions |
|
Total Amount |
Currency |
Total monetary amount of all canceled transactions |
Past 12 Weeks No Sale Transactions Totals
Visualization: Multi-KPI tile.
Permission: Sales and Operations.
Table 2-138 Past 12 Weeks No Sale Transactions Totals
| Category | Data Format | Description |
|---|---|---|
|
Transaction Count |
Integer |
Number of no sale transactions in the last 12 weeks |
|
Percent of Total Checks |
Percent |
No sale transactions as a percent of all transactions in the last 12 weeks |
All No Sale Transactions Activity
Visualization: Table.
Permissions: Sales and Operations and Employee Performance.
Table 2-139 All No Sale Transactions Activity
| Category | Data Format | Description |
|---|---|---|
|
Total Row |
The top row of the table shows totals for each category |
|
|
Name |
String |
Employee name or business date |
|
Total Transaction Count |
Integer |
Total quantity of all no sale transactions |
Past 12 Weeks Edited Closed Checks Totals
Visualization: Multi-KPI tile.
Permission: Sales and Operations.
Table 2-140 Past 12 Weeks Edited Closed Checks Totals
| Category | Data Format | Description |
|---|---|---|
|
Check Count |
Integer |
Number of edited closed checks in the last 12 weeks |
|
Percent of Total Checks |
Percent |
Edited closed checks as a percent of all checks in the last 12 weeks |
|
Amount |
Currency |
Monetary amount of edited closed checks in the last 12 weeks |
All Edited Closed Checks Activity
Visualization: Table.
Permissions: Sales and Operations and Employee Performance.
Table 2-141 All Edited Closed Checks Activity
| Category | Data Format | Description |
|---|---|---|
|
Total Row |
The top row of the table shows totals for each category |
|
|
Name |
String |
Employee name or business date |
|
Total Check Count |
Integer |
Total quantity of all edited closed checks |
|
Total Amount |
Currency |
Total monetary amount of all edited closed checks |
Past 12 Weeks Reopened Checks Total
Visualization: Multi-KPI tile.
Permission: Sales and Operations.
Table 2-142 Past 12 Weeks Reopened Checks Totals
| Category | Data Format | Description |
|---|---|---|
|
Check Count |
Integer |
Quantity of reopened checks in the last 12 weeks |
|
Percent of Total Checks |
Percent |
Reopened checks as a percent of all checks in the last 12 weeks |
|
Amount |
Currency |
Monetary amount of reopened checks in the last 12 weeks |
All Reopened Checks Activity
Visualization: Table.
Permissions: Sales and Operations and Employee Performance.
Table 2-143 All Reopened Checks Activity
| Category | Data Format | Description |
|---|---|---|
|
Total Row |
The top row of the table shows totals for each category |
|
|
Name |
String |
Employee name or business date |
|
Total Check Count |
Integer |
Total quantity of all reopened checks |
|
Total Amount |
Currency |
Total monetary amount of all reopened checks |
Report Notes
-
Checks or transactions with values that exceed calculated thresholds are displayed. Thresholds are calculated as the average value over the past 12 weeks plus one standard deviation.
-
No threshold is calculated. All occurrences are displayed.
These results are not necessarily indications of theft.
Parent topic: Summary Reports