--- title: Generating Product Mix Report (New Version) description: To generate a PMIX report, users must go to the Back Office then Reports then Product Mix Report. --- [Skip to content](https://support.mosaic-solutions.com/knowledge/generating-product-mix-report-new-version#main-content) English Show submenu for translations [Contact Customer Support](https://support.mosaic-solutions.com/knowledge/kb-tickets/new?hsLang=en) ![Mosaic Full Logo Blue (Transparent).png\]](https://support.mosaic-solutions.com/hs-fs/hubfs/Mosaic%20Full%20Logo%20Blue%20(Transparent).png?height=31&name=Mosaic%20Full%20Logo%20Blue%20(Transparent).png) - [Contact Client Support](https://support.mosaic-solutions.com/helixpaysupport/contactus) Open main navigation Close main navigation - [Contact Client Support](https://support.mosaic-solutions.com/helixpaysupport/contactus) - English Show submenu for translations - [Contact Customer Support](https://support.mosaic-solutions.com/knowledge/kb-tickets/new) - Go to mosaic-solutions.com Go to mosaic-solutions.com We are here to help. - There are no suggestions because the search field is empty. 1. [Mosaic Solutions Support and Help Center](https://support.mosaic-solutions.com/knowledge?hsLang=en) 2. [Mosaic POS](https://support.mosaic-solutions.com/knowledge/mosaic-pos?hsLang=en) 3. [Generating Reports](https://support.mosaic-solutions.com/knowledge/mosaic-pos?hsLang=en#generating-reports) # Generating Product Mix Report (New Version) ## To generate a PMIX report, users must go to the Back Office then Reports then Product Mix Report. Watch the video or follow the step-by-step guide below.     1. Open your web browser and type in admin.mosaic-pos.com and enter your account login credentials.  ![](https://support.mosaic-solutions.com/hs-fs/hubfs/image-png-Oct-04-2024-07-05-25-3711-AM.png?width=992&height=464&name=image-png-Oct-04-2024-07-05-25-3711-AM.png)   2. Once you’re logged in, click on the menu list icon on the top left part of your screen. ![](https://support.mosaic-solutions.com/hs-fs/hubfs/image-png-Oct-04-2024-07-05-26-6333-AM.png?width=1004&height=480&name=image-png-Oct-04-2024-07-05-26-6333-AM.png)   3. Select “Reports  (New)” then click on “Product Mix”. ![](https://support.mosaic-solutions.com/hs-fs/hubfs/image-png-Oct-04-2024-07-05-29-0500-AM.png?width=1016&height=484&name=image-png-Oct-04-2024-07-05-29-0500-AM.png)   4. Input the desired date range by clicking on the calendar icons on your screen. *\*\*Make sure that your date ranges start on **August 23** to generate the new version of PMIX.* ![](https://support.mosaic-solutions.com/hs-fs/hubfs/image-png-Oct-04-2024-07-05-30-3893-AM.png?width=1000&height=476&name=image-png-Oct-04-2024-07-05-30-3893-AM.png)   5. Select the Location and Terminal using the drop-down button to see available list of options. ![](https://support.mosaic-solutions.com/hs-fs/hubfs/image-png-Oct-04-2024-07-05-32-0992-AM.png?width=1004&height=476&name=image-png-Oct-04-2024-07-05-32-0992-AM.png)   6. Generate report via Excel (Green Icon) or PDF (Red Icon). ![](https://support.mosaic-solutions.com/hs-fs/hubfs/image-png-Oct-04-2024-07-05-33-9283-AM.png?width=1000&height=476&name=image-png-Oct-04-2024-07-05-33-9283-AM.png)   7. Go to your Desktop and select “File Explorer” or the “Folder Icon” and click on “Downloads”. ![](https://support.mosaic-solutions.com/hs-fs/hubfs/image-png-Oct-04-2024-07-05-37-4020-AM.png?width=996&height=484&name=image-png-Oct-04-2024-07-05-37-4020-AM.png)   8. Open your file (Excel or PDF) and you should have something that looks like this. ![](https://support.mosaic-solutions.com/hs-fs/hubfs/image-png-Oct-04-2024-07-05-38-5291-AM.png?width=1008&height=700&name=image-png-Oct-04-2024-07-05-38-5291-AM.png)   **NOTES:**           Added information: - Location Name - Product Group - Forced and Unforced Modifiers - Complimentary / Non-Revenue - Void Quantity - Item Price without VAT - Total Forced Modifier Price with VAT - Open Item - Total (Item Price x Quantity) - [Mosaic POS](https://support.mosaic-solutions.com/knowledge/mosaic-pos?hsLang=en#main-content) - [Placing Orders and Table Management](https://support.mosaic-solutions.com/knowledge/mosaic-pos?hsLang=en#placing-orders-and-table-management) - [Logging In, Shift Change, Day End](https://support.mosaic-solutions.com/knowledge/mosaic-pos?hsLang=en#logging-in-shift-change-day-end) - [Billing and Payment Processing](https://support.mosaic-solutions.com/knowledge/mosaic-pos?hsLang=en#billing-and-payment-processing) - [Getting Started with your POS](https://support.mosaic-solutions.com/knowledge/mosaic-pos?hsLang=en#getting-started-with-your-pos) - [Basic Troubleshooting](https://support.mosaic-solutions.com/knowledge/mosaic-pos?hsLang=en#basic-troubleshooting) - [Generating Reports](https://support.mosaic-solutions.com/knowledge/mosaic-pos?hsLang=en#generating-reports) - [Menu Management](https://support.mosaic-solutions.com/knowledge/mosaic-pos?hsLang=en#menu-management) - [Integrations](https://support.mosaic-solutions.com/knowledge/mosaic-pos?hsLang=en#integrations) - [Getting Started in Resto iQ](https://support.mosaic-solutions.com/knowledge/getting-started-in-resto-iq?hsLang=en#main-content) - [General Knowledge](https://support.mosaic-solutions.com/knowledge/getting-started-in-resto-iq?hsLang=en#general-knowledge) - [User Management](https://support.mosaic-solutions.com/knowledge/getting-started-in-resto-iq?hsLang=en#user-management) - [Navigation](https://support.mosaic-solutions.com/knowledge/getting-started-in-resto-iq?hsLang=en#navigation) - [Resto iQ Analytics](https://support.mosaic-solutions.com/knowledge/resto-iq-analytics?hsLang=en#main-content) - [Product Reports](https://support.mosaic-solutions.com/knowledge/resto-iq-analytics?hsLang=en#product-reports) - [Sales Reports](https://support.mosaic-solutions.com/knowledge/resto-iq-analytics?hsLang=en#sales-reports) - [General Knowledge](https://support.mosaic-solutions.com/knowledge/resto-iq-analytics?hsLang=en#general-knowledge) - [Other Reports](https://support.mosaic-solutions.com/knowledge/resto-iq-analytics?hsLang=en#other-reports) - [Resto iQ Inventory and Purchasing](https://support.mosaic-solutions.com/knowledge/resto-iq-inventory-and-purchasing?hsLang=en#main-content) - [Resto iQ Inventory - Reports](https://support.mosaic-solutions.com/knowledge/resto-iq-inventory-and-purchasing?hsLang=en#resto-iq-inventory-reports) - [Resto iQ Inventory - My Inventory](https://support.mosaic-solutions.com/knowledge/resto-iq-inventory-and-purchasing?hsLang=en#resto-iq-inventory-my-inventory) - [Resto iQ - Purchasing](https://support.mosaic-solutions.com/knowledge/resto-iq-inventory-and-purchasing?hsLang=en#resto-iq-purchasing) - [Resto iQ Inventory - My Ingredients](https://support.mosaic-solutions.com/knowledge/resto-iq-inventory-and-purchasing?hsLang=en#resto-iq-inventory-my-ingredients) - [Resto iQ Inventory - Menu Items](https://support.mosaic-solutions.com/knowledge/resto-iq-inventory-and-purchasing?hsLang=en#resto-iq-inventory-menu-items) - [Mosaic Analytics](https://support.mosaic-solutions.com/knowledge/mosaic-analytics?hsLang=en) - [Mosaic Inventory v2](https://support.mosaic-solutions.com/knowledge/mosaic-inventory-v2?hsLang=en) - [Mosaic Purchasing v2](https://support.mosaic-solutions.com/knowledge/mosaic-purchasing-v2?hsLang=en) - [Mosaic Back Office v2](https://support.mosaic-solutions.com/knowledge/mosaic-back-office-v2?hsLang=en) - [Contact Client Support](https://support.mosaic-solutions.com/helixpaysupport/contactus) [![Chill listening crop-3](https://support.mosaic-solutions.com/hs-fs/hubfs/Mosaic%20Circle%20M%20Icon%20Blue-2.png?width=24&height=24&name=Mosaic%20Circle%20M%20Icon%20Blue-2.png "Chill listening crop-3")](http://mosaic-solutions.com) Mosaic Solution Support and Help Center Copyright © 2026, Mosaic Solutions