Categories of Earnings by Range

The Categories of Earnings by Range report uses the Payroll Register by Date Range topic to display date range sums for earning categories by employee. Administrators can use this report to analyze earning amounts by category for a custom date range.

Fields

Fields included in the report template
Field Name	Group by	Sort Order	Totals
Pay Group	Yes	Ascending
Legal Entity	Yes	Ascending
Employee
Normal Earnings			Column: Sum
Taxable Benefits			Column: Sum
Reimbursements			Column: Sum
Memos			Column: Sum

Custom Fields

Normal Earnings

The Normal Earnings custom field displays the amount of normal earnings for the current range. It uses the following expression:

CASE
    WHEN PRPayRunRegisterPeriod.RecordType = 'Earning'
         AND PRPayRunRegisterPeriod.RecordCategory = 'Normal' THEN PRPayRunRegisterPeriod.Amount
    ELSE 0.00
END

Taxable Benefits

The Taxable Benefits custom field displays the amount of taxable benefits for the current range. It uses the following expression:

CASE
    WHEN PRPayRunRegisterPeriod.RecordType = 'Earning'
         AND PRPayRunRegisterPeriod.RecordCategory = 'Taxable Benefit' THEN PRPayRunRegisterPeriod.Amount
    ELSE 0.00
END

Reimbursements

The Reimbursements custom field displays the amount of reimbursements for the current range. It uses the following expression:

CASE
    WHEN PRPayRunRegisterPeriod.RecordType = 'Earning'
         AND PRPayRunRegisterPeriod.RecordCategory = 'Reimbursement' THEN PRPayRunRegisterPeriod.Amount
    ELSE 0.00
END

Memos

The Memos custom field displays the amount of memo earnings for the current range. It uses the following expression:

CASE
    WHEN PRPayRunRegisterPeriod.RecordType = 'Earning'
         AND PRPayRunRegisterPeriod.RecordCategory = 'Memo Calc' THEN PRPayRunRegisterPeriod.Amount
    ELSE 0.00
END

Filters

The template includes the following filters:

Report filters.