Total Earnings by Employee

The Total Earnings by Employee report uses the HR Compliance topic to display data based on employee earnings, taxes, and employer deductions. You can use this report to identify and analyze the cause of any pay disparities in your organization.

Fields

Fields included in the report template

Field Name	Group by	Sort Order	Totals
Employee	Yes	A to Z
Location	Yes	Ascending
Record Order		A to Z
Pay Grade
Pay Policy
Status
Base Salary
Record Type
Amount

Custom Fields

Amount

The Amount field displays the year-to-date amount. It uses the following expression:

CASE
    WHEN PRPayRunRegister.RecordType = 'Earning' THEN PRPayRunRegister.PayRunAmountYTD
    WHEN PRPayRunRegister.RecordType = 'Tax'
         AND PRPayRunRegister.ImpactsNetPay = 'False' THEN PRPayRunRegister.PayRunAmountYTD
    ELSE 0.00
END

Filters

The template includes the following filters: