Gross Margin per Item and Category

Gross margin shows what remains after goods costs, before staff and other expenses. Compare both amounts and percentages when evaluating products.

Gross profit = sales after discounts and excluding VAT − goods costs excluding VAT.

Gross margin % = gross profit ÷ sales after discounts and excluding VAT × 100.

Net sales of SEK 500,000 and goods costs of SEK 150,000 give gross profit of SEK 350,000 and a 70 percent margin.

Read categories

Open Analytics++ → Lönsamhet (Profitability), choose a period and read Lönsamhet per kategori. Sort by margin amount or percentage. Share means the category's share of calculated gross profit; Count means units sold.

Category Försäljning inkl. moms shows item amounts including VAT after discounts. Margin columns use revenue after discounts and excluding VAT. Subtracting the visible Cost of Goods from Revenue therefore does not reproduce the margin.

The scatter chart shows quantity, margin percentage and revenue by product. For product and variant detail, also open Menyanalys and switch between % and kr/st.

Avoid misleading comparisons

• Check cost prices in Meny. Missing costs can overstate totals; Profitability has no separate Warning table where you edit those prices.
• Product mix also calculates margin excluding VAT after discounts. Still check time basis, dates and filters when comparing.
• A high percentage on low volume can yield fewer kronor than a lower percentage on high volume.
• Use Periodjämförelse for two periods. The operating contribution view in Lönsamhet uses the selected comparison period when Jämför is enabled and shows changes when both periods have complete data.

Export for follow-up

Use CSV beside the category table. It summarises the selected interval; for a monthly series, export each month and label the files by period. It does not automatically contain a full year's month column. Sum revenue and costs before calculating a combined margin; do not simply average category percentages.