The CIBC Bank File Merge program allows you to set the bank file sequence number as well as merge multiple bank files together. By merging the bank files, you can reduce the cost by submitting only one bank file. You can merge multiple files per payroll, from multiple payrolls as well as merge in Accounts Payable bank files.
The bank file merge file generated by this process is named %%%%##.TAP, where %%%% are the 4 characters you define as the bank file name under the User Specific Parameters profile, and ## is the last two digits of the pay period you enter as the merge pay period. The merge file for this process is generated at the location pointed to by the SRB$OPSWRK logical. The merged bank file is then available for download via the Payroll Download File Process for submission to your bank.
This process should be run in batch so that a log is generated in the event of any errors.
The first screen (above) allows you to select the payroll ids and the applicable pay period. You can merge multiple pay periods for the same payroll as well merge bank files from multiple payrolls.
You can also merge bank files created by the finance system Accounts Payable. Enter '999' instead of a payroll id code to indicate an Accounts Payable bank file to be merge. You will be prompted for a 4-digit account run number to define the bank file name of AP####.TAP. The Accounts Payable bank files must be created at the location pointed to be the logical SRB$BASWRK0.
The following prompts enable the system to produce the CIBC transmission file submittal form. If you do not wish to use the form for anything other than internal verification, these prompts may be skipped.
Pay Period for this Payroll
-
Enter the pay period of the current payroll. This pay period is used for the generation of the bank merge file name.
Bank Sequence Number
-
Enter the bank sequence number.
District Name
-
Enter the full name of your organization, up to 40 characters.
District Phone
-
Enter the phone number the CIBC is to use to contact you.
District Fax
-
Enter your fax number.
District Contact [FullName]
-
Enter the full name of the contact. (This should be the payroll supervisor.)
The CIBC verification report will print a list of the payrolls merged with the amounts and number of entries. The transmission submittal form can be faxed directly to the CIBC once it has been signed.