Examples of Balance Exceptions

Here are two examples to illustrate two different types of balance exceptions that you may want to include in your balance exception report.

Track Increases in Commissions

Your company plans to train incoming sales staff on productivity techniques. To identify exceptional sales staff in the organization, you can run a report that lists workers whose commissions increased by 25 percent compared to their averages for the previous 3 months. You can set up a balance exception using the values 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.

Track Gross Earnings

Before you certify the current payroll run, as a payroll manager, you may want to know if the current gross payments are in line with the previous payroll run. The previous run verified the established levels of earnings that the company wants to maintain for the remainder of the quarter. This table provides an example of the values you enter to set up a balance exception to find out if the current gross earnings exceeds the gross earnings of the previous period by more than 10 percent:

Field

Values

Balance Exception Name

Gross Earnings

Comparison Type

Previous period

Comparison Value

1

Balance Name

Gross Earnings

Dimension Name

Relationship Period to Date

Variance Type

Percent

Variance Operator

Greater than

Variance Value

10

Severity Level

1

Note: Enter a lower value for a high priority exception.