Gross to Net by Range

The Gross to Net by Range report uses the Payroll Register by Date Range topic to display a list of employees with their totals for the specified date range of gross, deduction, garnishment, tax, and net.

Fields

Fields included in the report template

Field Name	Group by	Sort Order	Totals
Pay Group	Yes	Ascending
Legal Entity	Yes	Ascending
Employee		A to Z
Gross			Column: Sum
Deduction			Column: Sum
Garnishment			Column: Sum
Tax			Column: Sum
Net			Column: Sum

Custom Fields

Gross

The Gross field displays the gross amount for the date range. It uses the following expression:

CASE
    WHEN PRPayRunRegisterPeriod.RecordType = 'Earning'
         AND PRPayRunRegisterPeriod.ImpactsNetPay = 'True' THEN PRPayRunRegisterPeriod.Amount
    ELSE 0.00
END

Deductions

The Deductions field displays the deduction amount for the date range. It uses the following expression:

CASE
    WHEN PRPayRunRegisterPeriod.RecordType = 'Deduction'
         AND PRPayRunRegisterPeriod.ImpactsNetPay = 'True' THEN PRPayRunRegisterPeriod.Amount
    ELSE 0.00
END

Garnishments

The Garnishments field displays the garnishments amount for the date range. It uses the following expression:

CASE
    WHEN PRPayRunRegisterPeriod.RecordType = 'Garnishment'
         AND PRPayRunRegisterPeriod.ImpactsNetPay = 'True' THEN PRPayRunRegisterPeriod.Amount
    ELSE 0.00
END

Taxes

The Taxes field displays the tax amount for the date range. It uses the following expression:

CASE
    WHEN PRPayRunRegisterPeriod.RecordType = 'Tax'
         AND PRPayRunRegisterPeriod.ImpactsNetPay = 'True' THEN PRPayRunRegisterPeriod.Amount
    ELSE 0.00
END

Net

The Net field displays the net amount for the date range. It uses the following expression:

CASE
    WHEN PRPayRunRegisterPeriod.RecordType = 'Net' THEN PRPayRunRegisterPeriod.Amount
    ELSE 0.00
END

Filters

The template includes the following filters: