Pay commission
Pay commission with a settlement
Pay salespeople by purchase invoice, outside Business Central or through payroll, and print the payment advice.
updated: applies-to: 2.0.0.0
Settlement routes: outside Business Central and payroll count as paid on settlement posting; purchase invoices count as paid when the invoice posts.
A settlement pays your salespeople the commission that is payable. Each salesperson is paid their own way: outside Business Central, through a purchase invoice to their vendor, or through payroll.
Before you start
On each Salesperson/Purchaser card, in the Commission group, set the Commission Payout Method:
- Outside Business Central: you pay by check, bank transfer or another system.
- Purchase Invoice: enter the Commission Vendor No., and set the Commission Expense Account on Commission Setup.
- Payroll: enter the Commission Payroll ID. See Export commission to payroll.
Create and post a settlement
- Search for Commission Settlements and choose New, or choose New Settlement on the role center.
- Fill in the Description, Posting Date and Pay Up To Date. To pay some salespeople only, use Salesperson Filter.
- Choose Suggest Lines. You get one line per commission entry: what is payable up to the Pay Up To Date, less what was already paid.
Suggest Lines fills in what each salesperson is owed.
- Check the lines. To see the problems that would stop posting, choose Test Report. Then choose Post.
- Outside Business Central and Payroll lines are paid at once.
- Purchase Invoice lines create one purchase invoice per vendor, on the Commission Expense Account, with the settlement number as Vendor Invoice No. The commission counts as paid when you post that purchase invoice.
- Choose Payment Advice to print, for each salesperson, the documents and amounts paid.
A settlement posts only while your Bitta Commission license is active (or in the 14 days after its Valid Until date), and only when every salesperson it pays has a seat of the license. Otherwise posting is refused with a message that says why. Give the salesperson a seat on the Commission License page, then post again. The commission is withheld, not lost. See Subscription and license.
What Suggest Lines leaves out
- Entries on hold.
- Entries already on another settlement that is not posted.
- Salespeople whose lines add up to less than zero. You get a message, and their balance carries forward to the next settlement. To settle them too, turn on Settle Negative Balances on Commission Setup (see below).
Example:
| Salesperson | Lines | Total | Result |
|---|---|---|---|
| MAYA | +340.00, +50.00, +250.00, -30.00 (a return) | 610.00 | Paid 610.00. The -30.00 line is a clawback. |
| DANIEL | +20.00, -80.00 | -60.00 | Left out. The balance carries forward. |
Settle negative balances
When a salesperson owes commission back, for example after a return, their balance is negative. By default it carries forward until new commission covers it. To recover it at once, turn on Settle Negative Balances on Commission Setup. Then Suggest Lines keeps salespeople whose commission adds up to less than zero, and posting the settlement recovers the amount:
- Purchase Invoice: a purchase credit memo to the salesperson's vendor. The commission counts as recovered when you post it.
- Payroll: a negative row in the payroll file.
- Outside Business Central: a negative payment is recorded.
Settlement purchase documents are locked
The purchase invoices and credit memos a settlement creates carry the settlement's amounts. Their vendor, currency, accounts, quantities and amounts cannot be changed, because posting them records those amounts as paid. To pay a different amount, delete the unposted document. That deletes its settlement lines and frees the commission, so you can correct the commission and post a new settlement.
Undo a payment
- Outside Business Central and Payroll lines: choose Reverse on the posted settlement.
- Purchase Invoice lines: choose Cancel on the posted purchase invoice, or post a purchase credit memo for the whole invoice, applied to it. A credit memo for only part of the invoice is an ordinary adjustment with the vendor, and the commission stays paid.
The commission becomes payable again, and can be paid on a new settlement.
When an entry on the settlement was reversed on Commission Ledger Entries after the settlement paid it, Reverse names that entry first. The entry's reversal already took the payment back, and reversing the settlement takes it back again, so the next settlement pays it back. The question shows what is to be paid to the salesperson after the reversal, and the line that pays it back says Paid back: returned twice, on the settlement and on the statement. In the end the salesperson gets exactly the commission they earned.
- Correct on the posted purchase invoice cancels it and creates a new invoice. Posting the new invoice pays the commission once more, so the vendor and the commission ledger stay in step.
- Cancel on the credit memo that cancelled a settlement invoice posts a new invoice. That pays the commission again, too.
Deleting an unposted purchase invoice from a settlement deletes its settlement lines, so the commission can be suggested again. A posted settlement cannot be deleted.
From the settlement
Choose Find entries (Ctrl+Alt+Q) on a posted or reversed settlement, on its card or in the Commission Settlements list. The list shows the Commission Settlement itself, every Detailed Commission Entry the settlement paid or reversed (also those paid through its purchase invoices), and the G/L entries posted under its number.
Use Purchase Invoices, Posted Purchase Invoices, Purchase Credit Memos, Posted Purchase Credit Memos and Paid Entries to see what the settlement created. On a line, Ledger Entry opens the commission entry.