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.