Skip to main content
LB 2.0 Reports
Jeiah Isles avatar
Written by Jeiah Isles
Updated yesterday

Reporting Overview

This section will show you how to access the Reports Tab, where you will be able to run several reports. All reports can be printed or exported to excel.

Introduction

You get to choose what information you are pulling! You are able to select which report you are pulling in the “Reports” section of the dashboard. You also have the ability to choose the date range of the information being pulled.

Note: To pull reports, log into your dashboard and click "Switch to the Old Adm" on the top right.

Best Practices

Offering excel and CSV downloads gives our restaurant partners the ability to download, filter, and flexibly view our reports to fit the client's needs.

Benefits

Lunchbox reporting provides our clients a cross referencable number for reporting validation purposes. With check, item and modifier refunding now available our item level reporting will be better than ever.

Reports provide you with data to make informed decisions about your business. Lunchbox provides you with reports for a plethora of metrics so you can gain insights on your orders, sales, guests, locations, transactions, refunds, items, and more.

Limitations

Users must be granted access to view reporting through permissions assigned through the Lunchbox Enterprise Dashboard. Since reports can be split by location or globally, only those who have Corporate Access are able to view global reports. All other admins are able to access the by-location reports.

Feature Limitations

We do not present graphs or present the same level of dynamic filters as were present in 1.0 However reports can be downloaded to csv and excel and can be filtered and manipulated locally for reporting customization.

POS Limitations

We are not able to view orders that are not placed through the Lunchbox Admin Dashboard. Orders placed in-store for dine-in, takeout, or delivery will need to be viewed from the POS locally.

A user must make the edit in their POS and on the Admin Dashboard. Voids and refunds will not sync automatically from the POS.

How to Access Reporting

Step 1: From the LB Enterprise Dashboard scroll down to the Reports tab on the left-hand side of the screen.

Step 2: Select the store for which you wish to run the report using the Store Search drop down. Leave the store search blank if you wish to run the report Globally.

Step 3: From the drop-down, select the report you wish to run

Step 4: Select the date range using the From: and To: fields

Step 5: Click View to run the report

Note: Viewing reports is based upon a user's permissions. If you are unable to view a report and your position should have access, please reach out to your manager or CSM to check your permissions.

Print Report Results

To print your report:

Step 1: Once you have your report results, click the printer icon to print

Step 2: Select your printer

Step 3: Click Print

Export Report Results to Excel

To export your report to Excel:

Step 1: Once your report has run, click the green Excel icon to export

Step 2: Edit in Excel, as needed

Export Report Results to CSV

To export your report to CSV:

Step 1: Once your report has run, click the csv image icon to export the results to a CSV file

Step 2: Edit, as needed

Store Specific vs Chainwide Reports Side by Side

To run a Store Specific Report, you must first select a location for which you wish to run the report. To run a Chainwide Report, you must have Corporate Access. Chainwide reports return results for the entire chain as a whole. You can access the following Reports from the Reports Tab:

Account Bad Debts Report

This report is for House Accounts and details out any bad debts by House Account.

Store Specific View & Chainwide View Look the Same. Store Specific Reporting will only show for a single location.

Account Details History Report

This house account report shows a detailed list of all Payment Details.

Store Specific View & Chainwide View Look the Same. Store Specific Reporting will only show for a single location.

Account Discounts Report

This house account report shows a detailed list of all discounts by transaction date.

Store Specific View & Chainwide View Look the Same. Store Specific Reporting will only show for a single location.

Account Ending Balances Report

This house account report shows a detailed list of all ending balances by account.

Store Specific View & Chainwide View Look the Same. Store Specific Reporting will only show for a single location.

Account History/Statement

This report as accessed from the House Accounts Tab by searching an account and clicking Account History.

Account Transactions Report

Store Specific View & Chainwide View Look the Same. Store Specific Reporting will only show for a single location.

Admin Held Orders

This report displays a consolidated list of all orders that are in the admin held status including the Error Returned for reference.

Store Specific View & Chainwide View Look the Same. Store Specific Reporting will only show for a single location.

Catering Orders

This report displays all catering orders within the time frame you select, the customer’s information associated with the order, the status of each order, the total of the order, and refund amounts if any.

Store Specific View

Chainwide View - Store # is visible to differentiate orders by location.

Note: This report will only show native catering orders it will not include catering orders from 3P Platforms.

Credit Card Detail

This report displays the online orders, total $ amounts, credit card type used for the orders, authorization codes sent by your merchant when the credit card was authorized, the reference number for the captured amount, and refund date/amount, if any.

Note: Credit Card Details Report does not populate for Aggregation payments because the transaction occurs on the 3P side, and we don’t have visibility into their payment type. 3P providers do not send refunds that are placed through the 3P portal.

Navigate to the Report section in the Lunchbox Dashboard

Step 1. Select Credit Card Detail from Select Report:

Select Credit Card Detail from Select Report:

Step 2. Select the dates you want to view in your report

Click on From:

Step 4. Click the date you wish to pull the report for

Click on 28

Step 5. Click on View

Click on View

Credit Card Sales

This report breaks down the selected store’s online orders paid for by a credit card. Refunds will also display on this report. This report will also show gift card payments, if applicable.

Note: Credit Card Sales Report does not populate for Aggregation Restaurants only because the transaction occurs on the 3P side and we don’t have visibility into their payment type.

Store Specific View & Chainwide View Look the Same. Store Specific Reporting will only show for a single location.

Customer List (Date Range)

This report breaks down the customers that have registered and placed orders. This report displays customer information, including account creation date, opt-in status, # of orders placed, total $ spent, and date of first and last order.

Note: The Customer List will not pull for Aggregation Orders. We do not receive enough information from the 3P to generate a customer list.

Store Specific View & Chainwide View Look the Same. Store Specific Reporting will only show for a single location.

Customer List (Full)

This report breaks down the customers that have registered and placed orders. This report displays customer information, including account creation date, opt-in status, # of orders placed, total $ spent, and date of first and last order and is not filtered for a date range.

Note: The Customer List will not pull for Aggregation Orders. We do not receive enough information from the 3P to generate a customer list.

Store Specific View & Chainwide View Look the Same. Store Specific Reporting will only show for a single location.

Customer Registrations

Who has registered for a new account

Store Specific View & Chainwide View Look the Same. Store Specific Reporting will only show for a single location.

DAAS/Delivery As A Service Orders

This report displays Delivery As A Service orders, within the selected time frame, the order numbers, the customer’s information associated with the order, the placed and promised time of each order, the subtotal, discount, item tax, delivery charge, delivery charge tax, tip and total order amounts.

Note: This report will not show data for Aggregation unless the orders deliveries are being run through a third party delivery service. Example Grubhub orders are delivered by Doordash Drive.

Store Specific View

Chainwide View - The store number is visible from this view.

Delivery Daily Trend

This report returns total delivery sales during the chosen time period by day of the week, along with order count, average order amount, average out-the-door time, percentage of orders that were out the door in less than 7.5, 9 and 11 minutes, average estimated time of delivery, percentage of deliveries estimated less than 30 minutes, number of deliveries, runs, and deliveries per run.

Note: A Run is the # of times a driver is dispatched. They might be on a 'run' and deliver 3 orders.

Store Specific View & Chainwide View Look the Same. Store Specific Reporting will only show for a single location.

Delivery Dispatch Stats

This report is used for restaurants that choose to dispatch drivers using the Lunchbox Enterprise Dashboard. This report returns order count and average out-the-door time for deliveries by day of the week and time/part of the day. This report is only generated when a driver checks out an order to deliver and checks back in when they return.

Note: This report will not show data for Aggregation or restaurants that delivery using a 3rd Party Delivery service like Doordash Drive. This is for inhouse delivery use only.

Store Specific View & Chainwide View Look the Same. Store Specific Reporting will only show for a single location.

Delivery Labor Tracker

This report returns delivery orders during the selected time frame, hour of the day, number of orders, sales dollars, delivery driver drive time and non-drive time, total time, driver hours allowed and the over/under of total time to driver hours allowed.

Note: This report will not show data for Aggregation or restaurants that delivery using a 3rd Party Delivery service like Doordash Drive. This is for inhouse delivery use only.

Store Specific View

Chainwide View - This shows a list of all stores

Delivery Orders

This report displays all of the delivery orders within the time frame you select and includes customer information, order information, promised time of delivery, time assigned to driver, time driver dispatched, time order delivered, out the door time, order totals, driver name, miles driven, and calculated driver fee.

Store Specific View & Chainwide View Look the Same. Store Specific Reporting will only show for a single location.

Discount Sales

This report displays a list of discounted online orders, the order totals, the customer information associated with the orders, and the discount they used, including the CLU they entered.

Store Specific View & Chainwide View Look the Same. Store Specific Reporting will only show for a single location.

Note: This report will not show data for Aggregation. Discounts are not applied to 3P Orders.

Locations

This report will return a list of locations assigned to that specific user or the store list for the entire chain, depending on access level. This report shows the basic store information: store #, store name, address, phone #, fax #, region, time zone, email address, setup type, Agent version, last Agent Check-in, last Menu Export, status, delivery enabled and any current redirects for each location.

Store Specific View

Note: This report will not pull if a location is selected. To pull this report do so globally.

Chainwide View

Menu Hours

The Menu Hours report give you a day by day breakdown of the restaurant's Menu Hours from Open to Close. This can be filtered by menu.

Store Specific View & Chainwide View Look the Same. Store Specific Reporting will only show for a single location.

New Customer Orders

This report gives a break down of New Customer Orders and excludes orders from Customers who are already in your database within a specific timeframe.

Store Specific View & Chainwide View Look the Same. Store Specific Reporting will only show for a single location.

Open Invoices

This is consolidated report of all Open Invoices

Store Specific View & Chainwide View Look the Same. Store Specific Reporting will only show for a single location.

Order Check-ins

This report returns a list of online orders in which customers had checked in for order pickup during the selected time period, along with customer information, order information, check-in time, store check-in acknowledgment time, parking space number or check-in details supplied by the customer.

Store Specific View

Chainwide View - This report also includes a Store Column

Orders

This report displays orders, within the selected time frame, the customer’s information associated with the order, the status of each order, the total of the order, and refund amounts, if any.

Note: Regions can be configured in the admin dashboard for clients who are looking to view reporting by region. To set this up they must request this through their CSM or raise a ticket through support.

Store Specific View & Chainwide View Look the Same. Store Specific Reporting will only show for a single location.

Note: Canceled/voided orders do not show up on the Orders Report. Refunded orders, however, will display.

Orders By Hour

The report will detail out the quantity of orders by day within a certain timeframe.

Store Specific View

Chainwide View - The Store ID is visible in this view.

Order Item Detail

This report displays items that are ordered, within the selected time frame, the customer’s information associated with the item, the status of each item, the total qty of items on the order, and item name, unit price, extended price. Sortable by store and by item.

Note: This report is inclusive of items and modifiers.

Store Specific View & Chainwide View Look the Same. Store Specific Reporting will only show for a single location.

POS Order Errors

This report will return the response for all orders that received a POS Error.

Store Specific View & Chainwide View Look the Same. Store Specific Reporting will only show for a single location.

Production Sheet

This is an example of a Production Sheet Report, which is a production summary report for the day or days selected for the specific location.

Note: This report will not generate if the restaurant partner does not have order aggregation.

Store Specific View

Chainwide View

Note: This report is only available for Store Specific viewing,.

Provider Orders Report

The provider order report gives you a breakdown of the sales for all 3P orders by provider. This can be filtered by Store, by Provider and by status.

Note: This report will not generate if the restaurant partner does not have order aggregation.

Store Specific View & Chainwide View Look the Same. Store Specific Reporting will only show for a single location.

Note: Tips do not send through on this report unless the delivery driver for the restaurant is delivering their own 3P orders. These orders will reflect the order before any discounts that are applied on third party.

Sales by Customer

This report allows you to pull up a list of the customers who ordered within the time frame you select. Report provides customer’s name, phone number, date registered, order count, and order amount

Store Specific View & Chainwide View Look the Same. Store Specific Reporting will only show for a single location.

Sales by Discount

This report shows the total number of discounts/coupons redeemed on online orders by customers during the selected time frame, along with total sales dollars, total discount dollars, and net dollar amount after discount applied.

Store Specific View & Chainwide View Look the Same. Store Specific Reporting will only show for a single location.

Sales by Discount - By Store

This report shows the total number of discounts/coupons redeemed on online orders by customers during the selected time frame, along with total sales dollars, total discount dollars, and net dollar amount after discount applied.

Store Specific View

Note: This report is only available for Chainwide View.

Chainwide View -

ales by Discount - Daily

This report shows the total number of discounts/coupons redeemed on online orders by customers during the selected time frame by day, along with total sales dollars, total discount dollars, and net dollar amount after the discount applied.

Store Specific View & Chainwide View Look the Same. Store Specific Reporting will only show for a single location.

Sales by Item

This report provides a comprehensive list of all the items sold within the time frame you select, the quantity of each item sold, and the total cost.

Store Specific View & Chainwide View Look the Same. Store Specific Reporting will only show for a single location.

Sales by Payment Type

This report will display the number of orders, and the total amount of those orders, for each of the payment types you accept online.

Store Specific View & Chainwide View Look the Same. Store Specific Reporting will only show for a single location.

Sales by Region

This report will display the number of stores in each region, number of orders, number of active stores, the total amount of those orders, and YTD sales for each of your chain’s regions.

Store Specific View

Note: This report is only available for Chainwide View.

Chainwide View -

Sales by Source

This report shows the sales information by source (online, mobile, mobile app, Grubhub, Doordash etc).

Note: Mobile App means that it was ordered through the App. Mobile site means that is was ordered through a mobile friendly web browser on a cellphone.

Store Specific View & Chainwide View Look the Same. Store Specific Reporting will only show for a single location.

Sales by Source - By Week

This report shows the sales information by source by week (online, mobile, mobile app, Grubhub, Doordash etc).

Store Specific View & Chainwide View Look the Same. Store Specific Reporting will only show for a single location.

Sales by Source - By Week and Store

This report shows the sales information by source by week (online, mobile, mobile app, Grubhub, Doordash etc) and is broken down by store.

Store Specific View

Note: This report is only available for Chainwide View.

Chainwide View -

Sales by Store

Global report for a breakdown sales for the Chain by Store, Source/Service Type, Order Count and Gross Sales.

Store Specific View

Note: This report is only available for Chainwide View.

Chainwide View -

Sales by Store Condensed

Global report for a breakdown sales for the Chain by Store, Order Count and Gross Sales.

Store Specific View

Note: This report is only available for Chainwide View.

Chainwide View

Sales Tax

This report displays each type of sales tax and the total amount paid in sales tax on the online orders for the selected location during the time frame you select.

Store Specific View

Service Fees

This report is used to show you how much you are billed on a particular order or group of orders.

Note: This report is best for pulling the subtotal without including the tip. Commonly used for finding the average ticket price based on subtotal.

Store Specific View

Chainwide View - This report includes a store column.

Store Orders

This report displays a list of the online orders placed at the chosen location within the time frame you select. It displays the order #, the customer’s information associated with the order, the status of each order, the total of the order, and refund amounts, if any.

Store Specific View

Note: This report is only available for Chainwide View.

Chainwide View

Store Sales Condensed

This report shows you the total number of orders by store for the selected time frame.

Store Specific View

Note: This report is only available for Chainwide View.

Chainwide View

Transferred Orders

This report shows you all of the orders transferred during the chosen time period. Transfers typically occur when the order needs to be delivered by another location due to issues that occur in the store.

Store-Specific View & Chainwide View

Note: Reports listed here may not be available to all chains. If a report requires that a restaurant be selected first (Orders, Catering Orders etc.), the report option will not be shown in the drop down until a location has been selected.

Note: This report is not typically seen for Aggregation.

Note: Orders cannot be transferred if they have been sent to the POS.

Weekly Sales by Store

This report displays the weekly sales for all the stores in your chain by location.

Store Specific View

Chainwide View - This View includes the region.

Note: Reports listed here may not be available to all chains.

FAQs

  • Can we see a quick sales view for O&D and loyalty? Compare sales over a period of time?

Answer: Loyalty reports are found on the loyalty provider side. There is a Sales by discount report that can be referenced to see what coupons are being used.

  • Can we see a report showing average check for certain periods?

Answer: Not Supported. They would need to download the orders report and do some math using excel.

  • Can we see a report showing # of orders in a certain period?

Answer: Yes via the Orders Report filtered by timeframe.

  • Can we see a report showing total loyalty guests in the program and how they’re signing up – app, web?

Answer: Not currently in the admin dashboard this would be dependent on the Loyalty Provider.

  • Can we see a report showing Purchase % by mode – app, web & order type – curbside, delivery, to-go?

Answer: No but you can do a dollar value Sales by Store which will give you a side by side breakdown by Source.

  • Can we see a report showing the top discounts used?

Answer: There is a Discount Sales Report that can be filtered to view.

  • Can we see a report showing the Top products purchased online during certain periods?

Answer: Order item Detail Report could be used but would need to be filtered.

  • View of segment buckets and our customer base by bucket?

Answer: Enterprise is not currently pulling anything from Segment.

Did this answer your question?