Atrieve Payroll
Atrieve Payroll
Breadcrumbs

Batch Transaction By Pay/Deduction Code Report

The Batch Transaction by Pay/Deduction Code Report allows you to report on timesheet entry batch transactions for a selective range of pay period or batch codes. You have the option to report either timesheet entries or variable deductions entries selecting specific pay/deduction codes to be reported. The report order is based on the batch transaction entries.

This report includes an option to generate an export file, ######.CSV, where ###### is the job number. The export file is generated where the logical SRB$OPSWRK is defined. All fields within the export file have any extra spaces removed from the front and back of the fields and all fields are separated by a comma.

The export file for Timesheets includes the following fields:

  • Payroll ID code

  • Batch number

  • Suspended flag

  • Card #

  • Date

  • Employee number

  • Employee name

  • Shift code

  • Pay code

  • Description

  • Hours

  • Money

  • Input rate

  • Base rate

  • Pay premium

  • Shift premium

  • Occupation premium

  • GL Account

  • Cost Center

  • Salary Grid

  • Position Code (scheduling)

  • HR Hours Per Day

  • Absence Override Storage Bank

The export file for Variables includes the following fields:

  • Payroll ID code

  • Batch number

  • Override flag

  • Suspended flag

  • Date

  • Employee number

  • Employee name

  • Deduction code

  • Description

  • Employee amount

  • Employer share

  • Eligible amount

  • Reason

Report Timesheets or Variable Deductions

  • Enter 'T' to produce a report of timesheet entries for all/specific pay codes.

  • Enter 'V' to produce a report of variable deduction entries or a specific list of deduction codes.

When Reporting Timesheets has been selected:

Enter Pay Code to Report

  • Enter up to 15 pay codes one at a time that will determine which timesheet entries will be selected for reporting. Use the look-up for valid pay codes.

When Reporting Variable Deductions has been selected:

Enter Deduction Code to Report  

  • Enter up to 15 deduction codes (one at a time) to select variable deductions to be reported. Use the look-up for valid deduction codes.

Enter Starting Batch to Report

  • Enter a starting range for transaction selection. The starting pay period range must be entered (YYYYPP), although you may enter as much or as little of the batch code and document number values (TTTSS) required to select the transaction to be reported.

For example:

You may enter only the pay period YYYYPP to start selection at that pay period.

You may enter the pay period and batch code YYYYPPTTT, for selection starting at a specific pay period and batch code.

You may enter the pay period, batch code and document number YYYYPPTTTSS to start the transaction selection at a specific batch.

Enter Ending Batch to Report

  • Enter an ending range for transaction selection. The end pay period range must be entered (YYYYPP), although you may enter as much or as little of the batch code and document number values (TTTSS) required to select the transaction to be reported. Note: The century is not automatically added for these batch entries.

Include Generation of CSV Export File

  • Enter 'N' to omit the generation of the export file.

  • Enter 'Y' to include the generation of the export file.

The report lists the following information:

For timesheet entries:

  • A subtitle showing the batch number

  • SUSP is displayed for all Suspended entries

  • Entry date

  • Employee number

  • Shift code, pay code and description

  • Hours - amount entered in hours column

  • Money only - amount entered in the rate column if the pay code is a money only

  • Pay code

  • Input rate - amount entered in rate column

  • Base rate - the default rate from the function line

  • Pay premium - the premium associated with the pay code used

  • Shift premium - the premium of the shift code used

  • Occ premium - the premium of the occupation code used

  • GL code - the GL code to be charged for this entry

For variable deduction entries:

  • A subtitle showing the batch number

  • * OV * marker is shown on all Override Variable deduction entries

  • SUSP is displayed for all Suspended entries

  • Entry date

  • Employee number

  • Deduction code and description

  • Employee variable amount

  • Employer variable amount

  • Eligible variable amount

  • Reason for variable deduction

  • The totals for the report include the total hours and money for all batches selected, as well as the total number of different employees found.