BMO EFT Upload

Mark Sawh
Mark Sawh
Fifth Anniversary
in Blackbaud Financial Edge NXT® General Discussions
Hi ,

Our Canadian organization has moved to working remotely since the pandemic news was announced. We had to implement the EFT module so that we can continue to pay our vendors.


We bank with BMO who confirms they accept CPA 1464 file format. When we produced the EFT file from FE and uploaded to BMO's EFT portal, the file was rejected because as BMO helpdesk states "there is a problem with format. You choose 1464 option, but the file length is 4392 which is invalid. "


The test file we uploaded, only contained 1 payment and the file name was 0000 as instructed by BMO.


Does anyone know how to fix this and produce a proper file form 1464? We do not have NXT, we have FE 7.  Attached is the FE - EFT file output screen.




 

Comments

  • Kayla Euler
    Kayla Euler
    Fifth Anniversary Name Dropper Facilitator 1
    We are also having this issue as Blackbaud FE does not have BMO as a template set up. The only suggestion that BMO had for us was to manually make the corrections in the output file before uploading to BMO for processing - this is not something we wished to do as it can create errors due to manual entry. We are still waiting as we have been told that they are working on getting a template for BMO. 
  • Kevin Brazell
    Kevin Brazell Blackbaud Employee
    Tenth Anniversary Kudos 5 First Reply Name Dropper
    Hi Mark, 


    the size of the lines is due to the fact the Include Carriage return/line feed button is not marked. When this box is not marked, instead of short and concise lines, your eft file is 1 long continuous line that most banks will not accept. That needs to be marked every time you create an eft file, and it shortens the lines in the file, as most banks require so they can accept the file. Normally you should be able to mark it one time and it holds it permanently, but there is a bug that was found several years ago specific to just Canadian FE databases, where you can mark the box to include the carriage returns, but it doesn't hold it unless you mark it when creating payments like your screenshot shows. As of today it still happens.  I'd recommend marking the box, create your EFT, and attempt the upload again to see if your bank can accept it then. 

Categories