Skip to main content
Administrator Guide
Last Updated: 2023-06-23
Example: Audit Workers with Net or Gross Variance

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.
  1. Access the
    Maintain Payroll Audit Configurations
    task.
  2. On the
    Prior Period Comparison
    tab, click
    Create
    .
  3. Enter
    Net/Gross Variance Threshold (exclude Execs)
    for the
    Audit Rule Name
    .
  4. Select
    Worker
    for the
    Reporting Level
    .
  5. Add a row on the
    Worker(s) to include
    grid.
  6. On the
    Worker Eligibility Rule
    column, select
    Create Payroll Audit Worker Eligibility
    .
  7. Create 2 worker eligibility rules with these values:
    Worker Eligibility Name
    Field
    Comparison
    Value
    Exclude: Executive Pay Groups
    Pay Group Detail
    not in the selection list
    Executive (Monthly): Bonus Quarterly
    Executive (Monthly): Regular (Monthly)
    Region: USA Western US
    Region
    in the selection list
    USA - Western US
  8. On the
    Pay result(s) to include
    grid, create 2 audit rule with these values:
    Audit Detail Name
    Severity
    Payroll Calculation
    Comparison
    Percentage
    Amount
    Net > 10% Variance
    Warning
    Net
    greater than
    10
    0
    Gross > 10% Variance
    Warning
    Gross
    greater than
    10
    0
Run a payroll calculation and then run the audit rule with the
Run Payroll Audit
task.