Best Practice
- Recommendation - RDA recommends running the Gross Comparison Report AFTER Approving Jobs Not Paid. This report allows comparison of the Gross Pay Amounts from the CURRENT Payroll with a similar PREVIOUS Payroll. The Gross Comparison Report is ONLY available to Enterprise Clients, or with the purchase of Payroll Software Bundle PR30: Comparison Reports.
Gross Comparison Report
1. HR → Payroll → Start Tab → Gross Comparison Report
Select and Range Tab
2. Pay Identification (left): Choose the CURRENT Pay ID in the Dropdown
3. Pay Identification (right): Choose the PREVIOUS Pay ID (CANNOT be set as Historical) in the Dropdown for Comparison of Gross Amounts
4. Sort By: Choose to Sort by Pay Location, Pay Group, Work Location, or None in the Dropdown
5. Sort Employee By: Choose to Sort the Employees by Personnel ID, Last Name, or Social Security Number in the Dropdown
6. Select When Current Employee False: Select to Include CURRENT/Active Employees (recommended)
7. Select When Current Employee True: Select to Include FORMER/Inactive/Terminated Employees (recommended)
8. Choose the Range Criteria (optional) based on the following options:
- Primary Function
- Personnel ID
- Job Number
- Position ID
- Gross ID
- Rate ID
- Difference
- Pay Location
- Pay Group
- Work Location
- Source User
- Marital Status
- Sex
- Source
NOTE: Ranging on Pay Group and/or Rate ID to limit the Jobs to those Paid with Fixed Amounts (Ex: Salaries and/or Supplements) can be helpful. Normally after the start of the Fiscal Year, the Salaries and Supplements would NOT fluctuate every Pay Period, so there would be MINIMAL differences; but Hourly or Daily Paid Jobs do typically fluctuate every Pay Period, so there could be multiple differences for those Jobs.
9. Click Select to Run the Report
NOTE: The report lists Personnel ID, Name, Job #, Rate ID, and then Units and Gross for Each of the TWO Payrolls, and the Differences (+/-) between the two. A comparison of the Totals is provided at the bottom of the Report; included are side-by-side Salary, Salary Adjust, Adjustments, Hourly Units, Overtime Base, Overtime Above, Daily Units, Sick, Vacation, etc. ALL of the differences on this report should be Verifiable.
NOTE: IF an UNEXPECTED DIFFERENCE appears, Unselect the Employee/Job from the Payroll and make the necessary corrections.
NOTE: RDA recommends running the Total Select Payroll Report once the information on the Gross Comparison Report has been Reviewed.