Skip to content
Bitta Apps

Chapter 4 of 5Page 6 of 7

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 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.

The Commission Manager role center with the Payment, Start, This Month and Needs Attention tiles

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.

Next step

Ready to try Bitta Commission?