Example: Audit Workers with Net or Gross Variance
This example illustrates how to create an audit rule for comparing prior pay periods'
gross and net to the current period.
You want to see if there are any significant differences with USA West Region workers' net and
gross pay from the prior period payroll to catch any discrepancies. You also want to
exclude the Executive pay group because that pay group normally has variances
greater than 10%. You create an audit rule that finds workers in the USA West Region
excluding Executive Pay Groups that have a net or gross variance greater than
10%.
Create a:
- Executive (Monthly): Bonus Quarterly pay group.
- Executive (Monthly): Regular (Monthly) pay group.
- USA - Western US region.
Security:
Set Up: Payroll (Reporting)
domain in the Core Payroll area.- Access theMaintain Payroll Audit Configurationstask.
- On thePrior Period Comparisontab, clickCreate.
- EnterNet/Gross Variance Threshold (exclude Execs)for theAudit Rule Name.
- SelectWorkerfor theReporting Level.
- Add a row on theWorker(s) to includegrid.
- On theWorker Eligibility Rulecolumn, selectCreate Payroll Audit Worker Eligibility.
- Create 2 worker eligibility rules with these values:Worker Eligibility NameFieldComparisonValueExclude: Executive Pay GroupsPay Group Detailnot in the selection listExecutive (Monthly): Bonus QuarterlyExecutive (Monthly): Regular (Monthly)Region: USA Western USRegionin the selection listUSA - Western US
- On thePay result(s) to includegrid, create 2 audit rule with these values:Audit Detail NameSeverityPayroll CalculationComparisonPercentageAmountNet > 10% VarianceWarningNetgreater than100Gross > 10% VarianceWarningGrossgreater than100
Run a payroll calculation and then run the audit rule with the
Run Payroll
Audit
task.