--- title: How to Sort Purchase Orders by Supplier description: To sort POs by supplier, it is required to download the file and open it using Microsoft Excel. --- [Skip to content](https://support.mosaic-solutions.com/knowledge/how-to-sort-purchase-orders-by-supplier#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. [Resto iQ Inventory and Purchasing](https://support.mosaic-solutions.com/knowledge/resto-iq-inventory-and-purchasing?hsLang=en) 3. [Resto iQ - Purchasing](https://support.mosaic-solutions.com/knowledge/resto-iq-inventory-and-purchasing?hsLang=en#resto-iq-purchasing) # How to Sort Purchase Orders by Supplier ## To sort POs by supplier, it is required to download the file and open it using Microsoft Excel. This article provides a step-by-step guide on how to sort Purchase Orders by Supplier. 1. Click Purchasing (dropdown icon) ![](https://support.mosaic-solutions.com/hs-fs/hubfs/image-png-Oct-14-2024-03-16-14-1912-AM.png?width=1120&height=628&name=image-png-Oct-14-2024-03-16-14-1912-AM.png)     2. Select Purchase Orders ![](https://support.mosaic-solutions.com/hs-fs/hubfs/image-png-Oct-14-2024-03-16-16-2395-AM.png?width=1120&height=628&name=image-png-Oct-14-2024-03-16-16-2395-AM.png)     3. Click "Export" ![](https://support.mosaic-solutions.com/hs-fs/hubfs/image-png-Oct-14-2024-03-16-18-2384-AM.png?width=1120&height=628&name=image-png-Oct-14-2024-03-16-18-2384-AM.png)     4. Then open the downloaded file (.xls) using Microsoft Excel. ![](https://support.mosaic-solutions.com/hs-fs/hubfs/image-png-Oct-14-2024-03-16-19-7023-AM.png?width=1120&height=628&name=image-png-Oct-14-2024-03-16-19-7023-AM.png)     5. Press \[Cmd\] + \[a\] for MacOS or \[Ctrl\] + \[a\] for Windows 6. Press \[Cmd\] + \[t\] for MacOS or \[Ctrl\] + \[t\] for Windows 7. Create a table using the data provided. ![](https://support.mosaic-solutions.com/hs-fs/hubfs/image-png-Oct-14-2024-03-16-22-0876-AM.png?width=1120&height=628&name=image-png-Oct-14-2024-03-16-22-0876-AM.png)     8. Click the dropdown arrow beside any of the table headers to sort accordingly. In this example we will select **"Supplier"**. ![](https://support.mosaic-solutions.com/hs-fs/hubfs/image-png-Oct-14-2024-03-16-23-7418-AM.png?width=1120&height=628&name=image-png-Oct-14-2024-03-16-23-7418-AM.png)     9. You may "Select All" if you wish to see all Suppliers listed. ![](https://support.mosaic-solutions.com/hs-fs/hubfs/image-png-Oct-14-2024-03-16-25-6711-AM.png?width=1120&height=628&name=image-png-Oct-14-2024-03-16-25-6711-AM.png)     10. Alternatively, you can choose any listed Supplier to restrict the display on the table. As we are merely sorting, this action will not remove the information/rows; rather, Excel will simply conceal the details. ![](https://support.mosaic-solutions.com/hs-fs/hubfs/image-png-Oct-14-2024-03-16-28-1364-AM.png?width=1120&height=628&name=image-png-Oct-14-2024-03-16-28-1364-AM.png) - [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