Analysis by Brand
Distribution indicators per brand: stock, selling-out, share among brands, customer penetration, and average purchase per customer. The report for talking to principals in their own language.
Questions It Answers
- What share of active customers has ever bought this brand's products (penetration)?
- What is brand X's share against the other brands we sell?
- Which products have stock piling up while selling-out is small?
Filters
| Filter | What it does |
|---|---|
| Transaction Date | Required, a date-and-time range. Sales are counted within it; stock is taken as of its end. |
| Division | Pre-filled from the user role's default division. A role locked to one division cannot change it. |
| Department | Limits to one department (warehouse/outlet) inside the division; pre-filled from the role default when set. |
| Brand | One brand, or empty for all. This choice also sets the denominator of Share of Market. |
How To Read It
One block per brand; rows are that brand's active products.
| Column | Meaning |
|---|---|
| Balance | Stock as of the filter end date (in - out), in the chosen division/department. |
| Selling Out | Quantity sold minus returns, converted to the base unit (quantity 1 in the unit master). Invoices and cashier receipts count. |
| Share of Market (%) | Product's Selling Out / total Selling Out of all brands in the filter x 100. With a Brand filter set, the denominator is that brand alone - so 100% is split among its own products. |
| Penetration (%) | Distinct customers who bought the product / active customers in the master x 100. |
| Avg Sell / Customer | Selling Out / number of buying customers. |
| Selling Price | Base-unit selling price from the master. |
Why The Numbers May Differ
- This is the only sales report that converts units - its quantities will not match the "by Division" reports, which use invoice units.
- Penetration divides by all active customers, including those who never bought any brand; the figure is small for a large customer base.
- No approval-status filter; returns are already deducted.
- Inactive products are not shown even if they sold in the period.
Menu Location
- Sales & POS / Sales Reports / Analysis by Brand
/report/analyzeperbrand