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

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
Filter Fields and Buttons

Manager

  • From Date, To Date, Terminal  [Generate]

Store Admin

  • From Date, To Date, Terminal  [Generate]

Brand

  • no values/disabled

Enterprise

  • From Date, To Date, Account, Location, Terminal  [Generate]

Super Admin

  • From Date, To Date, Account, Location, Terminal  [Generate]
Page Buttons [Download Excel] - xls and xlsx format
Date Filter Limit With day end

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.
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us