Follow

Impos Analytics Master Report Guide

A series of master reports are available to you as soon as you sign up to Impos Analytics. These have been designed to give clients of all industries a thorough understanding of their data, but keeping in mind that all our clients have their own unique requirements, users also have the ability to make copies of these reports that they can then adjust and fine tune to meet their needs exactly.

All master report titles are prefixed with MR, for example MR001. These reports all operate on a trading day of 00:00 - 23:59. If your venue operates outside of these hours, there are also a series of reports prefixed with RR - these are copies of the MR reports, except with the trading day recalculated to operate from 05:00 - 04:59 the following day.

We are constantly adjusting and improving on our list of core reports, so if you have a requirement that you think would be of benefit to everyone, feel free to let us know so it can potentially be included in future master report releases.

 

MR001. Sales by Hour in a Day

Displays sales totals by hour (excluding GST). This report is used to determine the peak sales periods of the business.

Default Frequency: Daily (current day)

Filters: Store name, Order date range.

 

 

MR002. Sales by Category >Department > Item

Sales (excluding GST) in the venue broken down by category, with the ability to drill down into each category. This report is used to determine the efficiency of each sales category. 

Default Frequency: Daily (previous day)

Filters: Store name, Order date range, Order hour

 

 

MR003. Payment by Tender Type

Total payments received broken down by Tender Type. Allows a drill down into payments by staff and broken down by POS. Used for determining total payment received and split between payment types. 

Default Frequency: Daily (current day)

Filters: Store name, Payment date range

 

MR005. Payment by POS

Total Payment received through each POS terminal broken down by site.  Used for determining location efficiency.  Report includes GST.

Default Frequency: Daily (current day)

Filters: Store name, Payment date, Payment Method

 

 

MR006. Payment by Staff Member

Payments broken down by staff members for each site.  Used to determine efficiency in staff. 

 

Default Frequency: Daily (current day)

Filters: Store name, payment date range, payment method

 

MR007. Refund, Discount, Void and Reverse Payments by Employee

A summary of all Refunds, Discounts, Voids and Reverse payments showing all as a positive value. A further detailed report shows each of these transaction types by each staff member. Drill down into itemized transactions by staff member.  Used to determine the accuracy and accountability of staff. 

Voids are reported against the staff member who placed the original transaction, not the staff member who completed the void.

Default Frequency: Daily (current day)

Filters: Store name, Order date range

 

 

MR008. Refund, Discount, Void and Reverse Payments by Item

An itemized breakdown of all transactions by a selected staff member, showing all transactions including all Refunds, Discounts, Voids and Reverse Payments as positive amounts.

Default Frequency: Daily (current day)

Filters: Store name, order date, Employee name

 

 

MR009. Discount by Type

A listing of all the total discount amount provided by each discount type for the selected date range.

Default Frequency: Daily (current day)

Filters: Store name, Order date

 

 

MR012. No Sale

Listing of all No Sale events in the given time period, listed by employee, POS and time.

Default Frequency: Daily (current day)

Filters: Store name, date range

 

 

MR015 Sales by Day

Sales day by day, viewing last 7 days. Shows daily net sales inc GST and % of weekly sales total achieved each day.

Default Frequency: Weekly (from previous day)

Filters: Store name, Order date range

 

 

MR016 Daily Sales efficiency

Sales (including GST) for a selected day of the week, over the last 6 months, with a stacked column of categories.

Default Frequency: Prior 6 months

Filters: Store name, day of week, date range.

 

MR017. Price Set and Level Breakdown

Displays the breakdown of sales between price levels and price sets, with an insight into Profit and COGS for each combination.

Price Levels extend from 0 (no Adjustment attached) to 5. Price Sets extend from 1 to 3. Sales figures are excluding GST and Sales and Quantity are Net figures.  A category must be selected before the report can be run.

Default Frequency: Weekly (Prior 7 Days)

Filters: Order Date Range, Menu Category, Department, Price Level, Price Set

 

 

MR018. Spend Per Head by Employee

Lists the number of covers, net sales amount and average spend per head of an employee, split by store name and date.

Default Frequency: Weekly (including current day)

Filters: Store name, date range, sales station

 

 

MR020: BLD Payment Report

Breakdown of Payment Type by Station and time period Breakfast between 5am and 11:59am Lunch between 12pm and 16:59pm Dinner between 17pm and 4:59am

Default Frequency: Daily

Filters: Store name, date range

 

 

MR021. BLD Sales Report

Breakdown of Category by Station and time period.  Breakfast between 5am and 11:59am  Lunch between 12pm and 16:59pm  Dinner between 17pm and 4:59am  Master Sales View, 17/2/2016 5:16 PM

Default Frequency: Daily

Filters: Store name, date range

 

 

MR022. Item Sales Report

Report shows Net Quantity and Net $ value inc GST for sales during the selected time period.

Default Frequency: Daily (previous day)

Filters: Store name, Date range, Menu Category, Sales staff member

 

 

MR023. Lunch and Dinner SPH Breakdown

Spend per head breakdown per day, listing total covers, with the ability to filter by day, and order type, whether over the counter, tabs or tables.   Lunch between 5am and 17:29pm  Dinner between 17:30pm and 4:59am.

If 0 covers are assigned to the check, 0 covers are added to the total, however for each line calculation, 1 cover is assumed for Spend per head

Default Frequency: Weekly

Filters: Store name, order type, date range

 

 

MR024. Lunch and Dinner Category Rev Breakdow

Breakdown of Category by Station and time period  Lunch between 5am and 17:29pm  Dinner between 17:30pm and 4:59am.

Default Frequency: Weekly

Filters: Store name, Date range

 

 

MR025. Float in/Out Report

Sectioned by POS, a report showing denominations of cash and variance of Float Total - Cash Sale Total  (expected cash total)

Default Frequency: Weekly (from previous day)

Filters: Store name, station name, date range

 

MR026. Payment type summary

Summary of Payment types with totals for location, default for this calendar month.

Default Frequency: MTD

Filters: Store name, date range, payment method

 

 

MR027. Sales by Order Type

Sales summary by check type, showing totals for tabs, tables, member recharges, member spends and normal orders.

Default Frequency: Daily

Filters: Store name, date range, station name, menu category, menu department

 

 

 

MR029. Top 20 Selling items

Top 20 selling items default to the last calendar month, ranked by Dollar value inc GST  Master Sales View, 11/2/2016 2:55 PM

Default Frequency: Quarterly

Filters: Store name, date range, menu category

 

MR030. Category Report by staff

Category sales by Staff Member, also showing total sales over the time period. Staff members listed are the employee who originally opened the transaction, not necessarily the staff member who entered the sale.  Only checks which are paid will appear in this report.  

If a transaction is partially paid, the full value of the transaction will appear.

Default Frequency: Daily (previous day)

Filters: Store name, Pay Date range, Pay Station Name

 

 

MR031. Covers, tables and SPH by staff Child

Co Displayed with MR030

Number of covers, tables, and the SPH of all transactions, which is total sales divided by number of covers.  Staff members listed are the employee who originally opened the transaction, not necessarily the staff member who entered the sale.  Only checks which are paid will appear in this report.  

If a transaction is partially paid, the full value of the transaction will appear. 

Default Frequency: Daily (previous day)

Filters: Store name, Pay Date range, Sales station name

MR032. Order Name Report

Displays the Order name and bill total filtered by Date.

Default Frequency: Daily

Filters: Store name, date range

 

 

 

MR033. Weekly Density Report

Overview of a calendar week showing hourly performance of sales. Ability to filter by category and time.

Default Frequency: Weekly (current day and previous 6)

Filters: Store name, date range, menu category

 

 

MR034. Comparison Week by Week Report

Compares the selected week's figures to the previous week and the average of the 4 weeks preceding, day by day and highlights a negative or positive variance. All figures are Inc GST  

Default Frequency: Weekly

Filters: Order Date Range, Menu Category

 

 

MR035. Check Number Report

Shows all items on a check by check number and date.  All values are Net, and Dollar Figures are Ex GST.

Default Frequency: Daily (current day)

Filters: Store name, Order date range, Check number

 

MR036. Item Sale Journal

A check record of each time an item or modifier has been sold during a selected date range. Drill down to the listing for the entire check. All values are Net and Inc GST

Default Frequency: Daily (current day)

Filters: Store name, Order date range, Item name, Item number

 

 

MR037. Item Sales Report With COGS and Profit

Report shows Net Quantity and Net $ value EX GST for sales in a time frame, Cost per unit, profit (Sale - cost), COGS and percentage of total Profit sorted by Total Sales

Default Frequency: Weekly (previous 7 days)

Filters: Store name, top rank, order date range, menu category

 

MR038 Checks paid by Employee and tender type

Value of checks paid for by employee.

Note that if multiple payments are processed agaist the same check, multiple entries will appear in this report. Drills through to MR035. Check report.

Default Frequency: Weekly (prior 7 days)

Filters: Store name, Pay date range, payment method

 

 

MR039. Sales Breakdown By Department For the last week

A listing of sales by department and product with split by days of the week.

Default Frequency: Weekly (Previous 7 days)

Filters: Store Name, Date range

 

Was this article helpful?
0 out of 0 found this helpful