Gross to Net YTD by Pay

The Gross to Net YTD by Pay report uses the Payroll Register by Pay Run topic to display YTD total gross to net amounts by employee.

Fields

Fields included in the report template

Field Name	Group by	Sort Order	Totals
Pay Run Name	Yes	A to Z
Legal Entity	Yes	Ascending
Employee
YTD Gross			Column Total: Sum
YTD Deductions			Column Total: Sum
YTD Garnishments			Column Total: Sum
YTD Taxes			Column Total: Sum
YTD Net			Column Total: Sum

Custom Fields

YTD Gross

The YTD Gross custom field displays the YTD gross amount. It uses the following expression:

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

YTD Deductions

The YTD Deductions custom field displays the YTD deduction amount. It uses the following expression:

CASE
    WHEN PRPayRunRegister.RecordType = 'Deduction'
         AND PRPayRunRegister.ImpactsNetPay = 'True' THEN PRPayRunRegister.PayRunAmountYTD
    ELSE 0.00
END 

YTD Garnishments

The YTD Garnishments custom field displays the YTD gross amount. It uses the following expression:

CASE
    WHEN PRPayRunRegister.RecordType = 'Garnishment'
         AND PRPayRunRegister.ImpactsNetPay = 'True' THEN PRPayRunRegister.PayRunAmountYTD
    ELSE 0.00
END 

YTD Taxes

The YTD Taxes custom field displays the YTD taxes amount. It uses the following expression:

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

YTD Net

The YTD Net custom field displays the YTD net amount. It uses the following expression:

CASE
    WHEN PRPayRunRegister.RecordType = 'Earning'
         AND PRPayRunRegister.ImpactsNetPay = 'True' THEN PRPayRunRegister.PayRunAmountYTD
    ELSE CASE
             WHEN PRPayRunRegister.RecordType = 'Deduction'
                  AND PRPayRunRegister.ImpactsNetPay = 'True' THEN (PRPayRunRegister.PayRunAmountYTD * (-1))
             ELSE CASE
                      WHEN PRPayRunRegister.RecordType = 'Tax'
                           AND PRPayRunRegister.ImpactsNetPay = 'True' THEN (PRPayRunRegister.PayRunAmountYTD * (-1))
                      ELSE CASE
                               WHEN PRPayRunRegister.RecordType = 'Garnishment'
                                    AND PRPayRunRegister.ImpactsNetPay = 'True' THEN (PRPayRunRegister.PayRunAmountYTD * (-1))
                               ELSE 0.00
                           END
                  END
         END
END

Filters

The template contains the following filters: