ts reports guide 62
TRANSCRIPT
TableService v6.2
Report Guide
Copyright
Copyright ©2007, Radiant Systems, Inc. The information contained in this publication is confidentialand proprietary. No part of this document may be reproduced, disclosed to others, transmitted, storedin a retrieval system, or translated into any language, in any form, by any means, without written per-mission of Radiant Systems, Inc.
Radiant Systems, Inc. is not responsible for any technical inaccuracies or typographical errors con-tained in this publication. Changes are periodically made to the information herein; these changes willbe incorporated in new editions of this publication. Any reference to gender in this document is notmeant to be discriminatory. The software described in this document is provided under a licenseagreement. The software may be used or copied only in accordance with the terms of that agreement.
© Radiant Systems, Inc., 2007. All Rights Reserved. ALOHA® is a U.S. Registered Trademark of Radi-ant Systems, Inc. Microsoft®, and Windows® are registered trademarks of Microsoft, Inc. IBM® is a reg-istered trademark of International Business Machines Corporation. Other products mentioned aretrademarks or registered trademarks of their respective companies.
Revision #20070713
v6.2
Table of Contents
IntroductionHow This Guide is Organized ........................................................ ix-viiiConventions Used in This Guide ..................................................... ix-ix
Configuring Your Reports.................................................... 1-1Configuring the Clock In/Out Tab for the Labor Group ..................... 1-4Configuring the Reports Tab for the Financials Group ..................... 1-5Configuring the Reports Tab for the Printing Group ......................... 1-7Enabling Employees to Run Reports................................................ 1-9
Analyzing Your FOH Reports............................................... 2-1About Aloha FOH Reports ................................................................ 2-3
Key Benefits of the Aloha FOH Reports ........................................ 2-3Common Buttons on the FOH Reports Screen ............................. 2-6
Sales Reports ................................................................................... 2-8Restaurant Sales Report ............................................................... 2-8Sales by Revenue Center Report ................................................ 2-17Server Sales Report .................................................................... 2-19Flash Report ................................................................................ 2-20
Labor Reports ................................................................................. 2-25Labor Report................................................................................ 2-26Clock In/Out Times Report .......................................................... 2-27Employees Clocked In Report ..................................................... 2-28Employee Breaks Report............................................................. 2-29Break Alert Report ....................................................................... 2-32
Payment Report.............................................................................. 2-36Item Availability Report ................................................................... 2-37
iv Table of Contents
Drawer Report ................................................................................ 2-38Product Mix Report......................................................................... 2-39Employee FOH Sales Report ......................................................... 2-40
Analyzing Your BOH Reports...............................................3-1About Aloha BOH Reports ............................................................... 3-3
Key Benefits of the BOH Aloha Reports........................................ 3-3Common Buttons on the Reports Screen......................................... 3-6Sales Reports................................................................................. 3-11
Sales Report Summary/Weekly .................................................. 3-12Sales by Revenue Center Report................................................ 3-39Server Sales Detail Report .......................................................... 3-50Comparative Employee Sales Report ......................................... 3-61Performance Measures Report ................................................... 3-64Hourly Sales and Labor Report ................................................... 3-68Tiered Tax Report ....................................................................... 3-74
Employee Reports.......................................................................... 3-78Labor Report ............................................................................... 3-79Scheduled vs. Actual Labor Report ............................................. 3-86Employee Breaks Report ............................................................ 3-88Overtime Warning Report............................................................ 3-91Overtime Forecast Report ........................................................... 3-95Tip Income Report ....................................................................... 3-98Employee Tip Report................................................................. 3-104Front-of-House Cash Owed Report........................................... 3-109Speed of Service Report ........................................................... 3-111Time and Attendance Detail Report .......................................... 3-115Edited Punches Report ............................................................. 3-120
Payments Report.......................................................................... 3-123House Account Report ................................................................. 3-128Product Mix Report....................................................................... 3-129Quick Count Report...................................................................... 3-139Menu Item Prices by Name Report .............................................. 3-140Menu Item Prices by Number Report ........................................... 3-140Delivery Driver Report .................................................................. 3-141
Delivery Driver Report Settings ................................................. 3-142Delivery Production Report .......................................................... 3-143
Delivery Production Report Settings ......................................... 3-144Voids Report................................................................................. 3-145
Aloha TableService Report Guide v6.2
Void Report Settings.................................................................. 3-147Surcharges Report........................................................................ 3-148Back of House Security Levels Report ......................................... 3-150Back-of-House Users Report........................................................ 3-152Detailed Access Levels Report..................................................... 3-153System Parameter Summary Report............................................ 3-154Reprints ........................................................................................ 3-155
The File Menu............................................................................ 3-155The Reprint Menu ...................................................................... 3-157
Transfers Report........................................................................... 3-161Audit Report.................................................................................. 3-162
Select Transactions to Audit ...................................................... 3-163Crystal Reports ............................................................................. 3-167
Index
Aloha TableService Report Guide v6.2 Table of Contents v
vi Table of Contents
Aloha TableService Report Guide v6.2Introduction
Welcome to the Aloha TableService Report Guide, a comprehensive analysisof the reporting features provided by the Aloha system. You will learn thebenefits of each report, each available calculation, and see selected examplesto help you further understand the vast reporting capabilities.
Reports are essential in a business. They gauge the progress of your restaurantand determine your success or failure. In a corporation, reports provide animportant link from the store level to corporate. Some data involves specificcalculations to increase profitability or to show comparisons. These compari-sons could be between employees, selected days, or both.
Reporting data is a compilation of transactions which employees ring andclose from the Front-of-House (FOH) terminals. As the day progresses, youcan view up to the minute data with the FOH reports. Some reports also printto the local receipt printer. This data is usually not complete because theremay be outstanding checks or incorrect payments, therefore, never reportimportant information from the FOH reports. You can view sales, labor, andperformance measure information.
At the close of business, or during the system End-of-Day (EOD), the systemcompiles the data for the Back-of-House (BOH) reports. You can run, view,and print the BOH reports to a designated printer. The Aloha system has awide variety of reports available to you, such as the Hourly Sales and Laborreport, Sales by Revenue Center report, Labor report, Product Mix report, andmore. In most operations, the Weekly or Summary Sales report is the mostimportant report to you, and is used in accounting.
viii Introduction
How This Guide is OrganizedThis guide is designed to help you familiarize yourself quickly with the AlohaTableService reports. It is organized as follows:
Chapter 1: Configuring Your Reports
This chapter discusses the available settings used to configure and alter yourreporting capabilities for the FOH and BOH reports, such as what to includein the gross sales figure. Also, here you define the time interval necessary forsome reports, for labor and sales reporting.
Chapter 2: Analyzing Your FOH Reports
This chapter discusses the FOH reports, which provide you with up to theminute reporting data from the FOH terminals. Some reports display onscreen, and some you can print.
Chapter 3: Analyzing Your BOH Reports
This chapter discusses the BOH reports, which enable you to operate a suc-cessful business. The chapter provides information about how to limit and sortthe information that goes into your reports, and how to print reports before orafter previewing them in the system.
Index
Aloha TableService Report Guide v6.2
Conventions Used in This GuideNumerous graphics and instructions appear throughout this guide. These con-ventions make it easy to find and understand information.
Symbols and Alerts
The following graphic symbols alert you to important points throughout thisguide:
Highlights a special point of interest about the topic under discussion.
Alerts you that the operation being described can cause problems if you are not careful.
Directs you to a more complete discussion in another chap-ter of the current book, or other reference material.
Points to a useful hint that may save you time or trouble.
Aloha TableService Report Guide v6.2 Introduction ix
x Introduction
Aloha TableService Report Guide v6.2Chapter1
Configuring Your ReportsThis chapter discusses the reporting features within the Aloha systemthat enable you to alter certain reports, define reporting time intervals,assign employees the ability to review reports, and more.
Configuring the Clock In/Out Tab for the Labor Group ..................... 1-4Configuring the Reports Tab for the Financials Group ..................... 1-5Configuring the Reports Tab for the Printing Group ......................... 1-7Enabling Employees to Run Reports................................................ 1-9
1 – 2 Configuring Your
Reports Aloha TableService Report Guide v6.2Configuring
Your Reports
In this chapter you learn how to configure certain aspects of the FOH and BOH reports, such aswhat to include in sales calculations, and defining time intervals for reporting data.
We discuss the following tabs in the Aloha system:
• Clock In/Out tab for the Labor group in the Store Settings function.• Reports tab for the Financials group in the Store Settings function.• Reports tab for the Printing group in the Store Settings function.• Reports tab for the Access Levels function.
Refer to the Aloha TableService Reference Guide for more information on the tabs in the Aloha system.
Aloha TableService Report Guide v6.2 Configuring Your Reports 1 – 3
1 – 4
Configuring the Clock In/Out Tab for the Labor GroupThis tab enables you to set labor reporting options, overtime calculations, and clock in/out round-ing. In this section, we only discuss the options related to reporting. Select Maintenance > StoreSettings > Labor group > Clock In/Out to display the Clock In/Out tab.
Labor Reporting Group Box
The Labor Reporting group box enables you to define requirements related to labor reporting.
Clock-In Report Available — Enables employees to access the Employees on the Clock buttonon the FOH Reports screen. Required Option: You must also select ‘Labor and Clock Reports’ inMaintenance > Labor > Access Levels > Reports tab and assign the access level to the employee.
Disable Labor Reporting — Disables the printing of the clock-in and clock-out chits. Also,labor figures are not included in the Restaurant Sales report for the FOH. This option is used pri-marily for international operations.
Figure 1-1 TableService Store Settings - Labor Group - Clock In/Out Tab
Configuring Your Reports Aloha TableService Report Guide v6.2
Configuring
Your Reports
Labor Report Interval — Denotes the time interval (in minutes) used for calculating the FOHLabor Report. Labor costs are reported in increments of this interval.
Print Clock In — Prints the clock-in chit for each employee. Related Option: To disable print-ing of the clock-in chit, select ‘Disable Labor Reporting.’
Configuring the Reports Tab for the Financials GroupThis tab enables you to include comps and promos in net sales, exclude open sales on the netserver report, and more. Select Maintenance > Store Settings > Financials group > Reports to dis-play the Reports tab. In this section we discuss only the options related to reports.
Include Comps In Net Sales — Includes comp sales in the net sales amount.
Include Promos In Net Sales — Includes promo sales in the net sales amount.
No Open Sales on Server Sales Report — Only includes sales from closed checks on the ServerSales report.
Figure 1-2 TableService Store Settings > Financials Group - Reports Tab
Aloha TableService Report Guide v6.2 Configuring Your Reports 1 – 5
1 – 6
Exclude Comped Checks and Guests — Does not include checks in which a comp took theamount to $0.00, when calculating check and guest counts totals.
Include Zero Priced Items On FOH Pmix Rpt — Does not include items with a $0.00 price onthe FOH Product Mix report.
Display FOH Labor Hours in Minutes — Controls display of hours and minutes on FOHreports for Clock In/Out Times and the Labor report. If cleared, the hours display in a decimal, orhundredths, format.
Display clock in/clock out chit in minutes and hundredths — Controls display of hours andminutes on the clock in/clock out chit. If cleared, the times display in hours and minutes, orHH:MM. If selected, times and totals print in the HH:MM format and in hundredths, or decimals.
Report Non-cash Tenders by Term Revenue Center — Always reports non-cash payments torevenue centers attached to the terminal, even if you have attached a revenue center by an ordermode or by a table.
Tip Breakdown Prints on Clock Out Chit — Prints a tip breakdown section, such as the tiprate%, total charge sales and tip rate, total cash tips and tip rate, and more, at the bottom of theclock out chit. Related Options: The tip breakdown appears on the clock out chit for all employ-ees clocked in with an access level with ‘Order Entry’ selected.
Clock Out Chit Footer — Prints a defined guest check message as a footer at the bottom of theclock out chit. Select ‘00000 None’ to disable the feature. Related Options: To define a footermessage, create a messages in Maintenance > Messages > Guest Checks.
Gross Sales do Not Include Voids — Configures all gross sales calculations on reports toinclude voids.
Configuring Your Reports Aloha TableService Report Guide v6.2
Configuring
Your Reports
Configuring the Reports Tab for the Printing GroupThis tab enables you to print and define the time interval for the FOH Flash report. Select Mainte-nance > Store Settings > Printing Group > Reports tab.
FOH Flash Report time interval — Determines the number of minutes, per interval, to use fordisplaying the FOH flash report.
Print Flash Report — Enables you to print the FOH Flash report and displays the Print buttonon the FOH Entire Day Summary page. If cleared, you can only view the FOH Flash report.
No Interval Report — Disables the 15-minute interval report. The Interval report prints every15 minutes on a FOH printer as long as the sales data has changed within the 15-minute period.Do not select this check box if you want the report to print. Typically, this is used in cafeteriaenvironments that use TableService.
Figure 1-3 TableService Store Settings - Printing Group - Reports Tab
Aloha TableService Report Guide v6.2 Configuring Your Reports 1 – 7
1 – 8
Printers — Identifies a printer to which reports will print for the Interval report. If you need toadd or modify a printer, click Printer to access the Printers function. When you modify a printer,the change applies to all areas assigned to that printer.
Printer Groups — Prints the Interval report to all printers in the selected group. If you need toadd or modify a printer group, click Printer Groups to access the Printer Group function. Whenyou modify a printer group, the change applies to all areas assigned to that printer group.
FOH Sales by Revenue Report Sorted by Day Part — Enables the Revenue Center Salesreport to sort by day part. If you select multiple revenue centers to print, each sorts by day partand a total prints at the bottom. If one revenue center is selected, no total prints. To run a salesreport sorted by day part across all revenue centers, you can select the Restaurant Sales button onthe FOH Reports screen, then the Print button, and select all day parts when prompted with theFOH Select Day Parts screen.
Suppress FOH Labor Report Wages — Does not print wages on the FOH Labor report.
Break Alert Threshold Hour(s): — Defines the threshold in which employees can work contin-uously without a break before appearing above the Threshold line on the FOH Break Alert report.Enter time between 0 to 24 hours in decimal time. For example, type 4.25 to enter at total of 4hours and 15 minutes. 0 hours indicates no threshold and all employees clocked in appear on theFOH Break report. Required Option: You must clear ‘Use Break Rules’ in Maintenance > StoreSettings > Labor group > Breaks tab to enable this option.
Configuring Your Reports Aloha TableService Report Guide v6.2
Configuring
Your Reports
Enabling Employees to Run ReportsUse the Reports tab, to allow employees assigned to the access level the ability to view certainFOH reports. Select Maintenance > Labor > Access Levels > Reports to display the Reports tab.In this section we discuss only the options related to reports.
Restaurant Sales — Enables all employees using this access level to run sales reports from theFOH. Related Option: This option does not enable you to view the Flash Report, therefore, select‘Mgr Flash Rpt’ or ‘Server Sales’ to view the Flash report.
Server Sales — Enables all employees using this access level to run server sales reports for allservers from the FOH.
Labor and Clock Reports — Enables all employees using this access level to run the FOHLabor report and clock in and clock out reports from the FOH terminal.
Mgr Flash Rpt — Enables all employees using this access level to view FOH configured salereports.
Figure 1-4 TableService Labor > Access Levels > Reports Tab
Aloha TableService Report Guide v6.2 Configuring Your Reports 1 – 9
1 – 1
Payment Report — Enables all employees using this access level to run the FOH Paymentreport from the FOH. This report prints only credit card payments. The Payment Report buttonappears on the FOH Reports screen.
Product Mix — Enables all employees using this access level to run the FOH Product Mixreport from the FOH. The PMix Report button appears on the FOH Reports screen.
Server Flash Rpt — Enables all employees using this access level to view FOH sales reportsthat are broken down by individual.
Employee Breaks — Enables all employees using this access level to run the FOH EmployeeBreaks report. The Employee Breaks button appears on the FOH Reports screen.
0 Configuring Your Reports Aloha TableService Report Guide v6.2
Chapter2
Analyzing Your FOH ReportsThis chapter discusses the reports available from the FOH terminals.
About Aloha FOH Reports ................................................................ 2-3Key Benefits of the Aloha FOH Reports ........................................ 2-3Common Buttons on the FOH Reports Screen ............................. 2-6
Sales Reports ................................................................................... 2-8Restaurant Sales Report ............................................................... 2-8Sales by Revenue Center Report ................................................ 2-17Server Sales Report .................................................................... 2-19Flash Report ................................................................................ 2-20
Labor Reports ................................................................................. 2-25Labor Report................................................................................ 2-26Clock In/Out Times Report .......................................................... 2-27Employees Clocked In Report ..................................................... 2-28Employee Breaks Report............................................................. 2-29Break Alert Report ....................................................................... 2-32
Payment Report.............................................................................. 2-36Item Availability Report ................................................................... 2-37Drawer Report ................................................................................ 2-38Product Mix Report ......................................................................... 2-39Employee FOH Sales Report ......................................................... 2-40
2 – 2 Analyzing Your F
OH Reports TableService Report Guide v6.2Analyzing
Your FOH
Reports
About Aloha FOH ReportsThe Front-of-House (FOH) reports are generated from transactions on the FOH terminals. Theyare primarily used for viewing on the FOH terminal, but you can print some of them to the localprinter. Unlike the configurable BOH reports, you can not make setting changes to the FOHreports while viewing them on the screen. The numbers generated on the FOH reports displaytotals for the current day and up to the hour.
This section discusses the FOH reports grouped by sales, labor, and then miscellaneous reports.They are not discussed in the order they appear on the Reports screen (Figure 2-2). We also dis-cuss the Employee FOH Sales report, which is only available to employees via the Sales buttonon the Working with Tables screen.
Key Benefits of the Aloha FOH Reports
The following is a list of the Aloha FOH reports available to you and their key benefits. Buttonsthat differ from the report title are indicated in parenthesis:
Restaurant Sales Report — Displays and prints sales information from all terminals in usethrough eight views, including comps, promos, net sales, gross sales, and more. To a manager thisis the most important report for your sales reporting.
Sales by Revenue Center Report — Prints category sales information from terminals withineach revenue center, and a summary of all revenue centers.
Server Sales Report — Displays and prints sales information by category for each employee,total number of guests and checks, and the time each employee clocked in.
Flash Report — Displays and prints sales, labor, and performance measure information from allterminals for the last completed time interval defined in the BOH. For example, if you define theFlash report interval as an hour, then you see data generated from the last hour.
When these reports print, the FOH stalls momentarily as all resources are used to print or view. Do not continue to touch the Print button, or the FOH will not respond. We recommend to not print the FOH reports and only view them. Use the BOH reports to print data, as explained in Chapter 3, BOH Reports.
Aloha TableService Report Guide v6.2 Analyzing Your FOH Reports 2 – 3
2 – 4
Labor Report — Prints labor information from all terminals in use for labor dollars and laborhours.
Employee Clock In/Out Report (no title) — Displays and prints clock in and clock out infor-mation for each employee for the day.
Employees Clocked In Report (Employees on Clock) — Prints all employees currently on theclock, by job code. This is helpful when closing your restaurant and you want to know who isstill on the clock.
Employee Breaks Report — Displays and prints the start and end times of breaks, with a cumu-lative total, per shift, for each employee. This allows store managers to easily manage the breakstheir employees are required to take.
Break Alert Report — Displays and prints break information by each employee, and when eachrest and meal break is due for the employee.
Payment Report — Prints non-cash tender information for each employee by tender.
Item Availability Report — Prints remaining counts for items which have been marked asunavailable or available with a limited count.
Drawer Report (Drawer Payments Report) — Prints non-cash transactions and cash in andout transactions performed by each employee assigned to the drawer, and the total amount ofcash in the drawer.
Product Mix Report — Displays and prints product information in four separate sorting viewsfor all items sold from all terminals in use.
Employee FOH Sales Report — Displays sales, cash owed, and performance measure informa-tion for a specific employee. This is a report for employees, not for managers.
Analyzing Your FOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your FOH
Reports
To access the FOH reports:
1. Log in to the FOH. The Special Functions screen appears.
2. If the Special Functions screen does not appear upon log in, touch Special Functions on the Working with Tables screen. This is for scenarios where managers are able to perform order entry.
Figure 2-1 Special Functions Screen
Aloha TableService Report Guide v6.2 Analyzing Your FOH Reports 2 – 5
2 – 6
3. Touch Reports to display the Reports screen.
Common Buttons on the FOH Reports Screen
Most reports contain arrow buttons for up, down, left, and right navigation. Use these to viewmore of the report. Touch Print to print the report to a local printer and Done to exit the report.
The following common buttons are available on most of the FOH reports:
Figure 2-2 Reports Screen
Displays the next page of the report.
Displays the prior page of the report.
Moves to the left on the current page.
Moves to the right on the current page.
Prints the current page to the receipt printer.
Analyzing Your FOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your FOH
Reports
Prints the entire report to the receipt printer.
Exits the corresponding report without printing.
Aloha TableService Report Guide v6.2 Analyzing Your FOH Reports 2 – 7
2 – 8
Sales ReportsYou generate revenue through sales transactions from the FOH terminals. The Aloha reportsoffer several ways to view your sales, such as by day part, by employee, by revenue center, andby a defined time period.
We discuss the following reports pertaining to sales:
• Restaurant Sales Report• Sales by Revenue Center Report• Server Sales Report• Flash Report
Restaurant Sales Report
Touch Restaurant Sales on the FOH Reports screen to display and print the Restaurant Salesreport. The report provides a summary of up to date data based on sales generated for the day, byday part. To a manager, it is the most important report, as it reports information in several for-mats, depending on your needs.
The Restaurant Sales report has eight view options: Summary, Net, Sales, Labor, Payments,Comps, Promos, and Taxes. Touch Print to print the report for the corresponding view. TouchPrint All to print all views of the report.
Summary View
The Sales Summary view appears each time you access the Restaurant Sales report. This viewdisplays sales information, by day part, based on the following on screen calculation: net sales(gross sales - taxes - order mode charges) - comps - promos + taxes - payments + order modecharges + gift certificates sold - gift certificate comps - gift certificate promos + revenue items
Analyzing Your FOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your FOH
Reports
sold = cash balance. An ending void section displays for voided gift certificates and voided reve-nue items.
Figure 2-3 Restaurant Sales Report - Summary View
Aloha TableService Report Guide v6.2 Analyzing Your FOH Reports 2 – 9
2 – 1
Net View
Touch Net to display the Net Sales view. The Net Sales view displays the total net sales amountfor each sales and retail category, broken down by day part. It includes a grand total for each cat-egory, and each day part.
Figure 2-4 Restaurant Sales Report - Net Sales View
0 Analyzing Your FOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your FOH
Reports
Sales View
Touch Sales to display the Sales with Inclusive Taxes view. The Sales with Inclusive Taxes viewdisplays the total sales amount for each sales and retail category, broken down by day part. Thesales amount equals: net sales + inclusive taxes + comps. It also includes a grand total for eachcategory, and each day part.
Figure 2-5 Restaurant Sales Report - Sales with Inclusive Taxes View
Aloha TableService Report Guide v6.2 Analyzing Your FOH Reports 2 – 11
2 – 1
Labor View
Touch Labor to display the Labor view. The Labor view displays the total labor dollars and per-centages for each of the defined labor groups, broken down by day part. It includes a grand totalfor each labor group, and each day part.
$ — Displays the amount of labor dollars earned by each employee in the specified labor groupand period.
% — Displays the labor percentage based on the following calculation: labor dollars / (net sales+ inclusive taxes + comps) x 100 sales + inclusive taxes + comps.
Figure 2-6 Restaurant Sales Report - Labor View
2 Analyzing Your FOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your FOH
Reports
Payments View
Touch Payments to display the Payments view. The Payments view displays total payments madewith non-cash tenders, broken down by tender type, then by day part. It includes a grand total foreach non-cash tender type, and each day part.
Figure 2-7 Restaurant Sales Report - Payments View
Aloha TableService Report Guide v6.2 Analyzing Your FOH Reports 2 – 13
2 – 1
Comps View
Touch Comps to display the Comps view. The Comps view displays the total comp amountsapplied to guest checks, broken down by the comp type, then by day part. It includes a grand totalfor each type of comp, and each day part.
Figure 2-8 Restaurant Sales Report - Comps View
4 Analyzing Your FOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your FOH
Reports
Promos View
Touch Promos to display the Promos view. The Promos view displays the total promo amountsapplied to guest checks, broken down by the promo type, then by day part. It includes a grandtotal for each type of promo, and each day part.
Figure 2-9 Restaurant Sales Report - Promos View
Aloha TableService Report Guide v6.2 Analyzing Your FOH Reports 2 – 15
2 – 1
Taxes View
Touch Taxes to display the Taxes view. The Taxes view displays the total amount of taxes, bro-ken down by the type of tax, then by day part. It includes a grand total for each type of tax, andeach day part.
Figure 2-10 Restaurant Sales Report - Taxes View
6 Analyzing Your FOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your FOH
Reports
Sales by Revenue Center Report
Touch Sales by Revenue on the FOH Reports screen to display the Select Revenue Centers toPrint screen. Then print the Sales by Revenue Center report to the local receipt printer. You canselect a specific revenue center, or select All or None. Depending on the number of defined reve-nue centers, this report can be long.
The report shows sales by sales and retail categories, taxes, grand total (net sales + taxes), numberof checks, check average (grand total sales/checks), number of guests, and guest average (grandtotal sales/guests), broken out by revenue center, as shown in Figure 2-12:
Figure 2-11 Select Revenue Centers to Print Screen
Aloha TableService Report Guide v6.2 Analyzing Your FOH Reports 2 – 17
2 – 1
Figure 2-12 Sales by Revenue Center Report
11/15/02 Bar04:04 PM
Sales by Revenue Center
Cat Sales for MainFood 2.00Liquor 2.75Beer 0.00
Total 4.75Tax 0.33
Grand Total 5.08
# Checks 1Avg Checks 5.08
# Guests 1Avg Guests 5.08
** Cat Sales for All Rev Cnts**Food 2.00Liquor 2.75Beer 0.00Wine 0.00
Total 4.75Tax 0.33
Grand Total 5.08
# Checks 1Avg Checks 5.08
# Guests 1Avg Guests 5.08
8 Analyzing Your FOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your FOH
Reports
Server Sales Report
Touch Server Sales on the FOH Reports screen to display and print the Server Sales report. TheServer Sales report lists each employee, the time in which they clocked in, their total gross sales,the total number of guests they served, and their total number of guest checks. It includes a grandtotal for gross sales, number of guests, and number of checks. Touch Print to print the report.Touch Print by Employee to print a report for each employee.
Server — Designates the name of the employee.
Clock In — Designates the time the employee clocked in.
Gross Sales — Designates the amount of sales generated by the employee from all terminals.
# Guests — Designates the number of guest count generated by the employee from all terminals.
# Checks — Designates the number of checks generated by the employee from all terminals.
Figure 2-13 Server Sales Report
Aloha TableService Report Guide v6.2 Analyzing Your FOH Reports 2 – 19
2 – 2
Flash Report
Touch Flash Report on the FOH Reports screen to display the Flash report. The Flash report pro-vides a summary of data based on sales generated for the day, up to the last completed time inter-val. It is the most important report, as it lets you look at the information for the current day rightnow, to help you make important decisions regarding staffing, service, and more.
The Flash report has five view options: Last Period, Entire Day Summary, Entire Day Net Sales,Entire Day Performance, and Entire Day Labor. Touch Print to print the Entire Day Summaryview.
Last Period View
The Last Period view appears each time you access the Flash report. The Last Period view dis-plays sales, labor, and performance measure information for the last completed time interval.
Sales — Displays sales by categories for the last completed time interval, from all terminals.
Performance — Displays sales and labor percentages defined for each performance measure,for the last completed time interval.
Labor — Displays labor dollars and percentages defined for each labor group, for the last com-pleted time interval.
Figure 2-14 Flash Report - Last Period View
0 Analyzing Your FOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your FOH
Reports
Entire Day Summary View
Touch Entire Day Summary to display the Entire Day Summary view. The Entire Day Summaryview displays the number of guests, number of checks, gross and net sales amounts, and laborinformation for each time interval.
Guests — Specifies the number of guests by each time interval.
Checks — Specifies the number of checks by each time interval.
Gross — Designates the total amount of gross sales by each time interval, based on the followingcalculation: net sales + surchages + order mode charges + exclusive taxes.
Net — Designates the total amount of net sales by each time interval, based on the following cal-culation: net sales - inclusive taxes.
Comparative — This column is currently not in use.
Labor $ — Designates the amount of labor dollars earned by each time interval. The labor dollaris a total amount of dollars earned by each employee in the labor group and interval.
Labor % — Designates the labor percentage by each time interval, based on the following cal-culation: sales amount / labor dollars x 100.
Figure 2-15 Flash Report - Entire Day Summary View
Aloha TableService Report Guide v6.2 Analyzing Your FOH Reports 2 – 21
2 – 2
Entire Day Net Sales Summary View
Touch Entire Day Net Sales to display the Entire Day Net Sales view. The Entire Day Net SalesSummary view displays the net sales for each sales and retail category, broken down by timeinterval.
Figure 2-16 Flash Report - Entire Day Net Sales View
2 Analyzing Your FOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your FOH
Reports
Entire Day Performance View
Touch Entire Day Performance to display the Entire Day Performance view. The Entire Day Per-formance view reports information pertaining to performance measures by type, by time interval,with ending day part totals, and a grand total.
Figure 2-17 Flash Report - Entire Day Performance View
Aloha TableService Report Guide v6.2 Analyzing Your FOH Reports 2 – 23
2 – 2
Entire Day Labor View
Touch Entire Day Labor to display the Entire Day Labor view. The Entire Day Labor view dis-plays the labor hours, labor dollars, and labor percentages for each labor group, broken down bytime interval.
Figure 2-18 Flash Report - Entire Day Labor View
4 Analyzing Your FOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your FOH
Reports
Labor ReportsLabor dollars are very important to the profit margin of your restaurant. The less labor dollars youspend, the higher the margin.
We discuss the following reports pertaining to labor:
• Labor Report• Clocked In/Out Times Report• Employees Clocked In Report• Employee Breaks Report• Break Alert Report
The Flash report, discussed in the Sales Report section, also contains information for labor report-ing.
Aloha TableService Report Guide v6.2 Analyzing Your FOH Reports 2 – 25
2 – 2
Labor Report
Touch Labor Report on the FOH Reports screen to print the Labor Report. This report showslabor hours and cost based on time intervals defined in Maintenance > Store Settings > Labor onthe Clock In/Out tab, with an ending total.
Time — Designates the defined time interval.
Employees — Designates the number of employees who were clocked in for the defined timeinterval.
Hours — Designates the number of labor hours, for each defined time interval, based on the fol-lowing calculation: (number of minutes) x (number of employees).
Cost — Designates the labor dollars earned, based on the following calculation: total dollaramount of pay rates for all employees clocked in (pay rate + pay rate) x hours.
Figure 2-19 Labor Report
Labor ReportUnit # 100 DOB 11/15/9904:17 PM 11/15/99
Time Employees Hours Cost10:3011:00 1 0:00 0.0011:30 1 0:30 5.0012:00 1 0:30 5.0012:30 1 0:30 5.001:00 1 0:30 5.001:30 1 0:30 5.002:00 1 0:30 5.002:30 1 0:30 5.003:00 1 0:30 5.003:30 1 0:30 5.004:00 1 0:30 5.004:17 1 0:17 2.83
Total 1 5:17 2.83
6 Analyzing Your FOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your FOH
Reports
Clock In/Out Times Report
Touch Clock In/Out Times on the FOH Reports screen to display the Clock In/Out Times report.This report displays clock in and out information by each employee, sorted by job code, with anending total. It also includes total hours and declared tips.
Press Print to print this report to the local receipt printer. You receive a “Print Wages?” prompt.Press No if you do not want the pay rate, total pay, and summary total to print on the report. PressYes to print this information.
Time In — Designates the time the employee clocked in.
Time Out — Designates the time the employee clocked out.
Total Hrs — Designates the total hours the employee worked on the clock based on the follow-ing calculation: time out - time in.
Decl Tips — Designates the amount of tips declared by the employee.
Figure 2-20 Clock In Out Report
If you never want the wage information to print on this report, edit the NEVERPRINT-FOHWAGES variable in ALOHA.INI and set it to TRUE. You will no longer receive the prompt to print the wage information on this report.
Aloha TableService Report Guide v6.2 Analyzing Your FOH Reports 2 – 27
2 – 2
Employees Clocked In Report
Touch Employees Clocked In on the FOH Reports screen to print the Employees on Clock report.The report lists all employees by job code currently on the clock and the time they clocked in.You should use this report when you are closing to ensure your employees have clocked outbefore the End-of-Day runs.
Figure 2-21 Employees on Clock Report
Employees on Clock
04:12 PM 11/15/99
ServerServer, Server1 11:00 AMServer, Server2 11:15 AM
BartenderBar, Bartender1 10:30 AMBar, Bartener2 10:45
CashierCashier, Cashier1 11:15 AM
***************************
8 Analyzing Your FOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your FOH
Reports
Employee Breaks Report
Touch Employees Breaks to print the Employees Breaks report. The report includes the start andend times, with a cumulative total, per shift, for each employee. This allows store managers toeasily manage the breaks their employees are required to take.
Figure 2-22 FOH Employee Breaks Report
Aloha TableService Report Guide v6.2 Analyzing Your FOH Reports 2 – 29
2 – 3
4. Touch Print to print the report to the local receipt printer.
Figure 2-23 FOH Employee Breaks Report
Start Time — Time the employee clocked out for their break.
Aloha DinerEmployee Breaks Report
Unit #3118/1/2005 12:32 AM
StartTime
EndTime
TotalTime
Austin, MichaelShift 1
Meal Period 10:20 10:57 0.3014:08 14:38 0.30
Paid Break 16:13 16:33 0.2016:41 16:45 0.04
Rest Period 12:55 13:08 0.1314:02 14:04 0.0223:58 1:08 0.10
Unpaid Break 11:58 12:06 0.0814:44 14:48 0.0417:29 18:15 0.46
Employee Total 2.07----------------------------------------------------------------------------------------------------------------------------
TOTAL ALL 3.08
**************End of Report****************
0 Analyzing Your FOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your FOH
Reports
End Time — Time the employee clocked in from their break. If the employee is currently onbreak, the time is replaced by ‘------.’
Total Time — Total time of the break based on the following calculation: end time - start time. Ifthe employee is currently on break, the system does not calculate the current break.
<employee’s name> — Name of the employee. The report sorts in ascending order by the lastname of the employee, then by ID number.
<shift number> — Shift number of the current day the employee worked. For example, if thebreak occurred during the employee’s second shift of a double shift, ‘Shift 2’ displays. If theemployee worked only one shift for the day, or did not take a break for the shift, the heading doesnot display.
<break type> — Break type the employee takes, such as meal, paid, rest, and unpaid. The breaktypes display in alphabetical order.
<shift total> — Total time of break minutes the employee takes for the shift.
Employee Total — Total time of break minutes the employee takes for the day, including allshifts.
TOTAL ALL — Total time of break minutes in which all employee takes for the day.
You enable the system to display the total time in minutes and hundredths on the report and printed chits when you select ‘Display ClockIn/ClockOut Chit in Minutes and Hun-dredths’ in Maintenance > Store Settings > Financials group > Reports. For example, if the time is 30 minutes, the report displays 0.50.
Aloha TableService Report Guide v6.2 Analyzing Your FOH Reports 2 – 31
2 – 3
Break Alert Report
Touch Break Alert Report on the FOH Reports screen to display the Break Alert Report. Thisreport displays break information by each employee, and when each rest and meal break is duefor the employee.
In most U.S. jurisdictions, employees are required, by law, to take a break after a certain amountof time of work, to meet labor code standards. Some states, in particular, California, use verystrict labor code standards called rest period and meal period breaks, which legally bind employ-ers to give their employees breaks. Under these laws, employers could be subjected to legalactions taken by employees if the break is not taken, and often times they must remind or forcetheir employees to take a break at a certain time to stay within the labor rules. These break rulesare defined in the Aloha system in Maintenance > Store Settings > Labor group > Breaks.
With many responsibilities ranging from overseeing guest satisfaction to ensuring proper foodpreparation, managers often overlook the need to allow their employees to take a break. You cannow use the FOH Break Alert report to list the employees currently clocked in who are due totake a break. There are two versions of the report, based on if you are using the Break Rules fea-ture, or using a generic formula which utilizes a threshold method to indicate employees whohave worked past their break time.
If you do not use the Break Rules feature, you must define a threshold for the system to use todetermine when an employee is due for a break. This threshold determines the number of hoursand minutes an employee can continuously work without taking a break, before the employeeappears above the threshold line on the Break Alert report.
In both versions, the reports group employees first by labor groups, then sort employees whohave exceeded the required time, in descending order. If you select ‘Do Not Print Job Code’ inMaintenance > Labor > Job Codes > Job Code for a job code, employees assigned to the job codedo not appear on the report.
You cannot define a threshold to use for the Break Alert report, if ‘Use Break Rules’ is selected in Maintenance > Store Settings > Labor group > Breaks.
2 Analyzing Your FOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your FOH
Reports
GENERIC BREAK FORMULA SCENARIO: A restaurant is not restricted by the Break Rules fea-ture, however, needs to determine which employees are due to take a break. Define an hourlythreshold that determines the employees who are due for a break. The manager can access theFOH Break Alert report and quickly determine who worked continuously without a break andexceeded the defined threshold.
BREAK RULES SCENARIO: A restaurant is restricted by the Break Rules feature, and mustlegally give their employees rest and meal period breaks. The manager can access the FOHBreak Alert report and quickly determine who worked continuously without a break, based on thebreak rules defined in Maintenance > Store Settings > Labor group > Breaks.
Figure 2-24 Break Alert Report
Aloha TableService Report Guide v6.2 Analyzing Your FOH Reports 2 – 33
2 – 3
Touch Print to print the report to the local receipt printer. The information in the report dependson if you are using the generic break rules formula or the Break Rules feature.
Figure 2-25 Break Alert Report Using Generic Formula
Clock In Time: — Time the employee clocked in for their shift or returned from a break.
Time Worked: — Total amount of continuous hours worked based on the following calculation:Clock In Time + current system time.
=====Threshold====<4:15> — Defined threshold, as defined in Maintenance > Store Settings> Printing > Reports, used to determine when employees are due for a break. Employees thatappear above the ‘Threshold Line’ are overdue for a break. Employees that appear below the‘Threshold Line’ have yet to exceed the threshold.
Break Alert Report8/1/2005 12:54 PM
********************************************************************Clock In
Time:Time
Worked:ServerHunt, Christy 8:17a 4:37Salazar, Robert 8:21a 4:33===========Threshold========= 4:15Wilson, Lisa 8:52a 4:02
KitchenMacElroy, Maddie 7:43a 5:11McGrory, Rebecca 8:19a 4:35===========Threshold========= 4:15Little, Donovan 8:54 4:00***********************************************************************
4 Analyzing Your FOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your FOH
Reports
Figure 2-26 Break Alert Report Using Break Rules
Clock In Time: — Time the employee clocked in for their shift or returned from a break.
Rest Break due by: — Time the employee is due to take a rest period break, as defined by theBreak Rules feature in Maintenance > Store Settings > Labor group > Breaks.
Meal Break due by: — Time the employee is due to take a meal period break, as defined by theBreak Rules feature in Maintenance > Store Settings > Labor group > Breaks.
* — Indicates the employee is overdue for a break, based on the Break Rules defined in Mainte-nance > Store Settings > Labor group > Breaks.
Break Alert Report8/1/2005 12:02 PM
********************************************************************Clock In
Time:Rest Break
due by:Meal Break
due by:ServerHunt, Christy 8:17a 12:17p 2:17pSalazar, Robert 8:21a 12:21p 2:21pWilson, Lisa 8:29a 12:29p 2:29p
KitchenMacElroy, Maddie 7:43a 3:43p 1:43pMcGrory, Rebecca 7:44a 10:44a* 1:44pLittle, Donovan 8:20a 12:20p 2:20p************************************************************************ Indicates an employee is overdue for a rest break or a meal break.
Aloha TableService Report Guide v6.2 Analyzing Your FOH Reports 2 – 35
2 – 3
Payment ReportTouch Payments Report on the FOH Reports screen to print the Payment Report. The Paymentreport lists all payments made with a non-cash tender, such as credit card payments. The reportsorts the payments by tender, and lists the total amount of the payment, as well as the tip amountapplied to the tender. An ending total is included for each tender, as well as a grand total of allnon-cash tenders.
Figure 2-27 Payments Report
Payment Report08:04 AM 11/15/99
*** M/C ***Joe Smith:
54198888888888888 4.95 1.00Smith Total: 4.95 1.00
Sally Jones:541977777777777 5.00 1.50
Jones Total: 5.00 1.50
M/C Total: 9.95 2.50
***House Acct***Joe Smith:
01-M. Davis 55.00 10.00Smith Total: 55.00 10.00
Sally Jones:09-K. Clark 40.95 9.00Smith Total: 40.95 9.00
House AcctTotal:
95.95 19.00
GRAND Total: 109.90 21.50
6 Analyzing Your FOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your FOH
Reports
Item Availability ReportTouch Item Availability on the FOH Reports screen to print the Item Availability Report. Thereport compiles items, which have been marked as unavailable or available with a limited count.If the item is unavailable, the count reports as zero. This report is used with the Item Availabilityfeature.
Figure 2-28 Item Availability Report
Item Availability Report
11/15/99 Bar08:12 AM
Cranberry Juice 0Salmon 0Btl-Merlot 2Btl-Chardonnay 4
Aloha TableService Report Guide v6.2 Analyzing Your FOH Reports 2 – 37
2 – 3
Drawer ReportTouch Drawer Report on the FOH Reports screen to print the Drawer Payments Report. Thereport lists all employees assigned to a cash drawer, payments applied on all transactions per-formed by any person assigned to the drawer, the cash-ins and outs performed on the drawer, andthe total amount of cash in the drawer.
Figure 2-29 Drawer Payments Report
Drawer Payments Report01:37 PM 11/18/99
Bar 1
Employees:Sally Jones:
***Payments***01 House Acct: 20.00
02 Cash: 26.26Total Payments: 46.26
Cash In/Outs:Charles Davis
01:34 PM 50.00
Total Cash In Drawer: 76.26
8 Analyzing Your FOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your FOH
Reports
Product Mix ReportTouch Product Mix on the FOH Reports screen to display the Product Mix report. The report liststotals generated from all terminals in use and product items sold for the day. This is only onereport sortable by either percent, quantity sold, name of the item, or the price of the item. Eachview displays the report sorted from the highest number sold to the lowest number sold. The Per-cent view displays when you access the report.
Figure 2-30 Product Mix Report - Percent View
Aloha TableService Report Guide v6.2 Analyzing Your FOH Reports 2 – 39
2 – 4
Employee FOH Sales ReportThe Employee FOH Sales report is a report viewed by the employee. Access the report using theSales button on the Working with Tables screen, rather than the FOH Reports screen. Each reportis specific to the employee. Any employee responsible for sales can run the Employee Salesreport to view the sales specific to them.
The Employee FOH Sales report has five view options: Summary, Sales, Payments, Comps, andPromos.
Summary View
The Summary view appears each time you access the Employee FOH Sales report. The Summaryview reports sales, cash owed, and performance measures information for the employee.
Guests — Designates the total number of guests entered by the employee, generated from all ter-minals. (not shown)
Checks — Designates the total number of checks entered by the employee, generated from allterminals.
Get Checks — Designates the total number of checks the employee received using the GetCheck feature, generated from all terminals. (not shown)
Figure 2-31 Employee FOH Sales Report - Summary View
0 Analyzing Your FOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your FOH
Reports
Voids — Designates the total number of voids and the voided amount, performed under theemployee’s number.
Sales — Designates the amount of sales generated from the employee from all terminals.
Cash — Designates the cash amount the employee is expected to turn in after removing non-cashpayments.
Tip Share — Designates the tip amount the employee is expected to tip out (not shown).
Cash Owed — Designates the total cash amount the employee is expected to turn in after remov-ing non-cash payments and tip share.
Sales View
Touch Sales to display the Sales view. The Sales view reports sales for the employee by sales andretail categories, with an ending total.
Figure 2-32 Employee FOH Sales Report - Sales View
Aloha TableService Report Guide v6.2 Analyzing Your FOH Reports 2 – 41
2 – 4
Payments View
Touch Payments to display the Payments view. The Payments view reports sales by each definedtender.
Comps View
Touch Comps to display the Comps view. The Comps view reports sales by each defined comp.
Figure 2-33 Employee FOH Sales Report - Payments View
Figure 2-34 Employee FOH Sales Report - Comps View
2 Analyzing Your FOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your FOH
Reports
Promos View
Touch Promos to display the Promos view. The Promos view reports sales by each defined pro-motion.
Figure 2-35 Employee FOH Sales Report - Promos View
Aloha TableService Report Guide v6.2 Analyzing Your FOH Reports 2 – 43
2 – 4
4 Analyzing Your FOH Reports Aloha TableService Report Guide v6.2Chapter3
Analyzing Your BOH ReportsThis chapter discusses the reports available from the BOH.
About Aloha BOH Reports................................................................ 3-3Key Benefits of the BOH Aloha Reports ........................................ 3-3
Common Buttons on the Reports Screen ......................................... 3-6Sales Reports ................................................................................. 3-11
Sales Report Summary/Weekly................................................... 3-12Sales by Revenue Center Report ................................................ 3-39Server Sales Detail Report .......................................................... 3-50Comparative Employee Sales Report.......................................... 3-61Performance Measures Report.................................................... 3-64Hourly Sales and Labor Report ................................................... 3-68Tiered Tax Report........................................................................ 3-74
Employee Reports .......................................................................... 3-78Labor Report................................................................................ 3-79Scheduled vs. Actual Labor Report ............................................. 3-86Employee Breaks Report............................................................. 3-88Overtime Warning Report ............................................................ 3-91Overtime Forecast Report ........................................................... 3-95Tip Income Report ....................................................................... 3-98Employee Tip Report ................................................................. 3-104Front-of-House Cash Owed Report ........................................... 3-109Speed of Service Report............................................................ 3-111Time and Attendance Detail Report........................................... 3-115Edited Punches Report.............................................................. 3-120
Payments Report .......................................................................... 3-123House Account Report.................................................................. 3-128Product Mix Report ....................................................................... 3-129Quick Count Report ...................................................................... 3-139Menu Item Prices by Name Report............................................... 3-140Menu Item Prices by Number Report ........................................... 3-140Delivery Driver Report .................................................................. 3-141
Delivery Driver Report Settings ................................................. 3-142
3 – 2 Analyzing Your B
Delivery Production Report .......................................................... 3-143Delivery Production Report Settings ......................................... 3-144
Voids Report................................................................................. 3-145Void Report Settings ................................................................. 3-147
Surcharges Report ....................................................................... 3-148Back of House Security Levels Report......................................... 3-150Back-of-House Users Report ....................................................... 3-152Detailed Access Levels Report .................................................... 3-153System Parameter Summary Report ........................................... 3-154Reprints ........................................................................................ 3-155
The File Menu ........................................................................... 3-155The Reprint Menu...................................................................... 3-157
Transfers Report .......................................................................... 3-161Audit Report ................................................................................. 3-162
Select Transactions to Audit...................................................... 3-163Crystal Reports............................................................................. 3-167
OH Reports TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
About Aloha BOH ReportsThe Aloha reports provide vital information to aid in operating a successful business. The reportsmenu, contains selections that provide numerous reporting capabilities for sales, labor, productmix, payments, voids, and auditing.
The Sales, Employee, and Product Mix options include additional menu drop-down choices.
In addition, the Aloha system works with Crystal Report Writer. Crystal Report Writer (CRW) isa third-party software application available from Aloha dealers, and configured to produce cus-tom reports using data from Aloha .DBF files. The Aloha system includes a run-time version ofCRW allowing the use of Crystal Report Writer RPT files free of charge.
The report formats are configured by the user and no longer require font selection. Fonts are builtin to the system using the True Type capabilities of the Microsoft® Windows operating systems.
Configuring Voids in Gross Sales
Voids are included in gross sales for all FOH and BOH reports. You can configure the system toexclude voids from these reports by selecting the ‘Gross Sales Do Not Include Voids’ check boxin Maintenance > Store Settings > Financials > Reports. If this check box is cleared, all totals forgross sales include voids.
Key Benefits of the BOH Aloha Reports
The following is a list of the Aloha reports available to you and their key benefits. Menu optionsthat differ from the report title are indicated in parenthesis:
Sales Report — Displays sales information for all terminals in use for the selected date(s). Youcan select sales information for a single date, or for a week.
Employee Sales Report (Employee Sales Detail) — Displays sales information for a singleemployee, or groups of employees.
Refer to the Aloha TableService Reference Guide for more information on Store Set-tings.
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 3
3 – 4
Sales Comparison Report (Comparative Employee Sales) — Displays sales comparisonsbetween two employees, or groups of employees.
Hourly Sales and Labor Report — Displays sales and labor information for a defined period oftime. The information is based on when a guest check is opened.
Sales by Revenue Center Report — Displays sales information for a defined section of the res-taurant.
Labor Report — Displays labor information in three separate report options.
Weekly Schedule vs Actual Labor Report — Displays labor information compared to weeklylabor schedules. Schedules must be created for the selected week(s) to display accurate informa-tion.
Edited Deposits — Displays cash information such as cash drops and cash drop editing.
Overtime Warning Report — Displays labor information for employees reaching overtime.
Employee Breaks Report — Displays labor information for employees that take breaks.
PMix Report (Product Mix) — Displays product information for items sold in your establish-ment.
Payments Detail Report (Payments) — Displays payment information for all cash and non-cash tender transactions.
Daily Void Report (Voids) — Displays information pertaining to voids performed for theselected date(s).
Surcharge Report — Displays information pertaining to surcharges for the selected date(s).
Emp Performance Measures Report (Performance Measures) — Displays information per-taining to performance measures. Use this report to determine the value and progress of employ-ees.
Audit Report — Displays detailed information on the functions performed from the Front-of-House terminals. User this report to detect theft and for other monitoring purposes.
Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Back-of-House Security Levels Report (Back-of-House User) — Displays information per-taining to employees accessing the BOH program.
Back-of-House User Security Report — Displays information pertaining to the BOH users’restrictions.
Detailed Access Levels Report — Displays defined access level information and the functionseach level can perform.
Some reports are a collection of separate sections that display selected information defined byyou using the report settings dialog box. The examples given in this book do not display actualdata and are intended to be used as a guide.
In this guide you learn how to:
• Define and prioritize report fields for specific reports.• Navigate through the Preview Report screen.• Reprint guest checks and checkout reports by employee, date, etc.• Create custom reports through Crystal Report Writer.
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 5
3 – 6
Common Buttons on the Reports ScreenLocated on each of the report configuration dialog boxes are options that provide additional func-tionality. Click the button if it is available on the report.
Settings Button
If this option is available for the report, click Settings to display the Settings dialog box. Settingsare available for most of the reports listed on the Reports menu, and are used for configuring.
Each Settings dialog box displays a list of report fields allowing you to select the fields to includeon the report. Others have predefined fields to include on the report. These provide a ‘ReportPosition’ which is used to determine whether the field is included on the report, and the order inwhich the information prints. For example, if 10 different fields print on the report, the field des-ignated as Report Position 1 prints first, the field designated as Report Position 2 prints second,etc. Fields with Report Position 0 (zero) do not display on the report.
View Button
Click View to output and view a report on the screen. After making the report selections and thenecessary changes to the report settings, if any, click View. The ‘grind’ process is implementedon current day reports, and once it is complete, the report detail displays on the screen.
Print Button
Click Print to print a report to the printer instead of displaying it on the screen. After making thereport selections and the necessary changes to the report settings, if any, click Print. The ‘grind’process is implemented on current day reports, and once it is complete, the report detail prints.The report can also be printed while viewing it on the screen using the Printer button.
Export Button
Click Export to export files for third-party software applications. After making the report selec-tions and the necessary changes to the report settings, if any, click Export. The file is exportedand a confirmation message displays.
Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Export Settings Button
Click Export Settings to export an Aloha report to comma separated (*.csv), text (*.txt), or richtext (*.rtf) formats. Common applications, such as Microsoft Word and Excel use these types offormats. After making the report selections and the necessary changes to the report settings, ifany, click Export Settings. Select the file type and path, then click Save.
Select, Add, and Delete Report Setting
Select saved report settings for an Aloha report for different managerial levels, such as KitchenManager, Assistant Manager, and General Manager. A default setting is used. This feature isavailable for the following reports:
• Sales Report - Summary/Weekly• Labor Report• PMix Report - Summary/Weekly
To add a report setting:
1. Click Add. The Add New Report Setting dialog box displays, as shown in Figure 3-1:
2. Enter a Name for the new setting.3. Select a saved setting on which to base the new report setting, or select None to start
from scratch.
The default directory for files you export is RptExport. You can change the location to any directory you wish.
Figure 3-1 Add New Report Setting Dialog Box
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 7
3 – 8
4. Click OK to display the Sales Report Settings dialog box, or Cancel to end the opera-tion.
5. Make changes to the setting as necessary and click Save. You are returned to the Sales Report dialog box.
To delete a report setting:
1. Select a setting from the Select Report Setting drop-down list.2. Click Delete. The Delete report setting confirmation message displays.3. Click OK to delete the report setting, or Cancel to end the operation.
Close Button
Click Close to exit the report screen before or after a report has been viewed or printed. Whenthis button is selected, the screen returns to the main menu.
Report Date Selection
Select from the Report Date list box to run the report based on a single date or a range of dates.The list box is located on each of the report configuration dialog boxes. When defining a range ofdates, the system automatically includes all dates between the selected beginning and endingdates.
Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
An example of the Preview Report dialog box is shown in Figure 3-2:
The bottom toolbar displays the following buttons:
Figure 3-2 Preview Report Dialog Box
Displays the first page of the selected report.
Displays the previous page of the selected report.
report pagevertical scroll bar
move forward/backward in the report
exit print the report
enlarge and reduce
current view magnification
status bar
report title
horizontal scroll bar
toolbar
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 9
3 – 1
Displays the next page of the selected report.
Displays the last page of the selected report.
Exits the Preview Report screen without printing the report.
Prints the current page of the selected report.
Prints the entire report.
Enlarges and reduces the selected report.
0 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Sales ReportsThe Sales submenu provides reports that pertain to restaurant sales is shown in Figure 3-3:
The reports available from the Sales menu are:
• Sales - Summary• Sales - Weekly• Sales by Revenue Center• Server Sales Detail• Comparative Employee Sales• Performance Measures• Hourly Sales and Labor• Tiered Tax
Figure 3-3 Sales Submenu
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 11
3 – 1
Sales Report Summary/Weekly
The Sales report provides sales information by category and the breakdown of payment informa-tion by cash, non-cash, promos, gift certificates, etc. It also enables cash deposits to be edited oradded. The Sales report is a collection of sections, which are explained in detail. All sections areindependent of each other. You define the information to include on the report and the layout.
There are two options for the Sales report:
Summary Sales Report — Displays information for a selected date(s).
Figure 3-4 Sales Report Summary Preview
2 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Weekly Sales Report — Displays information for a selected week(s).
Figure 3-5 Sales Report Weekly Preview
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 13
3 – 1
Select Reports > Sales > Sales > Summary or Reports > Sales > Sales > Weekly to access thecorresponding report. The Sales Report dialog box appears.
Select a single date, or a range of dates, from the selection list.
Settings Button
Click Settings to access the Report Settings dialog box and change the report configuration, ifnecessary.
Figure 3-6 Sales Report Dialog Box
4 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Change Deposit Button
Click Change Deposit to enter or edit the daily deposit amount. If there is not a Deposit.txt fileavailable, or deposits have not been made for the day, the Edit Deposits dialog box automaticallyappears.
Select the deposit and click Add, Edit, or Delete. Use the function to determine an over/short con-dition against the deposit calculated from the FOH sales figures. Existing deposits display in thelist box.
Figure 3-7 Edit Deposit Dialog Box
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 15
3 – 1
Sales Report Settings
Click Settings to open the report configuration dialog box used to control the manner in whichthe data is printed on the report.
Available — Displays the available sections for the Sales report.
Included — Displays the sections included in the Sales report.
Options Group Box
Displays additional options when the section is selected.
> — Includes the section in the report.
< — Excludes the section in the report.
^ — Moves the section up in the order of sections.
V — Moves the section down in the order of sections.
Most sections provide the following check boxes:
Figure 3-8 Sales Report Settings Dialog Box
6 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Header Text — Provides the ability to title the section with a user-defined heading. The name ofthe section is used as the default.
Display with Previous — Displays one row sections with the previous section, if room allows.For example, if two sections display a single row of data and are defined together in sequentialorder, they display side by side.
Print Landscape — Displays the report in landscape format.
Sales Report Sections
The Sales report contains sections that display data reflecting different aspects of your operation.Some sections provide additional check boxes in the Options group box for additional latitude inhow the data is printed.
The following sections are available for the Sales report. Each section, and its correspondingoption, if any, are explained in detail. The sections are discussed in alphabetical order, not in theorder in which they are listed in the dialog box:
Additional Charges Section
The Additional Charges section displays a single-line total amount of additional charges appliedto sales. Additional Charges are defined in Store Settings > Financials.
Cash Cards by Sales Category Section
The Cash Cards by Sales Category section displays the total amount of cash card sales for eachsales and retail category, with an ending total.
Additional Charges 14.25
Cash Cards by Sales Category
Desserts 0.00
Sundaes 0.00
-------
Total 0.00
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 17
3 – 1
Cash Cards Sold Section
The Cash Cards Sold section displays the sales amount of each defined cash card, with an endingtotal.
Cash Payments Section
The Cash Payments section displays a single-line sales total of payments applied to cash. Thisincludes all tenders that report as cash, such as $1.00 and Next $.
Check Count by Day Part Section
The Check Count by Day Part section displays the total number of checks for each defined daypart, with an ending total. Day parts are defined in Maintenance > System > Day Parts.
Cash Cards Sold
Cash Card 0.00
-------
Total 0.00
Cash Payments 480.02
Check Count by Day Part
Breakfast 0
Lunch/Snck 9
Dinner 8
Overnight 5
-------
Total 22
8 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Check Count by Sales Type Section
The Check Count by Sales Type section displays the total number of checks for each defined salestype, or order attribute, with an ending total.
Comps Section
The Comps section displays the comped amount of sales. Comps are defined in Maintenance >Payments > Comps.
Total Only — Displays the total comped amount of sales.
List All — Displays the comped amount for each defined comp, with an ending total. This sec-tion could be long depending on the number of defined comps.
Check Count by Sales Type
Banquet 51
Cash 14
-------
Total 65
Comp Total 15.99
Comps
Mgr Comp 4.00
VIP 0.00
Emp Meal 2.39
Open % 9.00
-------
Total 15.99
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 19
3 – 2
List All with Values — Displays the comped amount for applied comps only, with an endingtotal. Comps with a $0.00 balance do not display.
Credit Card Tip Reduction Section
The Credit Card Tip Reduction section displays the total amount of sales from the percentagecharged to the employee for processing the tip or auto gratuity portion. The charge back is onlyapplied to the tip/auto gratuity portion, not the sales amount. This section is also referred to as‘Tip Refund’ and the percentage is defined in the ‘Tip Refund %’ text box in Maintenance > Pay-ments > Tenders.
Deposit (Over/Short) Section
The Deposit (Over/Short) section displays the total amount of calculated cash, deposits enteredor dropped, and the over/short total for the selected date of business. If the report uses a range ofdates, only the calculated cash line displays. The total deposit and over/short fields do not dis-play.
Comps
Mgr Comp 4.00
Emp Meal 2.39
Open % 9.00
-------
Total 15.99
Credit Card Tip Reduction 6.00
Deposit (calculated) 365.01
Deposit: Drop 500.00
--------
Deposit O/S 134.99
0 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
The formula for calculated cash is based on the following calculation: closed sales + taxes + sur-charges + order mode charges + tip refunds + gift certificates sold + cash cards sold + petty cashtransactions (if the account affects the deposit) + additional charges - non-cash tenders (if the ten-der affects the deposit) - comps - promos - non-collected delivery fees - petty cash transactions (ifthe account does not affect the deposit). Cash calculated is the expected cash in the drawer with-out non-cash payments.
Deposits are the total value of entries made with the BOH Edit Deposits function. The Over/Shortformula is based on the following calculation: calculated cash - deposits. Negative amounts dis-play in ( ).
Show ‘Affects Deposit’ Detail — Displays the total over/short amount of each tender with the‘Affects Deposit’ check box selected, with an ending total.
Deposit (calculated)
Cash 10.00
Travelers Checks 5.00
---------
Total 15.00
Deposit: Drop 14.00
Deposit O/S (1.00)
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 21
3 – 2
When you run the Weekly Sales report, the section displays by the days of the week.
List by ‘Report As’ — Displays the total over/short amount of each tender with the ‘AffectsDeposit’ check box selected, sorted by the ‘Report As’ option selected for the tender.
Show Deposit Detail — Displays the total amount of each deposit, with an ending total.
Sunday Monday
05/06/2001 05/07/2001
Deposit (calculated)
Cash 10.00 12.00
Travelers Checks 5.00 0.00
--------- ----------
Total 15.00 12.00
Deposit: Drop 14.00 11.00
Deposit O/S (1.00) (1.00)
Deposit (calculated) 1145.98
Deposit: Lunch 600.00
Deposit: Dinner 546.05
---------
Deposit O/S .07
2 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
When you run the report for multiple days, the section displays the total amount for each day.
Delivery Section
The Delivery section displays detailed delivery information such as total number of runs andorders, total amount of sales, driver fees, etc. This section displays only if the Delivery/FrequentBuyer product is in use.
Deposit (calculated) 1145.98
Deposit: 08/08/2001 600.00
Deposit: 08/09/2001 546.05
---------
Deposit O/S .07
The ‘Show Deposit Detail’ option is not available when running the Weekly Sales report.
Delivery
Runs 5
Orders 5
Sales 35.00
Driver Fees 3.50
Average Order 7.00
(% of Total Sales) 10%
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 23
3 – 2
Employee Over/Short Section
The Employee Over/Short section displays the excess or shortage amount of the cash owed andcollected for each employee who performed a checkout, with an ending total, based on the fol-lowing calculation: declared cash - calculated cash. Only job codes with ‘Must Declare Cash’shows over/short figures.
Exempt Taxables Section
The Exempt Taxables section displays the total tax exempt sales for each Tax ID, with an endingtotal.
Gift Certificates/Revenue Item Sold Section
The Gift Certificates/Revenue Item Sold section displays a single-line gift certificates and reve-nue items with an applied order mode.
Employee Over/Short
Employee Amount
Doe, John -0.14
Drawer 2 4.29
-------
Total 4.15
Exempt Taxables
Food 2.00
Alcohol 3.50
No Tax 0.50
-------
Total 6.00
Gift Certs Sold 650.00
4 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Show Detail — Displays the sales total for each defined gift certificates with an ending total.
Gift Certificate/Revenue Item by Sales Category Section
The Gift Certificates/Revenue Item by Sales Category section displays the total amount of giftcertificate/revenue item for each sales and retail category, with an ending total.
Gratuity by Payment Type Section
The Gratuity by Payment Type section displays a single-line total of gratuity sales.
Show Detail — Displays gratuity information for each cash and non-cash payment, with an end-ing total.
The Gratuity by Payment Type section contains the following columns:
Amount — Displays the total amount of sales with charge tips and auto gratuity.
Charge Tips — Displays the total amount of charge tips applied to transactions.
Gift Certs Sold
$50.00 50.00
$100.00 0.00
Deposit $100 100.00
Deposit Cater 500.00
-------
Total 650.00
Gift Certs by Sls Cat
Food 600.00
Retail 50.00
-------
Total 650.00
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 25
3 – 2
Auto Gratuity — Displays the total amount of automatic gratuity charges applied to transac-tions.
Sales — Displays the sales amount without charge tips and auto gratuity.
Deferred Tips — Displays the sales amount of tips, which are distributed at a later date.Deferred tips are usually posted and paid on a later pay period. This total does not calculate withother fields in this section and used as a reference.
Guest Count by Day Part Section
The Guest Count by Day Part section displays the total number of guests for each defined daypart, with an ending total. Day parts are defined in Maintenance > System > Day Parts.
Guest Count by Order Mode Section
The Guest Count by Order Mode section displays the total number of guests for each order mode,with an ending total.
Guest Count by Day Part
Breakfast 0
Lunch/Snck 9
Dinner 8
Overnight 5
-------
Total 22
Guest Count by Order Mode
Dine In 14
To Go 53
Drive Thru 7
-------
Total 74
6 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Guest Count by Sales Type Section
The Guest Count by Sales Type section displays the total number of guests for each defined salestype, or order attribute, with an ending total.
Non-Cash Payments Section
The Non-Cash section displays the sales amount applied with tenders other than cash. For exam-ple, a credit card payment is a non-cash payment. Non-cash tenders are defined in Maintenance >Payments > Tenders.
Total Only — Displays the total sales amount applied with non-cash payments.
List All — Displays the total amount for each defined non-cash payment, with an ending total.
Guest Count by Sales Type
Banquet 51
Cash 14
-------
Total 65
Non-Cash Payments Total 48.17
Non-Cash Payments
Gift Cert 0.00
Branded 18.22
Wholesale 4.98
Visa 0.00
-------
Total 48.17
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 27
3 – 2
List All with Values — Displays the total amount for applied non-cash payments only, with anending total. Payments with a $0.00 balance do not display.
Show Gratuity — Displays the sales and gratuity breakdown of each non-cash payment type,with an ending total. Columns ‘Amount’, ‘Charge Tip’, ‘Auto Gratuity’ and ‘Sales’ are added tothe section.
Non-Reset Totals Section
The Non-Reset Totals section displays the opening and closing reading totals for the register,with an ending gross total. Closing reading is the total of gross sales up to and including the mostcurrent selected date before grind. Opening reading is the total of gross sales up to and includingthe earliest selected date before grind.
Select ‘Use Non-Reset Totals’ in Maintenance > Store Settings > Security > POS Security inconjunction with this section.
Include Surcharges — Includes surcharges in the sales figures.
Non-Cash Payments
Branded 38.22
Wholesale 4.98
-------
Total 48.17
Closing Reading 203.20
-Opening Reading 203.20
Gross Sales 0.00
8 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Order Mode Charges Section
The Order Mode Charges section displays a single-line sales total for charges associated witheach defined order mode. For example, if a $0.30 charge is added to all to go orders, $0.30 isadded to the total for each transaction closed with a to go order mode. Order modes are defined inMaintenance > System > Order Modes.
Petty Cash Section
The Petty Cash section displays a single-line total amount applied to petty cash accounts. PettyCash accounts defined with the ‘Affect Deposits’ check box selected, does not calculate in thesection.
Show Detail — Displays totals for each defined petty cash account, even if the account did nothave any transactions, with an ending total.
Promos Section
The Promos section displays the discount amount from promotions based on the following calcu-lation: item sales price - promotional price. Promos are defined in Maintenance > Payments >Promotions.
Total Only — Displays the total savings amount of promotions.
Order Mode Charges 4.18
Petty Cash 14.21
Petty Cash
Supplies 10.00
Paidouts 4.21
Cake Deposit 0.00
----------
Total: 14.21
Promo Total 15.99
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 29
3 – 3
List All — Displays the discount amount from each defined promo, with an ending total. Thissection could be long, depending on the number of defined promotions.
List All with Values — Displays the discount amount for applied promos only, with an endingtotal. Promos with a $0.00 balance do not display.
Refunds Section
The Refunds section displays a single-line sales total of transactions applied with a refund.
Promo
$.99 Single 0.80
Burger Deal 1.50
Free Dessert
-------
Total 2.30
Promo
$.99 Single 0.80
Burger Deal 1.50
-------
Total 2.30
Refund Total 25.00
0 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Show Detail — Displays refund detail for each defined payment type for the tender, even if thetotal is zero. For example, if the original check is closed to a personal check, the refund amountdisplays under Check Refunds.
Sales Section
The Sales section displays a single-line sales total based on the menu item price and the optionsavailable for the section. The figure does not include refunds. If any of the following check boxesare not selected, they are indicated as ‘less’ in the header. For example, if Include Comps is notselected, the sales line displays, ‘Grs Sls less Comps’.
Sales is generated from orders sent manually by selecting an order mode or sent automatically.When running in a 24-hour operation, sales is generated from orders closed.
Include Voids — Includes voids in the section. This option is disabled when you select ‘GrossSales Do Not Include Voids’ in Maintenance > Store Settings > Financials > Reports.
Include Comps — Includes comps in the section.
Include Promos — Includes promos in the section.
Include Taxes — Includes taxes in the section.
Include Surcharges — Includes surcharges in the section.
Include Order Charges — Includes applied order mode charges in the section.
Include Additional Charges — Includes additional charges added to transactions.
Refunds
Cash Refunds 15.15
Non-Cash Refunds 6.00
-------
Total 21.15
Grs Sls 413.98
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 31
3 – 3
Do Not Display Descriptors — Does not display ‘less’ indicators for any cleared check box forthe section.
Sales by Category Section
The Sales by Category section displays sales information for categories by net sales, comps, pro-mos, taxes, and gross sales. Categories are defined in Maintenance > Menu > Categories.
Total Only — Displays a single-line sales total.
List All — Displays a sales total for each defined category.
List All with Values — Displays a sales total for each defined category to which transactionswere applied. Categories which did not have transactions, do not display.
The Sales by Category section contains the following columns:
Net Sls — Displays the total sales from menu items only.
Comps — Displays the total value of discount amounts applied to sales. For example, if 10% isdiscounted from a $5.00 check, $0.50 is added to the Comps column.
Promos — Displays the total value of the coupon amounts applied to sales. For example, if a$0.99 Sundae promo is applied to a sundae at a regular price of $1.49, $0.50 is added to the Pro-mos column.
Taxes — Displays the total value of both inclusive and exclusive tax amounts applied to the sale.
Gross Sales — Displays the total sales of all columns based on the following calculation: netsales + comps + promos + taxes.
To remove this column and have comps included in the Net Sales column, set the NETHASCOMPS variable to TRUE in Aloha.ini.
To remove this column and have promos included in the Net Sales column, set the NETHASPROMOS variable to TRUE in Aloha.ini.
2 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Sales by Concept Section
The Sales by Concept section displays the quantity of items sold and sales amount for itemsassigned to a particular concept, with an ending total. Items not assigned to a concept are consid-ered ‘common’.
Distribute Common — Divides common items according to the distribution percentages definedin Maintenance > System > Concepts. Common refers to items which are not dedicated to a par-ticular concept and shared across all concepts.
Straight Sales — Displays sales based on the original item price before you apply a comp or apromotion. Straight sales also include inclusive taxes.
Net Sales — Displays sales based on the following calculation: straight sales - inclusive taxes -comps (if you select ‘Include Comps in Net Sales’)- promos (if you select ‘Include Promos in NetSales’).
Sales by Concept
Quantity Amount
Concept A 6 40.00
Concept B 8 60.00
Common 14 100.00
------- -------
Total 28 200.00
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 33
3 – 3
Sales by Day Part by Category Section
The Sales by Day Part by Category section displays net sales for each sales and retail category byperiod, with an ending total. Day parts are defined in Maintenance > System > Day Parts.
Display Averages — Generates and displays the following averages for each day part:
• Check Average based on the following calculation: net sales per day part ÷ number of checks per day part.
• Guest Average based on the following calculation: net sales per day part ÷ number of guests per day part.
• Avg Guests/Check based on the following calculation: number of guest per day part ÷ number of checks per day part.
Sales by Day Part by Category
Breakfast Lunch Dinner
Food 100.00 200.00 300.00
Drinks 20.00 40.00 60.00
Misc 200.00 300.00 400.00
------ ------ ------
Totals 320.00 540.00 760.00
Breakfast Lunch Dinner
Check Avg 5.18 8.25 5.83
Guest Avg 4.75 5.50 5.25
Avg Guests/Check
1.09 1.50 1.11
4 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Sales by Order Mode Section
The Sales by Order Mode section displays sales reported for each defined order mode, with anending total. For example, if a check is closed with a Drive-Thru order mode, the check amount isadded to the Drive-Thru total.
Display Averages — Generates and displays the following averages for each order mode:
• Check Average based on the following calculation: net sales per day part ÷ number of checks per order mode.
• Guest Average based on the following calculation: net sales per day part ÷ number of guests per order mode.
• Avg Guests/Check based on the following calculation: number of guest per day part ÷ number of checks per order mode.
Order Mode Sales
To Go 5200.00
Dine In 1850.00
Drive-Thru 1200.00
----------
Total: 8250.00
Order Mode Sales
Net Sales Check Avg Guest Avg
To Go 5200.00 9.04 4.91
Dine In 1850.00 9.25 9.25
Drive Thru 1200.00 8.57 8.57
---------- -------- -----------
Total 8250.00 9.01 5.89
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 35
3 – 3
Sales by Sales Type Section
The Sales by Sales Type section displays sales information for sales types, or order attributes, bynet sales, comps, promos, taxes, and gross sales.
Total Only — Displays a single-line sales total.
List All — Displays sales totals for each defined sales type.
List All with Values — Displays sales totals for each defined sales type to which transactionswere applied. Sales Types without applied transactions do not display.
The Sales by Sales Type section contains the following columns:
Net Sls — Displays the total sales from menu items only.
Comps — Displays the total value of discount amounts applied to sales. For example, if 10% isdiscounted from a $5.00 check, $0.50 is added to the Comps column.
Promos — Displays the total value of the coupon amounts applied to sales. For example, if a$0.99 Sundae promo is applied to a sundae at a regular price of $1.49, $0.50 is added to the Pro-mos column.
Taxes — Displays the total value of both inclusive and exclusive tax amounts applied to the sale.
Gross Sales — Displays the total sales of all columns based on the following calculation: netsales + comps + promos + taxes.
To remove this column and have comps included in the Net Sales column, set the NETHASCOMPS variable to TRUE in Aloha.ini.
To remove this column and have promos included in the Net Sales column, set the NETHASPROMOS variable to TRUE in Aloha.ini.
6 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Surcharges Section
The Surcharges section displays a single-line sales total for surcharges and collected surcharges.The Surcharges Total line includes any surcharge with the ‘Guest Always Pays’ check boxcleared. The Surcharges Collected line includes any surcharge with the ‘Guest Always Pays’check box selected.
Tax by Tax ID Section
The Tax by Tax ID section displays amounts from each defined exclusive and inclusive tax, withan ending total. For example, if a check is closed with tax exemption, the check amount is addedto the Tax Exempt total.
Tip Share Section
The Tip Share section displays a single-line total amount of tips applied to transactions.
Surcharges Total 8.50
Surcharges Collected 7.10
Exclusive
Non-Taxable 42.91
Food Tax-1 21.54
Food Tax-2 0.00
Tax Exempt 18.30
Inclusive
---------
Total: 82.75
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 37
3 – 3
Vizor Section
The Vizor section displays a single line total amount of contributions made by the employee par-ticipating in the VizorVest mutual fund program. It also displays the additional cash owedamount from the employee only when the store collects tips.
Voided Gift Certificates Section
The Voided Gift Certificates section displays a single-line total value of gift certificates/revenueitems void from transactions.
Voids Section
The Voids section displays a single-line total of voids applied to transactions.
Show Detail — Displays void detail for each sales and retail category, with an ending total,rather than just a combined summary of the categories.
Total Vizor 25.00
Vizor Cash Owed 5.00
Voids Total 21.80
Voids
Sundaes 5.49
Beverages 0.69
Party 15.62
--------
Total 21.80
8 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Sales by Revenue Center Report
The Sales by Revenue Center report provides sales information by category for each revenue cen-ter, as well as number of guests, number of checks, payment information, comps, promos, tips,auto gratuities, and more. The Sales by Revenue Center report is a collection of sections, whichare explained in detail. All sections are independent of each other. You define the information toinclude on the report and the layout. The report displays as shown in Figure 3-9:
Figure 3-9 Sales by Revenue Center Preview
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 39
3 – 4
Select Reports > Sales > Sales by Revenue Center. The Sales by Revenue Center Report dialogbox appears.
Select a single date, or a range of dates from the selection list.
Figure 3-10 Sales By Revenue Center Dialog Box
0 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Sales by Revenue Report Settings
Click Settings to open the Sales by Revenue Center Report Settings dialog box shown in Figure3-11, used to control the manner in which the data is printed on the report:
The Sales by Revenue Center report contains sections with data reflecting different aspects ofyour operation. Some sections provide check boxes for additional latitude in how data for theselected report field is printed.
Figure 3-11 Sales by Revenue Center Report Settings
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 41
3 – 4
Sales by Category Section
The Sales by Category section displays net sales totals for each sales and retail category, by reve-nue center, with an ending total.
Num Guests Section
The Num Guests section displays a single-line total number of guests for each revenue center.
Show Detail — Displays the total number of guests by day part for the defined revenue center,with an ending total.
Net Sales by Category
Front Room Counter Total
Entrees 1850.20 500.00 2350.20
Sides 505.00 10.00 515.00
---------- -------- -----------
Total 2355.20 510.00 2865.20
Number of Guests
Front Room Counter Total
Total Guests 47 15 62
Number or Guests
Front Room Counter Total
Breakfast 14 3 17
Lunch 33 12 45
---------- -------- -----------
Total 47 15 62
2 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Num Checks Section
The Num Checks section displays a single-line total number guest checks for each revenue center.
Show Detail — Displays the total number of checks by day part for the defined revenue center,with an ending total.
Tax by Tax ID Section
The Tax by Tax ID section displays totals for each exclusive and inclusive tax, by revenue center,with an ending total.
Number of Checks
Front Room Counter Total
Total Guests 15 21 36
Number of Checks
Front Room Counter Total
Breakfast 8 10 18
Lunch 7 11 18
---------- -------- -----------
Total 15 21 36
Tax by Tax ID
Front Room Counter Total
Food Tax 12.01 22.50 34.51
Alcohol Tax 5.70 18.00 23.70
---------- -------- -----------
Total 17.71 40.50 58.21
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 43
3 – 4
Sales by Day Part Section
The Sales by Day Part section displays net sales totals for each defined day part, by revenue cen-ter, with an ending total.
Comps Section
The Comps section displays a single-line total for the comped amount of sales, by revenue center.Comps are defined in Maintenance > Payments > Comps.
Show Detail — Displays the comped amount of sales from each defined comp, with an endingtotal.
Sales by Day Part
Front Room Counter Total
Breakfast 520.00 620.00 1140.00
Lunch 1100.00 800.00 1900.00
---------- -------- -----------
Total 1620.00 1420.00 3040.00
Comps
Front Room Counter Total
Comp Total 0.00 5.00 5.00
Comps
Front Room Counter Total
MGR Comp 0.00 5.00 5.00
Emp Meal 0.00 0.00 0.00
---------- -------- -----------
Comp Total 0.00 5.00 5.00
4 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Combine Comps — Displays the comped amount of sales for applied comps only. Comps with$0.00 balance do not display.
Promos Section
The Promos section displays the sales amount from promotions based on the following calcula-tion: item sales price - promotional price. Promos are defined in Maintenance > Payments > Pro-motions.
Show Detail — Displays the sales amount from each defined promo, with an ending total.
Comps
Front Room Counter Total
MGR Comp 0.00 5.00 5.00
---------- -------- -----------
Comp Total 0.00 5.00 5.00
Promos
Front Room Counter Total
Promo Total 0.00 18.50 18.50
Promos
Front Room Counter Total
BOGO 0.00 18.50 18.50
Quick Combo 0.00 0.00 0.00
---------- -------- -----------
Promo Total 0.00 18.50 18.50
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 45
3 – 4
Combine Promos — Displays the sales amount for applied promotions only. Promotions with$0.00 balance do not display.
Payments Section
The Payments section displays the sales total, by revenue center, for each defined non-cash ten-der type, with an ending total. Payments with $0.00 balance display also. Payments are defined inMaintenance > Payments > Tenders.
Cash Payments — Displays cash sales for each revenue center.
Promos
Front Room Counter Total
BOGO 0.00 18.50 18.50
---------- -------- -----------
Promo Total 0.00 18.50 18.50
Payments
Front Room Counter Total
MC 15.00 2.00 17.00
Check 0.00 0.00 0.00
---------- -------- -----------
PaymentsTotal
15.00 2.00 17.00
Front Room Counter Total
Cash 51.00 10.00 61.00
6 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Sales by Day Part and Category Section
The Sales by Day Part and Category section displays net sales totals for all sales and retail catego-ries by day part. with an ending total. A section prints for each defined revenue center. This sec-tion can be long, depending on the number of defined revenue centers.
Tips Section
The Tips section displays net sales for all tenders defined as ‘tippable’, separated by day part,with an ending total. A separate section displays for all auto gratuity sales. A section displays foreach defined revenue center. This section could be long depending on the number of revenue cen-ters.
Net Sales for Revenue Center Front Room
Breakfast Lunch Total
Cones 10.00 50.00 60.00
Scoops 40.00 50.00 90.00
---------- -------- -----------
Total 50.00 100.00 150.00
Tips for Revenue Center Front Room
Breakfast Lunch Total
Cones 0.00 0.00 0.00
Scoops 0.00 0.00 0.00
---------- -------- -----------
Total 0.00 0.00 0.00
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 47
3 – 4
Add Charges Section
The Add Charges section displays additional charges for each revenue center, with an endingtotal.
Select Revs Button
Click Select Revs to filter the report by a specific revenue center(s).
To select the revenue centers to include in the report:
1. Click Select Revs. The Limit Which Revenue Centers to Report dialog box appears.
Additional Charges
Front Room Counter Total
Cover 0.00 0.00 0.00
---------- -------- -----------
AdditionalCharges Total
0.00 18.50 18.50
Figure 3-12 Limit Which Revenue Center to Report Dialog Box
8 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
2. Select Limit by Revenue Center.3. Click each revenue center(s) until all necessary revenue centers are selected, or select
the Select All Revenue Centers check box to include all revenue centers. 4. Click OK.
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 49
3 – 5
Server Sales Detail Report
The Server Sales Detail report contains sales information based on an individual employee, or allemployees who logged in to the system and rang sales. If generic employees are configured byshift, such as Cashier PM-1, use the report to report by shift, and not employees. The EmployeeSales report is a collection of sections, which are independent of each other. You define the infor-mation to include on the report and the layout. The report displays as shown in Figure 3-13:
Figure 3-13 Server Sales Detail Report Preview
0 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Select Reports > Sales > Server Sales Detail Report. The Employee Sales Report dialog boxappears.
Select a single date, or a range of dates, from the selection list. Select an employee from theemployee list or select ‘Select All Employees’ to include sales information for all employees.
Select All Employees — Includes all employees in the report. Select this instead of selectingeach individual employee.
Figure 3-14 Employee Sales Report Dialog Box
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 51
3 – 5
Server Sales Detail Report Settings
Click Settings to open the Employee Cash Report Settings dialog box used to control the mannerin which the data is arranged on the report.
The Server Sales Detail report contains sections that display data reflecting different aspects ofyour operation. Some sections provide check boxes for additional latitude in how data for theselected report field is printed.
Gross Sales Section
The Gross Sales section displays a single-line sales total based on the menu item price and theoptions available for the section. The figure does not include refunds. If any of the followingcheck boxes are not selected, they are indicated as ‘less’ in the header. For example, if IncludeComps is not selected, the sales line displays, ‘Grs Sls less Comps’.
Include Voids — Includes voids in the section. This option is disabled when you select ‘GrossSales Do Not Include Voids’ in Maintenance > Store Settings > Financials > Reports.
Figure 3-15 Employee Cash Report Settings Dialog Box
Grs Sls 413.98
2 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Include Comps — Includes comps in the section.
Include Promos — Includes promos in the section.
Include Taxes — Includes taxes in the section.
Include Surcharges — Includes surcharges in the section.
Use Cashier for Sales — Adds the sale to the total sales of the cashier. If not selected, the sale isadded to the total sales for the employee who keeps the tip. This check box should be set if oneemployee serves and keeps the tip, but another employee actually collects the payment. In this sit-uation, each employee’s sales report and checkout report amounts will match.
Include Order Charges — Includes applied order mode charges in the section.
Sales By Category Section
The Sales By Category section displays a single-line sales total for each sales and retail category.This section displays for each employee.
Show Detail — Displays net sales for each sales and retail category, with an ending total.
Sales by Category
Net Sls Comps Promos Taxes Grs Sls(less (n))
Total 26.00 1.00 5.00 2.50 34.50
Sales by Category
Net Sls Comps Promos Taxes Grs Sls(less (n))
Entrees 18.00 0.00 5.00 2.00 25.00
Sides 8.00 1.00 0.00 0.50 9.50
---------- -------- ----------- ------------ -------------
Total 26.00 1.00 5.00 2.50 34.50
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 53
3 – 5
Check, Guest Avg’s Include Comps/Promos — Includes comps and promotions in the checkand guest average calculation. Check average is based on the following calculation: sales +comps + promos / total of all checks. Guest average is based on the following calculation:sales + comps + promos / total of all guests.
Check, Guest Avg’s Include Taxes — Includes taxes in the check and guest average calcula-tion. Check average is based on the following calculation: sales + inclusive tax + exclusive tax /total of all checks. Guest average is based on the following calculation: sales + inclusivetax + exclusive tax / total of all guests.
The Sales By Category report section contains the following columns:
Net Sls — Displays the total sales from menu items only, deducting comps, promos, taxes, voids,and refunds/overrings.
Comps — Displays the total value of discount amounts applied to sales. For example, if 10% isdiscounted from a $5.00 check, $0.50 is added to the Comps column.
Promos — Displays the total value of the coupon amounts applied to sales. For example, if a$0.99 promo is applied to an item at a regular price of $1.49, $0.50 is added to the Promos col-umn.
Taxes — Displays the total value of both inclusive and exclusive tax amounts applied to the sale.
Sales by Category
CheckAvg
GuestAvg
Entrees 4.60 4.60
Sides 1.50 1.50
Sales by Category
CheckAvg
GuestAvg
Entrees 3.33 3.33
Sides 1.42 1.42
4 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Gross Sales — Displays the total sales of all columns based on the following calculation: netsales + comps + promos + taxes.
Check Average — Displays the calculated check average based on the following calculation: netsales ÷ total of all checks.
Guest Average — Displays the calculated guest average based on the following calculation: netsales ÷ total of all guests.
Sales by Day Part Section
The Sales by Day Part section displays net sales for each sales and retail category, by day part,with an ending total. The section displays for each employee.
Num Guests Section
The Num Guests section displays the total number of guests for each defined period, with an end-ing total. This section displays for each employee. Use this section to determine the employeewho served the most guests.
Net Sales by Day Part by Category
Breakfast Lunch Total
Beverages 42.00 514.00 556.00
Desserts 14.00 22.00 36.00
---------- -------- -----------
Total 56.00 536.00 592.00
Number of Guests
Breakfast 5
Lunch 50
Dinner 70
----------
Total 125
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 55
3 – 5
Num Checks Section
The Num Checks section displays the total number of checks for each defined period, with anending total. This section displays for each employee. Use this section to determine the employeewho opened the most checks.
Voids Section
The Voids section displays a single-line total amount of voids performed while the employee islogged in. This section displays for each employee.
Tax by Tax ID Section
The Tax by Tax ID section displays totals from each defined exclusive and inclusive tax, with anending total. This section displays for each employee. For example, if a check is closed with taxexemption, the check amount is added to the Tax Exempt total.
Number of Checks
Breakfast 5
Lunch 50
Dinner 70
----------
Total 125
Voids 14.00
Food Tax 75.00
Alcohol Tax 50.00
---------
Total 125.00
6 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Payments Section
The Payments section displays a single-line total of sales with applied payments.
Show Detail — Displays the payment detail for each tender.
Comps Section
The Comps section displays a single-line total amount for comps applied to sales. This sectiondisplays for each employee.
Show Detail — Displays comp detail for each of the defined comps, even if the comp was notapplied to the sale.
Payment Total 1500.00
Payments
Amex 22.50
Visa 81.00
---------
Total 103.50
Comps Total 33.00
Comps
Senior 22.50
Police 10.50
---------
Total 33.00
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 57
3 – 5
Promos Section
The Promos section displays a single-line total amount of promotions applied to sales. This sec-tion displays for each employee.
Show Detail — Displays promotion detail for each of the defined promotions, even if the pro-motion was not applied to a sale.
Cash Cards Sold Section
The Cash Cards Sold section displays the total amount of sales paid with cash cards for eachsales and retail category. This section displays for each employee.
Gift Certs Sold Section
The Gift Certs Sold section displays a single-line total amount of sales with applied gift certifi-cates.
Promos Total 57.00
Promos
Promo 1 28.00
Promo 2 29.00
---------
Total 57.00
Cash Cards
Cash Card 1 0.00
Cash Card 2 20.00
---------
Total 20.00
Gift Cert Total 50.00
8 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Show Detail — Displays the sales totals for each defined gift certificates with an ending total.
Credit Card Tip Refund Section
The Credit Card Tip Refund section displays a single-line sales total for all transactions which atip was refunded.
Surcharges Section
The Surcharges section displays a single-line sales total for total and collected surcharges. Thissection displays for each employee.
Order Mode Charges Section
The Order Mode Charges section displays a single-line sales total for charges associated witheach defined order mode. For example, if a $0.30 charge is added to all to go orders, $0.30 isadded to the total for each transaction closed with a to go order mode. Order modes are defined inMaintenance > System > Order Modes. This section displays for each employee.
Gift Certificates
$5 10.00
$10 40.00
---------
Total 50.00
Tip ReductionTotal
2.00
Surcharges Total 8.50
Surcharges Collected 7.10
Order Mode Charges 4.18
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 59
3 – 6
Petty Cash Section
The Petty Cash section displays a single-line total amount applied to petty cash accounts. Thissection displays for each employee.
Show Detail — Displays totals for each defined petty cash account, even if the account did nothave any transactions, with an ending total.
Petty Cash 14.21
Petty Cash
Supplies 10.00
Paidouts 4.21
Cake Deposit 0.00
----------
Total: 14.21
0 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Comparative Employee Sales Report
The Comparative Employee Sales report compares sales information by category for a particularday. This report is commonly used to find the percentage of a particular category compared toanother category. For example, what is the percentage of desserts sold compared to entrees. Thereport displays as shown in Figure 3-16:
Figure 3-16 Server Sales Detail Report Preview
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 61
3 – 6
Select Reports > Comparative Employee Sales. The Check Sales dialog box appears..
Select a single date, or a range of dates from the selection list. Select a base category and one ormore target categories for comparison. For example, sales in the Food category can be comparedto sales in the Salads, Cold Bev, Hot Bev, Fountain, and Food Mods categories.
The Comparative Employee Sales report contains the following columns:
Employee — Name of the tippable employee for the guest check.
Recpt# — Guest check number.
Item for Base Items — Item(s) found in the base category. For example, to compare a categoryagainst all product items, this would be the category containing all items.
Quantity for the Base Items — Quantity sold of the corresponding items.
Amount for the Base Items — Total sales of the corresponding item.
Item for Add-Ons — Item found in the target category. For example, to compare the percentageof desserts to all product items, dessert items would be found in the Add-Ons column.
Quantity for the Add-Ons — Quantity sold of the corresponding item.
Figure 3-17 Check Sales Dialog Box
2 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Amount for the Add-Ons — Total sales from the item found in the target category.
Quantity for the % of Base — Calculated percentages of the quantity of items sold based on thefollowing calculation: total quantity sold in target category ÷ total quantity sold in base category.This displays for the corresponding employee only and not for line items.
Amt for the % of Base — Calculated percentages of sales based on the following calculation:total sales in target category ÷ total sales in base category. This displays for the correspondingemployee only and not for line items.
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 63
3 – 6
Performance Measures Report
The Performance Measures report provides a detailed listing of all performance measures trackedfrom Front-of-House operations. Performance measures gauge necessary sales reporting, such ascounts to guests and sales per hour and are defined in Maintenance > Labor > Performance Mea-sures. The report displays as shown in Figure 3-18:
Figure 3-18 Performance Measures Report Preview
4 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Select Reports > Performance Measures. The Employee Performance Measure Report dialog boxappears.
Select a single date, or a range of dates, from the selection list.
Figure 3-19 Employee Performance Measure Report Dialog Box
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 65
3 – 6
Performance Measures Report Settings
Click Settings to display the Performance Measures Report Settings dialog box appears.
The following options are available for the Performance Measures report:
Sort By Group Box
Employee — Sorts the report by employee.
Performance Measure — Sorts the report by performance measure.
Filter by Revenue Center — Enables the report to be filtered by all revenue center(s). Selectthis setting to display all defined revenue centers in the list box. Select the revenue center(s) asnecessary and click Save.
Select All — Selects all revenue centers in the list box.
Figure 3-20 Performance Measures Report Settings Dialog Box
6 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Clear All — Clears all revenue centers from the list box.
Click Save to save the changes and return to the Performance Measures Report dialog box, orclick Close to return without saving.
The Performance Measures report contains the following columns:
Perf # — Performance measure ID number.
Perf Name — Name of the defined performance measure.
Perf Detail — Count and total amount of performance measure.
Shift — Shift number for the performance measure.
JobCode — Job code for which the employee was working.
Date — Date of business for the shift.
If you have configured a performance measure to calculate gross sales, you can exclude voids from gross sales by selecting ‘Gross Sales Do Not Include Voids’ in Maintenance > Store Settings > Financials > Reports.
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 67
3 – 6
Hourly Sales and Labor Report
The Hourly Sales and Labor report provides sales and labor information based on a chosen timeperiod, including the labor percentage as it pertains to net sales and as it pertains to gross sales.The information is based on when a guest check is opened. Certain job codes are eliminated fromthis report using the Do Not Update Flash/Hourly Sales Report check box located in Mainte-nance > Labor > Job Codes.
There are two options for the Hourly Sales and Labor report:
Summary Report — Displays information for a selected date(s)
Figure 3-21 Hourly Sales and Labor Summary Report Preview
8 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Weekly Report — Displays information for a selected week(s).
Figure 3-22 Hourly Sales and Labor Weekly Report Preview
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 69
3 – 7
Select Reports > Sales > Hourly Sales and Labor Report to access the Hourly Sales and Laborreport. The Hourly Sales and Labor dialog box appears.
Select a single date, or a range of dates, from the selection list.
Figure 3-23 Hourly Sales and Labor Dialog Box
0 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Hourly Sales and Labor Report Settings
Click Settings to open the Hourly Sales Report Settings dialog box containing time incrementsfrom which the ‘through time’ to use for creating the report can be chosen.
Select the ending time (Through Time) for determining the information to include on the report.For example, if 11:15 a.m. is selected, the report contains information through 11:15 a.m. Infor-mation after 11:15 a.m. is not included in the report.
Print Landscape — Prints the report in landscape format.
Gross Sales — Displays only gross sales totals. This option includes voids unless you select‘Gross Sales Do Not Include Voids’ in Maintenance > Store Settings > Financials > Reports.
Net Sales — Displays only net sales totals.
Select Revs Button
Click Select Revs to include only specific revenue centers in the report.
Figure 3-24 Hourly Sales Report Settings Dialog Box
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 71
3 – 7
To select the revenue centers to include in the report:
1. Click Select Revs. The Limit Which Revenue Centers to Report dialog box appears.
2. Select Limit by Revenue Center.3. Click each revenue center(s) until all necessary revenue centers are selected, or select
the ‘Select All Revenue Centers’ check box to include all revenue centers.4. Click OK.
The Hourly Sales and Labor report contains the following columns:
Start Time — Start time for the period.
Gross Sales — Gross sales for the time period based on the following calculation: net sales +taxes + comps + promos + surcharges. This option includes voids unless you select ‘Gross SalesDo Not Include Voids’ in Maintenance > Store Settings > Financials > Reports.
Net Sales — Total sales from menu items only, with comps, promos, taxes, voids, refunds, andoverrings deducted for the time period.
Figure 3-25 Limit Which Revenue Center to Report Dialog Box
2 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Guests — Total number of guests for the time period.
Checks — Total number of checks for the time period.
Labor Hours — Total labor hours for the time period.
Labor ( ) — Total labor dollars for the time period based on the following calculation: laborhours x employee’s pay rate.
Labor/Net Sales — Calculated percentage of labor dollars per net sales for the time period,based on the following calculation: labor dollars ÷ net sales.
Labor/Gross Sales — Calculated percentage of labor dollars per gross sales for the time period,based on the following calculation: labor dollars ÷ gross sales.
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 73
3 – 7
Tiered Tax Report
The Tiered Tax report displays three types of taxes, such as primary tax, gratuity tax, and bever-age tax, based on the percentage of gross sales by category, by revenue center. These taxes areindicated as Tax1, Tax2, and Tax3 respectively and calculated independently of all Front-of-House calculations.
The report displays as shown in Figure 3-26:
This report is specific to the standards of the Austrian government.
Figure 3-26 Tiered Tax Report Preview
4 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Select Reports > Sales > Tiered Tax Report. The Tiered Tax Report dialog box appears.
Select a single date, or a range of dates, from the selection list. Select the revenue center toinclude in the report.
Select all Revenue Centers — Selects all defined revenue centers.
Figure 3-27 Tiered Tax Report Dialog Box
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 75
3 – 7
Tiered Tax Report Settings
Click Settings to display the Tiered Tax Report Settings dialog box.
Select a Revenue Center — Designates the revenue center to include in the report. All definedrevenue centers display in the list.
Category and Tax Columns — Denotes the tax levels for the Tax1, Tax2, and Tax3 columns foreach sales category. Categories display in the order of their ID numbers.
Print Total Section — Prints an ending total on the report.
Don’t Print 0 Sections — Excludes categories that do not have any transactions.
Gross Sales Group Box
Include Voids — Includes voids in the gross sales total. This option is disabled unless you select‘Gross Sales Do Not Include Voids’ in Maintenance > Store Settings > Financials > Reports.
Include Comps — Includes comps in the gross sales total.
Figure 3-28 Tiered Tax Report Settings Dialog Box
6 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Include Promos — Includes promos in the gross sales total.
Include Taxes — Includes taxes in the gross sales total.
Include Surcharges — Includes surcharges in the gross sales total.
Include Order Charges — Includes order charges in the gross sales total.
The Tiered Tax report displays the following columns:
Gross — Displays the gross sales total, as defined in the Tiered Tax Report Settings dialog box.This calculation includes voids unless you select ‘Gross Sales Do Not Include Voids’ in Mainte-nance > Store Settings > Financials > Reports.
Tax1 Amount — Displays the taxed amount based on the following calculation: (gross sales xTax1%) ÷ (100 + Tax1%).
Net Sales — Displays net sales based on the following calculation: gross sales - Tax1 amount.
Tax2 Amount — Displays the taxed amount based on the following calculation: (net sales xTax2%) ÷ (100 + Tax2%).
Base for Tax3 — Displays sales based on the following calculation: Net - Tax2 Amount.
Tax3 Amount — Displays the taxed amount based on the following calculation: (Base for Tax3 -Tax3 %) ÷ (100 + Tax3).
Bottomline — Displays sales based on the following calculation: Base for Tax3 - Tax3 Amount.
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 77
3 – 7
Employee ReportsThe Employee submenu, shown in Figure 3-29, provides reports that pertain to restaurant labor.
The reports available from the Employee submenu are:
• Labor• Scheduled vs Actual Labor• Employee Breaks• Edited Punches• Overtime Warning• Overtime Forecast• Tip Income• Employee Tip • Front-of-House Cash Owed• Speed of Service• Time and Attendance Detail
Figure 3-29 Employee Submenu
8 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Labor Report
The Labor report generates shift information for a selected period of time. The Labor reports cancontain employee clock in/clock out times, break information, regular and overtime pay rates,regular and overtime hours, declared tips, and more. Define, name, save, and run as many laborreports with separate settings, as needed. The report displays as shown in Figure 3-30:
Figure 3-30 Labor Report Preview
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 79
3 – 8
Select Reports > Employee > Labor. The Labor Report dialog box appears.
Select a single date, or a range of dates, from the selection list. Select an employee from theemployee list, or click ‘Select All Employees’ to include sales information for all employees onthe report.
Figure 3-31 Labor Report Dialog Box
0 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Labor Report Settings
Click Settings to open the report configuration dialog box which allows the report title to beestablished using the Report Title text box, as well as the selection of the information to includeon the printed report.
Report Fields Group Box
Configure labor reports by clicking the check boxes to add or remove the information. A checkmark indicates the information is included in the report.
Employee Number — Denotes the ID number of the employee.
Employee Full Name — Denotes the full name of the employee.
Width — Indicates the width to use for the employee’s full name. Select from ‘Standard,’‘Wide,’ and ‘Extra Wide.’
Employee Nickname — Denotes the nickname of the employee.
Employee SS Number — Denotes the social security number of the employee.
Figure 3-32 Labor Report Dialog Box
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 81
3 – 8
Date of Business — Indicates the system date of business.
Job Code — Indicates the job code under which the employee clocked in.
Time In — Indicates the employee’s clock in time for the shift. Employee working a secondshift reports on a second line.
Time Out — Indicates the employee’s clock out time for the shift. Employees working a secondshift reports on a second line.
Paid Break Hours — Displays the total paid break minutes for the employee’s shift. The jobcode must have the ability to take paid breaks for data to display.
Unpaid Break Hours — Displays the total unpaid break minutes for the employee’s shift. Thejob code must have the ability to take unpaid breaks for data to display.
Regular Rate — Displays the regular rate of pay for the employee.
Regular Hours — Displays the total hours worked for the shift, excluding overtime hours.
Regular Pay — Displays the total labor dollars earned for the shift, excluding overtime hoursand dollars, based on the following calculation: reg rate x reg hours.
Overtime Rate — Designates the overtime pay rate for the employee. Overtime pay rates areconfigured as either ‘Calculate OT by Shift Rate’ or ‘Calculate OT by Average Rate’, as definedin Maintenance > Store Settings > Labor > ClockIn/Out.
If the overtime pay rate is configured as ‘Calculate OT by Shift Rate’, the pay rate is based on thefollowing calculation: reg rate x ‘mult’ text box. Define the ‘mult’ setting in the Overtime groupbox.
If the overtime pay rate is configured as ‘Calculate OT by Average Rate’, the pay rate is based onthe following calculation: (reg hours x reg pay rate) ÷ (reg hours + overtime hours) x (0.5 + regrate).
Overtime Hours — Denotes the total overtime hours worked for the employee’s shift.
Overtime Pay — Denotes the total overtime labor dollars earned for the shift, based on the fol-lowing calculation: overtime rate x overtime hours.
2 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Total Hours — Denotes the total number of hours worked for the employee’s shift, based on thefollowing calculation: reg hours + overtime hours.
Total Pay — Displays the total labor dollars earned for the employee’s shift, based on the follow-ing calculation: (reg hours x reg rate) + (overtime hours x overtime rate).
Other Wages — Displays columns for wage type, other wages hours, and other wages amount.
Total Other Wages — Displays the value of each line, including system generated ‘otherwages’.
(*) Edited — Displays a preceding asterisk if a punch whenever the transaction was editedthrough the Edit Punches function.
Edited By — Displays the name and ID number of the employee who edited the punch throughthe Edit Punches function.
Edited Date/Time — Includes the date and time for punches edited by an employee.
Credit Card Tips — Displays the total amount of tips from all non-cash tenders for theemployee’s shift.
Declared Tips — Displays the total amount of tips declared at clock out for the employee’s shift.This total is equal to or greater than the amount of credit card tips total.
Tippable Sales — Displays sales from order modes selected as tippable.
Tip Threshold — displays the threshold type enforced on the corresponding employee. Forexample, if an employee uses the ‘Global Percentage’ tip declaration method at 5%, the Laborreport displays ‘Global 5.00%.’Use this column to ensure employees declare at least this amountfor federal tax reasons.
Driver Fees — Displays the total driver fees collected by the employee.
Starting Mileage — Designates the starting mileage as entered by the employee when theyclocked in. The employee is required to enter starting mileage if ‘Track Mileage’ is selected inMaintenance > Labor > Job Codes > Delivery.
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 83
3 – 8
Ending Mileage — Designates the ending mileage as entered by the employee when theyclocked out. The employee is required to enter ending mileage if ‘Track Mileage’ is selected inMaintenance > Labor > Job Codes > Delivery.
Total Mileage — Designates the total number of miles driven for the employee’s shift based onthe following calculation: ending mileage - starting mileage.
Vizor — Denotes the total amount the employee contributed to the VizorVest investment pro-gram.
Waive Response — Reports responses from the employee when they are prompted to waivetheir meal period break. ‘Y’ indicates the employee waived the break. ‘No’ indicates theemployee did not waive the break.
Schedule Info — Includes the times for when the employee was scheduled to start work, endwork, the total time the employee was scheduled to work, and the job code for which theemployee was scheduled.
Export ID Group Box
Print the report with information from a third party software by the employee’s Export ID. Selectthe employee’s ID, a job code’s Export Code, or none. If None is selected, the Export ID is notincluded on the report.
Sort By Group Box
Sort the report by one of the six sort options: Employee Number, Employee Social SecurityNumber, Employee Last Name, Employee First Name, Job Code, and Export Job Code. If thereport is sorted by one of the employee settings, a secondary job code sort is needed. If the sortmethod is by job code, a secondary employee sort is needed.
Other Labor Report Settings
Print Detail Lines — Prints individual shift information in addition to totals.
Print Detail Subtotals — Includes details on the subtotals printed on the report.
4 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Print Summary Section — Provides a summary section at the end of the report. The summarysection encapsulates the information from the body of the report. This section does not displaycolumns that do not have data. The ‘Sort By’ selection determines the information in the PrintSummary section.
One Page Per Employee — Prints each employee’s record on a separate page.
Subtract Tip Reduction from CC — Subtracts tips applied to credit cards from sales.
Print Landscape — Prints the report in landscape format.
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 85
3 – 8
Scheduled vs. Actual Labor Report
The Scheduled vs. Actual Labor report compares the scheduled labor against the actual labor fora specific week or range of weeks. The report also compares sales dollars against labor dollars.
Select Reports > Employee > Scheduled vs Actual Labor. The Scheduled vs Actual Labor dialogbox appears.
Select a week, or range of weeks, from the Select Week list box.
Report by Shift — Breaks the report down into shifts.
Include in Sales on Report Group Box
The sales figures are adjusted using the check boxes in this group box. These check boxes dis-play here rather than on a Settings configuration dialog box, and define additional data to includein the sales figures on the report. The check boxes and their effect on the report are:
Inclusive/Vendor Taxes — Adds inclusive and vendor taxes to the sales amounts.
Exclusive Taxes — Adds exclusive taxes to the sales amounts.
Figure 3-33 Scheduled vs Actual Labor Dialog Box
6 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Promos — Includes promotions in the sales amounts.
Comps — Includes comps in the sales amounts.
After making the selections, click View or Print. To exit the report, click Done.
The Scheduled vs Actual Labor report provides the following columns:
Total Sales — Displays the gross sales for each defined sales category.
Job Group — Displays the job group and their corresponding job codes.
Scheduled Hours — Displays the total hours scheduled for each job code and job group.
Scheduled ($) — Displays the total number of labor dollars scheduled for each job code and jobgroup.
Scheduled % Sales — Displays the calculated percentage of sales for each job code and jobgroup, based on the following calculation: scheduled ($) x 100.
Actual Hours — Displays the actual number of hours worked for each job code and job group.
Actual ($) — Displays the actual total of labor dollars earned for each job code and job group.
Actual % Sales — Displays the calculated percentage of actual sales for each job code and jobgroup, based on the following calculation: actual sales ÷ 100.
Difference Hours — Displays the difference between scheduled hours and actual hours for eachjob code and job group, based on the following calculation: scheduled hours - actual hours.
Difference ($) — Displays the difference between scheduled and actual labor dollars for the jobcode and job group, based on the following calculation: scheduled labor dollar - actual labor dol-lar.
Difference % Sales — Displays the difference between scheduled and actual percentage of salesfor the job code and job group, based on the following calculation: scheduled % sales - actual %sales.
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 87
3 – 8
Employee Breaks Report
The Employee Breaks report contains a listing of the employee break ins and break outs. Thereport appears.
Select Reports > Employee > Employee Break. The Employee Break Report dialog box appears.
Select a single date, or a range of dates, from the selection list.
Figure 3-34 Employee Breaks Report Preview
Figure 3-35 Employee Breaks Report Dialog Box
8 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Employee Break Report Settings
Click Settings to open a report configuration dialog box that contains the Sort By group box usedto select the sorting method for the report.
Sort By Group Box
Only one sort option from the Sort By group box can be selected for the report.
When finished, click OK. The screen returns to the Employee Break Report dialog box.
The Employee Breaks report contains the following columns:
Emp SS# — Displays the employee’s social security number.
Period — Displays the period in which the break was taken.
Employee Name — Displays the employee’s name.
Emp # — Displays the employee’s POS ID number.
Date — Displays the date the break was taken.
Start Time — Displays the time the break started.
Figure 3-36 Break Report Dialog Box
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 89
3 – 9
End Time — Displays the time the break ended.
Paid Hours — Displays the total time of the paid break, based on the following calculation: paidbreak end time - paid break start time.
Unpaid Hours — Displays the total time of the unpaid break, based on the following calcula-tion: unpaid break end time - unpaid break start time.
Display Group Box
Use the Display group box to include waive break responses.
Waive Breaks — Includes waive break responses in the report.
Show Exceptions Only — Displays employee records that meet one of the following condi-tions:
• The scheduled employee did not waive their meal break and earned mandatory penalty pay.
• The scheduled employee waived their meal break, but earned mandatory penalty pay.• The non-scheduled employee earned meal break mandatory penalty pay.
0 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Overtime Warning Report
The Overtime Warning Report lists each employee, their hours worked, and their overtime hours.The report displays as shown in Figure 3-37:
Figure 3-37 Overtime Warning Report Preview
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 91
3 – 9
Select Reports > Employee > Overtime Warning. The Overtime Warning Report dialog boxappears.
Choose the beginning date for the report from the ‘Overtime as of’ list box.
Figure 3-38 Overtime Warning Report Dialog Box
2 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Overtime Warning Settings
Click Settings to display the Overtime Warning Report Settings dialog box to set warning levels.
Warning Levels
Warning levels may be set to show when an employee’s hours are approaching specified levels.For example, the settings shown in Figure 3-39 force the system to report for employees whohave reached 20+, 30+, or 35+ hours.
Print Job Codes with No Overtime — Prints the job codes that do not have any overtime sincethe ‘as of’ date.
The Employee Breaks report contains the following columns:
Emp# — Displays the employee’s job code ID.
Name — Displays the employee’s name.
Hours this Week Worked — Displays the total number of hours the employee has worked forthe week.
Figure 3-39 Overtime Warning Report Settings Dialog Box
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 93
3 – 9
Scheduled Hours this Week Worked — Displays the total number of hours the employee wasscheduled for the week.
Total Hours Over — Displays the total number of hours worked over each threshold defined inthe Overtime Warning Report Settings dialog box.
4 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Overtime Forecast Report
The Overtime Forecast report provides overtime information on the number of hours workedthrough a given day within a week, and the number of remaining hours scheduled to work for thatsame week. A schedule must be created in Functions > Labor Scheduler to display accurate infor-mation.
Select Reports > Employee > Overtime Forecast. The Overtime Forecast Report dialog box dis-plays as shown in Figure 3-40:
Choose the start and end date for the report from the selection list boxes.
Figure 3-40 Overtime Forecast Report Dialog Box
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 95
3 – 9
Overtime Forecast Report Settings
Click Settings to display the Overtime Forecast Report Settings dialog box.
Display Employees with OT Only — Displays only employees who are forecasted to receiveovertime and with a greater value than 0 in the ‘Forecasted OT Hours’ column.
Make the necessary changes and click OK. The screen returns to the Overtime Forecast Reportdialog box.
The Overtime Forecast report contains the following columns:
Actual Hours Worked to Date — Displays the total number of hours worked from the selectedstart of week date through the selected end date.
Remaining Scheduled — Displays the total number of hours scheduled from the last selecteddate through the end of that scheduled work week. If no schedule is created, the values arereported as 0.00.
Forecasted Total Hours — Displays the total number of forecasted hours based on the follow-ing calculation: actual hours worked + remaining scheduled.
Forecasted OT Hours — Displays the total number of estimated hours of overtime with the fol-lowing types of overtime:
If Weekly Overtime is in use, the forecasted OT hours are based on the following calcu-lation: forecasted total hours - n, where n is the number of overtime work hours.
If Daily Overtime or Extended Overtime are in use, the Forecasted OT Hours are basedon the following:
Figure 3-41 Overtime Forecast Report Settings Dialog Box
6 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
• Calculate the number of hours of overtime already worked based on the following calculation: the number of hours worked from the Start date to the End date - the number of overtime hours.
• Calculate the number of scheduled hours on a daily basis for the remainder of the week greater than the Daily Overtime threshold, based on the following calculation: hours scheduled per day - overtime day hours.
• Add the Number of OT Hours worked plus the Number of OT Hours scheduled for the remaining time period.
• Calculate the projected Weekly Overtime, based on the following calculation: Fore-casted Total Hours - overtime work hours.
• Compare the values of the Daily Overtime hours to the Weekly Overtime hours and record the greater value.
PTD Variance Worked vs Scheduled — Displays the number of actual hours worked to date -the number of hours scheduled through the selected week.
Hours Allowed before OT — Displays only if the Weekly Overtime type is enabled, based onthe following calculation: overtime work hours - actual hours worked to date.
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 97
3 – 9
Tip Income Report
The Tip Income report is used to conform to the IRS TRAC reporting policy. The report includestippable sales, declared tips, charged sales with tips, charged tips, and auto gratuities for eachemployee. The Charge Tips column includes tips and auto gratuity for all charge sales. The AutoGrat column is for cash auto gratuities only. This report allows a summary over a specified rangeof dates to be created. The report displays as shown in Figure 3-42:
Figure 3-42 Tip Income Report Preview
8 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Select Reports > Employee > Tip Income. The Tip Income Report Dialog Box appears.
Select a single date, or a range of dates, from the selection list.
Figure 3-43 Tip Income Report Dialog Box
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 99
3 – 1
Tip Income Report Settings
Click Settings to display the Tip Income Report Settings dialog box.
Sort by Revenue Center — Sorts the report by each defined revenue center.
One Page Per Revenue Center — Prints one page per revenue center, if ‘Sort by Revenue Cen-ter’ is selected.
Print Summary Section — Prints an ending summary section for all revenue centers, if ‘Sort byRevenue Center’ is selected.
Print Landscape — Prints the report in landscape format.
The Tip Income report contains the following sections that display tip information by employee:
Tippable Sales Group Box
Displays net sales for the employees who are required to declare tips. Sales are considered tippa-ble based on whether ‘Tippable Sales’ is selected for the order mode.
Figure 3-44 Tip Income Report Settings Dialog Box
00 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Net Sales Group Box
Enables you to specify the sales and retail categories to include in net sales, or to include all salesand retail categories.
Sales/Retail Categories — Includes the selected category(s) in net sales. Click each category toinclude in the report.
Select All Categories — Includes all sales and retail categories in net sales.
Non Cash Gross Sales w/Tips Group Box
Displays gross sales from transactions closed to a non-cash tender with a tip or gratuity applied.
Non Cash Net Sales Group Box
Displays net sales from transactions closed to a non-cash tender. Net sales is based on the cate-gory(s) selected in the Net Sales group box. If no categories are selected, all categories are used.
Payments Group Box
Displays the total amount from applied payments.
Declared Tips Group Box
Displays the amount of tips declared when the employee clocked out.
Non-Cash Tips Group Box
Displays the amount of tips manually entered when the employee closed transactions with a non-cash tender.
Cash Tips Group Box
Displays the amount of tips manually entered when the employee closed transactions with a cashtender.
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 101
3 – 1
Total Tips Group Box
Displays the total amount of tips manually entered when the employee closed transactions,regardless of the type of tender.
Non-Cash Gratuity Group Box
Displays the amount of automatic gratuity added to transactions closed with a non-cash tender.
Cash Gratuity Group Box
Displays the amount of automatic gratuity added to transactions closed with a cash tender.
Total Gratuity Group Box
Displays the amount of automatic gratuity added to transactions closed with all tenders.
Total Tips and Gratuity Group Box
Displays the amount of all tips and gratuity.
The Tip Income report contains the following columns:
Num — Displays the ID number of the employee.
Employee Name — Displays the name of the employee.
Tippable Sales — Displays the net sales amount for which the employee is required to declaretips.
Net Sales — Displays item sales based on the sales and/or retail categories you select.
Gross Non Cash w/Tips — Displays total gross sales of checks closed with a non-cash tenderwith a tip or gratuity added.
Net Non Cash — Displays net sales of checks closed with a non-cash tender.
Payments — Displays the total amount of all payments for the employee.
Declared Tips — Displays the amount of tips the employee declared at clockout.
02 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Non Cash Tips — Displays the total amount of tips entered manually for checks closed to a non-cash tender.
Cash Tips — Displays the total amount of tips entered manually for checks closed to a cash ten-der.
Total Tips — Displays the total amount of tips entered manually, based on the following calcula-tion: Non Cash Tips column + Cash Tips column.
Non Cash Grat — Displays the total amount of automatic gratuities applied to checks closedwith a non-cash tender.
Cash Grat — Displays the total amount of automatic gratuities applied to checks closed with acash tender.
Total Grat — Displays the total amount of automatic gratuities based on the following calcula-tion: Non Cash Gratuity column + Cash Gratuity column.
Total T & G — Displays the total amount of manually entered tips and automatic gratuitiesbased on the following calculation: Total Tips column + Total Gratuity column.
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 103
3 – 1
Employee Tip Report
Use the Employee Tip report to conform to the annual IRS 8027 report to display the tip declara-tions of tipped and indirectly tipped employees. With this report you can monitor and eliminatethe under declaration of tips, and also provide all the information you need for 8027 filing. You,and your tipped employees, are responsible for reporting tip information.
Figure 3-45 Employee Tip Income Report Preview
04 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Select Reports > Employee > Employee Tip. The Employee Tip dialog box appears.
Select a single date, or a range of dates, from the selection list. Select an employee from theemployee list, or click ‘Select All Employees’ to include sales information for all employees onthe report.
Figure 3-46 Employee Tip Report Dialog Box
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 105
3 – 1
Employee Tip Report Settings
Click Settings to display the Employee Tip Report Settings dialog box.
Declared Tips Equals Cash Tips — Changes the Total Tips calculation on the Employee Tipreport to the tips declared at checkout + charge tips. Related Options: ‘No Minimum DeclaredTips’ located in Store Settings > Labor > Employee Settings. If you select ‘Declared Tips EqualsCash Tips,’ the Total Tips calculation assumes ‘No Minimum Declared Tips’ is selected and youhave instructed your employees to declare only their cash tips upon checkout, as Aloha trackstheir charge tips. If you do not select ‘Declared Tips Equals Cash Tips,’ then the Total Tips calcu-lation assumes ‘No Minimum Declared Tips’ is not selected, and your employees must declare atleast the amount of their charge tips upon checkout; however to conform to IRS requirements,employees should declare a total of their cash and charge tips.
Include Gift Cards in Non-Charge — Includes sales and tips fully closed to gift card tenders inthe ‘Non-Charge’ columns, rather than the ‘Charge’ columns.
The Employee Tip report displays the following columns and rows, with the corresponding lineitem requirements to populate the 8027 report:
***Directly Tipped Employees*** — Heading for employees who clocked in under a job codewith ‘Order Entry’ selected and ‘Indirectly Tipped’ cleared, as defined in Maintenance > Labor >Job Codes.
Figure 3-47 Employee Tip Report Settings Dialog Box
06 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Total Sales — Total sales on which the IRS considers tippable, based on the following calcula-tion: tippable sales - tippable sales from checks with auto gratuity applied. This total correspondswith line item 5 on the 8027 report.
Total Tips — Total tips declared by the directly tipped employee. If you select ‘Declared TipsEquals Cash Tips,’ the calculation is the total tips declared at checkout + charge tips. If you clear‘Declared Tips Equals Cash Tips,’ the calculation is the total tips declared at checkout only. Referto Declared Tips Equals Cash Tips for more information. This total corresponds with line item 4bon the 8027 report.
Total % — Tip percentage for the employee, based on the following calculation: Total Tipsamount / Total Sales amount.
Charge Sales — Total tippable sales from checks tendered with a tender configured with ‘AllowTips,’ as defined in Maintenance > Payments > Tenders. The system includes checks with multi-ple tenders if one of the tenders is configured with ‘Allow Tips.’ If you select ‘Include Gift Cardsin Non-Charge,’ and you fully tender the check with a gift card, then the system does not includethe charge. Refer to Include Gift Cards in Non-Charge for more information. This total corre-sponds with line item 2 on the 8027 report.
Charge Tips — Total tips recorded by the Aloha system. If you select ‘Include Gift Cards inNon-Charge,’ and you fully tender the check with a gift card, then the system does not include thecharge. Refer to Include Gift Cards in Non-Charge for more information. This total correspondswith line item 1 on the 8027 report.
Charge % — Charge tip percentage for the employee. based on the following calculation:Charge Tip amount / Charge Sales amount.
Non Charge Sales — Total tippable sales excluding tips, based on the following calculation:Total Sales amount / Charge Sales amount.
Non Charge Tips — Total tips declared by the employee. If you clear ‘Declared Tips EqualsCash Tips,’ the calculation is declared tips - charge tips. If you select ‘Declared Tips Equals CashTips,’ the calculation is tips declared at checkout only. Refer to Declared Tips Equals Cash Tipsfor more information.
Non Charge % — Tip percentage for non-charge sales, based on the following calculation: Non-Charge Tips amount / Non-Charge Sales amount.
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 107
3 – 1
Tip Variance — The difference, as a percentage, between charge tips and non-charge tips, basedon the following calculation: Charge Tip percentage - Non-Charge Tip percentage.
Sales w/Auto Grat — Total tippable sales, including automatic gratuities.
Auto Gratuity — Total automatic gratuity applied to checks.
***Indirectly Tipped Employees*** — Heading for employees who clocked in under a jobcode with ‘Indirectly Tipped’ selected, as defined in Maintenance > Labor > Job Codes.
Total Tips — Total tips declared by the indirectly tipped employee. This total corresponds withline item 4a on the 8027 report.
***Total Tips*** — Heading for Total Tips.
Total Tips — Total tips based on the following calculation: Directly Tipped Employees TotalTips amount + Indirectly Tipped Employees Total Tips amount. This total corresponds with lineitem 4c on the 8027 report.
08 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Front-of-House Cash Owed Report
The Front-of-House Cash Owed report lists employees who ring checks, and cash declared andowed. Empty lines for the amount of drops and over/shorts are provided for checkouts. Thisreport lists employees who ring sales, even if a declaration of cash upon checkout is required. Thecharacters ***** print in the Cash Declared column for employees who are not required todeclare cash upon checkout, but have rung sales. No amount ($0) prints in the Cash Declared col-umn for employees who must, but do not, declare cash. To force employees to declare cash, the‘Must Declare Cash’ check box must be selected for their designated job code. The report dis-plays as shown in Figure 3-48:
Figure 3-48 Front-of-House Cash Owed Report Preview
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 109
3 – 1
10 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2Select Reports > Front-of-House Cash Owed and Declared. The Cash Owed Report dialog boxappears.
Select a single date from the selection list box.
Front-of-House Cash Owed Report Settings
Click Settings to open the Cash Owed Report Settings dialog box.
Column 1 Header — Designates the Column 1 heading to print on the Cash Owed report.
Make the necessary changes and click OK. The screen returns to the FOH Cash Owed dialogbox.
Figure 3-49 Cash Owed Report Dialog Box
Figure 3-50 Cash Owed Report Settings Dialog Box
Analyzing
Your BO
H R
eports
Speed of Service Report
The Speed of Service report displays information pertaining to the speed of processing transac-tions. This report helps management identify and track potential bottleneck areas of the restaurantand dining experience. The report displays as shown in Figure 3-51:
Figure 3-51 Speed of Service Report Preview
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 111
3 – 1
Select Reports > Employee > Speed of Service. The Speed of Service Report dialog box appears.
Select a single date, or a range of dates, from the selection list. Select an employee from theemployee list, or click ‘Select All Employees’ to include sales information for all employees.
Select All Employees — Selects all employees in the list box.
Figure 3-52 Speed of Service Report Dialog Box
12 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Speed of Service Report Settings
Click Settings to open the Speed of Service Report Settings dialog box.
Reporting Times Group Box
Select one of the following reporting time options to use for the Speed of Service report:
Report by Hour — Displays information by the hour.
Report Summary for Day — Displays information for the entire day.
Report Specific Time Segments — Displays information based on specific time segments. Thisoption enables the 15 minute increment check boxes.
Sorting Group Box
Select either Revenue Center, Day Part, Order Mode, Video Display Unit, or Store to define howto group the info on the report.
Figure 3-53 Speed of Service Settings Dialog Box
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 113
3 – 1
Reporting Statistics Group Box
Table/Check — Displays table or check information per employee based on the times defined inthe Reporting Times group box. The Table/Check option displays the following columns with anending total:
• The Checks column displays the number of tables or checks opened during the time period.
• The Sales column displays the amount of sales generated during the time period.• The Guests column displays the number of guests entered during the time period.• The Avg Open Time column displays the average time of transactions during the time
period.
Delivery — Displays delivery information per employee based on the times defined in theReporting Times group box. The Delivery/Frequent Buyer product must be enabled for data todisplay. The Delivery option displays the following columns, with an ending total:
• The Order Time column displays how long, in minutes, transactions remained opened, including drive time, based on the following calculation: time the check was closed - time the check was opened.
• The Kitchen Time column displays the time spent preparing the order, based on the fol-lowing calculation: time the driver signed out - time the check was entered.
• The Driver Time column displays the drive time for the order based on the following cal-culation: time the driver signed out - time the driver signed in.
Table Turns — Displays the average length of time between table turns per employee. The TableTurns option displays the following columns:
• The Table Turns column displays the length of time it took a table to turn based on the following calculation: time the last payment was applied - time the check was opened.
• The Open Time column displays the length of time a table was open based on the follow-ing calculation: time the check was closed - time the same check was opened.
14 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Time and Attendance Detail Report
The Time and Attendance Detail report provides the ability to report employee time in and out byday, report employee breaks by day, report time adjustments, report edit punch reasons and whoedited the punch, and provide a signature line and check number line. The report displays, asshown in Figure 3-54:
Figure 3-54 Time and Attendance Report
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 115
3 – 1
Select Reports > Employee > Time and Attendance Detail. The Time and Attendance DetailReport dialog box appears.
Select a single date, or a range of dates, from the selection list. Select an employee from theemployee list, or click ‘Select All Employees’ to include time and attendance information for allemployees.
Select All Employees — Selects all employees in the list box.
Figure 3-55 Time and Attendance Detail Report Dialog Box
16 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Time and Attendance Detail Report Settings
Click Settings to open the Time and Attendance Detail Report Settings dialog box.
Exclude Paid Breaks — Excludes paid break entries on the report.
Subtotal by Week — Includes a subtotal for the total net time worked by the employee, perweek.
New Page per Employee — Begins a new page for each employee.
Print Landscape — Prints the report in landscape format.
Report Fields Group Box
Employee Number — Includes the ID number for the employee.
Employee Full Name — Includes the first and last name of the employee.
Employee Nickname — Includes the nickname of the employee.
Figure 3-56 Time and Attendance Detail Report Settings Dialog Box
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 117
3 – 1
Employee SS Number — Includes the social security number of the employee.
Job Code — Includes the job code of the employee by each edited punch.
Declared Tips — Includes the amount of tips the employee declared.
Edited Date/Time — Includes the date and time for punches edited by an employee. RelatedOptions: If you select ‘Edit Date/Time’ and ‘Use Edit Punch Reasons’ in Maintenance > StoreSettings > Labor group > Employee Settings, the system forces the ‘Print Landscape’ optionwithout the ability to clear it.
Custom Line 1 Text — Allows you to add an extra line to print, such as ‘Employee SignatureX__________’. Type up to 80 alphanumeric characters.
Custom Line 2 Text — Allows you to add a second extra line to print, such as ‘Check#__________’. Type up to 80 alphanumeric characters.
Sort By Group Box
Sorts the Time and Attendance Detail report by employee identification. Select either EmployeeNumber, Employee Last Name, Employee First Name, or Employee SS Number.
The Time and Attendance Detail report displays the following columns:
Employee — Designates the employee ID number and name.
Date — Designates the date the employee worked.
Jobcode — Designates the job code in which the employee worked.
Type — Designates the type of punch, such as ‘Punch’, ‘Unpaid Break’, and ‘Paid Break’. Youcan edit all three types.
Start — Designates the time, in military hours, the employee clocked in.
End — Designates the time, in military hours, the employee clocked out.
Total — Designates the total number of hours the employee worked, based on the following cal-culation: End total - Start total.
18 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Net Time — Designates the adjusted total number of hours worked by the employee, minus theunpaid breaks.
Declared Tips — Designates the total amount of tips the employee declared.
Adjusted Declared Tips — Designates the total amount of tips the employee declared afteradjustments, such as an ‘adjust tip’ action.
Edited By — Designates the name of the employee who edited the punch.
Reason — Designates the selected reason for performing the punch. If Edit Punch Reasons arenot in use, then the column does not display.
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 119
3 – 1
Edited Punches Report
The Edited Punches report contains a listing of time and attendance information that has beenedited using the Edit Punches utility. When the Edit Punch Reasons feature is in use, the reasondisplays as a separate line item under each punch. ‘None’ indicates Edit Punch Reasons are inuse, but the data is prior to the implementation of the feature. The report displays as shown inFigure 3-57:
Select Reports > Employee > Edited Punches. The Edited Punches Report dialog box appears.
Figure 3-57 Edited Punches Report Preview
Figure 3-58 Edited Punches Report Dialog Box
The Settings button does not appear for employees who have the Edit option cleared for the Edited Punches report in Maintenance > Labor > Back Office Security Levels.
20 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Select a single date, or a range of dates, from the selection list.
Click Settings to display the Edit Punches Report Settings dialog box.
Edited Date/Time — Includes the date and time the employee edited the punch. When you selectthis option, the system forces the report to print in landscape rather than portrait format.
Suppress Pay Rate Information — Does not display the Pay Rate column on the EditedPunches report. Use this option for establishments that employ hourly managers and pay rateinformation is sensitive.
To prevent hourly employees from viewing pay rate information on the Edit Punches report, thegeneral manager should select ‘Suppress Pay Rate Information,’ on the Edit Punches Report Set-tings dialog box, click Save, then control the rights to changing the settings for the EditedPunches report through back office security levels. With proper security levels, managers who arepaid hourly cannot access the Settings button, and, therefore, cannot change the report to display
Figure 3-59 Edit Punches Report Settings
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 121
3 – 1
pay rates. Managers who are paid on salary and have editing rights, can access the Settings but-ton to change the configuration to make pay rates visible, if needed.
The Edited Punches report displays the following columns:
Emp# — Displays the ID number of the employee.
Name — Displays the name of the employee.
Date — Displays the date of business for the shift.
Jobcode — Displays the job code under which the employee clocked in.
Time In — Displays the clock in time for the shift.
Time Out — Displays the clock out time for the shift.
Pay Rate — Displays the pay rate for the employee.
Manager — Displays the name of the manager who edited the shift.
Figure 3-60 Edited Punches Report without Pay Rate Information
22 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Payments ReportThe Payments report contains detailed payment information pertaining to cash, credit cards, pro-mos, comps, and manager meals tendered in the FOH. When the comp or promo is applied by themanager, the manager’s name displays on the report. The report displays as shown in Figure 3-61:
Figure 3-61 payment Detail Report Preview
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 123
3 – 1
Select Reports > Payments. The Payment Detail Report dialog box appears.
Select a single date, or a range of dates from the selection list.
Figure 3-62 Payment Detail Report Dialog Box
24 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Payment Detail Report Settings
Click Settings to open the Payment Detail Report Settings dialog box used to control the mannerin which the data is printed on the report.
The following check boxes provide additional latitude in how the data for the specified field isprinted:
Sort by Revenue Center — Displays the report by revenue center.
Print Landscape — Prints the report in landscape format.
Comp Section and Promo Section Group Boxes
Both sections have three print options. Only one print option can be selected per section.
Print Line Item Detail Including 0 Items — Prints detail for all items, including those withzero amounts.
Print Line Item Detail - No 0 Items — Prints detail only for those items that do not have a zeroamount.
No Line Item Detail — Excludes the printing of item detail.
Figure 3-63 Payment Detail Report Settings Dialog Box
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 125
3 – 1
Payment Section Group Box
Include Cash Payments — Includes cash payments on the report.
Summary Group Box
Print Summary Section Only — Prints a summary of the report detail only. The details are notprinted.
Make the necessary changes and click OK. The screen returns to the Payment Detail Report dia-log box.
The Payment Detail report provides the following columns for each payment, comp, or promo:
Check # — Displays the guest check number.
Card # — Displays the credit card number.
Exp — Displays the expiration date of the credit card.
Quantity — Indicates the number of times the payment, comp, or promo was applied.
Amount — Displays the total sales amount. For comps and promos, this displays the reductionamount.
Grat — Indicates the amount of automatic gratuity.
Tip — Indicates the tip amount.
Total — Indicates the total amount applied to the check, based on the following calculation:amount + grat + tip.
Emp — Displays the employee who started the check for the corresponding payment, comp, orpromo.
You can fully or partially mask the credit card or debit card number with the ‘Credit Card Number Mask’ setting in Store Settings > Credit Card > EDC Setup.
26 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Mgr — Displays the manager who entered the comp or promo due to an employee who did nothave access required to apply it.
Time — Indicates the time the comp was applied.
Name/Item — Displays the name of the item that was comped. If multiple items on the checkwere comped, the text displays as ‘Not Available’.
Unit — Indicates the unit number of the comp, if entered.
% Total — Indicates the percentage of the comp or promo reduction compared to the totalamount, based on the following calculation: check’s comp amount ÷ total comp amount ORcheck’s promo amount ÷ total promo amount.
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 127
3 – 1
House Account ReportThe House Account report allows for the printing of house account invoices for use when billingcustomers.
Select Reports > House Account. The House Account function tab appears.:
Print Button
Select a single account from the list and click Print to print an individual invoice. To printinvoices for multiple accounts, hold down the Shift key, select the desired accounts, and clickPrint.
Balance Button
Click Balance to consolidate all existing transactions on the accounts and create balance forwardtotals that display on statements as a previous balance. This is normally done after printing state-ments for the current month. Infrequent consolidation creates long statements, and prematureconsolidation drops transaction detail from the current statements.
Figure 3-64 House Accounts
28 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Product Mix ReportThe Product Mix (PMix) report contains a total list of items sold for a selected day. Filter it byspecific categories or by terminal. The item detail, such as quantity sold, amount of sale, profit,and percentage of category sales, is also listed for each item.
When you select multiple days to report, the Product Mix report generates configuration datafrom the most recent dated subdirectory in your selection. Using RPT.INI, you can change thisfunctionality to use the configuration data from the most recent dated subdirectory available inthe selection list (TODAY). For example, in the most recent dated subdirectory, item #100 isnamed ‘Nachos’, but when you run the report, you select an older dated subdirectory. In this sub-directory, item #100 is named ‘Apple Pie’. Item #100 lists as ‘Nachos’ on the report, as this is thecurrent configuration.
To enable the PMix report to display current configuration data:
1. Select Start > Programs > Accessories > Notepad.2. Type [Ibertech] and press Enter.3. Type PmixData=True and press Enter.4. Click File > Save.5. Type RPT.INI in the ‘File Name’ field.6. Click Save and place the file in the Newdata directory.
There are two display options for the Product Mix report:
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 129
3 – 1
• The Summary Product Mix report displays information for a selected date(s).
Figure 3-65 PMix Report Summary Preview
30 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
• The Weekly Product Mix report displays information for a selected week(s).
The PMix report displays the following columns:
Item # — Displays the item number.
Item Name — Displays the name of the item.
Num Sold — Displays the quantity sold.
Price Sold — Displays the calculated price from which the item is sold. Calculations are lessinclusive taxes if ‘Include Inclusive Taxes’ is cleared in the Settings dialog box.
Amount — Displays the calculated value, based on the following calculation: (num sold) x (pricesold).
Cost — Displays the cost of the item value, based on the following calculation: (item cost) x(num sold).
Profit — Displays the profit of the item, based on the following calculation: amount - cost.
Figure 3-66 PMix Report Weekly Preview
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 131
3 – 1
Food Cost % — Displays the calculated value, based on the following calculation: cost ÷amount.
% Sales — Displays the calculated value, based on the following calculation: amount ÷ grandtotal amount.
Select Reports > Product Mix > Product Mix or Reports > Product Mix > Weekly to access thecorresponding report. The Product Mix Report dialog box appears.
Select a single date or a range of dates from the selection list.
Figure 3-67 PMix Report Dialog Box
32 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Product Mix Report Settings
Click Settings to open the Product Mix Report Settings dialog box used to control the manner inwhich the data is printed on the report. The Product Mix Report Settings dialog box displays withthe Settings dialog box displayed.
Settings Tab
The following check boxes and their effect on the final output are:
Include Sales/Retail Categories — Includes all sales and retail categories on the report.
Include Non-Sales/Retail Categories — Includes all non-sales and retail categories on thereport. Works in conjunction with the ‘Non-Sales Categories’ list box. Select one or more of thecategory names from the ‘Non-Sales Categories’ list box to include on the report.
Select All Cats — Includes all categories on the report.
Print Name — Determines the item name to print on the report. Select from ‘Short Name’,‘Long Name’, or ‘Chit Name’.
Sort By — Determines the sorting method used to print the report. Select between ‘Sales’,‘Quantity Sold’, ‘Profitability’ or ‘Item Num’.
Figure 3-68 Product Mix Report Settings Dialog Box
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 133
3 – 1
Group By — Groups the report by a particular attribute. You can group by ‘None,’ ‘Category,’‘Concept,’ ‘Employee,’ ‘Employee by Category,’ ‘Day Part,’ ‘Day Part by Category,’ ‘RevenueCenter,’ ‘Revenue Center by Category,’ ‘Sales Type,’ and ‘Sales Type by Category.’
Category — Groups items by category assigned to the item.
Concept — Groups items by the concept assigned to the item. This option is only avail-able for the Weekly Product Mix report.
Employee — Groups items by the employee entering the item.
Employee by Category — Groups items by the employee entering the item, by cate-gory.
Day Part — Groups items by the day part in which the item on the check is tendered.
Day Part by Category — Groups items by the day part in which the item on the checkis tendered, by category.
Revenue Center — Groups items by the revenue center in which the item on the checkis tendered.
Revenue Center by Category — Groups items by the revenue center in which the itemon the check is tendered, by category.
Sales Type — Groups items by sales type, or order attributes, assigned to the check. Thesales types appear in the order defined in OrdAttr.txt in the \Data and \NewData directo-ries. If you did not assign a sales type to a specific check, then the items, and the item
34 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
count, display under the NOT SELECTED section. This option is not available for theWeekly Product Mix report.
Sales Type by Category — Groups items by sales type or order attributes assigned to thecheck, by category. The sales types appear in the order defined in OrdAttr.txt in the \Dataand \Newdata directories, then by category ID. If you did not assign a sales type to a spe-cific check, then the items, and the item count, display under the NOT SELECTED sec-
Figure 3-69 Product Mix Report Grouped by Sales Type
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 135
3 – 1
tion. A summary section prints at the end of the report. This option is not available forthe Weekly Product Mix report.
Print Landscape — Prints the report in landscape format.
Report in Revenue Center Group Box
Check Closed — Includes items from closed checks.
Item Rung Up — Includes items that were ordered.
Display Price By Group Box
First Item Ordered — Reports sales of items from the revenue center in which the item isordered.
Item Rung Up — Reports sales of items from the revenue center in which the item is rung up.
Figure 3-70 Product Mix Report Grouped by Sales Type by Category
36 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Option Group Box
Same Item with Different Prices Separated — Separates the same item which has differentprices, separately. For example, if an item is placed on a submenu at $5.99, and also on a modifierat $0.99, the item displays on the report as two entries.
Exclude Zero Price Items — Excludes items with a zero price. For example, modifiers withoutan associated price, does not display on the report.
Include None Sold Items — Includes all defined items whether sold or not, in the report.
Show Tax Breakout — Displays items with different taxes as separate entries. For example, if anitem is defined at 8.25% on dine in orders, and 5% on to go orders, an entry displays for each.
Show Secondary Tax — Displays an entry for items with a secondary tax.
Include Misc Group Box
Include Gift Cert/Rev Items — Includes the gift certificate items in the report.
Include Inclusive Taxes — Includes inclusive taxes on the report.
Include Refunds — Includes refunds in the report.
Sales % Group Box
By Group — Calculates the percentage of the total sales based on the selection in the Group Bygroup box. For example, if Employee is selected, the report reflects the percentage of total netsales and total gross sales by employee.
By Category — Calculates the percentage of the total sales based on the selected categories. Forexample, if Select All Cats is selected, the report reflects the percentage of total net sales and totalgross sales by all categories.
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 137
3 – 1
Filters Tab
Click the Filters tab to drill down to specific aspects of the establishment, such as revenue center,terminal, or menu. The Filters tab appears.
Revenue Center — Filters the report to include data for the selected revenue center(s) only.Click Select All to include data from all revenue centers.
Terminal — Filters the report to include data from the selected terminal only. Select all toinclude data from all terminals.
Menu — Filters the report to include data for items on the selected menu only. Select all toinclude data from all menus.
Figure 3-71 Filters Tab
38 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Quick Count ReportThe Quick Count report displays the tracking and projected counts for items defined as trackingitems in the Quick Count product. Quick Count must be enabled for data to display.
Select Reports > Quick Count. The Weekly Quick Count Report dialog box appears.
Select a single date, or a range of dates, from the selection list.
Refer to the Quick Count Feature Focus Guide for more information on the Quick Count feature.
Figure 3-72 Weekly Quick Count Report Dialog Box
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 139
3 – 1
Menu Item Prices by Name ReportThe Item Prices by Name Report prints all item prices, sorted by name, per category. Alsoincluded is every submenu and modifier group attached to the item. The price reflects the price atwhich the item is sold. Select Reports > Menu Item Prices by Name to access the report.
Menu Item Prices by Number ReportThe Item Prices by Number report prints all item prices, by the item ID number, per category.Also included is every submenu and modifier group attached to the item. The price reflects theprice at which the item is sold. Select Reports > Menu Item Prices by Number to access thereport.
40 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Delivery Driver ReportThe Delivery Driver report provides a detailed listing of delivery trips, and works in conjunctionwith the Delivery/Frequent Buyer product. This report includes the driver’s name, average triptime, total trips, average order time, and total orders.
Select Reports > Delivery Driver Report. The Delivery Driver Report dialog box appears.
Select a single date, or a range of dates, from the selection list.
Figure 3-73 Delivery Driver Report Dialog Box
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 141
3 – 1
Delivery Driver Report Settings
Click Settings to display the Delivery Driver Report Settings dialog box.
Print Daily Subtotals — Includes daily subtotals on the report
Make the necessary changes and click OK. The screen returns to the Delivery Driver report dia-log box.
Figure 3-74 Delivery Driver Report Settings Dialog Box
42 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Delivery Production ReportThe Delivery Production report provides a detailed listing of delivery trips, such as the starting,ending, and average time.
Select Reports > Delivery Production. The Delivery Production Report dialog box appears.
Select a single date, or a range of dates, from the selection list.
Figure 3-75 Delivery Production Report Dialog Box
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 143
3 – 1
Delivery Production Report Settings
Click Settings to open the Delivery Driver Report Settings dialog box.
Report Interval — Sets the time interval to use when displaying the report information. Selectin 30 minute intervals with 1:00 representing an hour.
Set the report interval and click OK. The screen returns to the Delivery Production Report dialogbox.
Figure 3-76 Delivery Production Report Settings Dialog Box
44 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Voids ReportThe Voids report provides a detailed listing of voids performed in the FOH. A void is any itemthat has been committed to an order mode, such as dine in, and then deleted before the check isclosed. The order entry check window also displays the word (VOID) under the voided item. Thereport displays as shown in Figure 3-77:
Figure 3-77 Void Reason Preview
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 145
3 – 1
Select Reports > Void. The Void Report dialog box appears.
Select a single date, or a range of dates, from the selection list.
Figure 3-78 Void Report Dialog Box
If an employee is assigned to a job code with the ‘Allow to Void Own Items’ check box selected, they do not have to choose a void reason. The Void Report displays ‘Void Rea-son UNKNOWN’ on their transactions.
46 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Void Report Settings
Click Settings to open a report configuration dialog box used to control the manner in which datais printed on the report.
Print One Manager Per Page — Starts the report on a new page for each manager.
Print Zero-Priced Void Items — Includes all zero-priced items that were voided, such as modi-fiers.
Make the necessary changes and click OK. The screen returns to the Void Report dialog box.
The Void report contains the following columns:
Check # — Displays the guest check number containing the voided item.
Menu Item — Displays the name of the voided item.
Reason — Denotes the selected reason the item was voided.
Manager — Displays the name of the manager performing the void.
Time — Indicates the time of the void.
Server — Displays the tippable employee who started the check containing the voided item(s).
Amt — Indicates the amount of the voided item(s).
Figure 3-79 Void Report Settings Dialog Box
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 147
3 – 1
Surcharges ReportThe Surcharges report provides a detailed listing of all surcharges collected in the FOH. Sur-charges are additional charges that occur when specific items are sold. It is primarily used inFlorida where each alcoholic drink sold has a surcharge accessed to it. It is then up to the restau-rant to decide whether they will explicitly charge the cost to the guest, or reduce it as a cost ofbusiness. If the restaurant is collecting the money from the guest, the charge shows up as a lineitem on the guest check. If the restaurant is not collecting money from the guest, the chargeshows up as an expense and is deducted for the Net Sales calculation. When a surcharge isassessed on the item, the amount accumulates as a collected surcharge or a not-collected sur-charge. Collected surcharges add to the gross sales total.
Surcharges, used for such things as cover charges, are defined in Maintenance > Menu > Sur-charges. The report displays as shown in Figure 3-80:
Figure 3-80 Surcharges Report Preview
48 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Select Reports > Surcharges. The Surcharges report dialog box appears.
Select a single date, or a range of dates, from the selection.
The Surcharge report contains the following columns:
Sur# — Indicates the surcharge ID number.
Sur Name — Displays the name of the surcharge.
Count — Indicates the total number of surcharges applied.
Amount — Indicates the total sales from surcharges applied.
Figure 3-81 Surcharge Report Dialog Box
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 149
3 – 1
Back of House Security Levels ReportThe Aloha User Level Security Report prints user IDs, logins, and security levels, includingusers’ abilities to add or edit other users and security levels. The report displays as shown in Fig-ure 3-82:
Select Reports > Back-of-House User Security.
The Back of House User Security report contains the following columns:
Number — Indicates the employee’s ID number
First Name — Displays the employee’s first name.
Last Name — Displays the employee’s last name.
Security Level — Indicates the employee’s security level.
Start Time — Indicates the time the employee logged into the BOH.
Figure 3-82 Back of House Security Levels Report Preview
50 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
End Time — Indicates the time the employee logged out of the BOH.
Change Users? — Indicates if the employee has the ability to change users.
Change Security? — Indicates if the employee has the ability to change passwords.
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 151
3 – 1
Back-of-House Users ReportThe Back-of-House User Report prints security level information pertaining to employeesaccessing the BOH. Select Reports > Back-of-House User Report. The report displays as shownin Figure 3-83:
Figure 3-83 Back of House User Security Report Preview
52 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Detailed Access Levels ReportThe Detailed Access Levels Report prints access level information and the functions each levelmay perform, as defined in Maintenance > Labor > Access Levels. This report can be lengthy ifthere are many access levels. Select Reports > Detailed Access Levels Report. The report displaysas shown in Figure 3-84:
Figure 3-84 Detailed Access Levels Report Preview
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 153
3 – 1
System Parameter Summary ReportThe System Parameter Summary Report prints database settings, such as store information andguest check printing. Select Reports > System Parameters Summary Report.
54 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
ReprintsThe Reprints selection in the Reports menu launches the Aloha Reprint program and permits theguest checks or checkout reports for a specific date to be configured or reprinted with font speci-fications for font type, style, and size. The Reprint program provides two additional menus: Fileand Reprint.
The File Menu
The File menu in the Reprint program has two choices: Settings and Exit.:
Figure 3-85 Reprint File Menu
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 155
3 – 1
Change Font
Select File > Settings > Change Font. The Font dialog box appears.
The installed fonts are available for selection for the desired reports.
Select the type of font, font style, and size, then click OK to save the font information. These set-tings apply to all reprints.
Output to Printer
Select File > Settings > Output to Printer to print the reprinted guest check or checkout to anexternal printer.
Output to Screen
Select File > Settings > Output to Screen to display the reprinted guest check or checkout to thescreen.
Figure 3-86 Reprint Change Font
56 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Exit
Select File > Exit to close the Aloha Reprint program and return to the main screen.
The Reprint Menu
The Reprint menu has four choices used to select the printout to reprint.:
Figure 3-87 Reprint Menu
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 157
3 – 1
Guest Check
Select Reprint > Guest Check to reprint a guest check. The Select Date of Reprint dialog box dis-plays with a list of dates including the current date. Select a single date from the list, and clickOK. A list of the closed guest checks displays, as shown in Figure 3-88:
Sort Checks By Group Box
Sorts guest check information to be reprinted either by ‘Employee’, ‘Check Number’, ‘Time’,‘Table’, ‘Amount’, or ‘Primary Payment Type’.
Revenue Center — Filters the guest check information by a specific revenue center.
Reprint Button
Select the guest check(s) and click Reprint to reprint a single guest check, or multiple guestchecks without printing all of them.
Figure 3-88 Select Check for Reprint Dialog Box
The Reprint option is not available unless one or more guest checks are selected.
58 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Reprint All Button
Click Reprints All to reprint all guest checks. The information is sent to the printer or to thescreen, depending on the selection in the Reprints File menu.
Cancel Button
Click Cancel to cancel the selection and return to the Reprint program.
Checkout
Select Reprint > Checkout to reprint a checkout for an employee or the drawer checkout report.The Select Date of Reprint dialog box displays with a list of dates including the current date.Select a single date from the list, and click OK. The Select Checkout to Reprint dialog box with alist of the employee checkouts appears.:
Checkout Type Group Box
Employee — Displays a list of the employee checkouts invoked by each employee for each shift.This is the default selection when you display the ‘Select Checkout to Reprint’ dialog box. Clickthe Employee or Shift column to sort in ascending and descending order. If you select a checkout
Figure 3-89 Sort by Employee Shift
If you are using the Custom Checkout feature, you must have a Checkout.cfg file in the Data directory or the reprinted checkouts are blank.
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 159
3 – 1
report for an employee who was clocked in under a training mode, the ‘Training: Do Not Pay’line displays on the checkout report.
Drawer — Displays the list of drawer checkouts invoked by the ‘Checkout’ button on the FOH‘Assign Cash Drawer’ screen. In the FOH you can run a checkout using the Assign Cash Drawerfunction, and opt not to reset the drawer to zero. Only drawer checkouts where you opt to resetthe drawer to zero display in this list. Click the Cash Drawer or Time column to sort in ascendingand descending order.
Reprint Button
Select the checkout(s) and click Reprint to reprint a single checkout, or multiple checkouts with-out printing all of them.
Reprint All Button
Click Reprint All to reprint all checkouts. The information is sent to the printer or to the screen,depending on the selection in the Reprints File menu.
Cancel Button
Click Cancel to cancel the selection and return to the Reprint program.
Payment Reconciliation
Select Reports > Payment Reconciliation to reprint an employee’s Payment Reconciliation infor-mation. The Select Date of Reprint dialog box displays with a list of dates including the currentdate. Select a single date from the list, and click OK. A list of employee shifts required to per-form Payment Reconciliation displays. Select an employee and click OK.
Split Checks
Select Reports > Split Checks to reprint a check that has been split. The Select Date of Reprintdialog box displays with a list of dates including the current date. Select a single date from thelist, and click OK. A list of employee shifts that have split a check displays. Select a check andclick OK.
60 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Transfers ReportThe Transfers report provides a listing of all tables transferred between employees in the FOH. Itis commonly used as an audit tool for a single date. The report displays as shown in Figure 3-90:
Select Reports > Transfers. The Select Date dialog box appears.:
Select a date or the current date and click OK.
Figure 3-90 Transfers Report Preview
Figure 3-91 Select Transfer Date
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 161
3 – 1
Audit ReportThe Audit report provides detailed tracking of individual transactions that occur in the FOH,including an audit trail for checks that are empty and have been deleted from the Aloha systembecause they are empty. These entries display on the report with ‘CLOSE CHECK’ listed underType and are marked as ‘Fast Close’ in the Transaction column. The report displays as shown inFigure 3-92:
Figure 3-92 Audit Report Preview
62 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Select Reports > Audit. The Select Date drop-down box displays, prompting for a specific date toaudit.
Select a date from the drop-down list, and click OK. The Select Transactions to Audit dialog boxopens and permits the selection of the transactions to include in the report.
Select Transactions to Audit
The Select Transactions to Audit dialog box is a report configuration dialog box used to controlthe manner in which the data is printed on the report.
Narrow the report to a specific time interval by entering a beginning time in the ‘From’ and ‘To’text boxes, using 24-hour clock notation.
Figure 3-93 Select Date Dialog Box
Figure 3-94 Select Transactions for Audit Dialog Box
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 163
3 – 1
If a time interval is not entered, the entire 24 hours for the specified date are included on thereport. The following check boxes and text boxes provide additional latitude in how the data forthe specified field.
Training Sales Group Box
Include Training Sales — Includes sales that are entered while the employee is in ‘training’mode on the report.
Payments Group Box
Cash Payments — Prints cash payments.
Noncash Payments — Includes non-cash payments.
Comps — Includes comps.
Promos — Includes promos.
System Group Box
Terminal Up — Includes each the time the terminal is restarted.
Terminal Down — Includes each time the terminal is shut down.
Reroute Printer — Includes each time a printer is rerouted.
Reroute Print Group — Includes each time a printer group is rerouted.
Reroute Video — Includes each time a remote display system is rerouted.
Reroute Video Group — Includes each time a video group is rerouted.
Labor Group Box
Clock In — Includes the employee clock ins.
Clock Out — Includes the employee clock outs.
Edit Shift — Includes each time a shift is edited.
64 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Edit Break — Includes each time a break is edited.
Break In — Includes each time an employee performs a break.
Break Out — Includes each time an employee performs a break out.
Delete Checkout — Includes each time a checkout is deleted.
Delete Clock Out — Includes each time a clock out is deleted.
Disable Scheduling — Includes each time scheduling is disabled from the FOH.
Allow Clock In — Includes each time the manager has to allow an employee to clock in, if thepunctuation feature is activated in Maintenance > Store Settings.
Checkout — Includes each time a checkout is performed.
Manager Clock Out — Includes clockouts in which a manager approved when an employeedeclared less than their tip threshold.
Waive Break — Includes waive break responses from the employee.
Break Rule Violation — Displays break returns that required a manager approval.
Security Group Box
Log In — Includes log ins.
Log Out — Includes log outs.
Clear/Change Password — Includes each time an employee clears or changes a password.
Other Group Box
Transfers — Includes transfers.
Reopen Checks — Includes checks that were reopened.
No Sale Transactions — Includes no sale transactions.
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 165
3 – 1
Refunds — Includes refunds.
Void Items — Includes voided items along with the name of the manager.
Cleared Items — Includes items which were entered and removed with the Clear or Delete but-ton.
Reprint Check — Includes check reprints.
Order Items — Includes order items.
Close Checks — Includes closed checks.Sort by Number — Sorts all closed checks sequen-tially in the report, including checks used for training sales. Related Options: 1) You must select‘Close Checks’ to enable this option. 2) Selecting ‘Sort by Number’ automatically selects‘Include Training Sales.’
Update Exchange Rate — Updates the report with the current exchange rate when using for-eign currencies.
Split Checks By Server — Includes checks that were split.
Typed Messages — Includes messages entered with the FOH qwerty keypad.
Filter By Group Box
Filters the report either by employee or job code.
Employee List Box — Filters the report to include only the transactions for the specifiedemployee(s).
Select All — Includes transaction for all employees.
Make the necessary changes. There are two additional options provided on this dialog box. ClickAll to automatically include all transactions on the report. To clear all previous settings in theconfiguration, click Clear.
66 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Crystal ReportsCrystal Report Writer (CRW) is a third-party software product that enables custom reports to becreated or modified for use in products like the Aloha system. A run-time version of the productis included as part of the Aloha system. Use the RDB Crystal Reports choice in the Reports menuis used to integrate reports created by Crystal Report Writer.
The run-time version of the program does not provide the ability to design new reports. It merelyallows the running of reports built in the CRW format. To create reports using CRW requires afull version of the program. For more information on CRW, consult the Aloha reseller nearestyou. The report displays, as shown in Figure 3-95:
Figure 3-95 Crystal Report (Modifiers) Preview
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 167
3 – 1
Select Reports > Crystal Reports to open the Configure Crystal Reports function tab.:
Figure 3-96 Crystal Reports Function Tab
68 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2
Analyzing
Your BO
H R
eports
Add or Edit Button
Click Add to open the Add Crystal Report dialog box, select the report from the selection list, andclick Edit.
Description — Contains a long description used to identify the type and nature of the report.
Report File — Holds the name of the CRW report file. CRW reports always have the RPT filename extension. Browse allows a search of available RPT files to be performed.
Report Type Group Box
System Report — Defines the report using files in the \NEWDATA subdirectory.
Daily Detail Report — Defines the report to use files in the dated daily subdirectories.
Summary Report — Defines the report as a summary report for date ranges. When selected, thischeck box activates the Base Data file drop-down list.
Base Data File — Used to enter the name of the primary database file used by the new report.There are seven built in choices: Items, Payments, Revenue Centers, Sales, Table Turns, TimeAnd Attendance, and Voids.
Click OK to add the new report to the Aloha system.
Figure 3-97 Edit Crystal Report Dialog Box
Aloha TableService Report Guide v6.2 Analyzing Your BOH Reports 3 – 169
3 – 1
70 Analyzing Your BOH Reports Aloha TableService Report Guide v6.2Index
AAudit Report 3-162
BBreak Alert Report 2-32Break Alert Threshold Hour(s) 1-8
CClock In/Out Times Report 2-27Clock Out Chit Footer 1-6Clock-In Report Available 1-4Comparative Employee Sales Report 3-61Crystal Reports 3-167
DDisable Labor Reporting 1-4Display clock in/clock out chit in minutes and hundredths 1-6Display FOH Labor Hours in Minutes 1-6Drawer Report 2-38
EEmployee Breaks 1-10Employee Breaks Report 2-29, 3-88Employee FOH Sales Report 2-40
Comps View 2-42Payments View 2-42Promos View 2-43Sales View 2-41Summary View 2-40
Employee Tip Report 3-104Employees Clocked In Report 2-28Exclude Comped Checks and Guests 1-6
FFlash Report 2-20
Entire Day Labor View 2-24Entire Day Net Sales Summa-
ry View 2-22Entire Day Performance
View 2-23Entire Day Summary View 2-
21Last Period View 2-20
FOH Flash Report time interval 1-7FOH Sales by Revenue Report Sorted by Day Part 1-8Front-of-House Cash Owed Report 3-109
GGross Sales do Not Include Voids 1-6
HHourly Sales and Labor Report 3-68
IInclude Comps in Net Sales 1-5Include Promos In Net Sales 1-5Include Zero Priced Items On FOH Pmix Rpt 1-6Item Availability Report 2-37
LLabor and Clock Reports 1-9Labor Report 2-26, 3-79Labor Report Interval 1-5
Mmeal period breaks 2-32Mgr Flash Rpt 1-9
NNo Interval Report 1-7No Open Sales on Server Sales Report 1-5
OOvertime Forecast Report 3-95Overtime Warning Report 3-91
PPayment Report 1-10, 2-36Performance Measures Report 3-64PMix report 1-10Print Clock In 1-5Print Flash Report 1-7Printer Groups 1-8Printers 1-8Product Mix 1-10Product Mix Report 2-39
RReport Non-cash Tenders by Term Revenue Center 1-6Reprint
Checkout 3-159Payment Reconciliation 3-
160Split Checks 3-160
rest period breaks 2-32Restaurant Sales 1-9Restaurant Sales Report 2-8
Comps View 2-14Labor View 2-12Net View 2-10Payments View 2-13Promos View 2-15Sales View 2-11Summary View 2-8Taxes View 2-16
SSales by Revenue Center
Num Checks 3-43Sales by Revenue Center Report 2-17, 3-39
Add Charges 3-48Comps 3-44Num Guests 3-42Payments 3-46Promos 3-45Sales by Category 3-42Sales by Day Part 3-44Sales by Day Part and
Category 3-47Tax by Tax ID 3-43Tips 3-47
Sales ReportAdditional Charges 3-17Cash Cards by Sales
Category 3-17Cash Cards Sold 3-18Cash Payments 3-18Check Count by Day Part 3-
18Check Count by Sales
Type 3-19Comps 3-19Credit Card Tip Reduction 3-
20Delivery 3-23Deposit (Over/Short) 3-20Employee Over/Short 3-24Exempt Taxables 3-24Gift Certificate/Revenue Item
by Sales Category 3-25
Gift Certificates/Revenue Item Sold 3-24
Gratuity by Payment Type 3-25
Guest Count by Day Part 3-26
Guest Count by Order Mode 3-26
Guest Count by Sales Type 3-27
I - 2 Index TableService Report Guide v6.2
Non-Cash Payments 3-27Non-Reset Totals 3-28Order Mode Charges 3-29Petty Cash 3-29Promos 3-29Refunds 3-30Sales 3-31Sales by Category 3-32Sales by Concept 3-33Sales by Day Part by
Category 3-34Sales by Order Mode 3-35Sales by Sales Type 3-36Surcharges 3-37Tax by Tax ID 3-37Tip Share 3-37Vizor 3-38Voided Gift Certificates 3-38Voids 3-38
Scheduled vs. Actual Labor Report 3-86Server Flash Rpt 1-10Server Sales 1-9Server Sales Detail Report 3-50
Cash Cards Sold 3-58Comps 3-57Credit Card Tip Refund 3-59Gift Certs Sold 3-58Gross Sales 3-52Num Checks 3-56Num Guests 3-55Order Mode Charges 3-59Payments 3-57Petty Cash 3-60Promos 3-58Sales By Category 3-53Sales by Day Part 3-55Surcharges 3-59Tax by Tax ID 3-56Voids 3-56
Server Sales Report 2-19Speed of Service Report 3-111Suppress FOH Labor Report Wages 1-8
TTiered Tax Report 3-74Tip Breakdown Prints on Clock Out Chit 1-6Tip Income Report 3-98Transfers Report 3-161
TableService Report Guide v6.2 Index I - 3
I - 4 Index TableService Report Guide v6.2