[Vicki Hillary]

We are working on setting up electronic payments for our vendors and I am getting a little overwhelmed with all of the different file formats available.  Is there a difference between NACHA-CCD and NACHA-PPD?  Is the file format specific to the vendor receiving the payment or is it really based on the issuing bank?  Also, we are looking for best practices for obtaining vendor information related to EFT setup and what verification steps you take when setting up a vendor for their first electronic payment.

Thank you.

——————————
Vicki Hillary
RDV Corporation
Grand Rapids MI
——————————

[Thaddeus Suter]

Typically CCD format would be used for your Trade Vendors with Corporate Bank Accounts at their bank and PPD format for your Employee Vendors who more likely have personal accounts at their banks. The Payables EFT setup for your Checkbook would then be File Format Based on Vendor not Single Format. It is your bank however that will tell you what they want in your EFT file.

——————————
Thaddeus Suter
Retus, Inc
HELOTES TX
——————————
——————————————-

[David Shapiro]

We use an Abobe Sign template and send it to the vendor for them to complete. In addition to the standard NACHA file there is a capability to also have addendum records included but we have found there are various bugs in GP with addendum records. So I would stay away from these.

——————————
David Shapiro
Director of Information technology
Barron Collier Partnership
Naples FL
——————————
——————————————-

[Lou Spevack]

Microsoft said they would fix those bugs in the CTX format but never came through.  Ask your vendors to provide an email address for sending remittance advices.  When you run EFT payments, you can have the remittance forms emailed to each vendor.  If they provide a dedicated email, you won’t need to maintain it when the contact leaves the vendor.  If you maintain your own EFT formats, an enhanced editor like Notepad++ will be a huge help.  Most banks provide file mapping documentation and the GP mapping interface is pretty good.  Knowledge of the PM tables is helpful and installing the SDK that comes with Dynamics GP provides very good table reference.

——————————
Lou Spevack
American Council on Education
Washington MD
——————————
——————————————-

[John Buchman]

Hi  Vicki,
Your bank should be able to give you a spec sheet for the files.  You should be able to follow their instructions to update each field in the setup window.  Each bank typically has their own requirements.  They should also be able to process a test file to ensure it works properly.

——————————
John Buchman
Controller
Rio Marine
Houston
——————————
——————————————-

[Kevin Pritchard]

Hi Vicki, 

Greetings from another Michigan West Sider 🙂

I work for an ISV that takes care of all the legwork with setting up ACH. You’d still be sending payments directly from your bank account to your vendors. We integrate directly with GP so you’d basically just pick what you want to pay, upload that batch to our system, and we’d handle file generation and delivery to your bank (after an optional approval) . We also have a self service vendor portal to make onboarding your vendors to ACH easy, and secure. We’re also compliant with the new NACHA encrypted at rest requirements if that is a concern of yours as well. 

You can view more info here: https://www.fidesic.com/product/vendor-payments

Or feel free to reach out to me directly, happy to help if it makes sense, otherwise, no worries. 

 Kevin

——————————
Kevin Pritchard
Fidesic
——————————
——————————————-

[marlas Stinson]

Thanks for this interesting information! I will also try to same.

——————————
marlas Stinson
Noca+
??????
——————————
——————————————-