Originally written by John Hardwick, last updated Mar 26, 2026, on the Swan Retail knowledge base (FRS).
Part of: Financial Reports
The report calculates commission using a user specified start and end date and in detail or summary the report may take time to complete due to the complexity of the calculations.
Crystal report name Commission Statement 12
The report uses incentive schemes, commission groups and primary/secondary percentages set to produce an output.
When calculating a split incentive, the report calculates the full incentive for both primary and secondary salesperson using each person’s incentive scheme, then applies the COMMISSION_SPLIT setting to produce a value payable.
Order lines are only presented if selected.
Selection Criteria
Run time choices, user selectable.
-
Date Range
-
Show Sales Order Details
-
Yes / No
-
-
New Page on Change of Salesperson
-
Yes / No
-
Print Sequence
As indicated by blue numbered squares in the report example.
1 Salesperson
2 Payment / Commission Group
Report Totals
As indicated by yellow numbered squares in the report example.
1 Commission Group
2 Salesperson
3 Report Total
Printed Fields
Fields printed on the report.
-
Salesperson
-
Payment / Commission Group
-
Order number (if selected)
-
Transaction Value
-
Split Value (if applicable, should there be a secondary salesperson, for example)
-
Commission Percentage
-
Fixed Commission Payment
-
Sales Commission
-
Delivery Commission
-
Total Commission Per Order / Commission Group
-
Original Sales Value
-
Discounted Sales Value
-
Percentage Discount
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article