COGS

This ability provides Cost of Goods Sold (COGS) reporting but doesn’t require the use of recipes. We have added new COGS accounts which you can have automatically assigned to new inventory items via level interfaces as well as manually assigned by item. Then the COGS account can be associated to the revenue generated by the POS menu items. For information on manual adjustments and COGS, please visit the Manual Adjustment section of the manual.

To begin this process, you’ll need access to the Accounting/Other section under Interfaces. If you do not have this, please contact your Implementation Guide or Support.

Creating COGS Accounts

1. Navigate to System Setup, then Accounts. The last tab under Accounts is COGS Accounts. Click on the tab.
   
2. We have set up default COGS accounts for you to use or customize to your property’s needs.
   

1. Food
   
2. Food : Protein
   
3. Food : Dairy
   
4. Food : Produce
   
5. Food : Bakery
   
6. Food : Dry Goods
   
7. Beer
   
8. Wine
   
9. Liquor
   
10. Non Food
    

     3. To create, edit, remove, or rearrange COGS accounts, use the buttons on the far right of the account list. This property wanted more specific COGS. 

       4. You’ll need to provide a Department at minimum for your account. You can also create a Category. Inventory Items can use the specific Department: Category accounts and report on both, while POS revenue can only use  the Departments.

Assigning COGS to Inventory Items

You can assign COGS to inventory items by Store, Level or Item, just as you would any other interface. And just like other interfaces, items assigned to Levels where COGS is set will inherit the level’s setting. To narrow down the interfaces shown in the tab, use the Filter to only show COGS.

You can also set them from the main Inventory Items screen. Highlight the items you wish to set to a particular account, then right click and choose “Set Interface Code”, then “COGS”.

Assigning COGS to POS Items

 To assign COGS Departments to POS Items, use POS Item Map. Navigate there and select the stores you wish to work on. For more information on how to navigate POS Item Map, go to the section on it. You may need to scroll over or adjust the columns to see COGS Department.

   There are two ways to set COGS here, by single item or multiple items at once.

1. To set item by item, select the ellipsis next to the item you wish to set COGS for. It will bring up a list of accounts; click on the one you want and hit Select.
   
2. Alternatively, use the Ctrl+Click or Shift+Click function to highlight the items you wish to set to the same account and, from the lower right hand button on the screen, click “Set COGS for … POS Items”, or right click on the highlighted item(s) and select “Set COGS…”.
   
3. To remove the COGS for an item, click the red X or “Reset COGS Account”.
   

Reporting on Cost of Goods

We have created several COGS specific reports that will allow you to view the data that has been generated around your cost of goods departments and categories.  These reports will require the user to select a starting and ending physical inventory, and all report data will be centered between those two physical inventories. For more information on COGS reporting, please see our Reports manual.