UPCOMING: Configure the RBC Royal Bank Check Verification Upload
We have added a feature to allow you to upload a check verification file to a Quebec financial institution. This is currently configured for RBC Royal Bank specifications and has not been tested with other banks.
To set up a bank account to create Check Verification files for upload, you will need to set up the credentials and then assign the credentials to the bank account.
Step 1: Enter Bank Account Credentials
Navigate to:
Company > Company Support Lists > Check Verification Bank Accounts
This will open the Check Verification Bank Account tab where you can configure bank accounts for file creation. Click on Add New at the top left of the tab to set up a new account for the export.
In the Check Verification Bank Account pop-up, you will need to enter all required information. See below for descriptions of each field.
Description: This is a user-defined description to help you identify the bank account tied to this configuration.
Interface Type: Dropdown options include either CSV(Generic) or Quebec Bank Transfer. Choose Quebec Bank Transfer to configure RBC Royal Bank.
Bank Routing Number: Enter the routing number provided by the bank.
Bank Account Number: Enter your bank account number provided by the bank.
Last File Number: The bank requires consecutive file numbers assigned to uploads with no duplicates. You will need to add the number of the last file you uploaded in this box. RIMSS will increment this number by a quanity of 1 each time you create a file. This field only allows a number to be entered.
Filename: Enter the name that you would like to assign to the file upon creation.
Last Check Number: RIMSS will populate this field after you have created a file. The highest check number in the most recent export will be populated in the field.
Last Export Date: RIMSS will populate this field with the most recent file creation date after you have created a file.
The fields below will need to be completed using information provided by RBC Royal Bank. The field names were pulled directly from their specifications.
Other Value 1: File Identifier
Other Value 2: Originator's ID
Other Value 3: Destiination Data Centre
Other Value 4: Currency Code Identifier
Other Value 5: Instituational ID Number for Returns
Other Value 6: Account No. for Returns
Other Value 7: Originator's Short Name
Other Value 8: Originator's Long Name
An example of a completed Check Verification Bank Account is shown below. The information is for demonstration purposes only and is not tied to an actual bank account. Click OK to save the information once complete.
File Types as provided by RBC Royal Bank:
These header records will accommodate French Characters within the file.
- Test Input of full Record length of 1464 bytes: $$AA01CPA1464[TEST[NL$$
- Production Input of full Record length of 1464 bytes: $$AA01CPA1464[PROD[NL$$
These header records will not accommodate French Characters within the file. French Characters may be changed to blanks or other letters.
Test Input with full record length of 1464 bytes: $$AAPDCPA1464[TEST[NL$$
Production Input of full record length of 1464 bytes: $$AAPDCPA1464[PROD[NL$$
Step 2: Assign the Check Verification Configuration to the correct G/L Bank Account
Navigate to: Company > Find > Chart of Accounts Grid
Find the Bank Account in the list that you have Configured for the Check Verification export. Right-click on the account and choose Modify.
The Modify Account pop-up will now display a Check Verification dropdown. Click the dropdown and select the correct configuration for the account. Click Ok to save the selection.
Step 3: Add Bank Account Details to Supplier Master Records
Navigate to: Supplier > Find > Supplier
Double-click to open the supplier record to edit. Navigate to the Details tab. There are 3 new fields on this tab for you to enter the banking information. Click one of the Save options after entering this data.
Bank Routing Number: enter the routing number of the bank that you will submit the payment
Bank Account Number: enter the supplier's bank account number
Bank Account Type: optional field to capture the account type
Any supplier that does not have banking information entered will not be included in the export file.
You are now ready to begin exporting files to upload to the bank.