Back Office: Enterprise - Reports

Back Office: Enterprise - Reports

  1. Sign into the Back Office
    .
  2. On the left-side Navigation Panel, click Enterprise. Then click Enterprise Reports.


  3. Under Enterprise Reports are options to access specific reporting Dashboards:
Sale Report
The Sale Report dashboard contains reporting of sales broken down by the name of each tab: Departments, Categories, Sub Categories, Menu Items, Modifiers, Hourly Sales, Daily Sales, Sale Recap (most recent business day), Cashier Out (most recent business day), Weekly Summary, Sale Summary, Enterprise Detailed Report (can only be viewed via Export to Email), and Online Sales.
  1. Each reporting tab allows for filtering by various settings - including individual Stores, Departments, Categories, Sub Categories, Menu Items, etc. and to narrow the results by various Time Periods.

  2. Most reports include graphs representing Top Sales, Sales By Hour, and a more detailed table view of the data that allows for exporting.
          

  3. If a Split By… box is selected before Apply is clicked, more detailed information will be displayed – broken down by the identified value in the field. The below example is Split By MenuItem from the Categories tab.


  4. For the Sub Categories tab: if the Detailed View box is selected before Apply is clicked, it provides a more detailed breakdown of each listed Sub Category result.



  5. On the Hourly Sale report, if a + sign is clicked next to a Time, it’s expanded to show the sales during that hour, broken down by Server. Click the Time again to collapse the row and show the + again.
Employee
The Employee dashboard contains the Enterprise Payroll Report, where you can view an overview of the payroll. The report can be broken down by Time Period, Store, Employee, Process (recurring), Format, Status and Role. Also, you can select the formatting of the Excel file to download.
Gift Card

The Gift Card dashboard contains information on Gift Card redemption.

View the results broken down by Stores, Card Number, and Activity Type (In-Store or Online) – within a specific Time Period. Click the Group by Store box to organize the results by a specific Store. Click Apply to generate the results.
Royalty / Franchise
  1. Royalty – Contains sale information about paying out Royalties. The data is broken down by Store, with information on the Sales Subjected to Royalties, and the Royalty Fees. The report can be exported, with the file being directly downloaded or emailed.


    1. Select from the following fields and Time Period.
      1. Filter Stores By – Select from the dropdown.
      2. Selected [Options] – Select one or more options based on the Filter Stores By selection (click Select All to Select/Deselect all options).
      3. Selected Discounts – Select one or more options based on the Filter Stores By selection (click Select All to Select/Deselect all options).


      4. Exclude Loyalty Redemption – If selected, Loyalty Points will not be included. If deselected (default) they will be included.

    2. Click Apply. A table with the below columns appears, displaying values based on your selections:


      1. Store Name: The name of the Store.
      2. Business Date: The Date the Royalty Fee was applied.
      3. Net Sales: The Net Sale value (up to 2 decimal points).
        1. Net Sale = Gross Sale - Tax - Discount - Discount Tax - Void - Void Discount Tax
      4. Chargeable Discounts: Any Chargeable Discount amount from the Sale Recap Report.
      5. Loyalty Redemption: Any Loyalty Redemption amount from the Sale Recap Report
      6. Royalty Subjected Amount: The Royalty Subjected amount based on the following:
        1. If the Exclude Loyalty Redemption box is selected, the formula will be: Royalty Amount = (Net Sale - Loyalty Redemption + Chargeable Discount).
        2. If deselected, the formula will be: Royalty Amount = (Net Sale + Chargeable Discount).
      7. Royalty Fee: The value based on the formula Royalty Subjected Amount x Royalty Percentage.
      8. Gift Card Sold: Total amount of all sold gift cards.
      9. Gift Card Redeemed: Total amount of all redeemed gift cards.
      10. Total Due: User can view Total Due for that particular Store / Group / City / State / ZIP Code. Formula to get: Royalty amount + GC Sold - GC Redeemed.

  1. ACH Report – Contains sale information about ACH Transactions and Royalties.

    1. Select from the following fields and Time Period.

      1. Filter Stores By – Select from the dropdown.

      2. Selected [Options] – Select one or more options based on the Filter Stores By selection (click Select All to Select/Deselect all options).

      3. Selected Discounts – Select one or more options based on the Filter Stores By selection (click Select All to Select/Deselect all options).

      4. Credit Entry Class – Select PPD or CCD for the type of transaction.
        1. PPD (Prearranged Payment and Deposit): ACH transactions that involve a consumer account
        2. CCD (Corporate Credit or Debit): ACH transactions between businesses or other organizations

      5. Credit/Debit – Select to display Credit or Debit transactions (or Both).
        A screenshot of a computer Description automatically generated

      6. Exclude Loyalty Redemption – If selected, Loyalty Points will not be included. If deselected (default) they will be included.

    2. Click Apply. A table with the below columns appears, displaying values based on your selections:

      A screenshot of a computer Description automatically generated

      1. Store Name: The name of the Store.
      2. Business Date: The Date the Royalty Fee was applied.
      3. Net Sales: The Net Sale value (including up to 2 decimal points).
        1. Net Sale = Gross Sale - Tax - Discount - Discount Tax - Void - Void Discount Tax
      4. Discount: The total value of applied Discounts (negative value, up to 2 decimal points).
      5. Bank: The name of the Bank.
      6. Fees %: The percentage applied for Fees.
      7. Royalty Fees: The value from the formula Royalty Subjected Amount x Royalty Percentage.
      8. Total: The total in Royalty Fees.
      9. Download ACH Transaction File – Click the button to download the file. It contains the following information about ACH Transactions: Destination name, Destination Routing Number, Immediate Origin Name, Immediate Origin Number, Company Name, Company Entry Description, Company Discretionary Data, Company Identification Number, Originating DFI Identification
        Image
Loyalty

Contains information on Loyalty Point accrual and redemption. The data is broken down by Customer, with information on their Total Accumulated and Redeemed Points, and their Current Available Points. The report can be exported, with the file being directly downloaded or emailed.



Click a Customer Name to view a screen containing a breakdown of their Loyalty Point accrual by transaction.
 
To Export a Report:
  1. Click Export. The Export pane appears.
  2. On the Export pane: select the file Format, then click Export at the bottom. The file [... Reportxxxxxxxxxxxxxxxxx] will be downloaded. 
         

  3. Open the Export to view all info within one file.



    • Related Articles

    • Enterprise Level Gift Card Report

      Implementation in Back Office: Page Navigation: My Enterprise >> Enterprise Report >> Gift Card >> Redemption Report   The following fields should be included to filter the options and run the report, 1)      Stores – Users can select the stores they ...

    • Back Office: Enterprise - Sync Inventory

      Sign into the Back Office. On the left-side Navigation Panel, click Enterprise. On the Enterprise page, click Central Inventory then select Sync Inventory. The Sync Inventory page appears, which highlights the benefits that come with a fully synced ...

    • Enterprise Level Payroll Report

      Page Navigation: My Enterprise >> Enterprise Reports >> Employee >> Role based Payroll             A new sub menu “Employee” should be included under the Enterprise report.             The employee sub menu should include the Role based Payroll tab. ...

    • February 21 2022 Release Notes

      Features in Back Office: Role ID in the payroll report Role ID column must be added Toggle for Role ID must be added Supporting Document: Role ID. Bug Fixes

    • Back Office: Enterprise - Home

      Sign into the Back Office. On the left-side Navigation Panel, click Enterprise. For a moment, your data will load while the banner ‘Please wait while preparing your enterprise metrics’ appears. Then, the Enterprise page appears. On the Enterprise ...