Reporting Explained: Food Cost by COGS Department/Category

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 create and set COGS accounts

How it works: Food Cost by COGS Department/ Category reporting allows you to see the cost percentage for all COGS departments between a selected period. This information is based on starting inventory (physical inventory), inventory movement (purchasing), ending inventory (physical inventory) and net sales (point of sale).

Generating the Report: To generate this report you will need to have performed two physical inventories. For the most accurate reporting, we suggest doing weekly inventories, however bi-weekly and monthly inventories will also provide relevant and useful information.

Go to the Reports section in Yellow Dog 

  1. Select Standard Reports
  2. Open the folder titled F&B
  3. Open the folder titled Cost Reporting
  4. Select  “Food cost by COGS Category” or Food Cost by COGS Department”
  5. Select “Starting Inventory” - This will be the start of your date range.
  6. Select “Ending Inventory”- This will be the end of your date range.
  7. Select which COGS department or category you would like to run the report for.
  8. Generate Report.

Reading the Report 


1-3. Shows the filters used to produce the reports data, the example report is showing us activity for all COGS departments from 10/31/2018 thru 11/3/2018.

4. Change columns, sorting and grouping: This allows us to manipulate the view of the data within the report. Other columns available in this report:


a.Store Code: Number assigned to the store the report is being generated for.

b.Store Name: Name of store the report is being generated for.

c.Revenue Center: Point of sale from where the net sales are collected.                  

d.Department: COGS account

           e.Category: Sub COGS account *note* category may not apply to your database

5. Starting Cost: Purchase Cost of starting inventory on hand

6. Purchasing Adjustments Cost:Purchasing Adjustments Quantity x Calculated Cost as of transaction date (NOT Vendor Price) 

7. Ending Cost: Purchase Cost of Ending inventory on hand

8. Actual Usage Cost: Starting Cost + Purchasing Adjustments Cost - Actual Ending Cost

9. Net Sales: Total sales pulled from point of sale; point of sale items must be mapped properly to the correct COGS accounts for this to report accurately. For more information on POS item mapping please refer to What is POS Item Mapping?

10. Actual Cost Percentage: This is the cost percentage for your cost of goods sold,(Actual Usage divided by Net Sales).

11. Total of each column

12. This row allows you to save, export, print and close the current report.


 





    • Related Articles

    • Reporting Explained: F&B :Food Cost: Actual By Item

      Business Need: This report is helpful for users who want a report to show the cost of goods for items sold between two dates. How it Works: A F&B>Food Cost>Actual By Item report shows the actual usage cost for items sold between two dates based on a ...
    • 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 ...
    • 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 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 ...
    • 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 ...
    • Popular Articles

    • How To: Find Your Yellow Dog Inventory Version

      Understanding which version of Yellow Dog Inventory you're using is essential when exploring new features, as some enhancements and functionalities are specific to certain versions. All client types can benefit from knowing their Yellow Dog Inventory ...
    • How do I use Par & Re-Order Points?

      What is a Reorder Point? The minimum quantity you would like inventory of the item to be before ordering more. Items must go below this level to trigger reorder. Items set to 0 will not reorder until you go into negative stock. This is not ...
    • Tips & Tricks: How do I download and install drivers for my Zebra Printer?

      **As a note: Admin rights will be required to complete this task. If you do not have admin rights on your PC, please contact your IT for assistance** ZD410 Desktop Printer Support Site 1. Navigate to Drivers: 2. Select Zdesigner V. 5 Driver for ...
    • How To: Swap the On-Hand/Parent Size (Edit Base Unit)

      When managing items with multiple sizes, it’s essential to configure them correctly. The on-hand/parent size should always represent the base unit or smallest measurement, while additional sizes should be created for purchasing or counting sizes. If ...
    • Food and Beverage Core Features User Manual

      The Food & Beverage Core Functions User Manual is your key to understanding the potential of Yellow Dog. Whether you're a first-time user or a seasoned pro, this detailed manual will help you understand how to best utilize your Yellow Dog Inventory ...