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 completed per store.
Reports > Standard Reports > F&B > Cost Reporting > Inventory Items with No COGS Accounts
This report lists all inventory items that do not have a COGS account assigned.
- Includes items based on selected filters (store, level, item status)
- Returns only items where COGS = Not Set
-
Helps isolate gaps in COGS mapping that impact financial reporting
- Go to Reports > Standard Reports
-
Open F&B
-
Open Cost Reporting
-
Select Inventory Items with No COGS Accounts
- Set filters:
- Stores (default: All)
- Levels (default: All)
- Include Deleted Items (default: Excluded)
- Include Inactive Items (default: Excluded)
- Include No Count Items (default: Excluded)
-
Click Generate Report
| Column | Description |
|---|---|
| Store Code | Store identifier |
| Store Name | Name of the store |
| Department | Department assigned to the item |
| Category | Category assigned to the item (blank if not assigned) |
| Item | Item description |
| SKU | Unique item identifier |
| Size | Item size |
| COGS | Assigned COGS account (expected to show Not Set) |
Notes:
- Run this report before month-end to ensure all items are mapped
- Unmapped items will cause incomplete or inaccurate COGS reporting
-
After updating mappings, rerun the report to confirm resolution
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- 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: 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: Accounting Interface Codes
Use this report to view all available accounting interface codes and their associated GL codes. This helps you: Verify which accounts are configured Confirm GL code assignments Ensure accurate financial mapping for inventory transactions Reports > ...Reporting Explained: Product Mix
Use the Product Mix report to view sales data for POS items mapped to a recipe or item in Yellow Dog. Reports > Standard Reports > F&B > Sales > Product Mix The Product Mix report displays sales data for POS items associated with a recipe or item in ...
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 ...