Bank Feeds in Canada (BMO)

Wondering if anyone is successfully using Bank feeds in Canada? Looking for strategies that work. The client banks at BMO and BNC and we’ve had a hard time making connections to either. We’ve tried both Plaid and MX with no real success. We did have a connection to BMO but using a bank card instead of normal account credentials but that has since stopped working. And at one point we were able to connect successfully using MX but the Refresh did not return any transactions on accounts that definitely had transactions. Very frustrating!

Be the first to reply!

Hello @jeff00,

In 2024 R2 there is a new function to use Bank Feed from File using Secure SFTP. Have you explored this option with BMO Bank?

https://acumatica-builds.s3.amazonaws.com/builds/24.2/ReleaseNotes/AcumaticaERP_2024R2_ReleaseNotes.pdf

Regards,

Amaan Fazeer

Thank you Amaan. I did see that earlier when R2 was announced but we still have another month before its rolled out for us. But good suggestion. Will contact the bank and see if they will support it.

Thanks!

Jeff.

@jeff00 we try to connect with BNC, we can connect to BNC with Plaid but we dont see all the credit card without any known reasons.

We arent able with MX at this time and we don’t know why!

Interresting!

I attached the list of institution of Plaid for Canada, if needed(we got it via Plaid API )

@AmaanFazeer11 : do you know what is the file type supported by the STFP? There isnt a lot of information on the help about that? And the mapping?

Thanks!

This client has opted to use the new SFTP functionality in 2024R2 and is working with the bank to get things set up before their Always Current Upgrade date in February.

So this should resolve the reliability issue but I agree with you that the update documentation leaves some gaps in the steps. It indicates that we will have to define the mapping manually.

So that will be fun!

Hello @raphrf

Currently in 24 R2 csv file type is supported. There are plans to incorporate other file types such as BAI2 and VCF in future versions.

Regards,

Amaan

Hello @raphrf

Currently in 24 R2 csv file type is supported. There are plans to incorporate other file types such as BAI2 and VCF in future versions.

Regards,

Amaan

The bank ask me if they support theses kind of files

Do you know which are supported? maybe I misunderstand

Thanks

Hello @raphrf

CDF3 (The common data format 3) is being considered for 2025 R1 update.

I would suggest to keep an eye on release notes once version is released for further details on new supported file formats and other specifics

Amaan

Did this end up getting resolved in 25R1 or the upcoming 25R2 release?

I do not believe it is really Acumatica that should be resolving the coding part of the issue although Acumatica must have taken the lead on this to coordinate between the MX/PLAID and financial institutes. After all Acumatica is selling the Bank Feed and MX/PLAID are Acumatica integrated services. In our case we are bounced between Acumatica, MX and BMO OLBB and BMO SD for months now. each one blames another without any resolution yet.

About Acumatica ERP system

Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded