UPCOMING: Configure Bank Accounts and Suppliers for Canadian ACH Bank Transfer
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 ACH Bank Transfer 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 > ACH Bank Transfer 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 ACH Bank Transfer 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 ACH Bank 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 ACH Bank Transfer export. Right-click on the account and choose Modify.
The Modify Account pop-up will now display an ACH Bank Transfer dropdown. Click the dropdown and select the correct configuration for the account. Click Ok to save the selection. Clicking on the Edit button will open the ACH Bank Transfer Configuration pop-up and allow you to edit the underlying configuration.
Step 3: Add Bank Transfer Details to Supplier Master Records
Navigate to: Supplier > Find > Supplier
Double-click to open the supplier record to edit. Navigate to the Details tab.
To include the supplier in the ACH exports, you must first update the Payment Method to ACH Bank Transfer. This payment method is created by the system and will already be in the list to select.
Once you have assigned the Payment Method, the ACH Bank Transfer configuration fields will become editable. You must enter the Bank Routing Number, Bank Account Number, and ACH Bank Submission Email prior to saving the changes to the Supplier Record.
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
ACH Bank Submission Email: choose the email from the dropdown that will receive the Remittance Advice emails. This email must be set up and saved on the General tab prior to selecting in this dropdown.
Any supplier that does not have the Payment Method of ACH Bank Transfer will not be available for any payments set to the ACH Bank Transfer payment type.
Any payments that are not set to the ACH Bank Transfer Payment Type will not populate in the ACH Bank Transfer grid.
You are now ready to begin exporting files to upload to the bank.