Pay commission
Reports and the role center
The Commission Manager role center, statements, analysis, forecast, liability, reconciliation and exceptions.
updated: applies-to: 2.0.0.0
The role center shows amounts to pay and entries needing attention; liability and exception reports support month-end review.
The Commission Manager role center brings together the work of paying commission, and the reports answer the usual questions from salespeople, finance and auditors.
The Commission Manager role center
Choose the Commission Manager profile in My Settings.
What is owed, what waits, this month's earnings and what needs attention.
- Payment: To Be Paid (LCY), Awaiting Release (LCY), Open Settlements and Last Settlement (LCY).
- Start: New Settlement.
- This Month: Earned This Month (LCY) and Entries This Month.
- Needs Attention: Entries on Hold, Waiting for Release, Earned, Not Accrued (LCY) (only when Accrue in G/L is on) and Journal Lines.
- Navigation to settlements, commission entries, plans, assignments, teams, targets, salespeople, the Commission License and every setup page.
Each tile opens the entries it adds up.
Reports
Bitta Commission has 22 reports. Each one prints with its RDLC layout by default. Several also have Excel layouts, and Commission Statement and Commission Settlement also have Word layouts. An administrator can choose another layout on the Report Layouts page.
| Report | Answers | Options |
|---|---|---|
| Commission Statement | For each salesperson: to be paid at the start, earned, payable, paid and to be paid at the end, with detail lines. | Starting Date, Ending Date |
| Commission Pay Advice | A pay advice per salesperson for a whole period, grouped by customer, with the amount carried forward. | Commission Period, Starting Date, Ending Date |
| Commission Analysis | Every earning line with base, cost, margin, rate and commission, for pivot tables. | Salesperson, Plan, Customer, No. filters |
| Commission Forecast | What open quotes, orders and invoices will earn, per salesperson and shipment month. | Document filters, Earning Salesperson Filter |
| Commission Liability | What is owed on a date: waiting for customer payment, payable but not paid, and on hold. Use it for month-end accruals. | As of Date |
| Commission Reconciliation | For each salesperson, from to-be-paid at the start to to-be-paid at the end, by type of entry. | Starting Date, Ending Date |
| Commission Comparison | The commission of two periods, per salesperson or plan, with the change and the change in percent. | Period A and Period B dates, Compare By, Amount Type |
| Commission Exceptions | Sales that earned nothing, entries on hold or waiting for release, salespeople paid more than payable, and settlement purchase invoices not yet posted. | Starting Date, Ending Date |
| Commission Setup Check | Gaps in the setup as of the work date, including license problems. | |
| Commission Settlement | The payment advice of a settlement. | Settlement No. |
Earning Salesperson Filter on the forecast shows the commission of the salespeople you choose, also on documents they share but are not the salesperson of.
The role center groups the other reports under Commission, Payout and Plans and Audit:
| Group | Reports |
|---|---|
| Commission | Commission by Salesperson, Commission Detail by Document, Commission by Customer, Commission by Item, Returns and Clawbacks |
| Payout | Unpaid Commission Aging, Commission Settlement Register, Commission Settlement - Test |
| Plans and Audit | Commission Plan Listing, Salesperson Plans, Held and Reassigned Entries, Commission Journal - Test |
Commission Scoreboard
Commission Scoreboard on the role center ranks salespeople by sales, commission earned or how much of their sales target they reached. See Teams, targets and the scoreboard.
Power BI and the API
To analyze commission in Power BI or another tool, use the analytics feeds and API pages. See Power BI and the API.
Send statements to salespeople
Run Commission Statement for the period and send it with Send to, or schedule it. Each salesperson sees the descriptions you entered on journal lines.
Good to know
- Start month-end with Commission Exceptions and Commission Liability.
- If Accrue in G/L is on, compare Commission Liability with the Accrued Commission Account balance. See Accrue commission in the general ledger.