How to Create a Balance Exception Report

In this example, you create a balance exception and run the Balance Exception Report to compare the total payments made to your employees for the current payroll period with the payments you made in the previous payroll period.

Before you create and run the Balance Exception Report, you must create a balance exception for this example.

Create a Balance Exception

Let's look at the steps to create a balance exception to compare the net pay amounts for the current and the previous period.

1. On the Home page, click the Balance Exceptions quick action under the My Client Groups tab.

2. Click Create.

3. Select a legislative data group and click OK.

4. Complete the fields as shown in this table:

   Field	Value
   Balance Exception Name	Compare Net Payment Amounts to the Previous Period
   Comparison Type	Previous period
   Comparison Value	1 For comparison types that begin with Previous, the application enters 1 as the default value and makes it read only.
   Balance Name	Net Payment
   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.

5. Click Submit.

Create a Balance Exception Report

1. On the Home page, click the Balance Exceptions and Reports quick action under the My Client Groups tab.

2. Click Create.

3. Select the same legislative data group you selected in the previous task and click OK.

4. Complete the fields as shown in this table:

   Field	Value
   Exception Report Name	Compare Net Payment Amounts to the Previous Period
   Consolidation Group	Select a value to restrict this exception report to a specific consolidation group. Leave blank to not restrict the output or to decide at the time of report submission.
   Payroll	Select a value to restrict this exception report to a specific payroll. Leave blank to decide at the time of report submission, where payroll is a required parameter.

5. Click Add.

6. Select the Compare Net Payment Amounts to the Previous Period balance exception name and then click OK.

7. Click Submit.

Run the Balance Exception Report

1. On the Home page, click the Submit a Flow quick action under the My Client Groups tab.

2. Select the same legislative data group as in the previous tasks.

3. Select the Run Balance Exception Report flow pattern and then click Next.

4. Complete the fields as shown in this table:

   Field	Value
   Payroll Flow	Enter an appropriate name for this instance of the report.
   Process End Date	Enter a value.
   Balance Exception Report	Compare Net Payment Amounts to the Previous Period
   Payroll	Select a value to restrict this exception report to a specific payroll. Enter the same name as in the previous task, if one was specified.

5. Click Next.

   When you enter information on the Linked Flow section of the Submit a Flow page, select Current Flow as the payroll flow and Run Balance Exception Report as the task to ensure the report uses the payroll balances results for the current payroll flow.

6. Click Next.

7. Click Submit.

   When you submit a flow, it creates an instance of the flow, the application generates a checklist by default.

8. Click OK and View Checklist.

9. In the task list click the Run Balance Exception Report. View and monitor the status of the flow on this page.

10. Click on the on the task to go to the Process Results Details page.

11. You can view the output from the Output and Log files section.