--- title: "Mapping Recipes to Menu Items" slug: "mapping-recipes-to-menu-items" description: "Link recipes to POS menu items for theoretical cost and depletion tracking using the Menu Item Mapping navigation." updated: 2026-01-22T05:50:02Z published: 2026-01-22T05:50:02Z canonical: "docs.restaurant365.com/mapping-recipes-to-menu-items" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.restaurant365.com/llms.txt > Use this file to discover all available pages before exploring further. # Mapping Recipes to Menu Items ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/cdb76e8c-be0e-4fa2-829f-9dc37bb0d745.png) The true value in [Recipe Costing](/doc/docs/recipe-costing) lies in mapping recipes to POS [menu items](/doc/docs/menu-items-menu-item-links). This allows R365 to automatically track theoretical usage over time and helps users learn about their inventory. To begin, ensure that the following have occurred: 1. Inventory has been properly created through the [Item Costing Outline](/doc/docs/item-costing) 2. Recipes have been properly created through the [Recipe Costing Outline](/doc/docs/recipe-costing) 3. A successful [POS Integration](/doc/docs/pos-integration-overview) with [Menu Items](/doc/docs/menu-items-menu-item-links) appearing in the Menu Items list 4. [Menu Items](/doc/docs/menu-items-menu-item-links) list has been reviewed, and [menu item links have been updated](/doc/docs/menu-items-menu-item-links#review-menu-item-links) as necessary (this may not be relevant to every organization). Once all prerequisites have been completed, the Menu Item Mapping process is ready to begin. --- ## Navigation The menu item list is found on the menu item page. This page will list all the menu items that have been created in R365 from the POS integration. ****Navigation Steps**** 1. Open the **Sales & Forecasting** application. 2. Expand **Menu Items.** 3. Select **Menu Items**. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-3NUIAO3T.png) ****Search**** Navigate to pages with the [R365 global search bar](/doc/docs/r365-search): 1. Enter all or part of the **page name** in the R365 global search bar. 2. Select the page from the results list. > Only enabled pages can be searched for. If the desired page is not enabled, contact your CSM for assistance. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-1745007955784.png) --- ## Unmapped Menu Items When a menu item is unmapped, the field in the Recipe column will be blank. Each blank record will need to be mapped to a corresponding recipe in order to track that menu item’s theoretical usage. > Unmapped menu items cannot have their theoretical usage analyzed, but can be analyzed on the [Menu Item Analysis](/doc/docs/menu-item-analysis) and [Menu Price Analysis](/doc/docs/menu-price-analysis) reports found in the Sales tab of [My Reports](/doc/docs/my-reports-overview). ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-EXBY8VK3.png) Once a recipe has been Mapped to a Menu Item, the linked Recipe will be listed in the recipe column in the list, as shown below: ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-10F6GVE3.png) --- ## Menu Item Mapping Methods Menu items can be updated using multiple methods. The method used may be determined by the number of menu items that need to be mapped. Menu items can be updated manually or via import. ### Manually To manually map a menu item to recipe, follow these steps: *Click steps to expand for additional information and images.* **1) Locate and **click to open the menu item record** that needs to be mapped to a recipe.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-7K4DSZ31.png) **2) On the Rules’ **Recipe Selection** section, click the **Recipe** field.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-SU6J2QOY.png) **3) Enter the recipe name or scroll the dropdown to **search for the recipe** that will be mapped to this menu item. Then, **select the recipe.**** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-A8RGDYDP.png) **4) Update the **Name** field, if necessary.** The Name field is found on the **Settings** section of the updated menu item record. > This is the name that will be used to reference this menu item on all menu item-related report. It will also appear on the corresponding [Menu Item Link](/doc/docs/menu-items-menu-item-links) that ties this menu item record to the POS system that generated it. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-U23V91XB.png) **5) If the menu item is an **entree** item, toggle **On** the Entree switch. If not, leave this off.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-P5A7DJP1.png) **6) Update the **Margin %, Cost, and Price Values** as needed.** These will be useful for reporting and comparisons. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-SS3UWPSI.png) **7) Assign [menu item categories](/doc/docs/menu-item-categories) to the menu item.** > Menu item categories must first be created. > > This is an important step that should not be skipped. [Menu item categories](/doc/docs/menu-item-categories) are required for some of the inventory related reports in [My Reports](/doc/docs/my-reports-overview). ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-F6DL8958.png) **8) **Save** the record.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-1KPP3EMV.png) Repeat these steps until all necessary menu items have been linked. ### Via the Import Tool To update the menu items via the import tool, follow these steps: *Click steps to expand for additional information and images.* **1) Navigate to the **Menu Items page**, and **export the menu item list** by clicking the Export button.** On the updated table, this is done by clicking the Export button in the table action menu. In the classic view of the table, click the Excel export button in the top right corner of the table. > [!TIP] > R365 Best Practice > > To avoid exporting all menu items, including those that are already linked, sort the table to only show menu items without a linked recipe. Then, export the filtered list. **New Table View** 1. Open the **Sales & Forecasting** app. 2. Expand **Menu Items**. 3. Click **Menu Items**. 4. Open the **menu**. 5. Click **Export**. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-S51361HU.png) **Classic Table View** 1. Open the **Sales & Forecasting** app. 2. Expand **Menu Items.** 3. Click **Menu Items.** 4. Click the **export** button. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-PDS5N4CA.png) **2) Navigate to the **Recipes** page, and **export the list** by clicking the Export button.** On the updated table, this is done by clicking the Export button in the table action menu. In the classic view of the table, click the Excel export button in the top right corner of the table. **New Recipe Table View** 1. Open the **Inventory** app. 2. Expand **Recipes.** 3. Click **Recipes**. 4. Open the **menu**. 5. Click **Export**. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-MBCCO99C.png) **Classic Table View** 1. Open the **Inventory** app. 2. Expand **Recipes.** 3. Click **Recipes**. 4. Click the **Export button**. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-M00XFHO4.png) Users must have the necessary recipe permissions to view and manage the recipes list. **3) Open both **exported files**.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-8FJH3JKA.png) ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-UCTNVVAH.png) **4) Copy the recipe **Name** value from the recipe export file and paste it into the **Recipe** cell of the **corresponding Menu Item** on the menu item export file.** Repeat this step until all menu items have a recipe added. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-GASE5KSX.png) > Users can elect to type in the recipe name into each cell. However, R365 recommends using copy and paste so that all recipe names are exact and accurate. **5) Fill out any additional columns on the menu export like the menu item categories, entree, estimated cost, target profit %, etc.** If these are left blank, they can be edited later in the menu item record. > The menu item categories list can also be exported so that menu item category names can be copied and pasted for accuracy. > > > > If any of the columns are **not** present, such as EstimatedCost, or EstimatedPrice, add those columns to the spreadsheet template as needed. In the import, these columns will eventually need to be mapped to the corresponding record rows. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-6APNXNPP.png) **6) Review the data, and **save** the updated menu item list.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-GRBIRB3Z.png) **7) In R365, navigate to the **import tool.**** 1. Open the **Admin** application. 2. Expand **Import**. 3. Select **Import**. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-YZRISDPW.png) **8) Perform an **Update Existing** import and upload the updated menu item list saved in step 6.** 1. In Options, select **Menu Item.** 2. In Type, select **Update Existing.** 3. Click **Next**, and follow the instructions for completing the import. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-NTN1S8F0.png) Once imported, the recipes will be mapped to the menu item they were tied to,