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.

The Department, Union and Employee Number fields 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

1     Open the Detail Payroll Distribution window (PR> Reports> Detail Distribution).

2     Configure the report.

• Check the toggle next to each ALFRE designation you would like to include in the report.
  • 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).
• The Filter Type field is used to specify whether the report will be filtered by batch number or date. The selection in this field will determine which fields are enabled below.
• The Batch Number field is used to select the batch number you would like to include in the report.
  • 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 Batch Number field label to select one from a list. Only the batch of the type selected in the Batch Type field below will display in the window.
• The Date Type field is used to filter the report by either the date on the payroll check or the end date of the payroll period.
  • The Date From and Date To field are used to specify a date range for the payroll transactions that will be included in the report. 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 the report.
  • The Date fields will only be enabled if date is selected in the Filter Type field above.
• The Batch Type drop-down menu is used to select the type of batch you would like to display on the report. Select Computer to include a Computer Checks batch or select Manual to include a Manual Checks batch.
• The Department field is used to filter the employees that display on the report by the department attached to their employee record.
  • You can view the department attached to an employee record using the Employee Maintenance window (PR> Maintenance> Employee> General tab> Department field).
• The Union field is used to filter the employees on the report by the union unit attached to the employee record. Only the employees that belong to the selected union will display on the report.
  • Enter a union unit code or click the Union field label to 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).
• The Account From and Account To fields are used to filter the journal entry line items that display on the report by a range of GL accounts. Enter a GL account number or click the Account field label to select a GL account from a list. Only journal entry line items associated with the range of GL accounts will display on the report.
  • GL accounts are created and maintained using the Chart of Accounts Maintenance window (GL> Maintenance> Chart of Accounts).
• The Employee Number field is used to filter the report by a single employee. Enter an employee number or click the Employee Number field label to select one from a list.
• The Fiscal Year field is used to filter the journal entry line items that display on the report by the fiscal year on the line item.
• Check the Aggregate employees toggle to display one aggregate transaction total for each employee associated with each account included in the report. If the toggle is unchecked, every employee transaction total for every account included in the report will be displayed.
• Check the Page break by fund toggle to start a new page for each fund included in the report.

3     Print the report.

• Click the Print icon to process the report immediately or enter a date and time in the field next to the Print icon to schedule the report to generate at a later time. You can view the progress of the report on the Job Viewer window (SS> Utilities> Show Scheduled Jobs).
  • Click the Print icon drop-down menu and select Print Preview to preview the report before printing.
  • Click the Print icon drop-down menu and select Excel to export the report data to an Excel spreadsheet as unformatted data.
  • Click the Print icon drop-down menu and select Excel (Formatted) to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
  • Once the report is generated, you can also display the report using the View Reports window (SS> Utilities> View Report).