P4 Software
/
cifraHQ
Two Stimulsoft operations Reports show sales commissions:
Both Reports read the same commission ledger as the Commissions tab on each user, so their figures always agree with that tab and with the salesperson's commission balance.
Open Analytics > Operations Reports, select the Sales category, and choose the report. Set the date range and click Preview to open it in the report viewer, where you can print it or export it to PDF and Excel.
To print the statement for one salesperson, open the user from Setup > Users, go to the Commissions tab and click Print statement. Pick the period and click Open statement. The statement opens in the report viewer with that salesperson only. It opens even when they had no activity in the period.
The tiles at the top total the whole period: opening balance, commission earned, commission paid, and the amount owed at the close of the period.
The summary lists every salesperson with commission activity in the period or a balance at its start, with the most owed first:
| Column | Description |
|---|---|
| Opening | Commission owed to the salesperson at the start of the period |
| Earned | Commission from sales in the period, net of any voided payment |
| Adjustments | Credit notes and reassignments of balance between salespeople |
| Paid | What was paid through Payroll or with Pay, net of any Payroll reversed |
| Closing | What is still owed at the end of the period |
Closing always equals Opening + Earned + Adjustments - Paid. The totals row adds up every salesperson.
The detail, on a new page, lists each salesperson's commission movements in the period in date order. It shows the date, the type, the document (for example the sales order and line), the commission rule, the base amount, the percentage, the commission and the running balance. Each salesperson's detail closes with their closing balance.
Each page is one salesperson's statement:
Run from Analytics, the report prints a statement for every salesperson with activity or a balance, one per page. Run from Print statement on a user, it prints only that salesperson.
| Type | What it is |
|---|---|
| Earned | Commission on a sale, when the invoice is posted or paid, depending on your commission setting |
| Payment voided | A voided invoice payment that takes back commission earned on payment |
| Commission taken back | Commission an administrator took back from a fully credited invoice |
| Invoice voided | Commission taken back because its invoice was voided |
| Credit note | Commission taken back for returned goods |
| Reassigned | Balance moved to or from another salesperson |
| Paid by Payroll | Balance imported into a Payroll run |
| Payroll reversed | A Payroll run was deleted and the commission went back to the balance |
| Paid | Paid with the Pay button on the user |
Related: Users · Commission Rules · Salesperson Dashboard
Was this page helpful?