Back Office : Comparison Report

Back Office : Comparison Report

  1. Sign into the Back Office and select a Store.

  2. On the left-side Navigation Panel, click Reports then Comparison Report.

            


  1. When a Dashboard tab has a Time Period dropdown:


    1. Today – The report will run based on Today’s store business date.
    2. Yesterday – The report will run based on yesterday’s store business date.
    3. Last ‘N’ Days [Enter the number of Days, type the number or use ▲▼ to change the value by 1] – The report will run based on the entered days.
    4. This Week [Default] – Just the current week is displayed (if the report is run on Tuesday then from Sunday to Tuesday will be displayed).
    5. Last Week – The last week is displayed (from Sunday – Saturday or Monday – Sunday).
    6. Last 7 Days – Report will run based on from Today’s Date to last 7 Days.
    7. This Month – Just the current month will be displayed.
    8. Last Month – Just the previous month will be displayed.
    9. Last 30 Days – Report will run based on from Today’s Date to last 30 Days.
    10. Specific Date [Select the specific Date (Calendar View)] – Report will run based on the selected Date.
    11. Date Range [Select the From and To Dates (Calendar View)] – Report will run based on the From to To Dates. The From Date should be prior to the To Date.


    1. Search – When a Search bar is available on a page, the minimum number of characters is 3, and only letters and numbers are allowed.


    1. Columns – When a Columns button is clicked, a dropdown is shown where you can Select (show) or Deselect (hide) the columns you wish to view. Click Select All (default) to show or hide all columns.


    1. Pagination – The Rows Per Page dropdown – between 5 and 20 (intervals of 5).



    1. Sorting – If the table can be sorted by a column, it’s by Alphabetical (A-Z, Z-A) or Numerical (Ascending [Upward Arrow, Smallest-to-Largest]), (Descending [Downward Arrow, Largest-to-Smallest]) values.


    1. Export – Click Export to produce a file from the table. The Export pane appears:

          

    1. Format – Select one of XLSX (excel file), CSV or PDF.
    2. Delivery Options – Direct Download (directly to your computer) or Send by Email (file sent as Email Attachment).
      1. If Send By Email, enter the Email address (Mandatory) to send the file. If the address isn’t valid, you will receive an error message and won’t be able to Send.
      2. Click Cancel at the bottom to cancel the Export and return to the previous screen.
    3. Once Format and Delivery Options are set, click Export at the bottom to export the file as a Download or Email.

Comparison Report

Displays a comparison between two or more (click Compare Time to add more filters, up to a total of 4) selected Time Periods (Compare Time 1, Compare Time 2, etc.).

Select each Time Period, then click Apply.



Comparison Report Graph

When Apply is clicked, a circular graph representing each selected Compare Time Period’s Net Sales appears, with colorized sections representing the Service Types (QSR, Table Service, To Go, Bar Tab, etc.). Mouse over a specific graph section to view its net sales and the percentage of the total Net Sales.


  1. Click a corresponding color and section name caption to replace the Net Sales and amount in the middle with the section information. Click it again to reset to overall Net Sales.


  1. If there is no relevant data available, the message No data available appears.



Summary Table

Appears below the graphs, with a column representing each Compare Time Period and the following rows:

  1. Check Count: The number of Checks involved during the corresponding Time Period.
  2. Net Sales: The amount of Net Sales generated during the corresponding Time Period.
  3. Tax: The amount in Taxes collected during the corresponding Time Period.
  4. Net Void: The amount in Net Void entered during the corresponding Time Period.
  5. Discounts: The amount in Discounts collected during the corresponding Time Period.
  6. Refunds: The amount in Refunds collected during the corresponding Time Period.
  7. Gratuity: The amount of Gratuity collected during the corresponding Time Period.
  8. Cash: The amount of Cash collected during the corresponding Time Period.
  9. Payments: The total amount in Payments collected during the corresponding Time Period.

    • Related Articles

    • Wastage Report

      Implementation in Back office:   A new “Wastage Report” need to be developed to record and track the wastages. Page Navigation: Inventory >> Reports >> Wastage Reports   Wastage can happen in raw Inventory Items and with the final product.   The ...
    • Enterprise Level Payroll Report

      Requirement: An option should be included to export the employee payroll report in different format to upload to sage 300 software. Implementation in Back Office: Page Navigation: My Stores >> User Management >> Role              A new field “Role ...
    • Membership Report

      Implementation of Summary Report in back office: Page navigation: Ø  This report displays the details of allowance, debit from the allowance, available balance of a Customer when the payment is made using the membership plan. Ø  It has the following ...
    • Updated Account Balance Report

      Introduction: The new fields should be included in Back Office (Account Balance) and this will be reflected in Account Balance report. Requirement: ·         The new fields should be included in Back Office (My Store>> Settings>> Report Settings>> ...
    • Enhancement in Membership Report

      Implementation in Back Office:   1)     Overdraft item line in membership statement report. Page Navigation: My Stores >>  Reports >> Membership >> Membership Statement Report   A new field “Membership Overdraft Payment” should be shown in the ...