Payroll Allocation Report

Use this form to determine the format for the payroll costs that are distributed across multiple cost centers such as departments, divisions or locations.

Note:  Client Access Group security is enabled on this form.

To access this form, click Reports menu. Under Payroll|Report, click Payroll Allocation Report.

Note: You can also access the Payroll Allocation Report for a selected payroll in the Approval Payroll Reports form. To do this, select Approval Payroll Reports in the View Report/Analytic field on the Payroll Approval form, then select Payroll Allocation Report in the Report Title column.

To generate the payroll allocation report:

1. Complete the following fields:

Field

Description

Selection Parameters

Payroll Number

Enter the payroll number for this report or click the Payroll Number link to select one from the Payroll Search dialog box.

Note:  If you use a payroll number to generate the report, you cannot use a date range and vice versa.

Enter a Date Range

Check this field if you want to use a date range for this report

• Enter a Start Date and
• Enter an End Date

Sort Parameters

Primary Sort

This report will be sorted by the primary sort criteria selected here. Select the primary sort criteria from the following:

• Allocate/Sort by Department
• Allocate/Sort by Division
• Allocate/Sort by Job Code
• Allocate/Sort by Loction
• Allocate/Sort by Pay Method
• Allocate/Sort by Phase

Note:   

• Allocate/Sort by Project
• Allocate/Sort by W/C Job Class

Secondary Sort

This field is optional. Select the secondary sort criteria from the following:

• Allocate/Sort by Department
• Allocate/Sort by Division
• Allocate/Sort by Job Code
• Allocate/Sort by Loction
• Allocate/Sort by Pay Method
• Allocate/Sort by Phase
• Allocate/Sort by Project
• Allocate/Sort by W/C Job Class

Note:   

1. Secondary sort criteria cannot be used if the primary sort criteria is not selected.
2. Secondary sort criteria cannot be same as the primary sort criteria selected above.

Tertiary Sort

This field is optional. Select the tertiary sort criteria from the following:

• Allocate/Sort by Department
• Allocate/Sort by Division
• Allocate/Sort by Job Code
• Allocate/Sort by Loction
• Allocate/Sort by Pay Method
• Allocate/Sort by Phase
• Allocate/Sort by Project
• Allocate/Sort by W/C Job Class

Note:   

1. Tertiary sort criteria cannot be used unless both the primary and secondary sort criteria are selected.
2. Tertiary sort criteria cannot be same as the primary sort or secondary sort criteria selected above.

Report Parameters

Allocate Using

This field is optional. Specify which field this report would allocate from the following:

• Gross Pay (Default)
• Gross Earnings
• Hours Paid

Report Type

This field is optional. Specify the type of report to generate from the following:

• Detail w/Break Totals (Default)
• Detail Only
• Summary Only

Exclude Contributions

This field is optional. Indicate the desired option from the following:

• Include Contributions (Default)
• Exclude Contributions

Other Parameters

Sort On Allocation Codes Instead of Descriptions

This field is optional.

Note: If you do not enable this parameter, the system will sort fields by description. In addition, if you enable the Phase option in the Sort Parameters panel, the system will sort Phase by code (there is no description for phases).

Page Break on Primary Sort

This field is optional.

Include Expense Reimbursement Pay Codes

This field is optional. By default this flied is selected.

Include Non-Cash Pay Codes

This field is optional. By default this flied is selected.

Include Pay Rate with Pay Detail Information

This field is optional.

Suppress Client Bill Pending Allocations

This field is optional.

Deductions Allocated to Employee Home Assignment

This field is optional.

Taxes Allocated to Employee Home Assignment

This field is optional.

Include Admin Fees (ASO Clients only)

This field is optional.

Include Sales Tax

This field is optional.

Suppress Contribution Allocations

This field is optional.

Exclude Non-Billed Contributions

This field is optional.

Include Miscellaneous Charges

This field is optional. By default this flied is selected.

Include Administration Fees

This field is optional. By default this flied is selected.

Include Additional Fields (1st Column)

This field is optional.
2. Click Run.
i. The Payroll Allocation Report displays. You can scroll different pages to view more information.
ii. Click XLS to download the report.
3. Click Close to close this form.