Canadian ACH file format for RBC

Rebecca Gelinas

Is anyone currently utilizing RE to set up ACH (direct debit) transactions to send to RBC?  If so, which file format in RE are you using?  RBC continually rejects our test files that we generate out of RE (we've tested the CPA 1464 Format, and Royal Bank 1464 Format).  Instead, they send us back the formats they can accept (CPA 005, ACH 094, RBC Standard 152), which don't seem to match anything in RE.


We've been working on this off and on for a couple years, and have always given up in frustration because neither RBC or Blackbaud has been able to help guide us in the right direction. I would love to connect with anyone who has been successful in setting up direct debits in RE and generating the file to RBC.


 

Jeff Gignac

Rebecca Gelinas:

Is anyone currently utilizing RE to set up ACH (direct debit) transactions to send to RBC?  If so, which file format in RE are you using?  RBC continually rejects our test files that we generate out of RE (we've tested the CPA 1464 Format, and Royal Bank 1464 Format).  Instead, they send us back the formats they can accept (CPA 005, ACH 094, RBC Standard 152), which don't seem to match anything in RE.


We've been working on this off and on for a couple years, and have always given up in frustration because neither RBC or Blackbaud has been able to help guide us in the right direction. I would love to connect with anyone who has been successful in setting up direct debits in RE and generating the file to RBC.


 

Hi Rebecca


Did the bank tell you why it was not accepted? I suspect its because the EFT file created by RE does not contain the necessary line breaks.


You need to use the RBC format from the EFT transmission file section.  Once the file is created, you need to run the Line Break Utility.  I looked for information in the KB but the article I have recorded is no longer found.  However, this link should work


https://www.blackbaud.com/files/support/downloads/re7/InsertLineBreaks.exe


When you run the utility, you put in the name of the file you created from the EFT module and it will update the file with the correct line break (while making a back up of the file)


Send that new updated file to the bank and see if that works.


Please contact me off list if you are still having troubles.


Thanks


Jeff