Variance reporting
Description

Variance reports help you spot potential payroll mistakes and changes in Sage 50 Payroll - reducing risks and errors.

This feature:

  • Alerts you to variances in employees’ pay
  • Prompts you when to run the report, if variances are found
Cause
Resolution


Customise your variance settings

Variance reports look for differences between periods that you specify. Before you start using this function, you need to customise your variance settings.

  1. Click Company, then click Variance Settings.
  2. In the Include column, for each item, click the drop-down button.
  3. Select Yes to include an item or No to exclude an item.
  4. In the Variance Type column, for each item, click the drop-down button.
  5. For each item, choose whether you want to look for a fixed amount or percentage variance.
  6. In the Variance column, enter the value of the variance you want to show.
  7. Choose whether you want to base the variance upon Average Pay or Last Update Values.
  8. Select the Advise when variances occur checkbox.
  9. To check for variances in specified payments or deductions, click the Payments or Deduction tab, then repeat Steps 2 to 6.
  10. Click OK.

Print your variance settings

To print your variance settings in a report, follow the steps below.

  1. Click Reports, then click Company.
  2. Select the relevant Variance Settings Report, then click Print.
  3. Click OK, then close the report browser window.

Check for variances and exceptions

When you open Pre-update Reports, your software checks for variances based on the settings you've entered.

  1. Click Payroll, then click Pre-update Reports.
  2. If a message appears saying your software found any variances, click Yes.
  3. Click Print, then click OK.
  4. Click Close.

If your software detects a variance, ensure the employees' payments are correct before you update records.


Print extra reports

You can also print other reports that include employees based on pay amounts that you enter.

  1. Click Reports window, click Analysis.
  2. Double-click the Gross Pay Exceptions Report, then enter a maximum value for gross pay.
  3. Click OK, then click Print.
  4. Click OK, then click Close.
  5. Double-click the Net Pay Exceptions Report, then enter a maximum value for net pay.
  6. Click OK, then click Print.
  7. Click OK, then click Close.

 

Steps to duplicate
Related Solutions