The Categories of Deductions by Range report uses the Payroll Register by Date Range topic to display a list of employees and their total deductions for each category within the specified date range. You can use this report to analyze deduction amounts by category for a custom date range.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Pay Group | Yes | Ascending | |
| Legal Entity | Yes | Ascending | |
| Employee | |||
| Deferred Comp | Column: Sum | ||
| Pre Tax | Column: Sum | ||
| Post Tax | Column: Sum |
Custom Fields
Deferred Comp
The Deferred Comp custom field displays the deferred comp deductions. It uses the following expression:
CASE
WHEN PRPayRunRegisterPeriod.RecordType = 'Deduction'
AND PRPayRunRegisterPeriod.RecordCategory = 'Deferred Compensation' THEN PRPayRunRegisterPeriod.Amount
ELSE 0.00
END
Pre Tax
The Pre Tax custom field displays the pre-tax deductions. It uses the following expression:
CASE
WHEN PRPayRunRegisterPeriod.RecordType = 'Deduction'
AND PRPayRunRegisterPeriod.RecordCategory = 'Pre-Tax' THEN PRPayRunRegisterPeriod.Amount
ELSE 0.00
END
Post Tax
The Post Tax custom field displays the post-tax deductions. It uses the following expression:
CASE
WHEN PRPayRunRegisterPeriod.RecordType = 'Deduction'
AND PRPayRunRegisterPeriod.RecordCategory = 'Post-Tax' THEN PRPayRunRegisterPeriod.Amount
ELSE 0.00
END
Filters
The template includes the following filters: