Gross-to-Net Report
Use the Gross-to-Net Report to review balances generated from the payroll run, QuickPay, and payroll reversal calculations before calculating prepayments.
When to Run Report
The report displays the balances for the specified payroll period. Before you run the report, ensure that the payroll or QuickPay is run for the period for which you're running the report.
Parameters to Consider
Parameter values determine which records to include in a report. Most parameters are self-explanatory, but some of them, as mentioned in this table have special meaning in the context of the report.
| Parameter Name | Description |
|---|---|
| Process Start Date |
Use this field to specify the first effective date of the payroll process to include in the report. All processes with an effective date same or greater than the Process Start Date are reported. |
| Process End Date | Use this field to specify the last effective date of the payroll process to include in the report. For payroll runs, this is the 'Payroll Run Date'. All processes with an effective date equal to or before the Process End Date are reported. |
| Scope | Select Summary to display gross-to-net balances for each
payroll. The report doesn’t display the breakdown of the balances by
the process date. Select Detail to display a more detailed breakdown for different sets of process dates. |
| Report Category | A report category is a group of delivery options. Select a value to identify the set of delivery options for this report submission. You can define your own delivery option and include it in the report category. For example, you can define a report category to use a combination of both PDF and Excel delivery options for a single submission of the report. |
| Run Mode |
Use this parameter to decide if the extract-based report must retain or discard the transient data created during the report execution. The default value is Normal, the temporary transient data produced during report execution is discarded. Select the Debug option only to investigate an issue with the report output or when instructed by Oracle Support. |
| Display All Hours |
Select Yes to include hours from Supplemental Earnings and other element classifications. The default value is No and only hours from Regular or Standard Earnings and Absence Earnings are shown in the report. |
Consolidation Group Support
Use the Consolidation Group parameter to restrict the summary balances shown on the Gross-to-Net report to only those run results produced by payroll processes that are run with the same consolidation group as the report.
For example, you may run multiple off-cycle payroll runs or QuickPay runs to accommodate exceptions, such as late payments or final payments for terminated employees. You can now run the Gross-to-Net report to capture the gross-to-net summary balances of the off-cycle runs by using the same consolidation group to run the off-cycle runs and the Gross-to-Net report.
Flow Connector Support
Use flow connectors with the Gross-to-Net Summary report to combine data from different flows together in the report.
For example, you may have a requirement to generate separate payments and reports for the regular on-cycle payroll runs and the off-cycle payroll run results. Include the Gross-to-Net report in your flow pattern and define flow connector rules to segregate and consolidate separately the multiple off-cycle run results and the regular on-cycle run results. The defined flow connector rules consolidate and capture automatically the gross to net totals for the off-cycle and on-cycle run results separately, on flow submission.
Report Output
You can generate the report and view either the summary or detail report output, depending on your selection of the Scope parameter.
Summary Report
The Summary mode displays gross-to-net balances for each payroll. It doesn’t display the breakdown of the balances by the process date. In addition to the gross-to-net balances, the report also displays employer liabilities and hours balances.
The PDF output has these summary sections with subtotals in each section as given here:
-
Balance Categories Summary
-
Balances Summary section displays balances with subtotals for each balance category.
-
Balances by PSU and TRU Summary section is the same as the Balance Categories Summary but broken down for each PSU and TRU.
-
Balances by Payroll section shows the same information as the prior two sections but broken down for each PSU, TRU and payroll.
-
Balance Categories Summary
-
Balances Summary
-
Detail Report
Run the report in the Detail mode for a more detailed breakdown of the balances by the process date range. This breakdown is required only if you notice a discrepancy in the Gross-to-Net balances in summary mode.
For example, if you run the Gross-to-Net report for the period 01, January 2018 to 31, March 2018 for a monthly payroll. The summary version of the report displays the overall gross-to-net balances for all the processes within the three month period. The detail version of the report displays three different sections, each showing the gross to net balances for all payroll processes for that month.
In addition to the summary sections shown by the Summary report, the detail report also shows the following:
-
Balance Categories Summary
-
Balances Summary section displays balances with subtotals for each balance category.
-
Balances by PSU and TRU Summary section is the same as the Balance Categories Summary but broken down for each PSU and TRU.
-
Balances by Payroll and Process Date Range section shows the same information as the prior two sections but broken down for each PSU, TRU and payroll process date range.
-
Balance Categories Summary
-
Balances Summary
-