Understanding COGS Reports
Analyse actual vs theoretical cost of goods sold to manage profit.
Introduction
COGS (Cost of Goods Sold) reporting in Bepoz allows venues to measure the true cost of products sold during a specific period. These reports are essential for analysing profitability, identifying wastage, and fine-tuning purchasing decisions.
Important: Bepoz COGS reports focus on Adjusted Cost, not “Actual vs. Theoretical”. Adjusted Cost reflects the most reliable cost based on purchases, stock adjustments, and pricing data.
Accessing the Report
- Navigate to Back Office > Reports > Sales & Analysis.
- Choose 'COGS by Period' or similar cost reports.
- Select filters such as product category, site, or supplier.
- Generate and compare results.
Key Fields in Bepoz COGS Reports
Product Name
The product being evaluated for cost and margin performance.
Quantity Sold
The number of units sold during the report period.
Adjusted Cost
The cost assigned to each unit — typically derived from:
-
Purchase orders
-
Supplier invoice imports
-
Stock adjustments or corrections
This is the core value Bepoz uses in margin calculations.
Total Cost
The adjusted cost multiplied by quantity sold.
Gross Profit
The difference between sales revenue and adjusted cost.
Gross Profit %
The profit margin as a percentage of total sales.
Best Practices
- Ensure recipe and ingredient setup is accurate.
- Reconcile inventory regularly to maintain accurate costs.
- Review variance trends across multiple periods.
FAQs
Q: What is the difference between Adjusted Cost and Purchase Cost?
Adjusted Cost reflects the most recent reliable cost, which may include stock adjustments or corrected pricing — not just the last PO.
Q: Can I report COGS across multiple venues?
Yes, use site filters or run group-level reports for consolidated COGS reporting.
Q: Why is Theoretical Cost missing?
Theoretical cost is not included in most standard Bepoz COGS reports. Bepoz prioritises real-world Adjusted Cost to ensure reports reflect operational data, not assumptions.