01 Withholdings Grouped by Employee - Chained Report

This report displays Withholding Category and Tax Amount information grouped by Withholding Category, Check # and Employee Name. Report can be filtered by Corporation, Check Date range OR by a single Employee ID.

This report is intended to be executed for a single corporation.

A chained report contains multiple reports that automatically execute when the initial report is run. In this case, the following reports run when the 01 Withholdings Grouped by Employee - Chained Report is selected:

Each of the above reports can be run independently (click on the link if you wish to do so). However, they are primarily designed to work as a unit within the chained report.

A chained report must be exported (XLS, PDF, RTF and CSV).

The following information is based on running the chained report. If you plan on running the reports independently from each other, please click the links above to go to the specific report you wish to run.

Executable Formats

This report can be executed in the following formats:

  • Excel
  • PDF (Portable Document Format)
  • RTF (Rich Text Format)
  • CSV (Comma Separated Values)

Accessing the Report

To access the 01 Withholdings Grouped by Employee - Chained Report:

  1. From the Navigator, select Reporting.
  2. From the fly-out menu, select Reporting & Analytics.
  3. From Reporting & Analytics page, select System Reports in the Folder/Report navigator.
  4. In the System Reports folder, select the Payroll folder.
  5. In the Payroll folder, select the Withholdings Grouped by Employee - Chained Report folder.
  6. In the Wage Code Grouped by Employee - Chained Report folder, single-click on 01 Withholdings Grouped by Employee - Chained Report and click on the Export Report icon to select the format. Alternatively, you can right-click on 01 Withholdings Grouped by Employee - Chained Report and select Export As > and then the format.

Filters

This report has three filters:

  • Corporation: Corporation associated with the payroll process. This defaults to the Default Corporation of the logged-in User's Default Branch.

    Even though you can change the Condition on the filter, the report is designed to run based on the selection of only one corporation. Therefore, Bullhorn recommends leaving the Condition as "Equal To" and selecting the one Corporation for which you want to run the report.

  • Check Date: Date associated with the Check. The "From" date defaults to the first day of the previous work week. The "To" date defaults to the last day of the previous work week.
  • Employee ID: Allows you to indicate the specific employee(s) for which you want to run the report. If you want to view all employees, make sure the Condition is set to "Greater Than" and the Value set to "0" (zero).

The following conditions are available:

  • Equal To (Default for Corporation): Data must be equal to the Value. There is only 1 Value option.
  • Not Equal To: Data must not be equal to the Value. There is only 1 Value option.
  • Less Than: Data must be before the Value alphabetically or by date. There is only 1 Value option.
  • Less Than or Equal To: Data must be before or equal to the Value alphabetically or by date. There is only 1 Value option.
  • Greater Than (Default for Employee ID): Data must be later than the Value alphabetically or by date. There is only 1 Value option.
  • Greater Than or Equal To: Data must be later or equal to the Value alphabetically or by date. There is only 1 Value option.
  • Starts With (Not available for Check Date): Data must start with the Value. There is only 1 Value option.
  • Not Starts With (Not available for Check Date): Data must not start with the Value. There is only 1 Value option.
  • Ends With (Not available for Check Date): Data must end with the Value. There is only 1 Value option.
  • Does Not End With (Not available for Check Date): Data must not end with the Value. There is only 1 Value option.
  • Contains (Not available for Check Date): Data must contain the Value. There is only 1 Value option.
  • Does not Contain (Not available for Check Date): Data must not contain the Value. There is only 1 Value option.
  • Is Between (Default for Check Date): Data/Date must be between the two selected Values alphabetically, numerically or date-wise (inclusive). There are two Value options.
  • Is Not Between: Data/Date must not be between the two selected Values alphabetically, numerically or date-wise (inclusive). There are two Value options.
  • Is One Of: Data must match one of the selected Values. There are multiple Value options.
  • Is Not One of: Data must not match any of the selected Values. There are multiple Value options.

You have the following Value options:

For performance purposes the following two items should be noted when using the Values droplist. First, in order to enhance performance, once a value is selected, the droplist only displays those items alphabetically/numerically AFTER the selected item. To see all items again, delete the value (select it and press Delete on your keyboard) and then use the droplist. All items will display. Second, in order to enhance performance, the droplist only displays a set number of records. If the list of possible values is longer than the displayed list, select the name at the bottom of the list as the value. When you next click the droplist, the rest of the items display.

  • Single Value: To select a single value, you can use the drop-list.

  • Double Values: To select two values, click the drop-list on each value.

  • Multiple Values: To select multiple values, click the drop-list on the top field to select a Value to add to the list. To see the items on the list, click the lower drop-list. To remove an item from the list, click the red X to the right of the item.

Report Actions

The chained report runs the two linked reports: 02 Corp Summary Withholdings Grouped by Employee and 03 Detail Withholdings Grouped by Employee.

The 02 Corp Summary Withholdings Grouped by Employee displays a Corporation Summary by Withholding Category showing Tax Amount and Taxable Amount information.

The 03 Detail Withholdings Grouped by Employee shows Withholding Tax and Taxable Amount information grouped by Withholding Category, Check # and Employee.