Atrieve Payroll
Atrieve Payroll
Breadcrumbs

Storage Bank Transaction Analysis Report

The Storage Bank Transaction Analysis Report displays a complete listing of all storage bank transactions listed according to pay period start and end dates. 

Transactions are reported under the pay period represented by the transaction date. Transactions for prior periods will be listed in the pay period defined by the transaction entry date used on the entry. Storage bank adjustments are reported in the pay period where the adjustment was made with the transaction date listed as the pay period end date for the applicable pay period.

This report includes an option to generate an export file, ######.CSV, where ###### is the job number. The CSV file is generated in the work directory of the payroll, pointed to by the logical SRB$OPSWRK. The CSV file can be opened directly in Excel or emailed from the Email process on the main menu.

The export file includes the following fields:

  • Employee Number

  • Employee Name

  • Employee Status

  • Bank Number

  • Bank Table

  • Bank Name

  • Opening Balance (if applicable)

  • Transaction Date

  • Pay Period as defined by Transaction Date

  • Period Processed In

  • Transaction Code

  • Transaction Description

  • Pay Code (if applicable)

  • Hours/Days and/or

  • Amount

Enter Storage Bank Codes

  • Enter up to 25 storage banks to report.

Suppress Reporting Amount / Hours / Neither

  • Accept default when suppression of the Amount or Hours column is not required.

  • Enter 'A' to suppress the printing of the Amount column.

  • Enter 'H' to suppress the printing of the Hours column.

Suppression of a column, in conjunction with printing the opening balance allows for a running total to be printed.

Enter Starting Pay Period #

  • Enter the starting pay period for a range of pay periods to be reported.

Enter Ending Pay Period #

  • Enter the ending pay period for a range of pay periods to be reported.

Report All or Selected Employees

Report Employees Terminated/On Leave/Both

Sort by Employee# or Name 

  • Enter 'E' to report the employees sorted in employee number order

  • Enter 'N' to report the employees sorted in employee name order.

Sort by Date or Transactions Within Period

  • Enter 'D' to have the transactions per pay period sort based on transaction date.

  • Enter 'T' to have transactions within a pay period sorted first by transaction type and then date.

When Sort by Transaction Within Period Was Selected:

Compress Accruals and Increments

  • Enter 'N' when accrual and increment entries are not to be compressed.

  • Enter 'Y' to have the accrual and increment entries per period compressed to one line, omitting the pay code and date details. The date shown will refer to the pay period end date and the transaction description with show as compressed. This feature allows you to focus on the other details in a pay period such as withdrawals while still reporting the actual bank values.

Include Opening Balances

  • Enter 'Y' to include the opening balances of the banks or 'N' to omit the opening balances of the banks. The opening balances must be included along with suppression of either the Amount or Hours for the running balance to be printed.

When Running Balance Will be Printed:

Report Only When Negative Running Balance

  • Enter 'N' when entries are not to be excluded.

  • Enter 'Y' to only report those employee's where a negative running balance was found.

Exclude Withdrawals for Dates Outside Period Range

  • Enter 'N' when withdrawal entries are not to be excluded.

  • Enter 'Y' when withdrawal entries (WD – Withdrawal and WJ – Withdrawal Adjust) are to be omitted when the date of the withdrawal falls outside the selected reporting pay period range.

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:

  • Employee number, name and employee status

  • Storage bank code and description

  • Opening balance, when applicable

  • Storage bank code, table code and table description

  • Transaction date

  • Pay period as defined by the transaction date

  • Pay period transaction was processed under

  • Transaction code and description and pay code

  • Storage bank hours and/or amount

  • Running total, when applicable

  • Sub totals per pay period

  • Totals per employee's storage bank

  • Total of all banks per employee

  • Report total of all transactions