Know your Back Office Product Mix Report

Objective	This report aims to generate the Product Mix Report which consists items and modifiers sold and sales breakdown. This report only includes sales transactions.
User Access	Manager = Store Admin = can access own product mix report only Brand = no access Enterprise = can access all locations' product mix Super Admin = can access all accounts' product mix
Date Filter Limit	Should have day end data

Objective

This report aims to generate the Product Mix Report which consists items and modifiers sold and sales breakdown. This report only includes sales transactions.

User Access

Manager =

Store Admin = can access own product mix report only

Brand = no access

Enterprise = can access all locations' product mix

Super Admin = can access all accounts' product mix

Date Filter Limit

Should have day end data

Filters

Field / Button	Description	User Access
From Date	Starting POS Date	All Users
To Date	Ending POS Date	All Users
Account	Account Name	Super Admin
Location	Location Name	Enterprise, Super Admin
Terminal ID	The terminal ID of used POS device during transaction settlement	All Users
Generate	Generate the Product Mix Report	All Users

Download

File Format
xls
xlsx

View Table Values

View Table Column	Description
Location Name	Location Name
Product Group	The Product Group name where the item belongs to
SKU/Item Code	The current SKU or Item Code of the item
Item Name	The current Name of the Item
Open Item	Yes - if the item is an Open Item and created during transaction only No - if the item is created on Back Office
Forced Modifier Name	Names of forced modifiers added on the transactions
Unforced Modifier Name	Names of unforced modifiers added on the transactions
Per Price (item price w/o VAT)	Tax Exclusive Price of Item and Modifier
Total Forced Modifier Price with VAT	Tax-Inclusive Price of Forced Modifier
Item Qty	The total count of sold quantity of the item + modifier combination
Discount Qty	The total count of sold and discounted quantity of the item + modifier combination
Complimentary/Non-Revenue Qty	The total count of sold and marked as complimentary quantity of the item + modifier combination
Gross Sales	Sales before all deductions and after VAT and All Charges Inclusion: Sum of VATable Sales, VAT, VAT Exempt Sales, Zero Rated Sales, All Discounts, VAT Adjustment, Service Charge and Other Charges VAT Adjustment Computation = Displayed VAT Exempt Sales / .80 + Displayed Zero Rated Sales * 0.12
Discount Amount	The total amount of discounts
VAT Adjustment	The removed VAT from Tax-Inclusive Item and Modifier Prices. Based on 12% VAT Computation: Tax-Inclusive Item and Modifier Prices / 1.12 * 0.12
VAT	The VAT from Tax-Inclusive Item and Modifier Prices. Based on 12% VAT Computation: Tax-Inclusive Item and Modifier Prices / 1.12 * 0.12
Service Charge Amount	The total amount of Service Charge if applicable
Net Sales	Sales after all deductions and before VAT Inclusion: Sum of VATable Sales, VAT Exempt Sales and Zero Rated Sales

Future Enhancements

	Description	Target Deployment Date
Implement Handling of Different Item and Modifier Prices on Back Office Product Mix Summary Report	Fix the display of Item and Modifier Price on the Product Mix Report so that the clients get the correct and expected Net Sales (Item Price * Item Qty). Currently, only the initial prices are displayed hence Net Sales seems incorrect.