Discount Spiff Report

Discount Spiff Report

Discount Spiff Report

Reports -> Sales Reports -> "Discount Spiff"

Store employees can play a vital role in selling the items, especially during checkout. Employees can earn some commission by selling the items to customers when the discount is applicable. When the discount is being configured from the control center, the store admin or sales manager can enable the discount commission for the POS employee/cashier who will get the commission if the discount is triggered during the checkout.


                                                                 Figure 1
The Discount Spiff Report provides data on commission (spiff) when the discount is triggered. It also helps to calculate the employee's earnings (spiff) within the specific date range. The Discount Spiff Report will show the 6 types of data in the report.

1. Reaching the Discount Spiff Report

To reach the Discount Spiff Report, follow the below steps: 
  1. Step 1: Log into Control Center
  2. Step 2: Choose Point of Sale

                                                                                          Figure 1.1
  1. Step 3: Choose Reports
  2. Step 4: Choose Sales Reports

                                                                         Figure 1.2
  1. Step 5: Choose Discount Spiff                          

                                                                                                                               Figure 1.3
By clicking "Discount Spiff," you will be redirected to the "Discount Spiff Report" page with the report type and relevant filter options.

                                                                                                                          Figure 1.4
Initially, you will see the "Report data is empty" message. You need to select the date range to check the house account balance report sales data in the report.

2. Report Type

You can check the Discount Spiff data as per the different parameters by selecting the report type. You can see the total 6 different parameters to check the Discount Spiff data in the report:
  1. Spiff Discount Summary
  2. Spiff Discount Summary by Employee
  3. Spiff Discount Summary Group by Store
  4. Spiff Discount Details
  5. Spiff Discount Details by Employee
  6. Spiff Discount Item Details
                                                                                                                          Figure 2.1

2.1 Spiff Discount Summary

When you navigate to the report page, the Spiff Discount Summary report type will be selected by default.

                                                                                                                                                       Figure 2.1.1
By generating the report, you will see the following data in the tabular view:
  1. Discount Name: This column represents the name of the discount that was configured in the "Discounts" module.
  2. Spiff Qty: This column represents the spiff qty that was triggered and counted for the discount during checkout.
  3. Spiff Amount: This column represents the applicable spiff amount ($) as per the "Discount Commission" (Spiff Amount & Commission Trigger Type) setup.

2.2 Spiff Discount Summary by Employee

Select the "Spiff Discount Summary by Employee" report type to get the Discount Spiff Report data for the employees who earned the commission.

                                                                                                                                                       Figure 2.2.1
After selecting the type and generating the report, you will see the following employee-wise data in the tabular view:
Employee Name: You can see the name of the employee and the earnings summary details under the name. It is also possible that the employee can earn spiff from more than one different discount.
  1. Discount Name: This column represents the name of the discount that was configured in the "Discounts" module.
  2. Spiff Qty: This column represents the spiff qty that was triggered and counted for the discount during checkout.
  3. Spiff Amount: This column represents the applicable spiff amount ($) as per the "Discount Commission" (Spiff Amount & Commission Trigger Type) setup.

2.3 Spiff Discount Group by Store

Select the "Spiff Discount Summary Group by Store" report type to get the Discount Spiff Report data for stores.
                                                                                                                            Figure 2.3.1
After selecting the type and generating the report, you will see the following store-wise data in the tabular view:
Location (Store) Name: You can see the name of the store and the earnings details. It is also possible that multiple discounts have the discount commission configured.
  1. Discount Name: This column represents the name of the discount that was configured in the "Discounts" module.
  2. Spiff Qty: This column represents the spiff qty that was triggered and counted for the discount during checkout.
  3. Spiff Amount: This column represents the applicable spiff amount ($) as per the "Discount Commission" (Spiff Amount & Commission Trigger Type) setup.

2.4 Spiff Discount Details

Select the "Spiff Discount Details" report type to get the transaction details in which the discount commission was triggered.

                                                                                                                             Figure 2.4.1
After selecting the type and generating the report, you will see the following discount-wise data in the tabular view:
Discount Name: You can see the discount name and the transaction details of the discount commission. It is also possible that the discount commission is applicable to multiple stores.
  1. Store: This column represents the store name where the discount commission was triggered on the transactions.
  2. Date: This column represents the date and time span when the transaction was initiated with a discount commission.
  3. Reg #: This column represents the register number of the transaction.
  4. Receipt #: This column represents the receipt number of the transaction.
  5. Spiff Qty: This column represents the spiff qty that was triggered and counted for the discount during checkout.
  6. Spiff Amount: This column represents the applicable spiff amount ($) as per the "Discount Commission" (Spiff Amount & Commission Trigger Type) setup.

2.5 Spiff Discount Details by Employee

Select the "Spiff Discount Details by Employee" report type to get the transaction details for the employees to check the earned spiff amount as per the transaction details.

                                                                                                                                   Figure 2.5.1
After selecting the type and generating the report, you will see the following discount-wise data in the tabular view:
Employee Name & Discount: You can see the employee's name and the applicable discount commission for the discount. It is also possible that the employee earned the spiff from more than one discount.
  1. Store: This column represents the store name where the discount commission was triggered on the transactions.
  2. Date: This column represents the date and time span when the transaction was initiated with a discount commission.
  3. Reg #: This column represents the register number of the transaction.
  4. Receipt #: This column represents the receipt number of the transaction.
  5. Spiff Qty: This column represents the spiff qty that was triggered and counted for the discount during checkout.
  6. Spiff Amount: This column represents the applicable spiff amount ($) as per the "Discount Commission" (Spiff Amount & Commission Trigger Type) setup.

2.6 Spiff Discount Item Details

Select the "Spiff Discount Item Details" type to get the item details on which the discount commission was triggered.

                                                                                                                                                  Figure 2.6.1
After selecting the type and generating the report, you will see the item-wise following data in the tabular view:
Discount: You can see the item-wise discount spiff's derails under the specific discount name under which the item was selected and the discount commission was set up.
  1. UPC: This column represents the UPC code for an item.
  2. Item Name: This column represents the item name on which the discount commission was triggered during checkout.
  3. Spiff Qty: This column represents the spiff qty that was triggered and counted for the discount during checkout.
  4. Spiffs Given: This column represents the applicable spiff amount ($) as per the "Discount Commission" (Spiff Amount & Commission Trigger Type) setup.

3. Filter Options

You can filter the discount spiff data in the report by selecting the different filter options to get the exact record in the report.

3.1 Filter by Discount

Select the specific discount to get the discount spiff data in the report for that. By clicking the "Filter by Discount" option, you can select the specific discount(s) for which you want to check the discount spiff records in the report.

                                                                                                                                                            Figure 3.1.1
 

                                                                                                                                                            Figure 3.1.2
After selecting the discount(s), generate the report and check the desired discount spiff data.

3.2 Filter by Employee

Select the specific employee to get the discount spiff data in the report for that. By clicking the "Filter by Discount" option, you can select the specific employee(s) for whom you want to check the discount spiff records in the report.

                                                                                                                                                Figure 3.2.1
You can tick the checkbox of the employee(s) from the left side and move to the right side under the "Selected List" to get the discount spiff data.

                                                                                                                                                            Figure 3.2.2
After selecting the employee(s), generate the report and check the desired discount spiff data.

3.3 Filter by Location

You can filter the "Discount Spiff" data in the report by selecting a specific location or location group. From the top-right corner, there's a filter button to select the particular location(s)/location group(s).

                                                                                                                                                  Figure 3.3.1
By clicking that button, the "Manage Filters" button will pop up to select the location/location group to filter the House Account Balance data in the report accordingly.
1. Select the store (location) records and/or location group records from the list.
2. If you have already saved the filter for the specific location/location group, you can select it by clicking the "Manage Filters" button.

                                                                                                                                                  Figure 3.3.2
3. Store records/location Group records can be seen on the left side. Tick the checkbox for the record and move it to the right side under "Selected List."
4. Clear selection if you want to remove all the records under the "Selected List." You can also remove a single record from the list.
5. Once the records are selected, click the "Apply" button and generate the report, or click the "Save Filters" button to save for future use.

After generating the report, the discount spiff data can be seen as per the selection (filter location/location group).

                                                                                                                                                  Figure 3.3.3

3.4 Date Range

You can filter your sales data in the report by selecting the date range as well as specific times.
By clicking the edit box, you will be taken to a tiny calendar where you can select a specific date range. You can also manually enter the date manually in mm/dd/yyyy format.


                                                                                                                                                  Figure 3.4.1
If you want the sales data in the report for a specific time duration (till morning/evening), you can select the particular time (hours and minutes) from the date selection.
Presets
Presets label is provided to select the specific duration/interval to generate the category sales data with that.

In this way, you can check the discount spiff that was triggered during the sales transaction by filtering the report type as well as the filter option to get the data in the report.


    • Related Articles

    • Manual Discount Report

      Manual Discount Report Overview Reports -> Sales Reports -> "Manual Discount" You can provide the manual discount to the customer during the checkout. Although the system discount might be applied if it is applicable, apart from that, a cashier can ...

    • Discount Details Report

      KB Article Coming Soon!

    • Flash Report

      Flash Report Reports -> Sales Reports -> "Flash Report" Flash Report is about checking some configuration records in a quick way, so you don't need to redirect to the individual setups. You can check the following configurations to check their ...

    • Coupon Report

      Coupon Report Overview The Coupon Report displays a list of store and manufacturer coupons that provide discounts on a specific product or purchase amount. These coupons are funded either by the retail store or the product manufacturer, and the store ...

    • System Discounts Report

      System Discounts Report Overview This report is multiple reports in one and gives different formats, groupings, details, and summaries of system discounts applied in transactions. Different types of filters can also be configured, depending on your ...