COGS By Item Group

COGS By Item Group takes the cost of goods sold booked in the General Ledger for a period, every debit on accounts of type Cost of Goods Sold such as Cost of Goods Sold - YFF, and splits it across item groups in proportion to the sales of each group in the same period. It does not read the stock ledger; it allocates the GL total by the share of Sales Invoice item amounts per group, so the split is an estimate by product line, not an exact per item cost. It answers which lines earn and which only turn over. Groups with sales but no stock items also get a share, so read it with that in mind.

Group COGS = total COGS debits in the period x (group's sales amount / total sales amount)

1. 01Go to Stock > COGS By Item Group, or search for it.
2. 02Set Company, From Date and To Date; use a full month or quarter.
3. 03Read the total COGS at the top and the allocated COGS and percentage per item group.
4. 04Compare each group's COGS with its sales from Sales Analytics to get the margin.
5. 05Review pricing or purchasing for groups whose cost share exceeds their sales share.

Open to see which product lines carry the highest cost of sales.

Tour services item group carries most of the cost against the Rs 64,000 revenue.