Reporting Explained: Inventory Items with No COGS Account

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
 
  1. Go to Reports > Standard Reports
  2. Open F&B
  3. Open Cost Reporting
  4. Select Inventory Items with No COGS Accounts
  5. Set filters:
    1. Stores (default: All)
    2. Levels (default: All)
    3. Include Deleted Items (default: Excluded)
    4. Include Inactive Items (default: Excluded)
    5. Include No Count Items (default: Excluded)
  6. Click Generate Report  


ColumnDescription
Store CodeStore identifier
Store NameName of the store
DepartmentDepartment assigned to the item
CategoryCategory assigned to the item (blank if not assigned)
ItemItem description
SKUUnique item identifier
SizeItem size
COGSAssigned 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