# Brand Wise Sale
Aggregates sale invoice activity by brand — total quantity sold, sale value, and average unit price for brand performance analysis.
Overview
Go to Sales → Reports → Brand Wise Sale.
Report title in ERP: Brand Wise Sale
What it shows. One row per brand with total quantity sold, sale amount, return quantity, return value, net sale, and average unit price.
When to use it. Use to compare brand performance, identify top-selling brands, and support brand-level sales planning.
How amounts are calculated. Aggregates approved sale invoice lines by brand within the selected date range. Returns reduce net values when included.
Use Cases
- Brand manager review — Rank brands by sale value and quantity for the period.
- Promotional planning — Identify underperforming brands that need marketing support.
- Territory analysis — Filter by employee or route to compare brand sales by region.
- Return impact — Compare gross sales vs net sales after brand-level returns.
Filters
Date, Brand, Employee, Customer. Advanced Filter: Item Group, Route, Branch, Center, Payment Mode.
Columns
| **Column** | **Description** |
|------------|-----------------|
| Brand | Brand name. |
| Sale Qty | Total quantity sold. |
| Sale Amount | Total sale value before returns. |
| Return Qty | Total quantity returned. |
| Return Amount | Total return value. |
| Net Qty | Sale Qty minus Return Qty. |
| Net Amount | Sale Amount minus Return Amount. |
| Avg Unit Price | Average selling price (Sale Amount ÷ Sale Qty). |
Actions
- Generate — run the report for the selected filters
- Export / Export All — export to Excel
- Print — print the report
- Advanced Filter — open additional filter fields
- clear — reset active filters
FAQ
How is net amount calculated?
Sale Amount minus Return Amount for the selected period and filters.
Does this include credit notes?
Return amounts reflect approved credit notes linked to the brand.
Can I compare with targets?
Use Brand Wise Performance under Employee Reports for target comparison.
Are service items included?
Yes, if they have a brand assigned. Filter by item group to exclude services.
Does this include returns?
Returns are not in sale totals. Pair with Item Wise Sale Return for the same period.
Can I export for brand reviews?
Yes. Export to Excel for supplier or internal brand performance meetings.