How do I create and set COGS accounts?

How do I create and set COGS accounts?


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.


    • Related Articles

    • COGS Troubleshooting

      This document was designed to help users pinpoint where and why there are discrepancies in their COGS reporting.  Why COGS are inaccurate: If COGS numbers are appearing incorrectly in Yellow Dog one of the following will be the cause: Invoices were ...
    • How do I create an Invoice?

      This video will demonstrate how to create an Invoice Invoice Records Invoices are usually received after or accompanying your products’ delivery. Invoices will contain your freight, handling, discounts, etc.   Convert a Receipt or Purchase Order into ...
    • How do I create Matrices?

      This video will demonstrate how to create matrix items Matrices Matrices are a great tool to use for a lot of apparel retail environments. Rather than manually creating each piece in every size/color combination, matrices allow you to create multiple ...
    • Reporting Explained: Food Cost by COGS Department/Category

      Business Need: This report is helpful for F&B customers using COGS for tracking inventory. It allows clients to see their cost of goods sold percentage to better manage purchasing habits. For more information on setting up COGS please see How to ...
    • How do I create an item if I am a retail customer?

      Creating a new item for Retail: Once logged into Yellow Dog navigate to Create New Item Select the Level and Vendor for the item you are creating, and the SKU will be automatically generated.(If the level or vendor do not exist already choose the ...
    • Recent Articles

    • Yellow Dog/Spot On(Appetize) Integration Overview

      The document will provide an overview of the Yellow Dog Spot On(Appetize) integration Integration Approach The integration between Yellow Dog and Spot On (Appetize) can be configured to be a 1Way (sales pull only) or 2Way (sales pull and item push) ...
    • Yellow Dog/InfoGenesis Integration Overview

      The document will provide an overview of the Yellow Dog InfoGenesis Integration Integration Approach This integration can be setup as a 1Way (Sales Pull Only) or a 2Way (Pull Sales & Push Items) Sales – pulled in from a .txt file provided by ...
    • Yellow Dog/Shopify Integration Overview

      This document will provide an overview of the Yellow Dog Shopify Integration Integration Approach This integration can be set up in 4 primary ways: 1Way - pull sales only 2Way – pull sales and push on hands 2Way – pull sales and push items and on ...
    • Yellow Dog/Simpony2 w/Oracle Integration Overview

      This document will provide an overview of the Yellow Dog /Simphony 2Way integration Integration Approach The Yellow Dog/Simphony integration is a 2Way integration Sales – pulled in from files provided by Oracle once per day Codes – pulled from the ...
    • Yellow Dog/NCR Silver Integration Overview

      This document will provide an overview of the Yellow Dog/NCR Silver integration Integration Overview The Yellow Dog/NCR Silver integration is a 2Way integration Sales – Pulled from the NCR API Codes For reporting codes are pulled from the NCR API For ...