To-Date Net Pay by Pay

The To-Date Net Pay by Pay report uses the Payroll Register by Pay Run topic to display current, month-to-date, quarter-to-date, and year-to-date net pay amounts. Administrators can use this report to view the detailed amounts of net pay (individual codes and custom sub-sets) for reconciling totals to bank statements.

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	Yes	A to Z
Current Net Pay			Column Total: Sum
MTD Net Pay			Column Total: Sum
QTD Net Pay			Column Total: Sum
YTD Net Pay			Column Total: Sum

Custom Fields

Current Net Pay

The Current Net Pay custom field displays the current net pay amount. It uses the following expression:

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

MTD Net Pay

The MTD Net Pay custom field displays the MTD net pay amount. It uses the following expression:

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

QTD Net Pay

The QTD Net Pay custom field displays the QTD net pay 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

YTD Net Pay

The YTD Net Pay custom field displays the YTD net pay 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 includes the following filters:

Report filters.