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

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.