Commission Statement (1214 onwards)

Created by Migration Bot, Modified on Fri, 23 Oct at 11:25 AM by Migration Bot

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

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article