Calculating sales commissions in Business Central without spreadsheets

What standard Business Central sales commissions provide

Each salesperson record has a commission rate field. You assign a salesperson code to customers. It copies to sales documents, where you can change it per order. When an invoice posts, the system stores the code on the customer ledger entry with the sales amount and profit.

The salesperson commission report then lists those entries for a date range. It works out commission on sales and on profit for each person. There is nothing more to it: one rate per person, applied to everything they sold. For a small team on a flat plan that is often enough.

Where real Business Central sales commissions plans go beyond the standard

Few plans stay flat. Rates differ by product line. New business earns more than renewals. Tiers reward passing a quota. Two people may share credit on a large account. However, many companies pay only once the customer has paid. They also claw back when they credit an invoice.

Therefore a single rate field handles none of that. The result is usually an export to Excel and a fragile workbook maintained by one person. We read your written plan. Then we mark which rules the standard covers and which need more. Finally, we show the simplest way to close each gap.

How we extend sales commissions in Business Central

There are three routes. AppSource solutions for commission management suit plans with many rules that change often. A small AL extension suits a stable plan with a few specific rules. A Power BI model suits teams that want calculation and analysis in one place. They post the payable by journal.

Whichever route you choose, the calculation reads posted entries. So you can always trace it back to invoices. We build it in a sandbox and run it against a past period. Then we compare the output with what you actually paid. We explain any difference before anyone relies on the new numbers.

Accruing and paying Business Central sales commissions

Commission is an expense of the period when you recognize the sale, even if you pay it later. We set up an accrual journal, recurring where suitable. It books the expense and a liability from the calculated figures. Dimensions cover salesperson and department.

Next, payout depends on who gets paid. Employees normally get paid through payroll, so we pass the approved amounts to the payroll system. We set up independent representatives as vendors and pay them through payables. That also supports year-end reporting for them. Both paths clear the accrued liability.

Statements that salespeople accept

As a result, disputes fade when people can see how their figure came about. We produce a statement per salesperson. It lists each invoice, the basis amount, the rate and any adjustment. You get it as a report or as a Power BI page that filters to the person viewing it. Transparency builds confidence.

Data quality matters more than formulas. The usual pitfalls are easy to name. Some invoices have no salesperson code. Someone gets a house account by accident. Codes change after people set expectations. Credit memos carry a different code from the original invoice. We add checks that catch these before the period closes.

Business Central sales commissions questions

Does Business Central calculate commissions out of the box?

Yes, in a basic form. A rate on each salesperson applies to sales and to profit on posted invoices. A standard report shows the result per person for a period. Anything more detailed needs an add-on, an extension or a reporting model.

Can commission be based on profit instead of revenue?

Yes. The standard report shows commission on both sales and profit. For profit to mean anything, item costs must be accurate. Cost adjustment must also have run. Profit on an entry changes when later costs arrive.

Can we pay commission only on invoices the customer has paid?

Not with the standard report, which works from invoiced amounts. Paid-basis commission is a common extension: the calculation looks at applied payments on each invoice. We build and test it against your payment history. We handle partial payments too.

Can two salespeople share one sale?

A sales document carries one salesperson code. We handle shared credit with an added split table, an add-on, or the reporting model. We choose based on how often splits occur and how they are agreed.

Can commission use data from our CRM system?

Yes. When Business Central connects to Dynamics 365 Sales or another CRM, ownership and opportunity details can inform who gets credit. The amounts still come from posted invoices. The invoice stays the record of what you sold. That keeps Business Central sales commissions easy to audit.

Related pages

Business Central sales commissions draw on sales data, reporting and payroll. These pages cover customer rebates, tailored reports, passing figures to a payroll system and the connection with Dynamics 365 Sales. Begin with the page nearest to your plan, then ask our consultants how it fits your written commission rules. We can talk it through by video call. For the product detail, see Business Central documentation on Microsoft Learn.