The CUCBC (Credit Unions of BC) Bank File Merge 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 both locations pointed to by either the SRB$EXPorT or 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.
Bank files created by the finance system Accounts Payable can also be merged. 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
-
Enter a 4-digit sequence number.
The report lists the following:
-
Payroll location and pay period
-
Total deposits per location
-
Total # of details per location
-
File sequence per location
-
Grand totals of merge deposits