Employee-by-brand sales grid for a date range — quantity and sale amount before tax per brand, with employee and brand totals. Use it to see which brands each salesperson sold.
What it shows. One row per employee who has sales in the period. Each brand has two columns — Quantity and Value (sale amount before tax). A Total pair of columns and a footer Total row complete the grid.
When to use it. Compare how each salesperson sold across brands for a week, month, or custom date range. Use it for brand focus reviews and supplier meetings — not for target achievement.
How amounts are calculated. Adds up sale invoice item lines by the employee on the invoice and the brand on the item. Value is sale amount before tax. Approved, closed, and pre-approved invoices are included. Credit notes and returns are not deducted. Items with no brand appear under Others. Only employees and brands with sales in the selected period are shown.
Header (quick filters)
Advanced Filter (filter icon) — additional fields:
Tap Clear after applying Advanced Filter to reset advanced filters.
The first header row lists each brand (and Total) as a pair of columns. The second header row repeats Quantity and Value under every brand and under Total.
| **Column** | **Description** | |------------|-----------------| | Employee | Sales employee first and last name. | | Quantity (per brand) | Quantity sold of items in that brand. Default is inventory unit. | | Value (per brand) | Sale amount before tax for that brand. | | Total Quantity / Total Value | Row totals across all brands for the employee. | | Footer Total | Column totals for each brand, plus grand quantity and value. |Use More → Show In Report Unit to convert quantity to each item's report unit. Switch back with Show In Inv Unit. Value does not change.
How is this different from Brand Wise Sale?
Brand Wise Sale shows one row per brand with invoice count, discounts, sale amount before tax, and bill total. This report is a grid of quantity and sale amount before tax by employee and brand. It does not include returns.
Does this report show brand targets or achievement %?
No. Brand Wise Performance is no longer in the menu. This report is actual sales only. Use Sale Target Commission for target and commission reviews.
Are returns included?
No. Pair with Item Wise Sale Return for the same period if you need return impact by item or brand.
Are pre-approved invoices included?
Yes. Pre-approved sale invoices are included with approved and closed invoices.
Why don't I see some employees or brands?
Only employees and brands with sales in the date range appear. Your employee access in the Sale module may also restrict which employees you can see. Items without a brand are grouped under Others.
Does Customer Group change the results?
Customer Group is available in Advanced Filter. Customer, Customer Category, Center, Form Type, Zone, and Branch do apply. If Customer Group does not change the grid, use Customer or Customer Category instead.