Gross-to-Net Report
Submit the Gross-to-Net Report to review balances generated from payroll run, QuickPay, and payroll reversal calculations before calculating prepayments. View summary or detail listings of the total results calculated in the payroll run.
The report displays the balances for the specified payroll period. Typically, you run the report after each payroll run or, at a minimum, on a quarterly basis.
Before you begin, ensure that the payroll or QuickPay is run for the period for which you're running the report. Run after each payroll run or, at a minimum, on a quarterly basis.
Use Submit a Flow under Payroll in My Client Groups on the Home page, and submit the Run Gross-to-Net Report task to run the report.
Report Parameters
The parameter values determine which records to include in the report. These parameters have special meaning in the context of this report.
Payroll
The name of the payroll you use to run this report.
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 prior to the Process End Date are reported.
Control which results to view by specifying a date range that includes the process dates of the payroll calculations. The results of the report depend on the number of payroll calculations completed for the payroll within the date range.
Here's an example of how you can generate a report that combines results from two payroll periods.
-
Calculate the payroll for semimonthly payrolls. Offset the process date of the first payroll run to the second payroll period. This table displays the balances for each payroll run.
Payroll Period
Process Date
Balance
Total
January 1 to 15
January 17
Standard Earnings
3200.00
Employee Tax Deductions
1106.66
Employer Liabilities
468.80
January 16 to 31
January 31
Standard Earnings
3200.00
Employee Tax Deductions
1391.73
Employer Liabilities
468.80
-
Submit the Gross-to-Net Report with a start date of January 16 and an end date of January 31.
Both process dates fall between the selected dates, so the report displays the combined results of both payrolls as shown in this table.
Summary
Totals
Standard Earnings
6400.00
Total Gross Pay
6400.00
Employee Tax Deductions
2498.39
Total Deductions
2498.39
Total Net
3901.61
Employer Liabilities
937.60
Total Liabilities
937.60
Total Cost
7337.70
Scope
Control the results of the report by specifying the scope of the report, as given in this table.
Scope Value |
Report Results |
---|---|
Summary |
Displays gross-to-net balances for each payroll. It doesn’t display the breakdown of the balances by the process date. |
Detail |
Provides 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 determine 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.
For more information, refer to Delivery Options for Extract-Based Payroll Reports topic in the Help Center.
Process Configuration Group
Use this field to run the report for a specific process configuration group, instead of the default one. A process configuration group is used to set rules for payroll processes, such as enabling logging or setting the number of threads. You can select a value only if you have a predefined process configuration group.
Use the Payroll Process Configuration task to define a Process Configuration Group, before you can use it here.
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 to do so.
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.
Report Details
Run the Gross-to-Net report in summary or detail mode.
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 sub-totals in each section as given here:
-
Balance Categories Summary
-
Balances Summary section displays balances with sub-totals 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 sub-totals 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
-