Employee payroll by payroll plan report
The Employee payroll by payroll plan report breaks down payroll data by the individual payroll plans assigned to each employee. Where a typical payroll summary aggregates one row per employee, this report shows one row per (employee x payroll plan) -- useful when employees are enrolled in multiple plans or compensated under different structures.
Before you begin
- Run the Employee Payroll Summary report first to ensure the underlying data is accurate.
- Pay periods must be configured at the center.
Permission: Payroll (under View Employee Reports) β Required to access this report. Grant it on the View Employee Reports row in the Employee Manager section of the security role (Configuration > Security > Security roles > the role > Permissions).
Navigation: Employee > Payroll > select By Payroll Plan
Report details
| Aspect | Detail |
|---|---|
| Purpose | View pay-period earnings broken down by each payroll plan applied to the employee |
| Filters | Cycle (Monthly / Bi-weekly / Specific pay period) |
| View scope | Center |
Note: Hours such as Regular Hours, Service Hours, and Total Hours are shown in decimal format -- for example, 8 hours and 30 minutes appears as 8.50.
Columns
| Column | Description |
|---|---|
| Employee Code | Unique identifier for the employee. |
| First Name | Employee's first name. |
| Last Name | Employee's last name. |
| Employee Name | Full name (First Name + Last Name). |
| Job | Job role assigned to the employee. |
| Plan Name | Name of the payroll plan assigned to the employee, for example "Service Commission - Tier 1". |
| Plan Code | Unique code for the payroll plan. |
| Plan Type | Type of plan: Service commission, Product commission, Pay rate based on revenue, etc. |
| Revenue From | Source of revenue the plan uses for commission (Services, Products, or both). |
| Revenue range based on | How the revenue slab is calculated: Total Revenue, Sale Price Before Discount per production hour, Revenue per production hour, etc. |
| Commission(%) | Percentage commission awarded on qualifying revenue. |
| Commission Flat | Flat commission amount, if the plan uses a flat amount. |
| Total Commission | Total commission earned under the plan for the pay period. |
| Slab Identifier | Reference ID or name for the commission slab that applied. |
| Configured At | Whether the plan is configured at employee or job level. |
| Sale price before discount | Original sale price of the item or service before any discount. |
| Production hours | Total production hours worked in the pay period. |
| Total Hours | Total hours worked (production + non-production). |
| Revenue | Revenue credited to the employee (net or gross depending on settings). |
| Pay Rate | Hourly rate paid to the employee, if hourly pay is configured alongside commission. |
Tips
- Use this report when employees are on more than one plan or have plan-specific revenue slabs you want to validate before payroll.