Canadian ACH

  • Canadian ACH

    Posted by DSC Communities on March 7, 2017 at 12:26 pm
    • Tiffany Ziegler


      March 7, 2017 at 12:26 PM

      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


      March 7, 2017 at 1:12 PM

      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


      March 7, 2017 at 4:53 PM

      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
      Milford CT

    • Beat Bucher


      March 8, 2017 at 7:58 AM

      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
      Montreal QC GPUG Chapter Leader
      GP2013R2 / MR2012 CU14

    • Jen Kuntz


      March 8, 2017 at 11:39 AM

      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 Kuntz, CPA, CGA
      Microsoft MVP, Business Solutions
      Kuntz Consulting Inc.
      Cambridge, ON, Canada

    DSC Communities replied 6 years, 6 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

Log in to reply.

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!