Employee Active Payroll Balance Report

Run the Employee Active Payroll Balance report to view the current values for any given list of employee balances.

Compare this data against the archived data to assist in reconciling your periodic payrolls and quarterly and year-end balances. This report also helps you to determine if you have any tax balances over the statutory limits, such as Social Security.

Start the Run Employee Active Payroll Balance Report task from the Checklists or Submit a Flow page under Payroll in My Client Groups on the Home page.

Before you run the report, ensure successful completion of any payroll action, such as a payroll run, QuickPay, reversal, balance adjustment, or balance initialization.

Report Parameters

Here’s the list of parameters that are relevant for this report.

Payroll Flow

Enter the name of your payroll flow.

Start Date

If you include the Run Balance values, specify the start date. This date must coincide with the date of the selected payroll run.

End Date

Specify the effective date for balance retrieval. When you capture balance values across a range of dates, this represents the end of the range.

Payroll

Specify a value to run the report for a specific payroll run.

Consolidation Group

Select a value to run the report for the members of a consolidation group.

Tax Reporting Unit

Select a value to include all employees in a tax reporting unit (TRU) in your report results. Click Search to locate the TRU.

Payroll Relationship Group

Select a value to run this report for a group of employees in a payroll relationship group. Click Search to locate the group.

Employee Name

Select an employee name to run this report for a specific employee. Click Search to locate the correct employee.

Balance Dimension

Select the balance dimension you want to review:

• Run

• Quarter

• Year

• Quarter and Year

Quarter

Select the quarter you want to review.

Balance Group Usage

Select the balance group to include balance values in the report output.

Hide Records with Zero Values

Select if you don’t want records with 0 balances to show in this report.

Process Configuration Group

Select the process configuration group name, if you have defined any. This parameter is used for logging and reporting purposes.

Report Results

This report produces a pipe-delimited text file containing all live payroll balances for matching employees, filtered by parameters and time-frames. You can open this file in Microsoft Excel for additional filtering. If no employee balances match your report parameter criteria, the report returns an output file with no data.

For example, if you don’t select Yes for any of the Include Balance Values fields, the report captures no balances. The output file is empty.

The output file includes:

• Payroll balance information

• TRU

• Employee name and number

• Payroll relationship number

• Run type (Run level only)

• State, county, city, school district, and Pennsylvania locals (if applicable)