Understanding Balance Exceptions

Balance exceptions define the criteria you use to identify overpayments, underpayments, and trends. The variance may also be a result of incorrect setup or adjustment.

For example, as a payroll manager, to identify exceptional sales staff in the organization, you may want to run a report that lists sales staff whose commissions increased by 25 percent compared to their averages for the previous 3 months. You can set up a balance exception using values as shown in this table.

Field

Values

Balance Exception Name

Commission Increases Over 25 Percent

Comparison Type

Average in Months

Comparison Value

3

Balance Name

Commissions

Dimension Name

Relationship Month to Date

Variance Type

Percent

Variance Operator

Greater than

Variance Value

25

Severity Level

3

Note:

Enter a lower value for a high priority exception.

Use the Balance Exceptions task to create a balance exception and consider these components when you create a balance exception.
  • Comparison Types
  • Variance Operators
  • Severity Level
  • Formula Variance Type
  • Balance Variance Type
  • Run Dimension Support
  • Flow Connector Support