Gross to Net MTD by Pay

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

Custom Fields

MTD Gross

The MTD Gross custom field displays the MTD total gross. It uses the following expression:

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

MTD Deductions

The MTD Deductions custom field displays the MTD total deduction. It uses the following expression:

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

MTD Garnishments

The MTD Garnishments custom field displays the MTD total garnishments. It uses the following expression:

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

MTD Taxes

The MTD Taxes custom field displays the MTD total tax. It uses the following expression:

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

MTD Net

The MTD Net custom field displays the MTD total net. 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

Filters

The template contains the following filters: