Category Mappings

Configure GL account mappings for inventory categories

Sync Categories from Inventory System

25 categories defined in Inventory System. Syncing will import category names so you can map them to GL accounts. Categories without mappings will appear as "unmapped".

Category	Asset Account	COGS Account	Waste Account	Status
Beer Beer Inventory	0 Unknown	0 Unknown	-	Inactive
Beer - Bottled Bottled Beer Inventory	1451 Bottled Beer Inventory	5151 Bottled Beer Cost	7182 Waste Expense - Alcohol	Active
Beer - Draft Draft Beer Inventory	1452 Draft Beer Inventory	5152 Draft Beer Cost	7182 Waste Expense - Alcohol	Active
Cleaning & Chemical Cleaning Supplies	7120 Kitchen Supplies	7120 Kitchen Supplies	7185 Unknown	Active
Food Food Inventory	0 Unknown	0 Unknown	-	Inactive
Food - Bakery Food - Bakery Inventory	1420 Bakery Inventory	5120 Bakery Cost	7184 Waste Expense - Food	Active
Food - Beef Beef Inventory	1417 Beef Inventory	5117 Beef Cost	7184 Waste Expense - Food	Active
Food - Dairy Dairy Inventory	1410 Dairy Inventory	5110 Dairy Cost	7184 Waste Expense - Food	Active
Food - Grocery Food - Grocery Inventory	1411 Grocery Inventory	5111 Grocery Cost	7184 Waste Expense - Food	Active
Food - Pork pork Inventory	1416 Pork Inventory	5116 Pork Cost	7184 Waste Expense - Food	Active
Food - Poultry Poultry Inventory	1418 Poultry Inventory	5118 Poultry Cost	7184 Waste Expense - Food	Active
Food - Produce Produce Inventory	1405 Produce Inventory	5105 Produce Cost	7184 Waste Expense - Food	Active
Food - Seafood Seafood Inventory	1419 Seafood Inventory	5119 Seafood Cost	7184 Waste Expense - Food	Active
Liquor Liquor Inventory	0 Unknown	0 Unknown	-	Inactive
Liquor - Bourbon/Whiskey/Scotch Liquor - Bourbon/Whiskey/Scotch Inventory	1445 Liquor Inventory	5145 Liquor Cost	7182 Waste Expense - Alcohol	Active
Liquor - Cordials Liquor - Cordials Inventory	1445 Liquor Inventory	5145 Liquor Cost	7182 Waste Expense - Alcohol	Active
Liquor - Gin Liquor - Gin Inventory	1445 Liquor Inventory	5145 Liquor Cost	7182 Waste Expense - Alcohol	Active
Liquor - RTB/Seltzers Liquor - RTB/Seltzers Inventory	1445 Liquor Inventory	5145 Liquor Cost	7182 Waste Expense - Alcohol	Active
Liquor - Rum Liquor - Rum Inventory	1445 Liquor Inventory	5145 Liquor Cost	7182 Waste Expense - Alcohol	Active
Liquor - Tequila Liquor - Tequila Inventory	1445 Liquor Inventory	5145 Liquor Cost	7182 Waste Expense - Alcohol	Active
Liquor - Vodka Liquor - Vodka Inventory	1445 Liquor Inventory	5145 Liquor Cost	7182 Waste Expense - Alcohol	Active
Merchandise Merchandise Inventory	0 Unknown	0 Unknown	-	Inactive
NAB NAB Inventory	1430 N/A Bev Inventory	5130 N/A Bev Cost	7181 Waste Expense - Beverage	Active
Paper Products Paper Products Inventory	1460 Paper Products Inventory	7180 Paper & Disposables	7185 Unknown	Active
Supplies - Linen Linen and Linen Rental	7165 Unknown	7165 Unknown	7185 Unknown	Active
Uncategorized Miscellaneous Expense	7175 Unknown	7175 Unknown	7185 Unknown	Active
Wine Wine Inventory	1455 Wine Inventory	5155 Wine Cost	7182 Waste Expense - Alcohol	Active

GL Account Reference

Asset Accounts (1400-1499)

1405 - Produce Inventory
1410 - Dairy Inventory
1417 - Beef Inventory
1418 - Poultry Inventory
1420 - Seafood Inventory
1422 - Pork Inventory
1450 - Beer Inventory
1455 - Wine Inventory
1460 - Liquor Inventory

COGS Accounts (5100-5199)

5105 - Produce Cost
5110 - Dairy Cost
5117 - Beef Cost
5118 - Poultry Cost
5120 - Seafood Cost
5122 - Pork Cost
5150 - Beer Cost
5155 - Wine Cost
5160 - Liquor Cost

Waste Expense Accounts (7180-7184)

7180 - Paper/Disposable
7181 - Waste Expense - Beverage
7182 - Waste Expense - Alcohol
7183 - Waste Expense - Merchandise
7184 - Waste Expense - Food

Category Code * Select the inventory category to map (sync from Inventory to see all categories)

Asset Account Name Optional display name for the asset account

Asset Account *

Asset accounts (1400-1499)

COGS Account *

COGS accounts (5100-5199)

Waste Account

Waste expense accounts (7180-7184)

Category Mappings

Asset Accounts (1400-1499)

COGS Accounts (5100-5199)

Waste Expense Accounts (7180-7184)

Add Category Mapping

Confirm Action