COGS Troubleshooting

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:

  1. Invoices were not entered in Yellow Dog
  2.   POS Sales are missing
  3.   Inaccurate Physical Inventory Counts
  4.   Physical Inventories were not committed
  5.   More than one Physical was performed
  6.   Waste Adjustments were not recorded

If COGS numbers are appearing incorrectly in accounting one of the following will be the cause:

  1. Invoices were not entered into accounting software
  2.   POS sales are missing 

*If there are no discrepancies in any of these areas, the issue will be with Operational Workflows, or possible shrinkage*

How to identify where inaccuracies originate:

Invoices:

  1. Keeping up with purchasing is critical to ensuring that COGS numbers remain accurate. A Three-Way Match can be used to cross check – the Yellow Dog invoice, should match the vendor invoice, and what is posted to AP. Keeping these documents together – either by stapling, or scanning – will keep auditing easy at month end
    1.    The Purchase Order to Receipt to Invoice Report can be used to quickly identify purchasing documents that have not been fully invoiced. 
Sales:
  1. Confirming sales have been processed into Yellow Dog should be done regularly. Reviewing the All Sales Captured report will show all sales that occurred at the point of sale, regardless of it the items are tied to Yellow Dog items/recipes. This report should be compared to sales reporting from your Point of Sale for confirmation that nothing was missed

Physical Inventories:

  1. Yellow Dog recommends performing one physical inventory per period – week, month, etc. COGS reporting compares last periods physical to this period – one to one. Users can have separate count sessions in one physical. Our recommendation is for each area be a count session –i.e., kitchen, liquor, wine, snack bar, etc.
    1.        Ensuring that all active items are being included in physicals will keep costs and on hand values accurate
      1.  Tips & Tricks: How to confirm all items are being included in your physical
  1. Variances should be reviewed in the Resulting on Hand report found within the Physical editor prior to committing and any items found with inaccurate counts, should be recounted 
    1.    The Physical Inventory Worksheet can easily be printed to perform recounts
      1.    Printing Physical Inventory Worksheets

Adjustments:

  1. Performing regular manual adjustments to account for waste/spoilage, prevents having to catch up at month end.
    1.   How do I create a Manual Adjustment?


Recommended Reporting:

Post Physical:

  1.  Click Here for an overview of our 3 Base approach to F&B.
  2. For customers rounding 1st & 2nd base Yellow Dog recommends the Inventory Detailed Usage by COGS account
    1. This report will allow users to see a detailed breakdown of their COGS accounts in relation to Physicals, Sales, Purchasing, and Manual adjustments
    2. For customers rounding 3rd base Yellow Dog recommends the Actual v Theoretical by Department, Category. The Actual v Theoretical report also has an option for itemized to allow for more granular comparison in as needed.
      1.  This report will allow users to see the actual cost & usage of their items, versus the theoretical cost.

Troubleshooting:

  1. Confirm COGS accounts are mapped to POS Items by using report:
    1. Standard Reports>F&B>Cost Reporting>POS Items with No COGS accounts
      1.   POS Items without a COGS account mapped, will not have sales reflected in Yellow Dog.
  1. Confirm COGs Accounts are set for all ingredient items by using report
    1.   Standard Reports>F&B>Cost Reporting>Inventory Items with No COGS Accoun
      1. Inventory items without COGS accounts assigned, will not reflect sales, manual adjustments, purchasing or physical inventories in COGS reporting.

    • Related Articles

    • 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 ...
    • Reporting Explained: Cost Reporting- Inventory Items with No COGS Account

      Business Need: This report is helpful for F&B customers using COGS for tracking inventory. It allows clients to see which inventory items are not mapped to a COGS account. This is useful for troubleshooting variances in COGS cost reporting and ...
    • 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 ...
    • Reporting Explained: Cost Reporting- COGS Detail

      Business Need: This report is helpful for F&B customers using COGS for tracking inventory. It allows clients to see a detailed breakdown of their COGS accounts in relation to sales, purchasing, physical inventories, and manual adjustments.  How it ...
    • Reporting Explained: Cost Reporting- Inventory Detailed Usage by COGS Account

      Business Need: This report is helpful for F&B customers using COGS for tracking inventory. It allows clients to see a detailed breakdown of their COGS accounts in relation to sales, purchasing, physical inventories, and manual adjustments.  How it ...
    • Recent Articles

    • How To: Import Interfaces by Level using Balto

      This document will review how to import interface settings for a level using the Balto import tool. Prerequisites Items are required to exist in YD already Items cannot be marked as removed. The stores must also exist in YD Yellow Dog user with ...
    • How To: Update Par & Re-Order Points via the Balto Import Tool

      This document will review how to update Par & Re-Order Points via the Balto import tool With all Balto imports, be sure not to change any of the column headers in the template. Unused columns can be removed, but the headers should not be edited in ...
    • How To: Update Items Store Availability via the Balto Import Tool

      This article will review how to update items store availability with the Balto Import Tool With all Balto imports, be sure not to change any of the column headers in the template. Unused columns can be removed, but the headers should not be edited in ...
    • Yellow Dog/Jonas File Exchange Overview

      This document will provide an overview of the Yellow Dog Jonas File Exchange Integration Integration Approach This is a 2Way integration – pull sales and push items • Sales – pulled from a file • Items – pushed to .csv file • Codes – Inserted into ...
    • Yellow Dog/Jonas API Overview

      This document will provide an overview of the Yellow Dog Jonas API Integration Integration Approach This can be set up as a 2Way – Items are pulled from us, and sales are pushed or 1Way sales are pushed. NOTE: Jonas controls the flow of sales and ...