more-arw search

Q&A Forum

My company needs to convert many vendors "en masse" to ACH, is there a quick way to do this?

Marc Williams's Profile

Many of our vendors are still paid by check, so we want to convert, however we are manually having to update the information for each vendor in Oracle and for each paysite. Looking for a quick way to do this and still allow us to process the payments without using a 3rd party to collect information and then process for us outside our system.


Topic Expert
Wayne Spivak
Title: President & CFO
LinkedIn Profile
(President & CFO, |

Here's the easy decision:

How many vendors to change.
Time to make each change manually.
Fully costed employee per hour time.
Cost of a 3rd party software add-on.

Remember, you still have the same information acquisition costs unless you off-load this to your vendors directly and provide them with the ability to enter some system to record the info.

Anonymous User
Title: CFO
Company: Local Government Agency
(CFO, Local Government Agency) |

I've had to do things like this in the past but not with Oracle.

Generally, what I have found worked the easiest was to download current information from the system, frequently to Excel. Make the changes there and create a master upload file. Then reload that corrected information back to the accounting systems for each entity.

I've also been involved where we've used third party software or hired a contractor to update the data. But the results have usually ended up less than satisfactory and required extensive review with quite a bit of manual correction on top of the extraordinary costs of the software and/or consultants who did the work.

Thomas Simkiss
Title: VP of Cloud Applications
Company: Aces High
LinkedIn Profile
(VP of Cloud Applications, Aces High) |

Short answer to you question is no. If you software version supports direct ach output you need to
1. Contact the bank and get the format they want ( CTX, CCD, etc.) and transmission protocol (https, sftp, FTP with pgp, etc.)
2. Setup and test bank connectivity
3. Contact several vendors to get ach transmission. My rule is always five to ten.
4. Pilot with those five to ten fora week in test then a month in prod. Determine if you will send remittance advices and if so how.
5. During pilot. Reach out to your other vendors with what your policy is and what they need to do to take part.

If done right it's a 3 month project. Minimum.

Topic Expert
Edward Abbati
Title: Vice President of Finance
Company: Location Labs
LinkedIn Profile
(Vice President of Finance, Location Labs) |

I am converting our vendor to ACH as we speak. It has been around a three month project. Most of the work has been done manually getting the information directly from the vendors and uploading it into NetSuite. I have talk to our NS rep and I understand that we can set up a portal with our vendors who can update the information via the portal but that is another project.

Sherry Tornow
Title: Director
Company: ACT, Inc.
(Director, ACT, Inc.) |

Do you own the iSupplier module of Oracle eBusiness? This is a great tool to allow the supplier to provide their own information. Might be worth looking into.

Marc Williams
Title: Director of Accounting SSC
Company: Air Liquide
(Director of Accounting SSC, Air Liquide) |

Yes... we do own iSupplier but not using it right now.

So... they can go directly into the portal and add this information? If so, that would be great

Get Free Membership

By signing up, you will receive emails from Proformative regarding Proformative programs, events, community news and activity. You can withdraw your consent at any time. Contact Us.

Business Exchange

Browse the Business Exchange to find information, resources and peer reviews to help you select the right solution for your business.

Learn more

Contribute to Community

If you’re interested in learning more about contributing to your Proformative community, we have many ways for you to get involved. Please email [email protected] to learn more about becoming a speaker or contributing to the blogs/Q&A Forum.