Elbuz builds a sales report for a period: revenue, profit and margin for all or only closed orders, top products and categories, sales by source, ABC analysis and products without movement.
When you need this:
- You need monthly profit — the report subtracts cost price at the order's warehouse from revenue.
- Which products make money? — ABC analysis groups them by share of profit.
- Stock doesn't sell — the “Illiquid items” block shows everything without movement for over 30 days.
- A product is running out — “Products with critically low stock” shows items with 5 units or fewer left.
Where to start: Analytics → “Sales analytics” → the “Month” button.
What sales analytics can do
- “Count” — all orders or only closed sales.
- Revenue, profit, margin — by day, week or month, filtered by category, warehouse and order source.
- Cost price — taken from the order's warehouse or from the product card.
- ABC analysis — groups A, B and C by each product's share of profit.
- Slow-moving and low stock — products without movement for more than 30 days and items that are running out.
What the report shows and what counts toward the numbers
The sales report for a period is a separate window: left menu “Analytics” → “Sales analytics”. At the top are four metrics: “Total revenue”, “Total profit”, “Average margin” and “Number of orders”. Below are charts and tables: financial metrics by day, week or month, top products and categories, sales by order source, product margins and products without movement.
Set the period with the “Today”, “Month”, “Quarter” and “Year” buttons, or with a date range and the “Apply” button. Narrow the report with the “Product Category”, “Warehouse”, “Order Source” and “Advanced filter” fields; “Group by Period” switches between “By Day”, “By Week” and “By Month”.
1
Period buttons2
Count- Period buttons — Today, Month, Quarter and Year set the date range in one click.
- Count — chooses what the report counts: orders (the only available option here).
What counts toward the numbers — three rules that decide whether the report matches your expectations:
- Customer orders only. Sales invoices, tax invoices, sales receipts and cash orders are not included in sales analytics.
- What to count. The “Count” field decides which orders go into the numbers:
- “Orders” — all customer orders except canceled, returned, refused, draft and other orders that didn't go through. Every store has this figure.
- “Sales (closed)” — posted orders or orders in a final status: completed, delivered, handed over. This is revenue the store has already received.
- By order creation date, not by payment or shipping date. In “Sales (closed)”, a posted order counts toward revenue even with the “Canceled” status, so unpost canceled orders.
Revenue is the sum of order lines. Cost is quantity multiplied by the product's cost price at the order's warehouse (if none is set there, by the cost price from the product card). Profit is the difference. For orders in another currency, the report converts line amounts to the base currency at the rate recorded in the order itself.
Where cost price comes from and why profit can look odd
For each order line, the report takes the product's cost price at that order's warehouse; if it's zero there, it uses the cost price from the product card. Margin is profit divided by revenue, multiplied by 100. Three consequences explain most “odd” numbers:
- Cost price is current, not as of the sale date. The report calculates it when you open it, so after a purchase price change, profit for past months is recalculated at the new cost price.
- A product without a cost price gives 100% profit. When the cost price is zero both at the warehouse and in the card, the whole line amount goes into “Total profit” and inflates “Average margin”.
- Product tables leave such items out. “TOP 10 products by margin” and ABC analysis show only products with a non-zero cost price, so their total profit doesn't match “Total profit”.
Checking whether this is your case is easy: open the products with the highest revenue and look at the cost price in the card and at the warehouse. How it gets to the warehouse is covered in Inventory management.
How to read ABC analysis: by profit, 80% and 95% thresholds
The “ABC analysis by margin” block splits products by their share of profit, not revenue. Products are sorted by profit, and their shares are added up cumulatively: up to 80% — group A, up to 95% — group B, the rest — group C. It uses the period's 100 most profitable products with a non-zero cost price.
The “Show full report” button opens “Detailed ABC analysis” with a table for each product. The “Group Products by Field” field decides what counts as one product: “Product ID”, “Product Model” or “Product Edition” — the last one merges products with the same edition into one row.
How to find slow-moving stock and products running out
The “Illiquid items” block shows products with stock above zero whose stock hasn't changed for over 30 days (no entries in the stock movement log) or has never moved. Each row shows the warehouse, stock, last movement date and “Days without movement”. The chart shows only the 20 longest-sitting items: any other slow-moving stock isn't visible on it.
The “Warehouse” field keeps stock for the selected warehouse only, and “Product Category” keeps only that category and its subcategories. The 30-day threshold is fixed and counted from today: the period buttons don't affect this block. Movement is counted per product overall, so a sale from one warehouse removes the product from the slow-moving list at other warehouses too.
Next to it, the “Products with critically low stock” block lists items with 0 to 5 units left in the warehouse, inclusive (zero-stock items aren't shown); it doesn't depend on the period either.
Scenarios
Calculate profit for last month
What to do. Set last month's date range, choose “Sales (closed)” in “Count” and click “Apply”.
What you get. The “Total revenue”, “Total profit” and “Average margin” tiles for closed customer orders (posted or in a final status) created in that range. If order closing isn't tracked, the report shows figures for all orders.
What you won't get. The report uses the current cost price, not the one as of the sale date: after a purchase price change, last month's profit changes too.
Find products to clear out at one warehouse
What to do. Select the warehouse in the “Warehouse” field and look at the “Illiquid items” block.
What you get. Products with stock at that warehouse that haven't moved for more than 30 days, with the last movement date and the number of days without movement.
What you won't get. The 30-day threshold can't be changed, and the period buttons don't affect the block. A sale from another warehouse removes the product from the slow-moving list here too.
Compare website and marketplace sales
What to do. Look at the sales by order source block, or narrow the report with the “Order Source” field.
What you get. Revenue and profit separately for each source the orders came from.
FAQ
Revenue is zero, but there are loads of orders this month. Why?
Most likely the “Count” field is set to “Sales (closed)”, and this month's orders aren't posted yet or in a final status. Switch to “Orders” or post the orders: select the rows in the list and choose “Post document”.
Do canceled orders count toward revenue?
In “Orders” — no. In “Sales (closed)” — yes, if the canceled order is posted: unpost canceled orders.
How does the report count orders in dollars?
At the rate recorded in the order: each line amount is converted to the base currency.
Why is profit in the product tables lower than “Total profit”?
“TOP 10 products by margin” and ABC analysis leave out products without a cost price, while “Total profit” includes them — see where cost price comes from.
Can I set a monthly sales target and see the completion percentage?
No, the report has no target values — only actual figures. Keep your target separately and compare it with “Total revenue” for the same period.
Where to find it and who has access
- Menu
- Analytics → Sales analytics
- Prepare
- customer orders and product cost prices; for “Sales (closed)” — posted orders or final statuses
Related topics
- If you need the big picture of the documents window — Document list.
- If there's no cost price at the warehouse and profit looks odd — Inventory management.
- If you need to know how to post an order — Processing customer orders.
