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 inventory movement affects food cost.

 

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

 

The report calculates inventory usage cost based on item movement between two physical inventories.

Usage is calculated from transactions that occur between the selected physical inventories, including:

• Invoices

• Transfers

• Returns to vendors

• Manual adjustments
  

 

Generate the report

1. Go to Reports > Standard Reports.

2. Select F&B > Food Cost > COGS Reporting.

3. In the Date Range field, select the starting and ending physical inventories.

4. Optional filters:

   • COGS Accounts (all accounts are included by default)

   • Only Show Items That Were Counted (excludes items with a count of 0)

5. Click Generate.
   

 

Column	Description
COGS Department	The COGS account assigned to the item. If the column displays Not Set, the item does not have a COGS department assigned.
Starting Cost	The purchasing cost of inventory on hand at the starting physical inventory.
Received Cost	Cost of items invoiced during the period between the selected physical inventories.
Transfer Issued Cost	Cost of items included on transfers issued during the selected period.
Transfer Accepted Cost	Cost of items included on transfers accepted during the selected period.
Returned to Vendors Cost	Cost of items returned to vendors during the period between the selected physical inventories.

 

• Related Articles

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

• Reporting Explained: Inventory Items with No COGS Account

  Use this report to identify inventory items that are not mapped to a COGS account. This helps you: Prevent inaccurate COGS reporting Identify missing mappings Troubleshoot cost variances Note: COGS accounts are store-specific, so mapping must be ...

• Reporting Explained: Physical Inventory (detailed by Physical)

  The Physical Inventory > Detailed (select by physical) report provides a comprehensive view of a Physical Inventory. It shows: All items included in the physical Quantities counted Previous on-hand quantities Variance quantities and variance costs ...

• Reporting Explained: Food Cost Actual by Item

  Use this report to analyze the actual cost of goods sold (COGS) for items over a defined period. It helps you: Understand true item-level costs Compare cost against sales Identify margin and profitability trends Accurate results depend on completing ...

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

• How To: Install the Zebra ZD411 Printer Driver

  End user · Yellow Dog Inventory 2026 WHY IT'S IMPORTANT When you install the correct driver, Windows can communicate with your Zebra ZD411 printer so it prints labels and tags reliably from Yellow Dog Inventory. Without the driver, the ZD411 will not ...

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

• Food and Beverage User Manual

  The Food & Beverage 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 system. Download ...