Using the Sartox Payroll Verification Spreadsheet
Using the CCI Payroll Verification Spreadsheet
|
Open the Payroll Verification Spreadsheet
|
|
|
Enter the date of the PREVIOUS payroll run that you would like to compare the current QDE with.
Click on the Refresh Data button
|
|
|
For each person listed, you will be able to see if the current information in the QDE is the same as the last pay run or if it is different in some way (Beg Gross, Net Amts or Ded Amounts).
|
|
|
For example, if the Gross Amounts are different from the previous run, it will show as a “Difference”.
|
|
|
If the amounts are the same as the previous pay run in all areas (Beg Gross, Net Amt and Deductions) then the line will show as “Verified”
|
|
|
To review the entries that have a difference, click on the line that you would like to review.
Click on the View Comparison button
|
|
|
This will provide you with the details from the current pay run as well as the previous pay run with the differences highlighted in red.
Notice that you have a “Verified” and a “Follow-up” button. When you review the detailed information, you can mark this line using either button. The Verified button will mark the line as “Verified” and it will show in yellow along with the originally verified lines. The Follow-up button can be used to mark a line where you need to do additional investigation.
|
|
|
Note that you can also filter on the Verified? Column. For example, to see all lines marked with a “Difference”, filter on “Difference” in the Verified? column
|
|
Related Articles
Obtaining Counts for the SS300 Report using Payroll History Spreadsheet - Sartox
Obtaining Counts for the SS300 Report using your Payroll History Spreadsheet - Sartox Select the year that you need to obtain information for. Select “List of Object Codes” from the drop down list. List all of the object codes that apply to the ...Position Counts for Salaried Positions – Payroll Assignments
Position Counts for Salaried Positions – Payroll Assignments Spreadsheet Select “Type of Pay – S” on the Settings tab. Using this setting will bring in all employees that are coded as Salaried. Note that this will also bring in supplemental and ...Obtaining Counts for the SS300 Report using Payroll History Spreadsheet - LINQ
Obtaining Counts for the SS300 Report using your Payroll History Spreadsheet - LINQ Select the year that you need to obtain information for. Select “List of Object Codes” from the drop down list. List all of the object codes that apply to the ...Position Counts for Salaried Positions – Payroll Assignments Spreadsheet
Position Counts for Salaried Positions – Payroll Assignments Spreadsheet Select “Type of Pay – S” on the Settings tab. Using this setting will bring in all employees that are coded as Salaried. Note that this will also bring in supplemental and other ...Using the CCI Spreadsheets to determine who has worked more than 30 hours
Using the CCI Spreadsheets to determine who has worked more than 30 hours This example will show you how to format your payroll history pivot table to highlight hourly employees that have greater than 30 hours per week. Remember – you can’t hurt ...