Quick answer: The Cost of Goods Sold (COGS) report shows how much of each inventory item you used: starting quantity plus received, plus or minus transfers, minus ending quantity. You need at least two stock counts for the same inventory list. Then follow the steps below.
Product: Nomni Procure
Applicable to: Desktop
If you are already using Nomni Procure 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
In Reports, select Cost of Goods Sold under Inventory section.
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).
Select the date range for the report. You can only select dates where there are stock counts performed on the date.
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.
Transfer in and Transfer out: Quantity transferred to/received from another outlet.
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.
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)- ConsumedVariance %: 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
Theoretical COGS Report - theoretical cost of consumption based on sales data from POS
Need help?
Email support@nomni.ai or call 1300 445 483.