Skip to main content

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!

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

Reply


Terms & ConditionsCookie settings
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.
© 2008 — 2024  Acumatica, Inc. All rights reserved