Reporting Explained: Cost Reporting- COGS Detail

Reporting Explained: Cost Reporting- COGS Detail

 

The COGS Reporting report helps food and beverage (F&B) customers track inventory costs. It provides a detailed breakdown of Cost of Goods Sold (COGS) accounts and shows how costs relate to:

  • Sales

  • Purchases

  • Physical inventories

  • Manual adjustments

Use this report to verify that purchasing, sales, and inventory adjustments are recorded correctly.

 
Standard Reports > F&B > Food Cost > COGS Reporting
 
 

The COGS Detail report shows the total cost for all COGS departments within a selected date range.

Yellow Dog gathers this data from all areas that affect inventory. The report groups totals based on how inventory was added, transferred, sold, or adjusted.

For accurate results, verify the following before running the report:

  • All purchasing documents in the selected date range are received, transferred, or returned as appropriate.

  • Sales data matches your point-of-sale records.

  • Physical inventories are committed so their adjustments appear in the report.

If you see unexpected variances, review these areas for missing or incorrect transactions.

 
 
  1. Go to Reports > Standard Reports.
  2. Select F&B > Food Cost > COGS Reporting.
  3. Enter a date range and apply filters as needed:
    1. Store(s)
    2. COGS accounts
    3. Include or exclude items with No Activity
    4. Include or exclude No Count items
  4. Click Generate.

Column

Description

COGS

The COGS account assigned to the item.

Received Cost

Cost of items received on invoices within the selected date range.

Transfer Accepted Cost

Cost of items accepted through transfers during the date range.

Transfer Issues Cost

Cost of items issued through transfers during the date range.

Manual Adjustments Cost

Cost associated with manual inventory adjustments.

Physical Inventory Cost

Cost adjustments resulting from physical inventory counts.

Sales Cost

Cost of items associated with sales.

Returns Cost

Cost of items returned to vendors.


    • Related Articles

    • Reporting Explained: Cost Reporting- Inventory Detailed Usage by COGS Account

      The Usage Cost report shows the cost of inventory usage during a selected period. It includes detailed costs related to: Manual adjustments Invoices (received items) Returns to vendors Issued and accepted transfers Use this report to understand how ...

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

    • Reporting Explained: Food Cost by COGS Department/Category

      The Food Cost by COGS Department report shows food cost summarized by COGS department. Use this report to compare inventory costs with sales revenue and monitor food cost performance by department. Reports > Standard Reports > F&B > Food Cost > COGS ...

    • Reporting Explained: ReOrder

      Reporting Explained: Re-Order Business Need: This report will show items that are either at or below the re-order point assigned, and include the quantities needed to bring the items back up to Par. How it works: To best utilize this report users ...

    • Reporting Explained: Summary By Period

      The Inventory Summary by Period report provides an overview of inventory activity for a selected date and time range. It shows the starting inventory cost, all inventory movements during the period, and the ending inventory cost. Reports > Standard ...

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

    • Feature Overview: Par & Re-Order Points

      Par levels and reorder points help streamline purchasing in Yellow Dog. Par level is the ideal quantity to keep on hand. Reorder point is the minimum quantity that triggers reordering. You can update par and reorder points in the following locations: ...

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

    • FAQs: What are Bins?

      Question: What are Bins? Answer: Bins are optional location identifiers that specify exactly where an item is stored. You don’t need to create bins in advance. You can assign them: In the Stores tab of the item editor Through a Balto import Bins ...