Back Office: Sale Reports

Back Office: Sale Reports

Department
Category
Sub Category
Menu Item
Modifier
Hourly
Daily
Sale Recap
Cashier Out
Online Sales
Weekly Summary
Sale Summary
Future Order
Department
The default tab on the Sales Report screen. It shows data from all Departments by default, with the Top Sales in Graph and Table form, and the Sales By Hour chart.

  1. Select a Department from the dropdown (alphabetical order, created Departments from Product/Items > Departments).
    1. The dropdown has a Search option. Type the name of the Department to identify it more quickly (at least 1 character, with letters and numbers only). If no results are found, the message ‘No results match’ appears.



  2. Select a Time Period.

  3. Click Apply. The following data appears:


    1. Top Sales Graph – View the Top Sales, broken down by Department. It can be viewed as two options via the Level dropdown:
      1. Bar Graph (Default, screenshot below) – Rectangular bars in descending order.
      2. Donut Graph – Circular pie graph with pieces of data relative to size.
      3. The color of the displayed graph is based on the theme selection for the Store.
      4. At the top of every chart is the Category Sale Percentage ([Department Sale Amount / Total Sale Amount] x 100). 
      5. Mouse over on any Category to view the values based on the Sales along with its Category name, Percentage and Amount.



    2. Sales By Hour Chart
      1. The x-axis contains the Department’s Categories involved in sales, along with the Time Period (based on the sale Start and End Times) for those sales. Also, the Legend at the bottom denotes the color line representing each category.
      2. The y-axis contains the values of Net Sales amounts, with a line for each category.
      3. This shows the axis point for each and every Time Period along with its net sales value.
      4. Mouse over a point to show the Time along with the Department(s) and Sale Amount(s).



      1. Name – The Department’s Name.
      2. Sale Amount – The Department’s net sale amount.
      3. Quantity – The Department’s sale quantity.
      4. Tax – The Department’s total tax amount.
      5. Discount – The Department’s discount amount.
      6. % of sale – ([Sale Amount of Department / Total Sale Amount] * 100).
      7. Total – The Total sum amount of each column’s values.




Category
Displays data from all Categories by default, with the Top Sales in Graph and Table form, and the Sales By Hour chart.

  1. Select a Category from the dropdown (alphabetical order, created Departments from Product/Items > Category).
    1. The dropdown has a Search option. Type the name of the Category to identify it more quickly (at least 1 character, with letters and numbers only). If no results are found, the message ‘No results match’ appears.



  2. Select a Time Period.

  3. Click Apply. The following data appears:

    1. Top Sales Graph – View the Top Sales, broken down by Category. It can be viewed as two options via the Level dropdown:

      1. Bar Graph (Default, screenshot below) – Rectangular bars in descending order.
      2. Donut Graph – Circular pie graph with pieces of data relative to size.
      3. The color of the displayed graph is based on the theme selection for the Store.
      4. At the top of every chart is the Category Sale Percentage ([Category Sale Amount / Total Sale Amount] x 100).
      5. Mouse over any Category to view the values based on the Sales along with its Category name, Percentage and Amount.

    2. Sales By Hour Chart

      1. The x-axis contains the Department’s Categories involved in sales, along with the Time Period (based on the sale Start and End Times) for those sales. Also, the Legend at the bottom denotes the color line representing each category.
      2. The y-axis contains the values of Net Sales amounts, with a line for each category.
      3. This shows the axis point for each and every Time Period along with its net sales value. 

    3. Top Sales Table – Displays a Table view of a Categories sales data, with the columns:

      1. Name – The Category’s Name.
      2. Sale Amount – The Category’s net sale amount.
      3. Quantity – The Category’s sale quantity.
      4. Tax – The Category’s total tax amount.
      5. Discount – The Category’s discount amount.
      6. % of Sale – ([Sale Amount of Category / Total Sale Amount] * 100).
      7. Total – The Total sum amount of each column’s values.

Sub Category
Displays data from all Sub Categories by default, with the Top Sales in Graph and Table form, and the Sales By Hour chart.

​
  1. Select a Category and Sub Category (alphabetical order, created from the Product/Items menu). The Sub Category options are based on the Category selection.
              
    1. The dropdowns have a Search option. Type the name of the Category / Sub Category to identify them more quickly (at least 1 character, with letters and numbers only). If no results are found, the message ‘No results match’ appears.
      ​
  2. Select a Report Type.
    1. Default View – The following fields appear: Name, Sale amount, Quantity, Tax, Discount and % of Sale.

    2. Detailed View – The following fields appear: Seq.No, Name, Unit Price, Quantity, Excludes Tax, Tax, Total Amount, Discount and % of Sale.

  3. Select a Time Period.

  4. Click Apply. The following data appears:

    1. Top Sales Graph – View the Top Sales, broken down by Sub Category. It can be viewed as two options via the Level dropdown:
      1. Bar Graph (Default, screenshot below) – Rectangular bars in descending order.

      2. Donut Graph – Circular pie graph with pieces of data relative to size.

      3. The color of the displayed graph is based on the theme selection for the Store.
      4. At the top of every chart is the Sub Category Sale Percentage ([Sub Category Sale Amount / Total Sale Amount] x 100).
      5. Mouse over any Sub Category to view the values based on the Sales along with its Sub Category name, Percentage and Amount.

    2. Sales By Hour Chart

      1. The x-axis contains the Department’s Sub Categories involved in sales, along with the Time Period (based on the sale Start and End Times) for those sales. Also, the Legend at the bottom denotes the color line representing each category.
      2. The y-axis contains the values of Net Sales amounts, with a line for each Sub Category.

      3. This shows the axis point for each and every Time Period along with its net sales value.

    3. Top Sales Table – Displays a Table view of a Sub Categories sales data, with the columns:

      1. Name – The Sub Category’s Name.
      2. Sale Amount – The Sub Category’s net sale amount.
      3. Quantity – The Sub Category’s sale quantity.
      4. Tax – The Sub Category’s total tax amount.
      5. Discount – The Sub Category’s discount amount.
      6. % of Sale – ([Sale Amount of Sub Category / Total Sale Amount] * 100).

      7. Total – The Total sum amount of each column’s values.

Menu Item
Displays data from all Menu Items by default, with the Top Sales in Graph and Table form, and the Sales By Hour chart.

  1. Select a Department, then the subsequent Category, Sub Category, Menu Item, Serving Level, Price Level, and Employee.
    1. The three options will have a Search option in each dropdown (alphabetical order, created from the Product/Items page). Type a name to identify it more quickly (at least 1 character, with letters and numbers only). If no results are found, the message ‘No results match’ appears.
    2. For each dropdown, its options will be dependent upon the selections from the dropdowns to its left. (Example: Department is Alcohol, Category is Wine, Sub Category is Wine Bottle, then Menu Items will be limited to bottles of wine).

  2. Select whether to Split By Serving Level. If the box is checked, the Serving Size Level will be displayed alongside the Menu Item.


  3. Select the Time Period.

  4. Click Apply. The following data appears: Top Sales Graph, Sales By Hour Chart along with the following -

    1. Top Sales Table – Displays a Table view of a Sub Categories sales data, with the columns:

      1. Name – The Menu Item’s name.
      2. Department – The Menu Item’s department it belongs to.
      3. Category – The Menu Item’s category it belongs to.
      4. Sub Category – The Menu Item’s sub category it belongs to
      5. Sale Amount – The Menu Item’s net sale amount within the selected Sub Category.
      6. Quantity – The Menu Item’s quantity of sale within the selected Sub Category.
      7. Tax – The Menu Item’s total Tax amount within the selected Sub Category.
      8. Discount – The Menu Item’s Discount amount within the selected Sub Category.
      9. % of sale – The Discount Amount’s % of Sale within the selected Sub Category.
        1. Formula = ([Sale Amount of particular Menu Item / Total Sale Amount] * 100)
      10. Price Level – The defined Price Level.
      11. Total – The Total sum amount of each column’s values.

Modifier

Displays sales data from all Modifiers by default.

  1. Select a Modifier.

    1. The dropdown has a Search option. Type the name of the Modifier to identify it more quickly (at least 1 character, with letters and numbers only). If no results are found, the message ‘No results match’ appears.

  2. Select a Time Period.

  3. Click Apply. The below table with the following columns is populated:

    1. Item Name – The Menu Item’s Name which the selected Modifier belongs to.
    2. Modifier Name – The Menu Item Modifier’s name.
    3. Sale Amount – The Net Sale Amount within this Modifier.
    4. Quantity – The sale Quantity of the selected Modifier.
    5. Tax – The total Tax amount of the selected Modifier.
    6. Total – The Total sum amount of each column’s values.

Hourly
Displays data by Hourly periods. Select the Time Period, then click Apply.

Top Sales Graph – View the Top Sales, broken down by Menu Items. It can be viewed as two options via the Level dropdown:
  1. Bar Graph (Default, screenshot below) – Rectangular bars in descending order.
  2. Donut Graph – Circular pie graph with pieces of data relative to size.
  3. The color of the displayed graph is based on the theme selection for the Store.
  4. At the top of every chart is the Sub Category Sale Percentage ([Menu Item Sale Amount / Total Sale Amount] x 100).
  5. Mouse over any Menu Item to view the values based on the Sales along with its Sub Category name, Percentage and Amount.
Hourly Table - Displays a Table view of Hourly sales data by Date, with the following columns
  1. Time – The hourly period, populated based on the selected Date format in Application settings. When you click on a Time, it will expand to show all the activity that took place during the selected Time Period. The expansion provides the table broken down by Menu Items during that Hourly period.
  2. Menu Item – The Menu Item’s name.
  3. Date – A Date during the selected Time Period (the format selected in Application settings).
  4. Net Sale – The amount of Net Sales (Gross Revenue, minus applicable Sales Returns, Allowance and Discounts) during the Date and for each Item.
    1. Formula = Gross Sale – Tax – Gross Void (or [Net Void + Void Tax]) – Discount – Discount Tax – Void Discount – Void Discount Tax.
  5. Tax – The amount of calculated Tax on the Item(s) sold during the Hourly Period.
  6. Quantity – The amount of Item(s) sold during the Hourly Period.
  7. Discount – The amount in Discount applied to the Item(s) during the Hourly Period.
  8. Grand Sale – The amount (Net Sale + Tax) for the Item during the Hourly Period.
  9. Number of Customer – The number of customer transactions during the Hourly Period.
  10. Total – The Total sum amount of each column’s values.

Daily
Displays Sales data, broken down by Daily periods.

Select the Time Period, then click Apply. The following data appears:

  1. Top Sales Graph – View the Top Sales, broken down by Menu Items. It can be viewed as two options via the Level dropdown:

    1. Bar Graph (Default, screenshot below) – Rectangular bars in descending order.
    2. Donut Graph – Circular pie graph with pieces of data relative to size.
    3. The color of the displayed graph is based on the theme selection for the Store.
    4. At the top of every chart is the Sub Category Sale Percentage ([Menu Item Sale Amount / Total Sale Amount] x 100).
    5. Mouse over any Menu Item to view the values based on the Sales along with its Sub Category name, Percentage and Amount.

  1. Sales By Hour Chart

    1. The x-axis contains the selected Menu Items involved in sales, along with the Time Period (based on the sale Start and End Times) for those sales. Also, the Legend at the bottom denotes the color line representing each category.
    2. The y-axis contains the values of Net Sales amounts, with a line for each Menu Item.
    3. This shows the axis point for each and every Time Period along with its net sales value.

  2. Daily Table – Displays a Table view of Daily sales data by Date, with the columns:
    1. Date – A Date during the selected Time Period (the format selected in Application settings).
    2. Net Sale – Gross Revenue minus applicable Sales Returns, Allowances and Discounts.
      1. Formula = Gross Sale – Tax – Gross Void (or [Net Void + Void Tax]) – Discount – Discount Tax – Void Discount – Void Discount Tax
    3. Tax – This will include all the tax amount that are calculated for this particular period
    4. Discount – The amount in Discount applied to the Item(s).
    5. Grand Sale – The amount (Net Sale + Tax) for the Item during the Time Period.
    6. Each Date is clickable and expands to include a table which provides more information on sales that took place for that particular date - including the following columns:
      1. Check No – The transaction’s Check Number. Each value is clickable.
      2. Customer – The name of the customer on the check.
      3. Transaction Date – The Transaction’s Date and Time. (formatting based on Application settings).
      4. Floor No – The Name/Number of the Floor where the transaction took place.
      5. Table No – The Name/Number of the Table where the transaction took place.
      6. Net sale – The amount value of the Net Sale.
        1. Formula = Gross Sale – Tax – Gross Void (or [Net Void + Void Tax]) – Discount – Discount Tax – Void Discount – Void Discount Tax
      7. Total Tax – The amount of Total Tax.
      8. Incl Tax – The Inclusive Tax on the Menu Item (if applicable).
      9. CC Service Charge – The Service Charge on the Credit Card used for the transaction (if applicable).
      10. Discount – The amount in Discount applied to the Item(s).
      11. Gross receipt – Sum of all payments.
      12. Closed by – The Name of the User who closed the check.
      13. Closed on – The Node by which the check was closed.
      14. Grand Sale – The amount (Net Sale + Tax) for the Item during the Hourly Period.


      15. Check No - Each Check No is clickable and expands to include a Check Summary, Order Summary, Tax Summary and Payment Summary. Clicking Back reverts to the Date table.
        1. Additionally, there’s an option to Email a Copy of the Receipt. The Email Address field is available, with just one Email Address per send is available. Click Send Receipt to email the Check Details to the entered Address. The Send Receipt option will only be available once a valid Email Address is entered.


          1. Order Summary – Displays a Table with Order information, such as Item (including any Modifiers), Price, Price, Qty (Quantity) and Amount - along with a Sub Total for the Amount column.



          2. Tax Summary – Displays a Table with Tax information, such as Type, Rate % and Amount - along with a Tax Total for the Amount column.


          3. Payment Summary – Displays a Table with Payment information, such as Payment No, Type, Tip, CC Service Charge, Amount, Status, Auth Code and Transaction No.


Sale Recap
Displays a high-level overview of Sales activity.

  1. Select the Sale Recap Type. If Time Period was selected, then select the Time Period after the Report Type.

  2. Select an Employee or All employees (default).

  3. Select the Report Type (One Page PDF or Detailed Report).

  4. Date – The first and last Clock-In Dates and Times.
    Business Date – The beginning and ending Dates when sales occurred. 

  5. Based on your previous selections, the following data may appear:

    1. Check Status – Displays the Check Count, Guest Count, Cover Count, Average Per Check and Average Per Guest.

      1. Check Count – Total number of Checks during a selected Time Period. Will be displayed only when the Guest/Checks toggle is Enabled in Report Settings (under Settings). Check Void will not be included.
      2. Guest Count – Total number of Guests during a selected Time Period. Will be displayed only when the Guest/Checks toggle is Enabled in Report Settings (under Settings).
      3. Cover Count – Incremental based on the Category, Sub Category or Menu Item. Will be displayed only when the Cover toggle is Enabled in Settings > Sale Recap Report.
      4. Average Per Check – The Average amount ($) per Check (Total Amount / Total Checks).
      5. Average Per Guest – The Average amount ($) per Guest (Total Amount / Total Guests).


    2. Sales – The Total Sales for a selected Time Period.

      1. Gross Sales – The Gross Sales during the selected Time Period.
        1. 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)
      2. Net Sales – The Net Sales (gross revenue minus applicable sales returns, allowances and discounts) during the selected Time Period.
        1. Formula = Gross sale - Tax - Gross Void (or Net Void + Void tax)-Discount - Discount tax - Void discount - Void discount tax.
      3. Non-Taxable Net Sales – The Non-Taxable Net Sales during the selected Time Period.Non-Taxable Net Sales are any menu item which has zero ($0.00) amount.
      4. Grand Sales – The Grand Sales during the selected Time Period. Formula = Net Sale + Tax.
        1. Grand Sales will only display when the Grand Sale toggle in Settings > Report Settings > Sale Recap (Sale - Grand Sale) is Enabled.
      5. Gross Receipt – The Gross Receipt during the selected Time Period. Formula = Sum of all Payments.
        1. Gross Receipt will only display when the Grand Sale toggle in Settings > Report Settings > Sale Recap (Sale - Gross Receipt), is Enabled.
      6. Gross Void – The Gross Void during the selected Time Period (including Tax).
        1. Gross Void will only display when the Grand Void toggle in Settings > Report Settings > Sale Recap (Sale - Gross Void), is Enabled.
        2. Formula = Total price (menu item price + tax) menu item and modifier which are voided.
      7. Net Void – The Net Void during the selected Time Period (excluding Tax).
        1. Net Void will only display when the Net Void toggle in Settings > Report Settings > Sale Recap (Sale - Net Void), is Enabled.
        2. Formula = Total price (menu item price) menu item and modifier which are voided.
      8. Tax – The amount of Total Tax.
      9. Tax Exempt – The Tax Exempt amount during the selected Time Period.
      10. Item Service Charge – The Item Service Charge during the selected Time Period.


    3. Taxes – Displays all the Taxes that were collected during the selected Time Period. Below the Total Tax Collected line, the Rounding Off amount is displayed for just the Amount column.
      1. Tax Name – The Name of the Tax.
        1. If the Tax Split-Up toggle in Settings > Report Settings > Sale Recap (Taxes - Tax Split-Up) is Enabled, only then will the Tax Split-Up (Name, %, Net Sales, Amount and Tax Exempt) be displayed on the Sale Recap Report. If Disabled, then all the Taxes are displayed on a single line along with the calculations in Sale Recap Report. Only Rounding Off and Tax Exempt would be displayed.
      2. % – The calculated Tax Percentage.
      3. Net Sales – The Net Sales for the Tax.
      4. If the Tax With Net Sales toggle in Settings > Report Settings > Sale Recap (Taxes – Tax With Net Sales) is enabled, only then will Net Sales be displayed in the Sale Recap report.
      5. Amount – The Amount of Tax.
      6. Tax Exempt – The Amount of Tax Exempt value.
      7. By default, Refund Tax is displayed. If the Tax-Exempt toggle Settings > Report Settings > Sale Recap (Taxes - Tax Split-Up), only then will the Refund Tax be displayed in the Sale Recap report.


    4. Credit Card – All Credit Card transactions that took place during the selected Time Period.

      1. If CC Split Up is enabled in the Sale Recap Report settings then these columns will be displayed in Reports i.e., Count, Amt, Tip and SC. If disabled, then in Payment Summary section the Credit Card line item along with its Amount (Amt) will be displayed.
      2. Columns include Count, Amt, Tip and SC - along with the Deposit column available on an Admin screen (when the Show Cash Reward toggle is Enabled).
      3. The Total is available for all columns.


    5. Other Payment – Remaining payments from transactions other than Credit Cards.
      1. When Other Payemnt Split-Up in Sale Recap Report settings is Enabled, you can view the columns such as HA Payments, GiveX, Loyalty, Cash, Gift Card, Online Payment, and Others. If Disabled, then just the Credit Card and its Amount will be displayed.
      2. The Total will be available at the bottom.


    6. Payment Summary – A Summary for Credit Card, Side CC and Other Payments along with the Total. All 3 fields are displayed by default.


    7. Future Order – Displays the following items:
      1. Advance Payment in Cash – The amount received prior to the delivery order date.
      2. Advance Payment in CC – The amount received via cash advance by using a Credit Card.
      3. Payment Completed – Overall amount of payment from completed orders.
      4. Past Order Advance Payment – Displays 0.00 if no value is present for the above 3.


    8. Non-Sale Revenue – Displays revenue from Gift Cards, House Account, Delivery Charge, Membership, Gratuity, and Online Order Service Charges along with the Total amount.
      1. The Delivery Charge includes Driver Compensation and Store Compensation, and Delivery Compensation is clickable.
      2. At least one field should have a value of greater than 0 and will be displayed here.



    9. Tip/Gratuity – This includes the Tip amount received from all the payments such as Credit Card, Employee Tip, Tip Charge, Gift Card, HA Payment, GiveX, Gratuity, Employee Gratuity, Employer Gratuity, Membership Tip, Online Tip (should be clickable and includes Delivery Tip and Pickup Tip) along with Total.



    10. Discount – Displays the Check Discount, Item Discount and its Total followed by Discount Tax, Void Discount, Void Discount Tax, Cash Reward and Discount in Gift Card.



    11. Refund – Displays Refunds that have occurred during the selected Time Period. This includes Cash Refund, Non cash Refund and Refund Tax along with its Total. When the values are above zero, they are displayed in the report (Refund section).


    12. Summary – Displays Opening Balance, Paid In, Paid Out, Tip Paid Out, Cash Drop, Cash Expected and Over/Shortage, including negative values if applicable.


    13. Department Summary – Displays the amount of sales for each Department, with the Total at the bottom. This will display only if the Department Summary toggle in Settings > Sale Recap Report > Other Summaries is Enabled (Yes).



    14. Category Summary – Displays the amount of sales for each Category, with the Total at the bottom. This will display only if the Category Summary toggle in Settings > Sale Recap Report > Other Summaries is Enabled (Yes).



    15. Hourly Summary – Displays the amount of sales for each Hour of the day, with the Total at the bottom. This will display only if the Hourly Summary toggle in Settings > Sale Recap Report > Other Summaries is Enabled (Yes).



    16. Formula Definition – The formulas Cash Expected and Overage / Shortage can be customized.


    17. Cash Expected: Formula = Opening Balance + Cash Amount + Paid In - (Paid Out + Tip + Gratuity + Delivery Compensation + Cash Drop + Cash Refund + Driver Tip).
      1. Cash Expected - Add: Disabled by default. If Enabled, you can view the Opening Balance, Cash Amount and Paid In fields.
        1. Cash Expected - Subtract: Disabled by default. If Enabled, you can view the Paid Out, Cash Drop, Delivery Charge, Cash Refund, Driver Tip, and Tip Paid Out fields.
    18. Overage / Shortage: Formula = Closing Balance - Cash Expected
      1. Overage / Shortage - Add: Disabled by default. If Enabled, you can view the Paid Out, Cash Drop, Closing Balance, Delivery Charge, Cash Refund, Driver Tip, and Tip Paid Out fields.
      2. Overage / Shortage - Subtract: Disabled by default. If Enabled, you can view the Opening Balance, Cash Amount and Paid In fields.
      3. For each field, the Close option is available. If you select any field in Add then the same field will be greyed out for Subtract, and vice versa. You cannot select the field which is already selected in the same section.


    19. Summary – Displays the Balance with Paid In/Out, Cash and any Overage/Shortage.

      1. Opening Balance – The Opening Balance during the selected Time Period. It is displayed only when the Opening Balance toggle in Settings > Sales Recap Report > Summary is Enabled.
      2. Paid In & Paid Out – The amounts Paid In and Out during the selected Time Period. They are displayed only when the Paid In/Out toggle in Settings > Sales Recap Report > Summary is Enabled.
      3. Cash Drop – The amount in Cash Drop during the selected Time Period. It is displayed only when the Cash Drop toggle in Settings > Sales Recap Report > Summary is Enabled.
      4. Cash Expected – The amount in Cash Expected during the selected Time Period. It is displayed only when the Cash Expected toggle in Settings > Sales Recap Report > Summary is Enabled.
      5. Over / Shortage – The amount Over and Shortage during the selected Time Period. It is displayed only when the Over / Shortage toggle in Settings > Sales Recap Report > Summary is Enabled.

    20. User Defined – The name is displayed based on the user defined one in the sale Recap Report (for payment Mode).

    21. System Defined – The name is displayed based on the system defined one in the sale Recap Report (for payment Mode).

Cashier Out
Displays the Cashier Driver App Report, and appears if the Cashier Report for Driver toggle, under Settings > Application > Delivery at the bottom of the page, is set to Enabled (Yes). The Driver Closed Sales record will be displayed for this driver in Cashier Out Report.


  1. Select the following, along with Time Period.

    1. Employee – Select from an Employee created under User Management (in alphabetical order).
      1. Utilize the Search option to find an employee more easily.


    2. Report Type – Select One Page PDF or Detailed Report.


    3. Click Apply. The following data appears:

      1. Check Stats – Displays high-level data of checks.

        1. Check Count – The total amount of Checks during the selected Time Period, displayed only when the Guest/Checks toggle in Settings > Reports > Sales Recap Report is Enabled (Yes). Check Void will not be included.
        2. Guest Count – The total amount of Guests during the selected Time Period, displayed only when the Guest/Checks toggle in Settings > Reports > Sales Recap Report is Enabled (Yes).
        3. Cover Count – Based on the Category, Sub Category or Item, displayed only when the Cover toggle in Settings > Reports > Sales Recap Report is Enabled (Yes).
        4. Average Per Check – The Average amount (Total Amount / Total Checks) per Check in currency.
        5. Average Per Guest – The Average amount (Total Amount / Total Guests) per Check in currency.


      2. Sales – The total amount of Sales during the selected Time Period, broken down by Gross, Net and Non-Taxable Net.

        1. Gross Sales – The total amount of Gross Sales during the selected Time Period.
          1. Formula = Sum of all payments + Gross Void + Discount + Discount Tax + Void Discount + Void Discount - (GC Sold + HA Sold + Membership Sold + GiveX Sold + Gratuity + Delivery Compensation)
        2. Net Sales – The total amount of Net Sales during the selected Time Period.
          1. Formula = Gross sale - Tax - Gross Void (or Net Void + Void Tax) - Discount - Discount Tax - Void Discount - Void Discount Tax.
        3. Non-Taxable Net Sales – The total amount of Non-Taxable Net Sales during the selected Time Period.
          1. Non-Taxable Net Sales are any menu item which has zero ($0.00) amount.
        4. Grand Sales – The total amount of Grand Sales during the selected Time Period, and will display only when the Grand Sales toggle in Settings > Reports > Sales Recap Report > Sales is Enabled (Yes).
          1. Formula = Net Sale + Tax.
        5. Gross Receipt – The Gross Receipt during the selected Time Period, and will display only when the Gross Receipt toggle in Settings > Reports > Sales Recap Report > Sales is Enabled (Yes).
          1. Formula: Sum Total of all payments.
        6. Gross Void – The Gross Void (tax included) during the selected Time Period, and will display only when the Gross Void toggle in Settings > Reports > Sales Recap Report > Sales is Enabled (Yes).
          1. Formula: Total Price (Menu Item Price + Tax) Menu Item and Modifier which are voided.
        7. Net Void – The Net Void (tax excluded) during the selected Time Period, and will display only when the Net Void toggle in Settings > Reports > Sales Recap Report > Sales is Enabled (Yes).
          1. Formula: Total Price (Menu Item Price) Menu Item and Modifier which are voided.
        8. Tax – The total amount of Tax collected during the selected Time Period.
        9. Tax Exempt – The tax exempt amount during the selected Time Period.
        10. Item Service Charge – The Item Service Charge for the selected Time Period.

      3. Taxes – Displays all collected Taxes collected during the selected Time Period. Includes columns for Tax Name, %, Net Sales, Amount and Tax Exempt, but only if the Tax Split Up toggle in Settings > Report Settings > Sale Recap Report > Taxes is Enabled (Yes), then only Rounding Off and Tax Exempt will be displayed.
        1. Name – The Name of the Tax
        2. % – The calculated percentage taken for the Tax.
        3. Net Sales – The amount of Net Sales based on the Tax, and is only displayed when the Tax with Net Sales toggle in Settings > Reports > Sales Recap Report > Taxes is Enabled (Yes).
        4. Amount – The amount of Tax collected.
        5.  Tax Exempt – The amount that’s exempt from Taxes, and is only displayed when the Tax with Net Sales toggle in Settings > Reports > Sales Recap Report > Taxes is Enabled (Yes).
        6. Refund Tax is displayed by default.
        7. Total Tax Collected appears for Amount and Tax Exempt, with Rounding Off having a value just for Amount.

      4. Credit Card – Displays all credit card transactions during the selected Time Period.

        1. It includes columns for Count, Amt, Tip and SC which are only displayed when the CC Split Up toggle in Settings > Reports > Sales Recap Report > Payments is Enabled (Yes).
        2. The Deposit column is available in the Admin view which is only displayed when the Show Cash Reward toggle is Enabled.
        3. The Total is displayed for all available columns.


      5. Other Payment – Displays remaining transaction payments other than Credit Card.

        1. It includes fields for HA Payments, GiveX, Loyalty, Cash, Gift Card, Online Payment, and Others which are only displayed when the Payment Split Up toggle is Enabled (Yes).
        2. The Total is displayed for all available columns.


      6. Payment Summary – Displays a summary for Credit Card, SideCC and Other Payments (all 3 by default) along with the Total.


      7. Future Order – Displays financial data based on Future Order activity. The fields Advance Payment in Cash, Advance Payment in CC, Payment Completed and Past Order Advance Payment are displayed by default.

        1. Advance Payment in Cash – The amount received prior to the delivery order date.
        2. Advance Payment in CC – The amount in cash advance via Credit Card.
        3. Payment Completed – Overall payment completed orders.
        4. Past Order Advance Payment – If there’s no values for the above line items, 0.00 is displayed.


      8. Non-Sale Revenue – Displays revenue generated from non-traditional sales, including Gift Card Sold / Recharge, House Account Sold / Recharge, Delivery Charge Cost, Membership Sold / Recharge, Gratuity and Online Order Service Charge along with the Total.
        1. The Delivery Charge includes Driver Compensation and Store Compensation, and Delivery Compensation should be clickable.
        2. At least one field should have the value of more than 0.00 and is displayed.

        3. Tip/Gratuity: Includes the Tip amount received from all payments such as Credit Card, Employee Tip, Tip Charge, Gift Card, HA Payment, GiveX, Gratuity, Employee Gratuity, Employer Gratuity, Membership Tip, Online Tip - along with Total.
          1. Online Tip should be clickable and includes Delivery Tip and Pickup Tip.


      9. Discount – Includes the Check Discount, Item Discount and its Total followed by Discount Tax, Void Discount, Void Discount Tax, Cash Reward and Discount in Gift Card is displayed.



      10. Refund – Displays the refunds that have taken place during the selected Time Period. This includes Cash Refund, Non cash Refund and Refund Tax along with the Total. This section will be displayed only when values are above zero (0.00).


      11. Summary – Displays Opening Balance, Paid In, Paid Out, Tip Paid Out, Cash Drop, Cash Expected and Over/Shortage, and includes negative values (over/shortage alone).


      12. Department Summary – Displays the amount of sales for each Department, with the Total at the bottom. This will display only if the Department Summary toggle in Settings > Sale Recap Report > Other Summaries is Enabled (Yes).



      13. Category Summary – Displays the amount of sales for each Category, with the Total at the bottom. This will display only if the Category Summary toggle in Settings > Sale Recap Report > Other Summaries is Enabled (Yes).



      14. Hourly Summary – Displays the amount of sales for each Hour of the day, with the Total at the bottom. This will display only if the Hourly Summary toggle in Settings > Sale Recap Report > Other Summaries is Enabled (Yes).



      15. Formula Definition – Formulas for Cash Expected and Overage / Shortage can be customized.
        1. Cash Expected: Formula = Opening Balance + Cash Amount + Paid In - (Paid Out + Tip + Gratuity + Delivery Compensation + Cash Drop + Cash Refund + Driver Tip).
          1. Cash Expected - Add: Disabled by default. If Enabled, you can view the Opening Balance, Cash Amount and Paid In fields.
          2. Cash Expected - Subtract: Disabled by default. If Enabled, you can view the Paid Out, Cash Drop, Delivery Charge, Cash Refund, Driver Tip, and Tip Paid Out fields.
          3. For each field, the Close option is available. If you select any field in Add then the same field will be greyed out for Subtract, and vice versa. You cannot select the field which is already selected in the same section.
        2. Overage / Shortage: Formula = Closing Balance - Cash Expected
          1. Overage / Shortage - Add: Disabled by default. If Enabled, you can view the Paid Out, Cash Drop, Closing Balance, Delivery Charge, Cash Refund, Driver Tip, and Tip Paid Out fields.
          2. Overage / Shortage - Subtract: Disabled by default. If Enabled, you can view the Opening Balance, Cash Amount and Paid In fields.
          3. For each field, the Close option is available. If you select any field in Add then the same field will be greyed out for Subtract, and vice versa. You cannot select the field which is already selected in the same section.


      16. Summary – Displays the Balance with Paid In/Out, Cash and any Overage/Shortage.

        1. Opening Balance – The Opening Balance during the selected Time Period. It is displayed only when the Opening Balance toggle in Settings > Sales Recap Report > Summary is Enabled.
        2. Paid In & Paid Out – The amounts Paid In and Out during the selected Time Period. They are displayed only when the Paid In/Out toggle in Settings > Sales Recap Report > Summary is Enabled.
        3. Cash Drop – The amount in Cash Drop during the selected Time Period. It is displayed only when the Cash Drop toggle in Settings > Sales Recap Report > Summary is Enabled.
        4. Cash Expected – The amount in Cash Expected during the selected Time Period. It is displayed only when the Cash Expected toggle in Settings > Sales Recap Report > Summary is Enabled.
        5. Over / Shortage – The amount Over and Shortage during the selected Time Period. It is displayed only when the Over / Shortage toggle in Settings > Sales Recap Report > Summary is Enabled.


      17. User Defined – The name is displayed based on the user defined one in the sale Recap Report (for payment Mode).


      18. System Defined – The name is displayed based on the system defined one in the sale Recap Report (for payment Mode).

Online Sales
Displays information about Sales generated from Online-based transactions.

  1. Select the following fields along with Time Period:

    1. Source – Where the Order originated from, such as Web Order, Call Center, Mobile, Walkin, etc. and you can Select All.


    2. Order Type – How the Order is being served to the Customer, such as Pick Up, Delivery, etc. and you can Select All.


    3. Payment Type – The form of Payment the Customer applied to the Check, such as Cash, Loyalty, Online Payment, etc. and you can Select All.



  2. Click Apply. The table with the below columns is populated:

    1. Check Number – The unique Number to identify the Check.
    2. Order Ref. No. – This auto-generated Reference Number for the online sales order.
    3. Customer – The Type of Customer - such as Walkin, Dine-in, etc.
    4. Transaction Date – The Date the Check’s Transaction was conducted.
    5. Source – Where the Order originated from, such as Web Order, Mobile, Walkin, etc.
    6. Created By – The name of the User who created the Sale.
    7. Order Type – How the Order is being served, such as Pick Up, Delivery, etc.
    8. Payment Type – The Type of Payment the Customer applied to the Check
    9. Net Sale – Gross revenue minus applicable sales returns, allowances and discounts.
      1. Formula
        = Gross Receipt – Tax – Non Sale Total
        or
        = Gross Sale – Tax – Void – Discounts – Discount Tax – Void Discount – Void Discount Tax

    10. Tax – The percentage (%) rate charged for Tax.
    11. Service charge – Any applicable Service Charge when a Credit Card is used.
    12. Driver Tip – Any Tip given to the Driver for a Delivery Order.
    13. Gross Receipt – Sum of all payments applied to the Check.

  3. Click Apply.

Weekly Summary
Select the Time Period (defaults to This week), then click Apply. When you run the Weekly Summary report, you’re able to view the table.



  1. Summary – Displays the various types of sales that occurred during the selected week. Includes values for fields such as Net Void, Gross Receipt, Gross Sales, Net Sales, Gross Void, Grand Sales.
    1. Days of a Week – This filter is displayed based on the selected Time Period.
    2. Total – The Total amount of sales for that particular day.


  2. Payment Section – Displays the various types of payment methods that were utilized during the selected week – such as US Dollar, Online Payment, Cash, Online Payment (T), Visa (T), Cash, All Credit Cards (configured name(s) will be displayed).


  1. Tax Section – Displays the amount in taxes collected during the selected week. Includes values for Total Tax Collected, Tax Exempted and Rounding Off.



  2. Discount – Displays the amount in Discounts applied during the selected week. Includes values for Discount Tax, Discounts, Void Discount Tax and Void Discounts.



  3. Summary – Includes values for Over Shortage, Cover, Paid In, Paid Out, Tip Total, Cash Drop, Cash Expected, Loyalty, Opening Balance, COGS, and Factor4 Sold Amount.



  4. Other Payment – Includes values for Driver Tip, Cash Refunds and Non-Cash Refunds.



  5. Non-Sale Revenue – Includes revenue aside from traditional sales during the selected Time Period. Includes values for Gift Card Sold/Recharge, House Account Sold/Recharge, Delivery Charge Cost, Membership Sold/Recharge, Gratuity and Online Order Service Charge.




Sale Summary
Select from the following fields, along with Time Period.

  1. Employee– View all Employees created in User Management (sorted alphabetically), and select an Employee from the dropdown.
    1. You can utilize the Search function to find an employee more quickly.



  2. Service Type– All the Service Types that are available for the current Store. You can select one or more Service Types from the dropdown.



  3. Floor No – Select a floor number created in Settings > Store > Table from the dropdown.



  4. Table No – Select one or more table numbers created in Settings > Store > Table from the dropdown.



  5. Click Apply. The following data appears:

    1. Sale Summary Columns – Monetary values will have a Total at the bottom.
      1. Check Number – Displayed as a clickable link which displays the Check No screen.
      2. Customer – The customer type will be displayed here such as Walkin, Dine-in
      3. Transaction Date – The date to which the transaction occurs along with time will be displayed. Based on the Date Format and Time Format in Application Setting, this should be displayed.
      4. Floor No – The Floor Number
      5. Table No – The Table Name/Number
        1. Formula
          = Gross Receipt – Tax – Non Sale Total
          or
          = Gross Sale – Tax – Void – Discounts – Discount Tax – Void Discount – Void Discount Tax
      7. Total Tax – All Taxes (except inclusive tax) applied to the Check.
      8. Incl. Tax – Just the Inclusive Tax (not included in Total Tax).
      9. CC Service Charge – Any applicable Service Charge when a Credit Card is used.
      10. Discount – Any amount in Discount(s) applied to the Check.
      11. Gross Receipt – Sum of all payments applied to the Check.
      12. Closed By – The user who closed this Check.
      13. Closed On – The Node where the Check was closed.

    2. Check Number – The Check No page displays sections for Check Summary, Order Summary, Tax Summary and Payment Summary.
      1. You can Email a Receipt Copy enter the customer’s Email Address will be available and only one email id will be acceptable here in this textbox also the Send Receipt option will be available, once user enters the valid email id and click on Send Receipt option then this Check details will be sent to that relevant email.
      2. Click Back to revert to the main Sale Summary table view.


      3. Check Summary – Displays values for Check Number, Customer, Date (date and time), Service Type, Seat Number, Server Name, Gratuity, Discount, CC Service Charge, Cash Discount, Online Order Service Charge, Total, Total Tip, and Item Service Charge.


      4. Order Summary – Displays Order items (including Modifiers), Price, Qty and Amount along with Sub Total.


      5. Tax Summary – Displays a Summary of the Taxes collected during the selected Time Period, with columns for Type, Rate % and Amount which has a Tax Total.


      6. Payment Summary – Displays a Summary of the Payments during the selected Time Period, with columns for Payment No, Type, Tip, CC Service Charge, Amount, Status, Auth Code and Transaction No.



Future Order
Displays information about Orders where the delivery date was a future date from the order date.

  1. Enter the Check Number.
  2. Select the Order Date (calendar view).
  3. Select the Delivery Dates (calendar view).
  4. Click Apply. A table with the below columns is populated:

    1. Check Number – The Future Order’s Check Number.
    2. Paid Amount – The amount paid at the time the Future Order was placed.
    3. Balance Amount – Any remaining balance after the Paid Amount is applied.
    4. Ordered Date – This shows future order date. Based on the Date format in Application Settings the Date will be populated.
    5. Delivery Date – This shows the future order delivery date. Based on the Date format in Application Settings the Date will be populated.
    6. Status – This shows the status of the future i.e., closed or active/open

 

    • Related Articles

    • Detailed View of Subcategory Sale Report

      Implementation in Back-Office: Page Navigation: My Stores >> Reports >> Sale >> Sub-Category sale report         A new field “Report Type” should be included in the sub-category sale report.         The filter option “Detailed View” should be shown ...

    • Enhancement in Sale Summary Report

      Implementation in Back Office: Page Navigation: My stores >> Report >> Sale >> Sale summary   A new toggle option “Group by employee” should be included in the sale summary report. ...

    • Back Office: Enterprise - Reports

      Sign into the Back Office . On the left-side Navigation Panel, click Enterprise. Then click Enterprise Reports. Under Enterprise Reports are options to access specific reporting Dashboards: Sale Report The Sale Report dashboard contains reporting of ...

    • Back Office: Batch Reports

      Sign into the Back Office and select a Store. On the left-side Navigation Panel, click Reports then Batch. When a Dashboard tab has a Time Period dropdown: Today – The report will run based on Today’s store business date. Yesterday – The report will ...

    • Back Office: Inventory Reports

      Log into the Back Office and select a Store. Under Reports > Inventory Reports. On the Inventory Reports dashboard, select a tab. Master Stock Purchased Item Consumption Log Compare Inventory Count Sheet COGS Adjust Inventory Inventory Item History ...