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

    • Feature Overview: Client ID

      What is a Client ID? The Client ID is a unique identifier assigned to each Yellow Dog Inventory system. Who is it for? The Client ID will be used by any user that will access a Yellow Dog mobile or web app. What is it used for? A Client ID is ...

    • Feature Overview: Password Recovery

      What is Password Recovery? Password Recovery is a built-in feature that allows Yellow Dog users to securely reset their login credentials independently by answering predefined security questions. This self-service option reduces the need for ...

    • 377 Food & Beverage Webinar

      Curious about Yellow Dog Inventory version 377? New features, smarter workflows—watch the 377 Webinar now! Want to join the live webinar? We're hosting the 377 Food & Beverage Webinar weekly. Click HERE to sign up.

    • Feature Overview: Retail Price Fields

      Yellow Dog offers 3 different retail price fields (Default Retail, Current Retail, Starting Retail) in the item editor to provide different retail price tracking functions. Where: Item Editor > Retail Details tab Who: Retail users who manage retail ...

    • Yellow Dog/Silverware Integration Overview

      This document will provide an overview of the Yellow Dog Silverware Integration Integration Approach This can be setup as a 2Way – Push items and Pull sales or a 1Way – Pull sales Sales – Pulled from the Silverware API Codes – Pulled from the ...