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

    • Send Saved Report Emailing

      You can configure saved reports to be automatically emailed to you and/or team members on a set schedule. How do I schedule daily email reporting? You can configure saved reports to be automatically emailed to you and/or team members on a set ...
    • Purchasing Flow for Food and Beverage

      The Yellow Dog Inventory purchasing flow ensures that all aspects of inventory management, from restocking to adjusting errors in transfers, are covered systematically. Each document type in the flow serves specific functions that collectively ...
    • Updating Count XL Application

      You may need to update your Count XL application on your handheld device to ensure it runs properly and smoothly. If you have received the following errors, your Count XL application may need to be updated: • “Invalid network error” • “API error” • ...
    • Removing Items with On-Hand Quantity (Decimal)

      You might encounter difficulty removing specific inventory items due to an error indicating that the item cannot be removed since its on-hand quantity is not zero, possibly because the decimal point is not properly adjusted. Changing the Decimal ...
    • ZD411 Printer Troubleshooting

      Labels Skipping When Printing When you are not able to print labels or labels are skipped when printing you will need to adjust the sensor inside the printer. If your labels are skipping when printing, make sure you have adjusted your sensor. To do ...