Skip to main content

Cost of Goods Sold (COGS) Report

Compare two stock counts to see how much stock have been used in-between

Updated this week

Applicable to: Buyer Hub

If you are already using Zeemart to do stock counts, you can generate a Cost of Goods Sold (COGS) Report (previously known as 'consumption report') provided you have done at least two stock counts for the same inventory list.

The report allows you to see, for each inventory item:

  • the starting quantity

  • quantity received (based on GRN data)

  • any inventory transfers to/from other locations

  • ending quantity

Based on the above information, we will calculate consumption using this formula:

(Starting quantity + Quantity received + (or -) Transfers in/out) - Ending quantity

Steps

1. In Reports, select Cost of Goods Sold under Inventory section.

2. In the Cost of Goods Sold page, first select the outlet (location), then select inventory lists to be included in the report (you can select more than one list).

3. Select the date range for the report. You can only select dates where there are stock counts performed on the date.

4. Click Show report. You can export the result as an Excel file. To display other columns such as Wastage, Transfer in, Transfer out, click Show/hide columns to customise the columns shown in the report.

  • Price: Current price of the item.

  • Opening: Total quantity as per the stock count on the start date.

  • Received: Quantity received using GRN or based on Invoice data.

  • Transfer in and Transfer out: Quantity transferred to/received from another outlet.

  • Closing: Total quantity as per the stock count on the end date.

  • Consumed: Quantity used/consumed during the selected period. Calculated using this formula: Opening + Received + Transfer in - Transfer out - Closing.

  • COGS: Value of quantity consumed during the period.

  • Consumed (theoretical): Refers to the theoretical quantity consumed based on sales data from POS during the selected date range. Only available if there is POS integration.

  • Theoretical COGS: Value of Consumed (theoretical), calculated by multiplying with the average price.

  • Qty variance: The difference between Consumed and Consumed (theoretical) quantities, calculated using this formula: Consumed (theoretical) - Consumed

  • Variance %: Calculated using this formula: (Consumed (theoretical) - Consumed / Consumed (theoretical)) * 100. For example, if Theoretical consumption is 10 and Actual is 12: (10-12)/10*100 = -20.0%

5. You can also see which stock counts have been included for the calculation of the report by selecting the Stock counts tab.

See also

Did this answer your question?