Retail Back Office: Discounts Report

Retail Back Office: Discounts Report


Navigation: Sign into the Back Office for your Retail Store. Select Reports > Discount


  1. Sales Created By Window – For certain reports, when a Sales Created By value is clicked, a new window opens:

    1. Upon clicking the Sale Created By employee, it routes to a separate window which shows the sale made by the respective employee. Click < Back to revert to the main table page.
      1. Receipt Number – Node and Receipt Number [Node-ReceiptNumber format].
      2. Customer – The service type of the customer.
      3. Transaction Date – The Date and Time the receipt was generated.
      4. Net Sales – The net sales made for the employee.
      5. Total Tax – The net tax made for the employee.
      6. Incl. Tax – The inclusive tax made by the employee.
      7. CC Service Charge – The cc service type generated.
      8. Discount – Discount generated for the receipt.
      9. Gross Receipt – The net receipt for the services.
      10. Closed By – The employee who closed the receipt will be shown.
      11. Closed On – The POS Node from where the receipt was closed.
      12. Grand Sales – The total sales made for the employee.

    2. Receipt Number Window - When a Receipt Number is selected, the Receipt's page appears, broken down by the following sections:
      1. Receipt Summary – Displays a breakdown of the Receipt, including Receipt Number, Customer (Name), Date (and Time, DD-MM-YYYY 00:00 AM/PM format), Service Type, Seat Number (based on the Service Type), Gratuity (amount), Discount (amount), Service Charge (if applicable for Credit Card charges), Online Order Service Charge (if applicable for Online Orders), Total and Total Tip (amounts collected for the receipt), Cash Discount, and Item Service Charge.


      2. Order Summary – Displays a breakdown of the customer’s Order on the Receipt, including (Menu) Item, Price and Qty (of the Menu Item), Amount (Price * Quantity), and Sub Total (sum of the values in Amount).


      3. Tax Summary – Displays a breakdown of the Receipt, including Type (of Tax), Rate % (of Tax to the Receipt), Amount (Menu Item Price * % of the Tax), and Tax Total (sum of the values in Amount).


      4. Payment Summary – Displays a breakdown of the Payment(s), including Payment No (of the Receipt), Type (of payment: Cash, CC, etc.), Tip (added to the Receipt), CC Service Charge (when applicable), Amount (paid on the Receipt), Status (Success or Failed), Auth Code Transaction No [Number] (of the Receipt), and Payment Ticket (download the Ticket in PDF format). Note: If there are multiple payments, then all of them are displayed.



Discount
Store Credit
Discount
Report Type > Summary
  1. Discount – Select the Name of the Discount from the dropdown, or select All (Default).


  2. Sales Created By – Select an Employee who entered the Discount(s) (as established by their Role that has access to Discounts when set up in User Management), or All (Default). If an Employee is selected, the first 8 characters of their username will appear on the table. Scroll up or down to find the Employee sorted alphabetically, or Search to find more quickly.

  3. Discount Coupon Type – Select the Coupon Type (Promo, Comp or Donation) to base the listed Discounts on, or select All (Default).


  4. Summary Table - Displays the results when you click Apply, with the columns Discount Name, Discount Total, % of Total, Count, Average and Discount Coupon Type.
    1. Discount Name – The Name of the Discount as established in Back Office.
    2. Discount Total – The whole number followed by 2 decimals will be the discount total format. The net discount total for the discount selected will be shown in this row.
    3. % of Total – Total percentage of the discount value with the total sale will be shown here.
    4. Count – The number of times (whole numbers only) the discount has been applied.
    5. Average – The Discount Total divided by the Count value (up to 2 decimal points).
    6. Discount Coupon Type – The Discount Type (Promo, Comp, Donation).
    7. Total Discounts – The total for the columns Discount Total, % of Total, Counts, and Average.
    8. Total Receipts – The Total number of Receipts based on your selection
    9. % of Receipt Discounted – The [(Total Number of Discounted Receipts / Total Receipts) * 100].
    10. Gross Sales – The value of the formula: Sum of all payments + Gross Void + Discount + Discount Tax + Void Discount + Void Discount Tax - (GC Sold + HA Sold + Membership Sold + GiveX Sold + Gratuity + Delivery Compensation).
    11. % Discount of Gross Sales – The value of the formula: (Total Discount / Gross Sale) * 100.
    12. Receipts Discounted – The sum of all receipts discounted will be shown.

Report Type > By Employee
Generates a series of dropdowns pertaining to Employees, as established from the Discounts page in Back Office.

  1. Approved By – Select an Employee who closed the receipt (as established by their Role that has access to Discounts when set up in User Management), or All (Default). If an Employee is selected, the first 11 characters of their username will appear on the table. Scroll up/down to find the Employee sorted alphabetically, or Search to find more quickly.

  2. Employee Name – Select an Employee who entered the Discount(s) (as established by their Role that has access to Discounts when set up in User Management), or All (Default). If an Employee is selected, the first 11 characters of their username will appear on the table. Scroll up/down to find the Employee sorted alphabetically, or Search to find more quickly.

  3. Discount – Select the Name of the Discount from the dropdown, or select All (Default). If an Employee is selected, the first 11 characters of their username will appear on the table. Scroll up/down to find the Discount sorted alphabetically, or Search to find them more quickly.

  4. Sales Created By – Select an Employee (as established by their Role that has access to Discounts when set up in User Management), or All (Default). If an Employee is selected, the first 8 characters of their username will appear on the table. Scroll up/down to find the Employee sorted alphabetically, or Search to find them more quickly.

  5. Discount Coupon Type – The Discount Type (Promo, Comp, Donation), or select All (Default).


  6. Report Type > By Employee Table – After clicking Apply, the following columns are shown:
    1. Date – The Date the sale was made (DD-MM-YYYY format).
    2. Receipt – Node and Receipt Number (Node-ReceiptNumber format).
    3. Sale Created By – The Employee who created the Sale. Clicking it opens a new window.
    4. Applied By – The Employee who applied the Discount.
    5. Approved By – The Employee who closed the receipt.
    6. Employee Name – The respective employee’s name will be in this column.
    7. Reason – The Reason and feedback for the discount.
    8. Discount Name – Discounts name entered from the back office will be shown in this column.
    9. Discount Type – The discount type will be shown in this column - (Item based discount/Receipt based discount/ Open receipt /Open item / Mix and match discount).
    10. Discount Amount – The discount for the sale will be displayed in this column.
    11. Receipt Total – The net value of the sale will be displayed.
    12. Quantity – The number of sale item from which the discount was applied for will be shown.
    13. Total – Displays the Sum of the Discount Amount and Quantity columns, broken down by Sale Created By value.
Report Type > By Discount
Generates a series of dropdowns pertaining to Discounts, as established from the Discounts page in Back Office.
  1. Approved By – Select an Employee who closed the receipt (as established by their Role that has access to Discounts when set up in User Management), or All (Default). If an Employee is selected, the first 11 characters of their username will appear on the table. Scroll up/down to find the Employee sorted alphabetically, or Search to find more quickly.

  2. Employee Name – Select an Employee who entered the Discount(s) (as established by their Role that has access to Discounts when set up in User Management), or All (Default). If an Employee is selected, the first 11 characters of their username will appear on the table. Scroll up/down to find the Employee sorted alphabetically, or Search to find more quickly.

  3. Discount – Select a Discount name, or All (Default). If an Discount is selected, the first 11 characters of their username will appear on the table. Scroll up/down to find the Employee sorted alphabetically, or Search to find more quickly.

  4. Sale Created By – Select an Employee who entered the Discount(s) (as established by their Role that has access to Discounts when set up in User Management), or All (Default). If an Employee is selected, the first 8 characters of their username will appear on the table. Scroll up or down to find the Employee sorted alphabetically, or Search to find more quickly.

  5. Discount Coupon Type – Discount Coupon Type – Select the Coupon Type (Promo, Comp or Donation) to base the listed Discounts on, or select All (Default).


  6. By Discount Table – After clicking Apply, the following columns are shown:
    1. Date – The Date the sale was made (DD-MM-YYYY format).
    2. Receipt – Node and Receipt Number (Node-ReceiptNumber format).
    3. Sales Created By – The Employee who created the Sale. Clicking it opens a new window.
    4. Applied By – The Employee who applied the Discount.
    5. Approved By – The Employee who closed the receipt.
    6. Employee Name – The respective employee’s name will be in this column.
    7. Reason – The Reason and feedback for the discount.
    8. Discount Name – Discounts name entered from the back office will be shown in this column.
    9. Discount Type – The discount type will be shown in this column - (Item based discount/Receipt based discount/ Open receipt /Open item / Mix and match discount).
    10. Discount Amount – The discount for the sale will be displayed in this column.
    11. Receipt Total – The net value of the sale will be displayed.
    12. Quantity – The number of sale item from which the discount was applied for will be shown.
    13. Total – Displays the Sum Total of the Discount Amount and Quantity columns.
Report Type > By Discount Type
Generates a series of dropdowns pertaining to Discount Types, as established from the Discounts page in Back Office.
  1. Approved By – Select an Employee who closed the receipt (as established by their Role that has access to Discounts when set up in User Management), or All (Default). If an Employee is selected, the first 11 characters of their username will appear on the table. Scroll up/down to find the Employee sorted alphabetically, or Search to find more quickly.

  2. Employee Name – Select an Employee who entered the Discount(s) (as established by their Role that has access to Discounts when set up in User Management), or All (Default). If an Employee is selected, the first 11 characters of their username will appear on the table. Scroll up/down to find the Employee sorted alphabetically, or Search to find more quickly.

  3. Discount – Select a Discount name, or All (Default). If an Discount is selected, the first 11 characters of their username will appear on the table. Scroll up/down to find the Employee sorted alphabetically, or Search to find more quickly.

  4. Sale Created By – Select an Employee who entered the Discount(s) (as established by their Role that has access to Discounts when set up in User Management), or All (Default). If an Employee is selected, the first 8 characters of their username will appear on the table. Scroll up or down to find the Employee sorted alphabetically, or Search to find more quickly.


  5. Discount Coupon Type – Discount Coupon Type – Select the Coupon Type (Promo, Comp or Donation) to base the listed Discounts on, or select All (Default).


  6. By Discount Type Table - After clicking Apply, the following columns are shown:
    2. Receipt – Node and Receipt Number (Node-ReceiptNumber format).
    3. Sales Created By – The Employee who created the Sale. Clicking it opens a new window.
    4. Applied By – The Employee who applied the Discount.
    5. Approved By – The Employee who closed the receipt.
    6. Employee Name – The respective employee’s name will be in this column.
    7. Reason – The Reason and feedback for the discount.
    8. Discount Name – Discounts name entered from the back office will be shown in this column.
    9. Discount Type – The discount type will be shown in this column - (Item based discount/Receipt based discount/ Open receipt /Open item / Mix and match discount).
    10. Discount Amount – The discount for the sale will be displayed in this column.
    11. Receipt Total – The net value of the sale will be displayed.
    12. Quantity – The number of sale item from which the discount was applied for will be shown.

    13. Total – Displays the Sum Total of the Discount Amount and Quantity columns.
Report Type > By Cash Reward
Generates a series of dropdowns pertaining to Cash Rewards, as established from the Discounts page in Back Office.
  1. Approved By – Select an Employee who closed the receipt (as established by their Role that has access to Discounts when set up in User Management), or All (Default). If an Employee is selected, the first 11 characters of their username will appear on the table. Scroll up/down to find the Employee sorted alphabetically, or Search to find more quickly.

  2. Employee Name – Select an Employee who entered the Discount(s) (as established by their Role that has access to Discounts when set up in User Management), or All (Default). If an Employee is selected, the first 11 characters of their username will appear on the table. Scroll up/down to find the Employee sorted alphabetically, or Search to find more quickly.

  3. Discount – Select a Discount name, or All (Default). If an Discount is selected, the first 11 characters of their username will appear on the table. Scroll up/down to find the Employee sorted alphabetically, or Search to find more quickly.

  4. Sale Created By – Select an Employee who entered the Discount(s) (as established by their Role that has access to Discounts when set up in User Management), or All (Default). If an Employee is selected, the first 8 characters of their username will appear on the table. Scroll up or down to find the Employee sorted alphabetically, or Search to find more quickly.


  5. Discount Coupon Type – Discount Coupon Type – Select the Coupon Type (Promo, Comp or Donation) to base the listed Discounts on, or select All (Default).


  6. By Cash Reward Table – After clicking Apply, the following columns are shown:
    1. Date – The Date the sale was made (DD-MM-YYYY format).
    2. Receipt – Node and Receipt Number (Node-ReceiptNumber format).
    3. Sales Created By – The Employee who created the Sale. Clicking it opens a new window.
    4. Applied By – The Employee who applied the Discount.
    5. Approved By – The Employee who closed the receipt.
    6. Employee Name – The respective employee’s name will be in this column.
    7. Reason – The Reason and feedback for the discount.
    8. Discount Name – Discounts name entered from the back office will be shown in this column.
    9. Discount Type – The discount type will be shown in this column - (Item based discount/Receipt based discount/ Open receipt /Open item / Mix and match discount).
    10. Discount Amount – The discount for the sale will be displayed in this column.
    11. Receipt Total – The net value of the sale will be displayed.
    12. Quantity – The number of sale item from which the discount was applied for will be shown.

    13. Total – Displays the Sum Total of the Discount Amount and Quantity columns.

Report Type > Discount Applied By
Generates a series of dropdowns pertaining to how Discounts are Applied By, as established from the Discounts page in Back Office.
  1. Approved By – Select an Employee who closed the receipt (as established by their Role that has access to Discounts when set up in User Management), or All (Default). If an Employee is selected, the first 11 characters of their username will appear on the table. Scroll up/down to find the Employee sorted alphabetically, or Search to find more quickly.

  2. Employee Name – Select an Employee who entered the Discount(s) (as established by their Role that has access to Discounts when set up in User Management), or All (Default). If an Employee is selected, the first 11 characters of their username will appear on the table. Scroll up/down to find the Employee sorted alphabetically, or Search to find more quickly.

  3. Discount – Select a Discount name, or All (Default). If a Discount is selected, the first 11 characters of their username will appear on the table. Scroll up/down to find the Employee sorted alphabetically, or Search to find more quickly.

  4. Sale Created By – Select an Employee who entered the Discount(s) (as established by their Role that has access to Discounts when set up in User Management), or All (Default). If an Employee is selected, the first 8 characters of their username will appear on the table. Scroll up or down to find the Employee sorted alphabetically, or Search to find more quickly.


  5. Discount Coupon Type –– Select the Coupon Type (Promo, Comp or Donation) to base the listed Discounts on, or select All (Default).


  6. Report Type > Discount Applied By Table – After clicking Apply, the following columns are shown:
    1. Date – The Date the sale was made (DD-MM-YYYY format).
    2. Receipt – Node and Receipt Number (Node-ReceiptNumber format).
    3. Sales Created By – The Employee who created the Sale. Clicking it opens a new window.
    4. Applied By – The Employee who applied the Discount.
    5. Approved By – The Employee who closed the receipt.
    6. Employee Name – The respective employee’s name will be in this column.
    7. Reason – The Reason and feedback for the discount.
    8. Discount Name – Discounts name entered from the back office will be shown in this column.
    9. Discount Type – The discount type will be shown in this column - (Item based discount/Receipt based discount/ Open receipt /Open item / Mix and match discount).
    10. Discount Amount – The discount for the sale will be displayed in this column.
    11. Receipt Total – The net value of the sale will be displayed.
    12. Quantity – The number of sale item from which the discount was applied for will be shown.

    13. Total – Displays the Sum Total of the Discount Amount and Quantity columns.
Report Type > By Name
Generates a series of dropdowns pertaining to Discount Names, as established from the Discounts page in Back Office.
  1. Approved By – Select an Employee who closed the receipt (as established by their Role that has access to Discounts when set up in User Management), or All (Default). If an Employee is selected, the first 11 characters of their username will appear on the table. Scroll up/down to find the Employee sorted alphabetically, or Search to find more quickly.


  2. Employee Name – Select an Employee who entered the Discount(s) (as established by their Role that has access to Discounts when set up in User Management), or All (Default). If an Employee is selected, the first 11 characters of their username will appear on the table. Scroll up/down to find the Employee sorted alphabetically, or Search to find more quickly.


  3. Discount – Select a Discount name, or All (Default). If an Discount is selected, the first 11 characters of their username will appear on the table. Scroll up/down to find the Employee sorted alphabetically, or Search to find more quickly.


  4. Sale Created By – Select an Employee who entered the Discount(s) (as established by their Role that has access to Discounts when set up in User Management), or All (Default). If an Employee is selected, the first 8 characters of their username will appear on the table. Scroll up or down to find the Employee sorted alphabetically, or Search to find more quickly.


  5. Discount Coupon Type – Select the Coupon Type (Promo, Comp or Donation) to base the listed Discounts on, or select All (Default).


  6. By Name Table – After clicking Apply, the following columns are shown, organized by Discount Name:
    1. Discount Name – The name of the Discount (established in Back Office).
    2. Menu Item – The name of the Menu Item (established in Back Office) the Discount has been applied to.
    3. Quantity – The number of times the Discount has been applied to the item.
    4. Total Amount – The net sale amount of the item.
    5. Discount Amount – The amount in Discount applied to the item.
    6. Discount Percent – The value of the formula = (Discount Amount / Total Amount) * 100.
    7. Total – The sum of values in Quantity and Discount Amount, for each Discount Name.

Store Credit
Displays information about accumulated Store Credits. Filter by Action Type and Time Period then click Apply.
  1. Action Type – Select the type of Action on Store Credit you want to be generated.

    1. Add – The first time a Customer is receiving Store Credit.
    2. Update – A change in the Store Credit.
    3. Refund – A refund to the Store Credit Card.
    4. Redeem – Drawing from the existing amount in of Store Credit.


  2. Store Credit Table – After clicking Apply, the following columns are shown (if there are no results, the message ‘No transaction for selected time period’ appears).
    1. Node and Receipt Number – (Node-ReceiptNumber format).
    2. Employee Name & ID – The Name and ID of the Employee who conducted the Store Credit transaction.
    3. Customer Name – The Name on the Customer’s Account.
    4. Customer Email – The Email Address on the Customer’s Account.
    5. Customer Phone – The Phone Number on the Customer’s Account.
    6. Credit Amount – Based on the Action Type, as a whole number with up to 2 decimal points.
    7. Date and Time – The date, time and PM/AM of the sale will be shown in this column. The date will be in the following format - DD/MMM/YYYY, Time will be in this format - HH.MM, PM/AM.
    8. Action Type – The type of action selected (Update, Added, Refunded).
    9. Source – Source should be either in Webpos or callcenter. The source from which the sale made will be displayed in this column.