Profit Analysis
Inventory → Profit Analysis (/inventory/profit) shows which items make
money. For a date range it lists, per item, how many were sold, what they
brought in, what they cost, and the gross profit and margin.
How the figures are worked out
It helps to know where the numbers come from, because they are estimates rather than accounting figures:
- Qty Sold is the stock that went out of your warehouses in the range — deliveries and stock-outs.
- Revenue is that quantity multiplied by the item's current Default price. It is not read from actual invoices, so discounts, customer prices and quantity breaks are not reflected.
- COGS (cost of goods sold) depends on the Costing Method chosen at the top of the page.
- Gross Profit is Revenue − COGS, and Margin is gross profit as a percentage of revenue.
For invoice-based figures, use the Cost of Goods Sold report on Inventory Reports, which shows invoiced revenue and margin.
Before you begin
inventory.profit.viewopens the page.inventory.profit.managelets you change and save the costing method. The Warehouse Manager role has both.- Items need an active Default price, or their revenue shows as zero.
The costing methods
| Method | COGS is based on |
|---|---|
| Standard Cost | The item's Standard Unit Cost from the Item Catalog. |
| Average Cost | An average of what you have paid. |
| Latest Purchase Price | The most recent cost you paid. |
| Actual (Moving Average) | What the stock ledger actually charged when each unit went out — the same cost your valuation uses. The most accurate choice. |
The method you save is used every time anyone opens the page, so agree on it with finance. Changing it never changes any stock value or past transaction — it only changes how this page calculates profit.
Use the page
- Set the From and To dates.
- Check the Costing Method. To change it, choose another and select Save.
- Read the summary cards: Total Revenue, Total COGS, Gross Profit and Avg Margin.
- Use the tabs:
- By Item — a grid with SKU, Name, Category, Unit Cost, Selling Price, Qty Sold, Revenue, Gross Profit and Margin (UoM and COGS are hidden by default). Sort by Gross Profit or Margin to find your best and worst items, and export as usual.
- Top 10 Chart — the ten most profitable items as a chart.
Gross profit is green when positive and red when negative.
Common issues
| Problem | What to check |
|---|---|
| "No sales in range" | Nothing went out in those dates. Widen the range. |
| Revenue is zero for an item | It has no active Default price. |
| Margins look too good or too bad | Check the costing method, and that the item's Default price is current. |
| The method dropdown is greyed out | You need inventory.profit.manage. |
Related pages
- Item Pricing — the Default prices used for revenue.
- Inventory Reports — the invoice-based Cost of Goods Sold report.