---
title: "Manage QuickBooks Item Mapping"
slug: "manage-quickbooks-item-mapping"
description: "Map R365 purchased items and recipes to QBO external cost and inventory accounts."
updated: 2025-08-25T22:00:30Z
published: 2025-08-25T22:00:30Z
canonical: "docs.restaurant365.com/manage-quickbooks-item-mapping"
---

> ## 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.

# Manage QuickBooks Item Mapping

The [QuickBooks Online (QBO) integration](/doc/docs/quickbooks-online-integration) and requires users to manage item mapping within the QuickBooks Integration screen.

From the [Items tab](/doc/docs/quickbooks-mapping-screen), Users can map R365 Purchased Items and Recipes to External Cost and Inventory Accounts. This is used for transmitting Journal Entries for Waste Logs and Item Transfers. Item management can be performed individually or in bulk from the items tab of the [QuickBooks mapping screen](/doc/docs/quickbooks-mapping-screen).

---

## Map R365 Items Individually

To map or edit item mapping, follow these steps:

*Click steps to expand for additional information and images.*

****1)** Navigate to the [**Integrations page**](/doc/docs/integrations-menu).**

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-2GRI7GYM.png?sv=2026-02-06&spr=https&st=2026-10-27T17%3A47%3A39Z&se=2026-10-27T18%3A47%3A39Z&sr=c&sp=r&sig=x66%2FcInM5PyjfGnCkJ%2BqLEVvx3m7Y7AhYE7WxhUcJXM%3D)

****2)** Expand the **Banking category**.**

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-VXM8GTFJ.png?sv=2026-02-06&spr=https&st=2026-10-27T17%3A47%3A39Z&se=2026-10-27T18%3A47%3A39Z&sr=c&sp=r&sig=x66%2FcInM5PyjfGnCkJ%2BqLEVvx3m7Y7AhYE7WxhUcJXM%3D)

****3)** Click the **QuickBooks card.****

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-DPVRL0WF.png?sv=2026-02-06&spr=https&st=2026-10-27T17%3A47%3A39Z&se=2026-10-27T18%3A47%3A39Z&sr=c&sp=r&sig=x66%2FcInM5PyjfGnCkJ%2BqLEVvx3m7Y7AhYE7WxhUcJXM%3D)

****4)** Click **edit mapping.****

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-1T27DS3Z.png?sv=2026-02-06&spr=https&st=2026-10-27T17%3A47%3A39Z&se=2026-10-27T18%3A47%3A39Z&sr=c&sp=r&sig=x66%2FcInM5PyjfGnCkJ%2BqLEVvx3m7Y7AhYE7WxhUcJXM%3D)

****5)** Click the **items tab.****

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-56OGC6M6.png?sv=2026-02-06&spr=https&st=2026-10-27T17%3A47%3A39Z&se=2026-10-27T18%3A47%3A39Z&sr=c&sp=r&sig=x66%2FcInM5PyjfGnCkJ%2BqLEVvx3m7Y7AhYE7WxhUcJXM%3D)

****6) Expand** to **full screen** to view all columns. *(Optional)***

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-LBD3OSPX.png?sv=2026-02-06&spr=https&st=2026-10-27T17%3A47%3A39Z&se=2026-10-27T18%3A47%3A39Z&sr=c&sp=r&sig=x66%2FcInM5PyjfGnCkJ%2BqLEVvx3m7Y7AhYE7WxhUcJXM%3D)

****7)** Click the select **R365 GL account dropdown** in the Item Cost Account column.**

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-VGNH3OZO.png?sv=2026-02-06&spr=https&st=2026-10-27T17%3A47%3A39Z&se=2026-10-27T18%3A47%3A39Z&sr=c&sp=r&sig=x66%2FcInM5PyjfGnCkJ%2BqLEVvx3m7Y7AhYE7WxhUcJXM%3D)

****8)** Select the desired **R365 GL Account** for the item costing.**

Users can scroll or begin typing in the search bar to locate the desired account.

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-CU3GURE2.png?sv=2026-02-06&spr=https&st=2026-10-27T17%3A47%3A39Z&se=2026-10-27T18%3A47%3A39Z&sr=c&sp=r&sig=x66%2FcInM5PyjfGnCkJ%2BqLEVvx3m7Y7AhYE7WxhUcJXM%3D)

****9)** Click the select **R365 GL Account dropdown** in the Item Inventory column.**

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-3VKG1Y24.png?sv=2026-02-06&spr=https&st=2026-10-27T17%3A47%3A39Z&se=2026-10-27T18%3A47%3A39Z&sr=c&sp=r&sig=x66%2FcInM5PyjfGnCkJ%2BqLEVvx3m7Y7AhYE7WxhUcJXM%3D)

****10)** Select the desired **R365 GL Account** for the item inventory.**

> [!NOTE]
> Users can scroll or type in the search bar to locate the desired account.

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-MSL5T2C3.png?sv=2026-02-06&spr=https&st=2026-10-27T17%3A47%3A39Z&se=2026-10-27T18%3A47%3A39Z&sr=c&sp=r&sig=x66%2FcInM5PyjfGnCkJ%2BqLEVvx3m7Y7AhYE7WxhUcJXM%3D)

****11)** Click **save** in the top ribbon.**

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-NP9N7GK9.png?sv=2026-02-06&spr=https&st=2026-10-27T17%3A47%3A39Z&se=2026-10-27T18%3A47%3A39Z&sr=c&sp=r&sig=x66%2FcInM5PyjfGnCkJ%2BqLEVvx3m7Y7AhYE7WxhUcJXM%3D)

---

## Map R365 Items in Bulk

To map or edit item mapping in bulk, follow these steps:

*Click steps to expand for additional information and images.*

****1)** Navigate to the [**Integrations page**](/doc/docs/integrations-menu).**

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-2GRI7GYM.png?sv=2026-02-06&spr=https&st=2026-10-27T17%3A47%3A39Z&se=2026-10-27T18%3A47%3A39Z&sr=c&sp=r&sig=x66%2FcInM5PyjfGnCkJ%2BqLEVvx3m7Y7AhYE7WxhUcJXM%3D)

****2)** Expand the **Banking category**.**

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-VXM8GTFJ.png?sv=2026-02-06&spr=https&st=2026-10-27T17%3A47%3A39Z&se=2026-10-27T18%3A47%3A39Z&sr=c&sp=r&sig=x66%2FcInM5PyjfGnCkJ%2BqLEVvx3m7Y7AhYE7WxhUcJXM%3D)

****3)** Click the **QuickBooks card.****

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-DPVRL0WF.png?sv=2026-02-06&spr=https&st=2026-10-27T17%3A47%3A39Z&se=2026-10-27T18%3A47%3A39Z&sr=c&sp=r&sig=x66%2FcInM5PyjfGnCkJ%2BqLEVvx3m7Y7AhYE7WxhUcJXM%3D)

****4)** Click **edit mapping.****

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-1T27DS3Z.png?sv=2026-02-06&spr=https&st=2026-10-27T17%3A47%3A39Z&se=2026-10-27T18%3A47%3A39Z&sr=c&sp=r&sig=x66%2FcInM5PyjfGnCkJ%2BqLEVvx3m7Y7AhYE7WxhUcJXM%3D)

****5)** Click the **items tab.****

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-HTG3YZR9.png?sv=2026-02-06&spr=https&st=2026-10-27T17%3A47%3A39Z&se=2026-10-27T18%3A47%3A39Z&sr=c&sp=r&sig=x66%2FcInM5PyjfGnCkJ%2BqLEVvx3m7Y7AhYE7WxhUcJXM%3D)

****6) Expand** to **full screen** to view all columns. *(Optional)***

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-LBD3OSPX.png?sv=2026-02-06&spr=https&st=2026-10-27T17%3A47%3A39Z&se=2026-10-27T18%3A47%3A39Z&sr=c&sp=r&sig=x66%2FcInM5PyjfGnCkJ%2BqLEVvx3m7Y7AhYE7WxhUcJXM%3D)

****7)** Click the **checkbox** next to the desired items. *(Select all items that will be mapped to the same cost and inventory accounts.)***

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-5SKWR4T1.png?sv=2026-02-06&spr=https&st=2026-10-27T17%3A47%3A39Z&se=2026-10-27T18%3A47%3A39Z&sr=c&sp=r&sig=x66%2FcInM5PyjfGnCkJ%2BqLEVvx3m7Y7AhYE7WxhUcJXM%3D)

****8)** Click **edit R365 GL accounts** in the bottom right corner.**

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-0AB6LZJ1.png?sv=2026-02-06&spr=https&st=2026-10-27T17%3A47%3A39Z&se=2026-10-27T18%3A47%3A39Z&sr=c&sp=r&sig=x66%2FcInM5PyjfGnCkJ%2BqLEVvx3m7Y7AhYE7WxhUcJXM%3D)

****9)** Use the **dropdown** selector to select the **item cost account**.**

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-P5ZQA8N1.png?sv=2026-02-06&spr=https&st=2026-10-27T17%3A47%3A39Z&se=2026-10-27T18%3A47%3A39Z&sr=c&sp=r&sig=x66%2FcInM5PyjfGnCkJ%2BqLEVvx3m7Y7AhYE7WxhUcJXM%3D)

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-YVFZG2TK.png?sv=2026-02-06&spr=https&st=2026-10-27T17%3A47%3A39Z&se=2026-10-27T18%3A47%3A39Z&sr=c&sp=r&sig=x66%2FcInM5PyjfGnCkJ%2BqLEVvx3m7Y7AhYE7WxhUcJXM%3D)

****10)** Use the **dropdown** selector to select the i**tem inventory account**.**

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-9Z4IKT5Y.png?sv=2026-02-06&spr=https&st=2026-10-27T17%3A47%3A39Z&se=2026-10-27T18%3A47%3A39Z&sr=c&sp=r&sig=x66%2FcInM5PyjfGnCkJ%2BqLEVvx3m7Y7AhYE7WxhUcJXM%3D)

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-QN5KGQC3.png?sv=2026-02-06&spr=https&st=2026-10-27T17%3A47%3A39Z&se=2026-10-27T18%3A47%3A39Z&sr=c&sp=r&sig=x66%2FcInM5PyjfGnCkJ%2BqLEVvx3m7Y7AhYE7WxhUcJXM%3D)

****11)** Click **update items.****

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-8T4RJKCR.png?sv=2026-02-06&spr=https&st=2026-10-27T17%3A47%3A39Z&se=2026-10-27T18%3A47%3A39Z&sr=c&sp=r&sig=x66%2FcInM5PyjfGnCkJ%2BqLEVvx3m7Y7AhYE7WxhUcJXM%3D)

****12)** Click **save** in the top ribbon.**

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-BFK6JT31.png?sv=2026-02-06&spr=https&st=2026-10-27T17%3A47%3A39Z&se=2026-10-27T18%3A47%3A39Z&sr=c&sp=r&sig=x66%2FcInM5PyjfGnCkJ%2BqLEVvx3m7Y7AhYE7WxhUcJXM%3D)

Restaurant365

Financial account used to record specific transactions in the general ledger.