The COGS Analysis Report allows for Posted vs Live variance comparisons of Cost of Goods Sold by General Ledger. 

Report Usage 

This report takes Beginning/Ending Inventory and Sales data to calculate Usage and % Cost of Goods. This makes it useful if you have access to the Accounts Payable and Inventory modules, but lack the advanced tools associated with the Recipes module.

Report Features 

  • Filter by location or location group. 
  • Filter by date. The report can be run for any specified length of time. 
  • Filter by Inventory Cycle. 
  • Filter by COGS Categories. Manually select COGS Categories using the checkboxes, or select all COGS Categories by selecting ALL. Clear your selection using CLEAR. 

Frequently Asked Questions 

Q: How are Usage and Posted/Live percentages calculated? 

A: Usage = Beginning + Purchased – Ending Posted % = (Posted Usage / Sales) Live % = (Live Usage / Sales) 

Q: Why is a location not showing on the report? 

A: This report is tied to the Inventory module, and only shows whitelisted Inventory locations. 

Q: Why do the dates on the report differ from the range I selected in Step 2? 

A: The report looks for any instances of the Step 3 Inventory Cycle that fall within your chosen Step 2 date range. To capture the cycle in its entirety, the report may roll dates back/forward.