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.
-
On the Home page, click the Balance Exceptions quick action under the My Client Groups tab.
-
Click Create.
-
Select a legislative data group and click OK.
-
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.
-
Click Submit.
Create a Balance Exception Report
-
On the Home page, click the Balance Exceptions and Reports quick action under the My Client Groups tab.
-
Click Create.
-
Select the same legislative data group you selected in the previous task and click OK.
-
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.
-
Click Add.
-
Select the Compare Net Payment Amounts to the Previous Period balance exception name and then click OK.
-
Click Submit.
Run the Balance Exception Report
-
On the Home page, click the Submit a Flow quick action under the My Client Groups tab.
-
Select the same legislative data group as in the previous tasks.
-
Select the Run Balance Exception Report flow pattern and then click Next.
-
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.
-
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.
-
Click Next.
-
Click Submit.
When you submit a flow, it creates an instance of the flow, the application generates a checklist by default. -
Click OK and View Checklist.
-
In the task list click the Run Balance Exception Report. View and monitor the status of the flow on this page.
-
Click on the on the task to go to the Process Results Details page.
-
You can view the output from the Output and Log files section.