Sales by Division, Service Staff, and Product
Sales per product for each service staff member (technician, therapist, mechanic) recorded on the invoice lines. The basis for service-staff commission.
Questions It Answers
- Which services and products did each staff member deliver, and for how much?
- What is a staff member's commission base this period?
- Who is the most productive staff member in each division?
Filters
| Filter | What it does |
|---|---|
| Transaction Date | Date range of the sales. Empty means the whole history - slow on years of data, so always fill it. |
| Division | Pre-filled from the user role's default division. A role locked to one division cannot change it. |
| Product Code | One product only - handy for tracing the history of a single item. |
| Service Staff | One service staff member; pre-filled from the role default when set. |
| Customer | One customer only. A role locked to a specific customer gets it pre-filled and read-only. |
| Sales Representative | One sales rep only; pre-filled from the role's default when set. |
| Serial Number | Match a serial number exactly (=) or partially (like). Only meaningful when the company uses serial numbers. |
How To Read It
Nested result: Division > Service Staff > product rows. Unlike the sales rep, service staff is recorded per line - one invoice can be split across several staff.
| Column | Meaning |
|---|---|
| Quantity, Unit | Quantity sold in the unit written on the invoice - not converted to the base unit, so 1 box and 12 pcs show as two rows. |
| Gross | Price x quantity before line discount. |
| Discount | Discount per product line. Invoice-level discount (at the foot of the invoice) is not here. |
| Net | Gross - Discount. |
| Tax, Extra Tax | Line VAT, and any extra tax (e.g. restaurant tax) computed per product. |
| Subtotal | Net + Tax + Extra Tax. |
| Profit, Profit Margin | Shown only to roles allowed to see purchase prices. Profit = Gross - Discount - tax included in the price - COGS at the time of sale. Profit Margin = Profit / (Gross - tax included in the price) x 100%. |
| Serial Number, Expiration Date | Shown only when the company uses product serial numbers/expiry; otherwise the columns are absent. |
Source: Sales invoices and POS cashier receipts that are approved (when the approval workflow is on). Returns are not deducted here - see the Sales Return reports.
Why The Numbers May Differ
- Invoice lines without service staff are grouped under a blank staff member; fill the Service Staff column on the invoice for them to show here.
- Service-staff commission rules read the same data, but the commission itself is in the commission report - this report is sales value only.
- POS cashier receipts are included here. Sales Summary and Sales Trend read Sales invoices only, so their totals are lower than this report whenever there are cashier sales.
- Documents still waiting for approval are not counted. If the approval workflow is on and the figures look low, check the Approval Queue.
- Invoice-level discount (at the foot of the invoice) does not reduce the per-product figures here, so the Subtotal total can exceed the invoice totals in Sales Summary.
- Profit and Profit Margin disappear from the table when the user's role may not see purchase prices - not because the data is empty.
Menu Location
- Sales & POS / Sales Reports / Sales by Division, Service Staff, and Product
/report/salesdivservicedoerprod