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 ...
    • 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 ...
    • 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 ...