This dashboard is designed to give you a weekly snapshot of your Cost of Goods Sold (COGS), helping you track how your inventory is being used, and its impact on your sales and profitability.
At the top of the page, you can switch between your different COGS reports.
Date Selector: Choose the day or range you want to review.
Location Selector: View data for a specific site, or look at all your sites together.
Warning Alerts ⚠️ - A warning may alert you to any potential data discrepancies, such as significant differences between the opening and closing stocktakes. These discrepancies may be impacting the accuracy of the calculations, and should be reviewed.
Weekly COGs Metrics
This section provides a summary of your most important metrics (The time frame section will tell you from what dates the following data is from):
Total Net Sales (£/$): The total revenue generated during the selected period.
Theoretical COGS: The expected COGS based on sales data and standard recipes
Actual COGS: The real cost of goods sold, based on your stocktake and purchases.
-Beginning Inventory: The value of stock at the start of the period.
-Purchases: Additional inventory bought during the week.
-Transfers: Any stock moved between locations.
-Ending Inventory: The value of stock remaining at the end of the period.
If you see a large difference in between Actuals/Theoretical % - A large gap between the theoretical and actual COGS may indicate issues with stock usage, waste, or incorrect POS Matching.
If you're unable to identify the issue yourself, please get in touch with our support team via LiveChat who will be able to assist you.
Category COGS Breakdown & Stocktake Variance
On the bottom table, you can toggle between Category Level COGS and COGS Variance reports using the horizontal tab menu.
These tables will allow you to understand and analyse the reasons for variances in COGS over your selected time period.
Category COGS Breakdown
The table beneath the top-line summary provides a detailed view of how your COGS is broken down by category:
Product Class: Categories - ie. Beverage, Food, Retail, and Other.
Opening Stocktake: Total starting stock value for the category.
Purchases & Transfers: Total new stock value added/transferred during the week.
Closing Stocktake: Total remaining stock value at the end of the week.
COGS (£): Total calculated cost of goods sold for the category.
COGS (%): Total cost of goods sold as a percentage of net sales for the category.
Gross Margin (%): The profitability of the category.
Sales: The total revenue generated by the category.
COGS Variance
This table allows you to view COGS performance at a product level. Sometimes products may be used more or less than planned, so this is where you can view those variances and use that information to highlight areas for improvement to increase your cost savings.
Product Name: The Line Level Item, such as "2L Whole Milk" or "Roasted Coffee Beans."
Product Class: Categories - ie. Beverage, Food, Retail, and Other.
Pack Type: The type of packaging the product comes in (ie. bottle, carton, case)
Theoretical Usage: The amount of the product that should have been used based on your sales (dictated by the linked recipe/product created in Edify).
Theoretical Cost: The expected cost of the theoretical usage
Waste: The amount of the product that was discarded or spoiled during the period.
Transfers: Tracks any stock that was moved to another site. Find out more here about how transfers are reported in COGs based on sent date.
Purchases: The amount of the product ordered and received during the reporting period.
Inventory Start: The quantity of the product in stock at the beginning of the period.
Inventory End: The quantity of the product remaining in stock at the end of the period.
Inventory Change (%): The difference between your last two stocktakes.
Actual Usage: The amount of the product that was actually used during the period, based on what you purchased, counted in your stocktakes and wasted.
Actual Cost: The real cost incurred based on the actual usage.
Variance: The difference between theoretical and actual usage. A positive variance (+%) indicates overuse (possibly due to unlogged waste, spillages, or over-portioning). A negative variance (-%) suggests underuse (potentially due to stocktaking errors or missed sales).
Variance Cost (£): This outlines the financial impact of the variance, showing how much extra the overuse or underuse has cost you.
There's something wrong with the numbers on my report
COGS reports are generated using information from your Stocktakes, Recipes/Products and Sales Data. If you notice something doesn't look quite right with your report, make sure to check the following three things first:
Are my last Stocktakes accurate?
Have any items been counted incorrectly?
Is the product/recipe in Edify matched up to the item on your POS correctly?
Check your POS Dashboard and ensure the correct item and unit of measure have been linked
Are your Recipes set correctly in Edify?
Check the recipe ingredients and costs - has there been a mistake made?
If you've checked these and still can't identify the reason for the discrepancy, please reach out to our support team via LiveChat who will be able to assist.
Weekly COGS FAQs
Can you view 'all sites' for the Weekly COGS report?
No, currently it is not possible to select 'all sites' when viewing this report. It is only possible to select "All Sites" for the Line Level COGS and Flash Reports.
If I change the price of products in Edify, will this affect the historic reporting?
Historical Stocktakes, Purchases and Transfer records will not change. However, your "Theoretical" costings in your reports will change historically - (ie. the cost of your recipes will update!).