Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / EFT for Payables for t...
Microsoft Dynamics GP (Archived)

EFT for Payables for the Royal Bank of Canada

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi Everyone:

Would someone using the EFT for Payables with RBC or anyone knowledeable in properly setting up the RBC EFT for Payables file format, be kind enough to share the layout of the file, so that we can substitute our own values?

I understand that you may have some apprehension about sharing this information, but if such is your concern, would it not be possible to replace any confidential information with dummy data that will act like useful placeholders?

I am sure there are many of us who would very much appreciate such a magnanimous gesture, instead of the  typical 'details are available in the eBanking documentation' response. I sincerely hope that there is someone out there that is both knowledgeable and considerate enough to extend their offer of help, to be of assistance to those of us who are not quite proficient with the application.

If I could get some help with this File Format, I would in return, create a detailed document & publish it on this forum, so that many more could benefit from it.

I thank you all in advance.

Regards.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: EFT for Payables for the Royal Bank of Canada

    Steven,

    I see this post was several years ago and I hope you have successfully managed to get the IAT lines generated.  I also hope you would share your results - how did you get this to work?

    thanks!

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: EFT for Payables for the Royal Bank of Canada

    Hi Everyone:  Thank you for all of your responses. I realize now that there are standard file formats for 5 of the large Canadian banks.

    If you google for EFT file Format Specifications for Canadian Banks, including the Royal Bank of Canada, you'll be able to see them. There is some Client specific tweaking, but very little. Theses specific items are based on the EFT Bank Maintenance information, under Financials > Checkbook (besides of course, the vendor banking information).

    As soon as I am able to get some time, I'll do a write up for the benefit of those whoare new to the porocess, as I was several months ago.

    If you have any specific question I can help you with in the meantime, please post it here or drop me a note @  deesom@hotmail.com.

    Regards to all.

    David.

  • Steven Anderson Profile Picture
    Steven Anderson 185 on at
    Re: EFT for Payables for the Royal Bank of Canada

    I am working with this for Dynamics GP.  In Dynamics GP, there is an EFT format predefined for RBC that looks like it matches their specification.  I have used this to format an output file for CAD transactions to Canadian vendors.  However, for US vendors they require additional IAT lines.  These are included in the predefined RBC format, but I can't seem to get GP to generate the lines.  If anyone knows what settings are needed to get GP to create the RBC IAT lines in the output file, I'd appreciate any suggestions.  Thanks.

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    Re: EFT for Payables for the Royal Bank of Canada

    Hi Everyone,

    I second Ian in this topic... the EFT file format is very specific for each bank. We use EFT format, but don't have the RBC in our list of financial partners. At the end of the day, it's not that much difficult and as Ian said, start with something and let it check by the bank, or even better let them send you a sample of how the file is supposed to look. Some banks use a single line of data which contains all, and some are more likely to use a header-detail type style. I think GP has some default templates for the TD and NB in Canada. You can start of one those templates. If you don't find them, contact me by e-mail and I'll send you a template for the TD Bank (80 columns row format).

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: EFT for Payables for the Royal Bank of Canada

    Hi All - I wish you luck!! I have in the past suggested that we create a repository of tested and implemented 'hand made' EFT file formats. But got absolutely no response. I'd still be interested in getting something like this going though.

    If anyone wants to send me the RBC file specification document - I'll take a look and see if there is anything that jumps out as being a potential problem.

    At the end of the day - make your absolute best attempt at the file - and submit it to the bank for testing -- they will quickly identify the problem areas.

    Best regards,

    Ian.

  • LynnA Profile Picture
    LynnA 40 on at
    Re: EFT for Payables for the Royal Bank of Canada

    Hi,

    I am wondering if you ever got the RBC EFT for Payables File Fomat figured out?  We are in the process of trying to implement EFT for payables with RBC and I wondered how you made out.

    Thanks for any input or advice that you may have.

    Lynn

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans