Skip to main content
All CollectionsFor RestaurantsReports and Data
Theoretical Cost of Goods Sold (COGS) Report
Theoretical Cost of Goods Sold (COGS) Report

Calculate the theoretical cost of your venue's consumption based on Sales data from POS

Updated over 2 months ago

Applicable to: Buyer Hub

The Theoretical COGS report is an invaluable tool for gaining deeper insights into your business's cost structure. By leveraging POS integration, recipe mapping, and flexible date selection, you can obtain a comprehensive view of your expenses and make more informed financial decisions.

What is the Theoretical COGS Report?

Unlike the regular COGS report, which is limited to periods between stock counts, the Theoretical COGS report allows you to select any date range. This is made possible through the integration of Point of Sale (POS) data and the use of product recipes within Zeemart. The report calculates the COGS based on sales data from your POS, mapped against the recipes in Zeemart, providing a more dynamic view of your costs.

Prerequisites

To generate the Theoretical COGS report, ensure that:

  1. POS Integration: Your POS system is integrated with Zeemart.

  2. Product Recipes: Recipes for your products are set up in Zeemart.

  3. POS Mapping: Products from your POS are mapped to the recipes in Zeemart.

Generating the Report

Step 1: Selecting a Location and Period

  • Location: Choose the location for which you want to generate the report.

  • Period: You can select any start and end date. For quick access, you can use the pre-set date ranges like "Last month."

Step 2: Viewing the Report

  • Click on "Show report" to generate the results.

  • The report will display the total COGS during the selected period. For example, based on sales data and recipe mapping, you might see that the COGS is $11,698, with total sales around $50,000. This would result in a COGS percentage of approximately 23%.

Step 3: Detailed Breakdown

  • Per Item Breakdown: The report provides a detailed breakdown per item. For instance, if you sold 700 Almond Croissants, the COGS for these would be calculated and displayed (e.g., $2,415.00 for the period).

  • Weekly Overview: A week-by-week chart shows total sales and COGS, allowing you to track fluctuations over time. For instance, one week might show a COGS percentage of 25%, while another week might be around 18%.

Additional features

'Expense category' view

This tab categorises your inventory items by expense category, offering another way to analyse your data. Note that discrepancies in totals between this and other tabs may occur if some items lack assigned expense categories.

'Sales category' view

This view shows all categories of your POS products, the sales amount, and the calculated COGS based on recipes. The sales categories here come from the categories you assigned in the POS. The percentage of COGS relative to sales is also displayed, helping you assess cost efficiency.

Including Wastages in COGS

If you record wastages in Zeemart, you can include these in your COGS calculation.

Simply check the "Include other costs" box before generating the report, and the COGS amount will adjust accordingly to include wastage and any other stock adjustments you've created on Zeemart.

Did this answer your question?