The Additional Bank File Merge provides the ability to set the bank file/batch sequence number as well as merge multiple bank files together. By merging the bank files, the cost of submitting bank files is reduced. Not only can multiple files per payroll be merged, from multiple payrolls as well as merge in Accounts Payable bank files.
This bank merge option is used for all the following banks, based on the Bank PROGRAM defined under the User Specific Parameters Profile:
-
Alberta Treasury
-
Bank of Montreal – Both 80 and 1464 formats
-
National Bank of Canada
-
Nova Scotia Bank
-
Royal Bank
-
TD Bank
-
Norwest Bank (US)
-
Stockman Bank (US)
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.
Select the payroll ids and the applicable pay period. Multiple pay periods can be merged 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.
Bank Sequence Number
This field is not applicable on US bank merges.
Enter the next bank sequence number to be used.
The report lists the following:
-
Report header lists file sequence number and merge file name.
-
Payroll description and pay period
-
Total deposits per location
-
Total # of details per location
-
Total debits per location when applicable
-
Total # of debits per location when applicable
-
Grand totals of merge deposits
-
Grand totals of merge debits