RPOWER.Reports - Report List

From RPOWERWiki

Jump to: navigation, search

PDF examples of the reports are available here.

Some reports are available in CSV format to resolve issues with Excel merging cells. If a CSV format is available, the link to the CSV example is listed after the report description.

Contents

Catering

Catering Menu Item Quantities 
A list of menu items and the quantities which need to be made to fulfill delivery/catering orders for the day.
Food Sheet 
A catering/delivery report which shows when orders are needed, who requested the order, and what menu items are on the order. Also shows delivery time for each order.
Order Sheet 
A menu item level view of what a customer ordered and when it is due to be delivered. Includes item notes.
Tally Sheet 
A catering/delivery report showing order summary information such as the delivery date/time, the customer, and the amount of the check
Voided Catering Tickets 
Tickets with numbers and names that were for catering and voided

Comparison

Average Sales vs. Labor 
Shows averages of sales and labor totals for each hour of the day
Meal Time Sales Comparison 
a graph showing sales totals per meal time
Month Comparison 
Compares the selected month with the same month last year. Also shows estimated sales for the remainder of the selected month.

CSV: Month Comparison

Product Sales Year to Year 
A menu item comparison of sales between the date range in the selected year and the same date range in the prior year
Profit Center Sales Comparison 
a graph depicting sales totals for each profit center
Sales and Labor Comparison 
a chart comparing the sales for the selected date range against the labor cost for the selected date range
Sales and Voids Comparison 
a chart comparing the sales for the selected date range against the voids for the selected date range
Sales per Table 
a graph showing the net sales amounts per table
Sales vs Labor 
Takes a date range and compares the sales against the labor cost for that date range. Options exist to break sales/labor costs down by hour or half hour.
Trending Daily Sales vs Labor 
a graph plotting the net sales and the labor costs for each day of the selected date range
Weekly Sales Vs Labor 
Shows a comparison of sales totals and labor cost for a week
Year to Year Same Dates 
Compare net sales for the same dates last year as this year.
Year to Year Same Date Range 
Compares net sales for the same dates last year as this year
Year to Year Same Day of Year 
Compares net sales for a date range this year, with the same date range last year, meaning same days of the year, not necessarily the same dates.

Corporate

Daily Business 
A daily summary report showing payments by workstation, Refunds and Voids by Server, the day's labor cost, sales category totals, and sales vs. labor summary.
Daily Flash 
Takes a selected date, and reports sales totals for the prior 6 days. Also with Rolling Week totals, week-to-date, period-to-date, and year-to-date totals.
Daily Flash-Week To Date 
Shows a stores progress day by day throughout the selected week.Has week-to-date, period-to-date, and year-to-date totals.
Net Sales History 
Sales today, sales same day last week, with a percentile of net gain or loss. Also compares same day last year, last week to date and last year posted to date with percentile of net of loss or gain.
Royalty and Marketing 
For each store, shows the gross and net sales for each day, and what percentage of net sales goes to Royalty and Marketing fees.
Royalty, Marketing, and Coop 
For each store, shows the gross and net sales for each day, and what percentage of net sales goes to royalty fees, marketing fees, and COOP fees.
Store Sales Data 
For each store, for each day in the selected date range, shows the gross and net sales as well as sales tax and gift card totals

Customer

Customer Labels 
This report prints out customer names and addresses in a format appropriate for labels.
Customer List 
Shows a list of customer information, including the last date the customer placed an order. This is great for doing mailers.
Customer Payments 
a list of transactions by the customer on the payment (which may not be the same as the customer on the ticket)
Customer Summary 
Shows the number of times a customer has visited, the total amount they spent for all those visits, an average amount spent per visit, and their most ordered item.
Customer Order History 
For a date range will show you what customers ordered, and what menu items they ordered.
Customer Sales by Profit Center 
Sales totals for each customer for each profit center
House Account Totals 
A list of house accounts, and how much they spent over the selected date range.
Transaction List with Customer 
a list of transactions by the customer on the ticket (which may not be the same as the customer on the payment)
Transactions by House Account 
for each house account, a breakdown of the transactions for each member

Daily Sales

Daily Sales 
Shows payment totals, sales department totals by meal time, drawer totals by meal time, and guest count. When run for more than one store, aggregates the totals. To see the stores broken out separately, use the Daily Sales by Store report.
Daily Sales (DCCC) 
a Dizzy's Club Coca-Cola specific report which shows a variety of totals, such as tips, voids, catering customer sales, and avg. check per manager shift
Daily Sales Breakdown 
Shows payment, payout, sales, void, discount, and comp totals. Each set of totals broken out into its own table.
Daily Sales by Day 
sales, payment, sales category, and tender totals displayed for each day in the selected date range.

CSV: Daily Sales by Day

Daily Sales by Store 
The same as the Daily Sales report, but broken out by store. To see the store totals aggregated, use the Daily Sales report.
Daily Sales Summary 
This report displays the gross and net sales for the selected day as well as net sales for the week, and the same week last year.
Daily Sales with Paid Outs 
Typical Daily Sales Report with paid out review and total amount of paid outs.
Deposits 
A report showing totals for individual payment methods so that restaurants can track their deposits.

Discount

Discount Category Summary 
Shows discount totals, as well as detail for the selected date range.
Manager Discount Summary 
Shows a discount summary for each manager who authorized a discount during the selected date range as well as detailed information about the ticket the discount appeared on.
Server Discount Summary 
For each server, shows a summary of the discounts they issued to customers. Also has a detail section so the manager can see which tickets had discounts applied to them.

Employee and Labor

Daily Labor Summary 
The web version of the Daily Labor Summary section of the Close Day report.
Daily Labor Summary by Job 
The web version of the Daily Labor Summary section of the Close Day report.
Edited Time Clock 
Shows edited time clock records and who edited them
Employee Breaks 
Shows the amount of time an employee worked and how many break minutes were taken. Also contains a signature line for authoriztion if an employee did not take a break during a shift.
Employee Hours No Pay, No Tips 
Shows punch-in/out records for each employee, but does not show pay information nor tip information for each employee.
Employee Hours No Pay, With Tips 
Shows punch-in/out records and tip information for each employee, but not pay information.
Employee Hours With Pay, With Tips 
Shows punch-in/out records for each employee as well as tip and pay information.
Employee Hours With Pay, No Tips 
Shows punch-in/out records and pay information for each employee, but not tip information.
Labor 
Shows a comparison between a store's net sales and their labor cost. Also shows the difference in labor cost between the current week and previous week.
Labor by Category and Job 
labor totals are broken down inside each labor category by job
Labor by Day 
Cost of Labor in dollars by employee for the day and total for the range of dates.
Overtime Summary 
Shows the number of hours each employee has worked, and the number of overtime hours worked. This report has an approaching overtime option so the manager can scope the report to only show people who have worked more than 30 hours this week, for instance.
Payroll 
Shows the hours each employee worked, the amount to pay each employee, and the employee's pay rate.
Payroll Summary 
A one-line-per-employee labor summary.
Server Commission 
Shows net sales and payment totals per employee
Server Daily Summary 
For each employee, shows the sales total, number of transactions, tip total and gratuity total.
Server Hourly Totals 
Displays sales, guest, check, and tip totals for each employee for every hour of the day.
Server Productivity 
For each server, shows total sales, total checks, total tip, average check, and declared tips
Server Productivity by Meal Time
Shows Server Productivity figures for each meal time.
Server Productivity by Profit Center
Shows Server Productivity figures for each profit center.
Server Sales and Payments 
Shows sales department and payment method totals by employee
Server Sales Statistics 
shows check count, guest count, and sales department totals for each employee
Server Sales Tip Percentages 
Shows each server's cash and charge sales as well as their declared cash tips and charge tips.
Tipped Employee 
Shows an employee's tips, tip fees, and tip pool contributions.
Transactions by Cashier 
a transaction count for each cashier broken out by each hour of the day
Weekly Sales vs. Labor
Shows average check and labor figures for this week, prior week, and the same week last year.

Meal Time

Meal Time Breakdown 
Shows sales department totals, ticket totals, and payment totals for each mealtime for a store.
Meal Time Gain or Loss 
Shows the menu items at their actual sale price compared with their non-adjusted Level 1 price.
Meal Times by Day 
A tabular report showing a breakdown of the sales during each mealtime for each day in the selected date range.
Meal Time vs. Price Level Pricing 
The actual sales totals of the menu items sold during a meal time compared to totals of their Level 1 prices.
Meal Time Sales by Profit Center 
Sales for each of the meal times broken down by profit center.
Product Sales by Meal Time 
Shows the menu item sales figures for each mealtime. ; Product Sales by Profit Center : The menu items sold in each profit center.
Product Sales CrossTab - Profit Center 
A tabular report showing the sales amounts for each menu item sold in each sales category.
Product Sales by Profit Center 
Shows the menu item sales figures per profit center. Also shows what percentage of the profit center sales totals was contributed by each menu item's sales totals.
Workstations by Meal Time 
The net sales rung up on each workstation for each mealtime of the business day.

Order Speed

Order Speed 
For the selected day, shows the average wait time for tickets per each hour of the business day.
Productivity 
Shows the amount of time each ticket was open, how long before the ticket was assigned to a driver, and when it was closed.

Other

Close Day 
shows one of 3 statuses for a store for each day in the selected date range: Whether the store closed its day, whether it sent only intraday posts (meaning it sent data throughout the day but we did not get a close day post), or whether the store did not send anything at all
Did Not Export 
Shows which stores did not export data for a given date range.
Import Verification 
Displays which stores in a consolidation group exported data for a particular date range.
Import Verification-Weekly 
Displays which stores in a consolidation group exported data for a particular week.
Menu Item Notes 
Displays menu item notes on specifically tagged sales categories.

Pay Outs

Pay In Pay Out by Category 
Paid Ins and Paid Outs organized by Pay Out Category showing date, ticket #, reason, employee, employee manager, and total.
Pay Out 
Pay Out Summary based on date, ticket#, category, reason, employee manager, and the total amount.
Pay Out & Pay Ins by Day 
the pay outs/pay ins for each day in the selected date range

Payments

Payments by Date 
Shows the payment totals for each date in the selected date range.
Payments by Profit Center 
For each profit center shows the number of transactions, amount of tips, grats, and tax per payment.
Payments by Profit Center by Workstation 
Shows payment totals for each workstation in a profit center
Transactions by Payment 
Shows the transactions for the day grouped by payment method.

Product Mix

Price Level Breakdown 
Shows menu items and the item's price at each price level
Product List 
Plain jane product list showing the sales category, menu item name, upc, plu, and price.
Product Sales by Room 
Product Sales by Room : For each room, shows the dollar amount and quantity of each product sold.
Product Sales by Sales Category 
For each sales category, shows the menu item sales information as well as the percentage of that sales category's sales contributed by that menu item.
Product Sales by Sales Department 
For each sales department, shows the menu item sales information, as well as the percentage of that sales department's sales contributed by that menu item.

With Detail: Product Sales by Sales Department

Product Sales by Store 
Product Sales by Store : Shows the products sold at each store.
Product Sales Quantities 
For a selected store shows the quantities of each menu item sold
Product Sales Quantities by Meal Time 
For each meal time, shows the quantity of each menu item sold.
Product Sales Quantities by Store and Date 
A tabular report showing the quantity sold for each menu item sold for each store for each date in the date range.
Product Sales Quantities by Store 
A tabular report showing the quantity sold for each menu item sold for each store (dates are aggregated, not separated out).
Product Sales CrossTab - Sales Department 
A tabular report showing the sales amounts for each menu item sold in each sales department.
Product Sales by Sales Category 
For each sales category, shows the menu item sales information, as well as the percentage of that sales category's sales contributed by that menu item.
Product Sales by Store 
For a consolidation group, shows the quantity of each menu item sold at each store.
Product Sales by Room 
For each room, shows the quantity and sales totals for each menu item sold in that room.

Refunds

Server Refund Summary 
Shows the refunds issued by servers as well as a detail section showing the tickets containing refunds.

Reservations

Reservations 
A report tracking customers, their reservation time, and the menu items ordered. Also comes with a notes field.

Sales by Month

Average Check by Month 
Average check amount sorted by month, with an average amount for all months.
Product Sales by Month 
product sales totals for each menu item for each month of the year to date
Sales by Month 
For each store, shows the net sales for each month during the selected year.
Traffic by Month 
A count of customers by month.

Sales Detail

Average Check by Day 
Shows guest count and the average check amount per guest.

CSV: Average Check by Day

Consolidated Product Sales by Sales Category 
Shows sales totals aggregated from all restaurants in a consolidation group (instead of showing totals for each restaurant separately).

With Detail: Consolidated Product Sales by Sales Category

CSV: Product Sales by Sales Category

Historical Hourly Sales 
Shows net sales totals for the selected date, and the same day of the week as the selected date for the last 4 weeks.
Product Sales by House Account 
For each house account, shows the customer under that account and each menu item he/she has ordered as well as the date that menu item was ordered and the quantity ordered.
Product Sales by Sales Department 
Sales department total with percentage based on all sales. The total sale percentage is based on the department against total of all stores.
Product Sales - Quantities 
A tabular report showing quantities of each menu item sold at each store.
Product Sales Quantities by Meal Time 
A tabular report showing quantities of each menu item sold at each store broken down by day and meal time.
Product Sales Quantities by Store and Date 
Number of items sold sorted by date and store.
Product Sales Quantities by Store 
Number of items sold, sorted by date.
Product Sales CrossTab - Sales Department 
Shows sales totals by sales department and total sales.
Product Sales by Sales Category 
This shows menu items with quantities and sales. Percentage is based on sales in category, store sales, and if you have multiple stores how much item makes up against all stores.
Product Sales CrossTab - Sales Category 
Items broken up by quantity and sales, cross referenced against the other stores, with a total number sold and sales between all stores.
Product Sales by Day 
Shows product sales totals for each date in the selected date range.
Product Sales by Half Hour 
Every item or mod broken down by half-hour ordered.
Product Sales by Hour 
Every item or mod broken down by hour ordered. Broken down by category, price, quantity and sales. Also broken down by meal times.
Product Sales by Meal Time 
Sales category and menu item sales totals broken down by meal time.
Product Sales by Profit Center 
Sales category and menu item totals broken out by profit center.
Product Sales by Room 
Item quantities and amounts broken up by room ordered in.
Product Sales by Server 
Sales categories and menu item totals broken out by server.
Product Sales by Server and Hour 
Shows a list of tickets (including detail) grouped by hour for each employee.
Product Sales by Store 
Item totals for multiple stores.
Product Sales by Table 
Shows the sales total and quantity of products sold at each table.
Transaction Detail 
Shows ticket information ordered by each 15 minute segment throughout the day.

With Detail: Transaction Detail with Detail

Transaction Detail with Menu Items 
Shows transaction detail for all tickets containing the selected menu item for the selected date range
Transaction Detail with Sales Category Items 
Shows ticket detail for tickets containing menu items from the selected sales category.
Transactions per Hour 
Transaction totals broken out for each hour of the business day.

CSV: Transactions per Hour

Product Sales per Hour by Profit Center 
Shows transaction counts and dollar totals for each hour per each profit center.
Transactions per Hour Summary 
Shows transaction counts and dollar totals for each hour per store.

Sales Summary

Average Table Turnover Time 
Shows the average amount of time a table was in use for the selected date range and profit center.
Exceptions 
Gross Sales, with refunds/discounts, and refunds/discounts percentage of sales.
Non-Tipped Credit Cards 
Shows non-tipped credit card totals for each server.
Profit Center Summary 
Shows the profit center with number of guests and average amount per check.
Sales Breakdown 
Shows gross sales, voids, hash, discounts, and net sales.
Sales Summary 
Shows sales summary information for each store.
Sales Tax 
Shows taxable and non-taxable sales totals for each date in the selected date range.
Top 10 / Bottom 10 Discounts 
Graphs and lists of the 10 most used and 10 least used discounts.
Top 10 Menu Items by Sales and Quantity 
graph showing the top 10 menu items sold
Weekly Sales Department Summary 
Sales department totals for each week in the selected date range.
Weekly Sales Summary 
shows weekly sales, payment, void, and business analysis statistics for the each day in the selected week

Voids

Server Void Summary 
Shows a summary of the void reasons for each server who issued voids, as well as a detail section showing the tickets containing voids.
Void Reason 
Shows void reasons and the menu items they have been used on.
Void Reason Bar Graph 
a graph showing the amounts voided by the void reasons used during the selected date range
Views
Personal tools