×
 

PilotLive Reports

Live Sales

The Live Sales report provides real-time turnover information – open tables and closed tables in each outlet. Export and save the data to various formats including PDF, MS Excel or Word for easy analysis.
View Report

Sales Information

The Sales Information report consolidates daily transactional data for each outlet. Have access to the turnover figures with or without VAT, view discounts and customers, as well as bills and a bill’s average, to assist with effective forecasting.
View Report

Consolidated Transactions

The Consolidated Transactions report captures all bills processed the previous day, month and year. It also indicates the year-on-year increase in transactions for each outlet to provide a comprehensive overview of transactional patterns.
View Report

Turnover Listing

Basic turnover listing per store for the current month.
View Report

Consolidated Turnover

The Consolidated Turnover report summarises total sales for the previous day, month and year. This enables the easy comparison of increased turnover year-on-year across different outlets.
View Report

Turnover Chart

The Turnover Chart report provides a visual comparison of turnover across all outlets between selected periods of time. The bar chart visually demonstrates the turnover information for quick and effective analysis.
View Report

Weekly Turnover Summary

The Weekly Turnover Summary provides an overall view and comparison of trading information compared to the previous year. View discounts, covers, bills and sales increase percentage. Daily turnover, cumulative turnover and cover average comparisons are displayed on a bar chart for quick and effective monitoring of data.
View Report

PLU Sales

The PLU Sales report provides a comprehensive breakdown of items sold within each outlet. Items are categorised and all items can be viewed from a drop down list. Each item’s PLU number, the quantity of sales and price is displayed on the report to assist with product purchasing.
View Report

PLU Time Sales

The PLU Time Sales report provides a breakdown of each individual item sold during a specified time period. The report also shows the amount of each item sold and the total value of the sales for each item.
View Report

Take Away and Delivery Revenue Split

Revenue split by sitdown, Takeaway and Delivery for the current period - requires Pilot Orders module.
View Report

 

Trading Patterns

The Trading Pattern report displays revenue and sales metrics per hour with information on bills, covers and meals, as well as the percentage contribution for each hour of the day. The turnover in each timeslot can be viewed on a graph, while sales contributions during breakfast, lunch and dinner are displayed in a pie chart.
View Report

Trading Patterns (Cost Centre)

Trading patterns by cost centre and time period - defaults to current period.
View Report

Main Meal Comparatives

The Main Meal Comparatives Report provides information on the meal average per outlet, as well as the average spend per customer.
View Report

Discounts by Cost Centre

Breakdown of discounts grouped by category and cost centre.
View Report

Purchasing Report

The Purchasing report provides a detailed list of all purchases made within a specified time period. The report displays a list of suppliers along with each items purchased, the cost, VAT and total amount paid to help simplify the stock management process and improve the tracking of suppliers.
View Report

Theoretical Cost of Sales

This report contains a theoretical version of cost of sales based on recipe costings and current product prices. This is a resource intensive report, and runtime will depend on the number of costings, PLU's, and transactions for the period.
View Report

Prepsheet Variance by Category

This report details all daily Prep Variances, with a drilldown by Category and by Item. A chart is used to display problem areas (red is shortage, blue is over).
View Report

Theoretical Stock On Hand

This report shows estimated stock on hand and value. The report uses the last available stock take, and then calculates usage based on PLU sales, recipes etc. The report is accurate up to the last day end. This report is resource intensive and can take longer than other reports to load.
View Report

Stock Usage

Actual stock usage between stock takes, by masterfile item, with purchase value, plus closing stock on hand.
View Report

Stock Usage by Store

Actual stock usage between stock takes, by masterfile item, with purchase value, plus closing stock on hand.
View Report

 

Prep Variance Chart

The Prep Variance Chart provides the value of daily stock variances represented as a bar graph.
View Report

Stock Valuation

The Stock Valuation Reports shows the value of all stock on hand, at the time of any stock take. The valuation is summarized by category, with a drill down into detail of every single masterfile item. Zero quantity items can be excluded.
View Report

Stock Price Comparison by Store

This report compares the cost of products across stores, using the latest stock price as listed in the Masterfile. Prices that are below, or match the minimum price across  stores are green, those over the minimum price are red. Results can be filtered to only show products that have different pricing.
View Report

Products Actual vs Theoretical Usage

A comparison of Theoretical stock usage vs Actual stock usage. You can drill down by Direct Cost Category and/or Expense Category. The bar-chart view represents variances; red is shortage and blue is overage. Details can be interactively sorted by Product Name, Variance or Variance value. The date range is from stock take to stock take. By default, only products with variances are shown.
View Report

 


Waiter Commissions

The Waiter Commissions report displays the sales made by each waiter during a specified period. View the amount of customers served by each individual waiter, commission earned, bills processed and points scored to effectively monitor staff productivity and identify individual waiters that require further training.
View Report

Clock-in Status

A consolidated listing of current staff logged in, or last logged in. Data is drawn from Pilot InTime time and attendance module.
View Report

 

Exception Report

The Exception Report provides the connection status of all outlets to the PilotLive system. View when the last information update took place, the last transaction was made and the connection time to keep track of operations in each outlet.
View Report

Cashup Variances

Daily cashup variances - defaults to current month.
View Report

Consolidated Sales Returns

Consolidated Sales returns (negative voids) for the current period, by date/item/waiter/table.
View Report

Sales Returns

Sales returns (negative voids) for the current period, by date/item/waiter/table.
View Report

Supplier Listing

All static supplier details as per site.
View Report

User Access List

A list of all users currently authorized to view store data.
View Report

Site Details

Static site details - trading date /version / batch number etc.
View Report

Discounts and Voids

Discounts and voids for the current period, by date/type, with item and reason.
View Report

Bill Globals

List of all the details that are displayed on the bill in store.
View Report

Income Statement

The Income Statement provides a detailed report of total sales, profits, losses and expenses. Direct costs and expenses are listed according to categories with detailed information about each product. With this report you can easily determine the profitability of an establishment over a selected time period.
View Report

Cash Movement

Daily cash movement by type per site - defaults to current month.
View Report

Cash Payout Audit

Audit report highlighting the discrepancies between cash payout and cash purchases.
View Report

Income Statement (Consolidated)

The Consolidated Income Statement provides information on the total profits and losses across multiple stores over a selected time period.
View Report

Banking

Daily banking report by type per site - defaults to current month.
View Report

Cash Payout Listing

List of all cash payouts made in the store.
View Report

Sales Comparison

Loyalty sales comparison - year on year.
View Report

Sales Percentage

Loyalty sales as a % of total sales - year on year plus average.
View Report

Sales vs Loyalty

Loyalty sales value vs total sales - year on year with trend.
View Report

 

Swipe Rate

Loyalty client - table swipe rate vs total tables - year on year with average.
View Report

Table Spend

Loyalty client spend vs non-loyalty client spend - year on year with trend.
View Report

PLU Costings

Menu item costings grouped by category.
View Report

Stock PLU Links

List of raw materials linked to sales items.
View Report

 

Preplinks Audit

Audit report that highlight potential errors in the prepsheet links and PLU costings.
View Report