Gross to Net QTD by Pay

The Gross to Net QTD by Pay report uses the Payroll Register by Pay Run topic to display quarter-to-date 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
QTD Gross			Column Total: Sum
QTD Deductions			Column Total: Sum
QTD Garnishments			Column Total: Sum
QTD Taxes			Column Total: Sum
QTD Net			Column Total: Sum

Custom Fields

QTD Gross

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

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

QTD Deductions

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

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

QTD Garnishments

The QTD Garnishments custom field displays the QTD garnishment amount. It uses the following expression:

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

QTD Taxes

The QTD Taxes custom field displays the QTD tax amount. It uses the following expression:

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

QTD Net

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

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

Filters

The template contains the following filters: