YTD Wage Analysis by Pay

The YTD Wage Analysis by Pay report is based on the Payroll Register by Pay Run topic. This report allows you to compare wage-impacting earnings and deductions against agency wages. You can use the report to review limited YTD wages and the resulting YTD tax accumulation.

Fields

Fields included in the report template

Field Name	Group by	Sort Order	Totals
Pay Group	Yes	Ascending
Legal Entity	Yes	Ascending
Employee	Yes	A to Z
Type
Category
Code
YTD Amount			Column: Sum
YTD Total Wages			Column: Sum
YTD Limited Wages			Column: Sum
YTD Tax			Column: Sum

Custom Fields

Type

The Type custom field displays the record type. It uses the following expression:

CASE
    WHEN PRPayRunRegister.RecordType = 'Earning' THEN CONCAT(' ', PRPayRunRegister.RecordType)
    WHEN PRPayRunRegister.IsWCBDeduction = 1 THEN 'WCB'
    ELSE PRPayRunRegister.RecordType
END

YTD Amount

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

CASE
    WHEN PRPayRunRegister.RecordType = 'Earning' THEN PRPayRunRegister.PayRunAmountYTD
    WHEN PRPayRunRegister.IsWCBDeduction = 1 THEN 0.00
    WHEN PRPayRunRegister.RecordType = 'Deduction' THEN -1 * PRPayRunRegister.PayRunAmountYTD
    ELSE 0.00
END

In the report, the data in this field is masked when the user role doesn't have the Payroll Pay Run Results access authorization.

YTD Tax

The YTD Tax custom field displays the year-to-date amount of tax for the employee. It uses the following expression:

CASE
    WHEN PRPayRunRegister.RecordType = 'Tax' THEN PRPayRunRegister.PayRunAmountYTD
    WHEN PRPayRunRegister.IsWCBDeduction = 1 THEN PRPayRunRegister.PayRunAmountYTD
    ELSE 0.00
END

In the report, the data in this field is masked when the user role doesn't have the Payroll Pay Run Results access authorization.

Filters

The template includes the following filters: