Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Tiffany Ziegler]

We are looking at various ways to pay vendors in Canada. We haven’t had a great need for it thus far, and have historically just wired funds whenever need. We may be going down a path where we’ll need to do these types of transactions more often. That being said, does anyone have experience with Canadian ACH? We currently utilize the ACH functionality within GP (although I think GP refers to it as EFT). We process an EFT batch, create the text file and upload that to the bank. My question is, is the process the same for a Canadian EFT? I assume we would choose Canada as the country on the EFT setup window and provide the necessary info. But are there other differences? Can American and Canadian ACH’s be in the same text file? Will the funds received by American or Canadian in this manner?

Any thoughts are much appreciated!

——————————
Tiffany Ziegler
Vice President & Controller
Velcor Leasing Corporation
Madison WI
——————————

[George Rios]

Hello Tiffany,

You have some great questions, which are not easy to answer in a forum. I believe the first place to start your research should be with your bank. Mainly, you can ask them what values need to be populated in order for you to effect Canadian Dollar payments via ACH. Can you use the existing Dynamics GP EFT layout? Or would you need to pass additional information when making payments in foreign currencies? 

It is easier to map a course when you know your destination.

——————————
George Rios
Bond Consulting Services
Long Beach CA
——————————
——————————————-

[Dan Troxell]

Tiffany, we use the out-of-the-box GP EFT format for RBC – (Royal Bank of Canada) and it works fine.  There are also several more Canadian bank formats included, Bank of Montreal, National Bank of Canada, CIBC and Toronto Dominion.

——————————
Dan Troxell
Dynamics GP System Admin
Subway
Milford CT
——————————
——————————————-

[Beat Bucher]

Hi Tifffany,
Agree with Dan… not much  difference as such in GP from the Canadian Bank vs. US.. As he said, use the out-of-the-box EFT templates that are already in GP and customize them (if required)..
You definitely need to work with your bank, even it it’s one of the majors where the template is already in GP.. those things tend to change over time..

——————————
Beat Bucher
Business Analyst, Dynamics GP MVP
Ultra-Electronics Forensic Technology Inc.
Montreal QC/Canada
+1-514-489-4267
@GP_Beat http://dyngpbeat.wordpress.com/
Montreal QC GPUG Chapter Leader
GP2013R2 / MR2012 CU14
——————————
——————————————-

[Jen Kuntz]

Hi Tiffany,

A lot will depend on your bank, where you pay the Canadian vendors out of. The format of the file is dictated by your bank, not by the country/location you are paying. In GP, this might mean a different file layout for Canadian vendors, that you assign to those vendors when you set them up for EFT.

Some high level info on Canadian banking, the bank format is as follows:
– 3 digit bank (financial institution #)
– 5 digit branch number
– varying lengths for account numbers but the most common is 7 or 8 digits in length. Each bank can vary but at any one bank, the length should be the same (that’s one way to check if your data input is accurate!)

In GP, if you were using a Canadian bank for instance, typically both the Bank and Branch # appear together in one field, to kind of mimic a US routing number (more or less). Example 00312345 would be bank 003 and branch 12345. Sometimes the EFT format needs this to be reversed, so it might display as 12345003.

Hope that helps.
Jen

——————————
Jen Kuntz, CPA, CGA
Microsoft MVP, Business Solutions
Kuntz Consulting Inc.
Cambridge, ON, Canada
——————————
——————————————-