Summary

The Detail Payroll Distribution Report displays the GL accounts affected by a selected computer or manual check batch or during a specified date range. This report is similar to the GL Distribution Report generated on the Computer Checks palette (PR> Computer Checks> GL Distribution), but it displays the employee attached to each journal entry line item and can be filtered by union, GL account number and employee number.

The Detail Distribution Report can be generated for committed or uncommitted batches. If you generate the report for an uncommitted batch, the Distribution step on the batch process must be complete or no information will display on the report.

TheDepartment,UnionandEmployee Numberfields are used to filter the employees that display on the report. If you filter the report by department, union or employee number, only the journal entry line items associated with the selected employee records will display on the report.

Step by Step

1Open theDetailPayrollDistributionwindow (PRReportsDetailDistribution).

2Configure thereport.

• Check the toggle next to eachALFREdesignation you would like to include in thereport.
  • GL accounts are given their ALFRE designation when they are attached to an account type (GL Maintenance Chart of Accounts General tab Account Type field).
• TheFilter Typefield is used to specify whether thereportwill be filtered by batch number or date. The selection in this field will determine which fields are enabled below.
• TheBatch Numberfield is used to select the batch number you would like to include in thereport.
  • This field will only be enabled, and is a required field, if the Filter Type is set to batch.
  • Enter a batch number or click the field search button to select one from a list. Only the batch of the type selected in theBatch Typefield below will display in the window.
• TheDate Typefield is used to filter thereportby either the date on the payroll check or the end date of the payroll period.
  • TheDate FromandDate Tofield are used to specify a date range for the payroll transactions that will be included in thereport. The date used to filter the transactions is specified in the Date Type field above.
    • You must specify a Date From or a Date To in order to run thereport.
  • The Date fields will only be enabled if date is selected in the Filter Type field above.
• TheBatch Typedrop-down menu is used to select the type of batch you would like to display on thereport. Select Computer to include a Computer Checks batch or select Manual to include a Manual Checks batch.
• TheDepartmentfield is used to filter the employees that display on thereportby the department attached to their employee record.
  • Enter a department or click the field search button to select one from a list.
  • You can view the department attached to an employee record using the Employee Maintenance window (PR Maintenance Employee General tab Department field).
• TheUnionfield is used to filter the employees on thereportby the union unit attached to the employee record. Only the employees that belong to the selected union will display on thereport.
  • Enter a union unit code or click the field search buttonto select one from a list.
  • Union units are created and maintained using the Union Unit Maintenance window (HR Maintenance Union Unit).
  • You can view the union units attached to an employee record using the Employee Maintenance window (PR Maintenance Employee General Information tab Union field).
• TheAccount FromandAccount Tofields are used to filter the journal entry line items that display on thereportby a range of GL accounts. Enter a GL account number or click the field search buttonto select a GL account from a list. Only journal entry line items associated with the range of GL accounts will display on thereport.
  • GL accounts are created and maintained using the Chart of Accounts Maintenance window (GL Maintenance Chart of Accounts).
• TheEmployee Numberfield is used to filter thereportby a single employee. Enter an employee number or click field search button to select one from a list.
• TheFiscal Yearfield is used to filter the journal entry line items that display on thereportby the fiscal year on the line item.
• Check theAggregate employeestoggle to display one aggregate transaction total for each employee associated with each account included in thereport. If the toggle is unchecked, every employee transaction total for every account included in thereportwill be displayed.
• Check thePage break by fundtoggle to start a new page for each fund included in thereport.
• Check theDisplayDetailstoggle to include additional employeedetails in thereport. This toggle will be disabled when the Aggregate employees toggle is checked above.
  • When this toggle is checked, thereportwill include either the Check Date or Per End Date column based on the selection in the Date Type field. Thereportwill also include the Type column to display the Pay Code, Deduction Code, or Benefit Code. Each of these will also include the code description.

3Print thereport.

• Once the requiredreportsettings have been specified, click the Print buttonto print yourreport.
• Click the options arrow on the right side of the Print button to see other print options.
  • Select PDF to print thereportin the default Springbrook PDF format.
  • Select Excel to export thereportdata to an Excel spreadsheet as unformatted data.
  • Select Excel (Formatted) to export thereportdata to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of thereport.
  • Once a print option is selected, that option will automatically be selected the next time you access thereport. For example, if you select Excel from the drop-down menu, the next time you access thereportthe Excel button will be displayed by default.
• Click the Schedule iconnext to the Print button in order to schedule thereportto generate at a later date and time.
  • Enter a Date and Time to generate thereportand clickSUBMIT.
• Users can also regenerate a report with the same configuration as a prior report via the report history section. This can help improve efficiency when an identical report is frequently generated.
  • Once a report has been generated, the date and time it was generated will display in the report history accessed via the Expand Arrow button on the right side of the window.
  • Expand the report history and click on a previous report record to automatically populate the report criteria with the criteria specified on the previously generated report. Hover over the Info icon to view the parameters on the previous report.
  • This section will display the last three times the report was generated.