The HSBC Bank File Merge program allows you to set the bank file/batch sequence number as well as merge multiple bank files together. By merging the bank files, you can reduce the cost by submitting less bank files. 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.
Pay Period for this Payroll Merge
-
Enter the pay period to be used in the definition of the merged bank file name.
The following prompts enable the system to produce the Bank of HSBC transmission file submittal form. If you do not wish to use the form for anything other than internal verification, these prompts may be skipped.
District Name
-
Enter your organization's full name. If in doubt, use the same name as used on correspondence with the bank.
District Phone
-
Enter the district's phone number, if the payroll department has its own phone number, it should be the payroll supervisor's phone number.
District Fax
-
Enter the district's fax number.
District Contact [FullName]
-
Enter the payroll supervisor's full name. If there is no payroll supervisor, enter the name of the person the bank is to contact in the event of a problem with the transmission.
Contact Phone
-
Enter the phone number of the contact person.
Alternate Contact [FullName].
-
Enter the full name of an alternate contact that the bank may contact in the event there is a problem with the bank transmission.
Alternate Phone
-
Enter the phone number of the alternate contact.
The HSBC 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 HSBC bank once it has been signed.