The To-Date Gross to Net Summary by Range report uses the Payroll Register by Date Range topic to display a row for each total: earnings, deductions, garnishments, taxes, and net, with records grouped by employee. The report contains columns for date range, MTD, QTD, and YTD amounts. Administrators can use this report to review employee totals for month, quarter, year, and date range, for each record type.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Pay Group | Yes | Ascending | |
| Legal Entity | Yes | Ascending | |
| Employee | Yes | A to Z | |
| Record Type | A to Z | ||
| Date Range Amount | Column: Sum | ||
| MTD Amount | Column: Sum | ||
| QTD Amount | Column: Sum | ||
| YTD Amount | Column: Sum | ||
| Record Order |
Filters
The template includes the following filters: