Retail Back Office: Enterprise - Reports

Retail Back Office: Enterprise - Reports



Navigation: Sign into the Back Office. On the left-side Navigation Panel, click Enterprise. Select Enterprise Reports, and the dropdown contains options to access specific reporting Dashboards:

Enterprise Reports

Sale Report
The Sale Report dashboard contains reporting of sales broken down by the name of each tab: Enterprise Report, Departments, Categories, Sub Categories, Retail Items, Hourly Sales, Daily Sales, Sale Recap (most recent business day), Cashier Out (most recent business day), Weekly Summary, Sale Summary, and Enterprise Detailed Report (can only be viewed via Export to Email).
  1. Each reporting tab allows for filtering by various settings - including individual Stores, Departments, Categories, Sub Categories, Retail 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 Enterprise Report tab: if a Store Name is selected:

    1. A drilldown table for that Store appears, with a more detailed breakdown of the column totals, based on the Time Period.


  5. 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.



  6. On the Hourly Sale tab: 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 Reports dashboard contains the Enterprise Payroll Report tab, where you can view an overview of the payroll. The report can be broken down by Time Period, Store(s), Employee, Process (recurring), Format, Status and Role. Also, you can select the formatting of the Excel file to download.

After clicking Apply, the table displays Payroll information broken down by the store(s) selected in the Stores dropdown.


House Account
House Accounts allow customers to have an Account with a Retail Store (like a Gift Card) but functions like a Credit Card, where there is a limit and a balance. The House Account Enterprise Report page contains the following tabs:

HA Activity
HA Statement
The HA Activity tab contains the following filters:

  1. Card Number - You can enter and search for a particular Card Number.
  2. Activity Type - Select a type of transaction (or All) from the dropdown:


  3. Employee - Select an employee (or All) from the dropdown:


  4. Make selections from the above filters (and Time Period), then click Apply. The below table containing the following columns is populated:

    1. Date: The date
    2. Customer: The customer name.
    3. Card Number: This column displays the house account card number.
    4. User Name: The store employee name who involved in this transaction
    5. Receipt No: The receipt number for each transaction.
    6. Activity Type: This column displays which kind of transactions are made with the house account. Customers can add new amounts to their balance, or they can make purchases by using the house account card.
    7. Amount: The number of transactions made with the house account.
    8. Balance: How much is left in the account.
The HA Statement tab contains the following filters:

  1. Customer - Select a Customer (or All).

  2. Make selections from the above filters (and Time Period), then click Apply. The below table containing the following columns is populated:
    1. Date: This column displays the date 
    2. Receipt #: This displays the receipt number for each transaction paid with a house account.
    3. Retail item: This displays the Retail item in the receipt. If there are multiple Retail items, it shows it with a new line.
    4. HA Recharge: Recharge amount.
    5. Price: This calculates the price based on the below formula.
      1. NetSales - Total Discount Amount + Inclusive Discount
    6. Tax: The tax amount value per each Price.
    7. Total: The total amount based on the formula:
      1. Price + Tax (then rounded off to 2 decimal places)

  3. Under the main table is a highlighted table with the following information:

    1. Summary: sum of each of the HA Recharge, Price, Tax and Total columns
    2. Beginning Balance: Balance before the transaction is performed.
    3. HA Recharge: Recharge amount.
    4. Net Sale: Sum of net sales.
    5. Tax: Sum of tax
    6. HA Payment: Total payment made with HA.
    7. HA Refund: Total refund
    8. HA Adjustment Credit: In the adjustment case, the credit amount is displayed.
    9. HA Adjustment Debit: In the adjustment case, the debit amount is displayed.
    10. Other Payment: If there is a different payment method along with the house account, it displays the total amount of these payments.
    11. Current Balance: This shows the current balance of a customer in house account.
Gift Card
The Gift Card Enterprise Reporting page contains the Redemption tab which provides information on Gift Card redemption.

Select from the following filters: Stores, Card Number, and Activity Type (In-Store or Online) and a Time Period. You can also select the Group by Store box to organize the results by each Store.

When ready, click Apply to populate the below table containing the following columns:

If Group by Store is selected:
  1. Store: Store name will appear.
  2. Card Number: Card Number will appear.
  3. Issuing Store: It is the master store that issued [sold] the gift card.
  4. Debit: Debit amount will appear.
  5. Credit: Credit amount will appear.
  6. Redemption Store: The store at which the issued card is redeemed for the sales made.
  7. Store Level: Store level will appear.
  8. Total: At the end of each store, a summary should be included to show the Total (Total for each store).
  9. Grand Total: Sum of Debit and Credit amount.



If Group by Store isn't selected:

  1. Card Number: Card Number will appear.
  2. Issuing Store: It is the master store that issued [sold] the gift card.
  3. Debit: Debit amount will appear.
  4. Credit: Credit amount will appear.
  5. Redemption Store: The store at which the issued card is redeemed for the sales made.
  6. Store Level: Store level will appear.
  7. Grand Total: Sum of Debit and Credit amount.
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.

    1. Select from the following fields and Time Period.
      1. Filter Stores By – Select from the dropdown.
      2. Selected Stores – 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. Gift Card Sold: Total amount of all sold gift cards.
      8. Gift Card Redeemed: Total amount of all redeemed gift cards.
      9. Royalty Fee: The value based on the formula Royalty Subjected Amount x Royalty Percentage.
      10. Total Due: The total amount due for the specific Store / Group / City / State / ZIP Code.
        1. Formula = 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:

      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.

    3. Download ACH Transaction File – Click the button at the upper-right 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.
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.

Select a Customer Name (or All) and a Time Period, then click Apply. The below table containing the following columns is populated:
  1. Customer Name: The name of the Customer.
  2. Sign Up Date: The date the Customer signed up for a Loyalty Account.
  3. Last Redemption Date: The most recent date that Loyalty Points were redeemed.
  4. Last Accumulated Date: The most recent date that Loyalty Points were accumulated.
  5. Total Accumulated Points: The sum of all accumulated Loyalty Points.
  6. Total Redeemed Loyalty Points: The sum of all redeemed Loyalty Points.
  7. Current Available Points: The current amount of available Loyalty Points.
  1. Click a Customer Name to view a table displaying a breakdown of their Loyalty Point accrual by transaction, containing the following columns:
    1. Date: The Date of the receipt.
    2. Receipt Number: The Receipt Number.
    3. Event: The type of Event.
    4. Points Adjusted: The amount of points for the adjustment.
    5. Adjusted by/Adjusted Reason: The name of the Employee who performed the adjustment, and the reason they provided.
    6. Loyalty Reward: The customer's balance of Loyalty Reward Points.
Customer Item History
  1. This report includes a customer’s details, such as: Sale (Menu Item, Modifiers), Void, Store Credit, Gift Card, Refund, Open Item, and Open Modifier. It also includes filters such as Filter Stores By, Customer Name and Time Period. The Apply option will be available.

  2. Columns on the Report: 
    1. Date - Displays the Business Date of the Sale.
    2. Check No (Receipt if Retail Store/Account) - Displays the Check/Receipt Number
    3. SKU/Barcode - Displays the SKU/Barcode.
    4. Description - Shows the item details of the Customer such as Sale (Menu Item, Modifiers), Void, Store Credit (Redeem and Balance), Gift Card (Redeem and Balance), Refund, Open Item, and Open Modifier.
    5. Quantity - Displays the Quantity of the Sale. If it is scale item, then the measure type will appear.
    6. Net Sale - Displays the Price of the Menu Item. Only the Price of the Menu Item will appear in the Net Sale column and if the menu item has inclusive tax, then it should be included. Price (net sale) and Discount is calculated for an item, and it will be multiplied by the Quantity in order to match the Total.
    7. Discount - Displays the discount for the sale.
    8. Total - Displays the overall Total. Also, the Total Row will be available for the Quantity, Net Sale, Discount and Total columns.

Notes:
  1. The data will be gathered from POS, OLO, Call Center, Kiosk, VRT, and Custom App.
  2. Customers will appear in the Customer filter based on the selection made in the Filter Stores By dropdown.
Item Sale History
This report includes filters such as Filter Stores By, Item Name (Menu/Retail) and Time Period, then click Apply to apply the filter selections.

Table Columns:
  1. Item Name – The name of the item appears at the top of the table.
  2. Transaction Date – The selected transaction date (sale business date).
  3. Receipt Number – The unique receipt number.
  4. Customer Name – The name of the customer who purchased the selected item. If no customer is linked to the sale, then N/A appears.
  5. Quantity Purchased – The quantity of the item that was purchased.

Note:
  1. The data will be gathered from POS, OLO, Call Center, Kiosk, VRT, and Custom App.
  2. Items will appear in the Item filter based on selections made in the Filter Stores By dropdown.

Export a Report

  1. Click Export. The Export pane appears.


  2. On the Export pane: select the export file's Format and Delivery Option then click Export at the bottom-right.  
              
    1. If Send by Email, the Email field appears. Enter the Email Address the report should be sent to.


  3. The file will be downloaded (to the assigned folder on your computer) or emailed to the entered Email Address.
              

  4. Open the Export to view all the info within one file.
    1. Example: XLSX file

    • Related Articles

    • 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: Enterprise Reports Sale Report The Sale Report dashboard ...

    • Retail Back Office: Enterprise - Sync Inventory

      Navigation: 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 ...

    • Retail POS: Membership Payments

      Membership gives the ability to organize Customers into Loyal Customers. By using Membership Account, you will be able to organize and apply Tax exemptions to Members of the group, maintain the account balance, and issue allowances. Membership ...

    • Retail Back Office: Enterprise Stores

      Navigation: Sign into the Back Office for your Retail Store. On the left-side Navigation Panel, click Stores. The Stores page appears, with each tile representing a Store under your Enterprise. Click on a Store's tile to access its Back Office. Note: ...

    • Retail Back Office: Membership Reports

      Navigation: Log into the Back Office for your Retail Store, then select Reports > Membership. The Membership report page contains the following tab options: Membership Summary Membership Statement Membership Summary Displays the details of a ...