Atrieve Payroll

Employee Bank Account Report

This report lists each bank/transit number used reporting all employees within that bank. Each bank/transit number is reported on a separate page. The bank title from the bank data base will be used if the bank/transit currently exists in the database. Employees paid by cheque are listed separately. This report gives you a list of all banks currently used on the employees.

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 includes the following fields:

  • Payroll ID code

  • Employee number

  • Employee name

  • Employee status

  • Bank number

  • Bank description, when available via data base

  • Employee account number

  • Bank split percentage or amount

  • Pay disposition

Report Employees Terminated / On Leave / Both

Sort Within Bank by Employee Number or Employee Name

  • Enter 'E' to produce the report in employee number order.

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

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.

This report lists the following:

  • Title per bank lists bank number and bank description, if available

  • Employee number and name

  • Bank account number

  • Bank account percent/amount split

  • Pay disposition