How to setup Payroll & Payroll Reports for RBL for Barbados

How to setup Payroll & Payroll Reports for RBL for Barbados

ROYAL BANK OF CANADA

Setup

Maintenance >> Payroll Setup >> Banking and other payees

>> Head Office : Ensure all head offices are there for all banks. This will only apply to banks but if the customer wants other agencies such as insurance to show on the pay slip under deductions , they must be setup here as well.

>> Payees: Ensure that the payees are setup for all banks and linked to the branches

>> Company Payee Links: All payees must be linked to the company

Maintenance >> Downloads/ Uploads

Mapping Tables

Mapping types: Head Office

Mapping Table code: RBBB

Description: RBBB ROUTERS

Drill down when mapping is created and create a Head Office for each of the Banks which were created in head office tab. Enter Head office, select bank and mapped value.

Router numbers must be 9 digits long for Barbados banks - 3 From the Head office listed in the table and 6 from the Transit No. setup in the Payee. 

Find list Attached: Bank Brach Code

Bank Download Setup

New record: Select company, the main bank used for the download

Bank FLD 1: Enter mapping table code for routing numbers. Eg. RBCR


Reports

Payroll Reports

Payment reports >> Royal Bank ACH Download

Select Net Pay and enter pay group. Submit and the report will be generated. Select the ACH Download and generate the file.


Also, find a sample of the ACH file for your reference.