Balance Exception Report

Use the Balance Exception Report to identify potentially incorrect payments or amounts withheld. The report identifies values that vary for the same balance dimension. This variance could indicate overpayments or underpayments.

Use the Submit a Payroll Flow quick action under the My Client Groups tab to run this report.

Before you run this report:

  • Use the Balance Exceptions task to create a balance exception.

  • Use the Balance Exceptions and Reports task to create a balance exception report that groups together one or more balance exceptions.

  • Create an Exception Report Name that you can use to run the Balance Exception Report. For instance, you can create an Exception Report Name of Monthly Car Allowances Paid in Excess of the Previous Month, to determine the monthly car allowance paid to employees in excess of 600 more than the previous month.

Report Parameters

The parameter values determine which records to include in the report. For example, you can run this report for a specific consolidation group or payroll relationship group. Predefine these groups before you can use them. Most parameters are self-explanatory, while the following have special meaning in the context of this report.

Payroll Flow

The name of the payroll flow you use to run this report. The selected flow uniquely identifies a specific instance of the report execution.

Process Start Date

Use this field to specify the first effective date of the payroll process to include in the report. All processes with an effective date same or greater than the Process Start Date are reported.

Process End Date

Use this field to specify the last effective date of the payroll process to include in the report. For Payroll Runs this is the 'Payroll Run Date'. All processes with an effective date equal to or prior to the Process End Date are reported.

Note:

For offset payrolls, the effective date of the payroll or QuickPay run could be after the end date of the payroll period. In such cases, ensure that your Process End Date must be on or after the effective date of the process you want to include in the report.

Balance Exception Report

The name of the Balance Exception Report you use to run this report.

Payroll

Select the required payroll name.

Process Configuration Group

Use this field to run the report for a specific process configuration group, instead of the default one. A process configuration group is used to set rules for payroll processes, such as enabling logging or setting the number of threads. You can select a value only if you have a predefined process configuration group.

Note:

Use the Payroll Process Configuration task to define a Process Configuration Group, before you can use it here.

Consolidation Group

Use this field to run the report against a consolidation group. For example, you can use this field to run this report for a subset of payrolls. You can select a value only if you have a predefined consolidation group. If you specified a value when defining the exception report, select the same value or leave it blank.

The value chosen while submission takes precedence over the one used while defining the report. If you leave the field blank, the report runs for all consolidation groups.

Payroll Statutory Unit

Select a value to report on the balances of employees in a specific PSU. If you leave the field blank, the report runs for all PSUs.

Tax Reporting Unit

Select a value to report on the balances of employees in a specific TRU. If you leave the field blank, the report runs for all the TRUs.

Location

Use this field to view the balance results for employees who have at least one assignment for the selected location. The balance values may not necessarily correspond to the location parameter only. It is also dependent on the dimensions and the other associated contexts.

Payroll Relationship Group

Use this field to run the report for persons belonging to a specific payroll relationship group. You can specify a value only if you have a predefined payroll relationship group.

Note:

Use the Object Groups task to define a process configuration group, a consolidation group, or a payroll relationship group, before you can use it here.

After you have entered the above details, in the Linked Flows section, select the payroll flow as the Current Flow and the Run Balance Exception Report as the task. This ensures that the report uses the payroll balances for the current payroll flow.

Report Results

The report provides details of payroll balance results for matching persons, filtered by the defined exception criteria, specified time frame and the selected parameters. The output report includes:

  • Payroll Statutory Unit

  • Tax Reporting Unit

  • Person Number

  • Person Name

  • Payroll Relationship Number

  • Employment Level

  • Current Balance

  • Variance Value

The report output additionally displays the Previous Balance, Difference, and Difference % columns when the Comparison Type is Previous Period or Previous Month.