Salesperson - Commission (report)

The Salesperson - Commission report shows sales performance and commission earnings for each salesperson over a selected period. The report lists posted sales documents by posting date and document number, and includes sales amount, profit, and adjusted profit per transaction.

For each line, the report calculates sales-based, profit-based, and adjusted profit-based commissions using the salesperson's commission percentage. The report is grouped by salesperson and ends with subtotals per salesperson and an overall total, providing a clear breakdown of revenue, profitability, and earned commissions for the period.

Available layouts

INTRODUCED IN: Business Central 2025 release wave 2.

The report includes different layouts for different use cases:

• An Excel layout with worksheets designed for print and for analysis.
• A Word layout designed for print/PDF output.

You can export either layout from the Report Layouts, edit it in Excel or Word to cater for your needs, and import it back to Business Central. To learn more, go to Creating your own report layouts.

Use cases

Analyze the commissions by salesperson. See the customer, document, sales amounts and profit amounts provided by a salesperson's contributions.

Sales representatives can use the report to:

• Track personal sales performance and understand how individual transactions contribute to commission earnings.
• Verify commission calculations per invoice and identify discrepancies early.
• Understand the relationship between sales volume, profit, and commission outcomes.

Sales managers can use the report to:

• Compare performance and commission payouts across salespeople.
• Evaluate whether commission structures align with profitability goals.
• Identify top-performing salespeople based on sales, profit, or adjusted profit.

Finance managers can use the report to:

• Validate commission liabilities before payroll or commission settlements.
• Reconcile commission expenses with posted sales and profit figures.
• Support audit and compliance activities by providing a transparent commission calculation trail.

Sales operations analysts can use the report to:

• Analyze trends in sales and commission over time.
• Assess the impact of pricing, discounts, or cost adjustments on commission payouts.
• Provide data to refine commission models and incentive programs.

Try the report

Try the report here: Salesperson - Commission

Related information

Sales reports
Ad hoc analysis of sales data
Sales analytics overview

Find free e-learning modules for Business Central here