Is there a US $ batch format? I'm not seeing one

Hello Janet,

No sorry, EFT does not handle ACH. It is only for Canadian Banks.

Janet:

You can do US EFT from a US based bank (RBC Georgia for example) using PrintBoss. This would be fully integrated like Canadian EFT payments with Adagio Payables EFT.

Alternatively you could use Telpay, as I do, to pay your US vendors electronically but the USD part of Telpay is not integrated with Adagio.

That's unfortunate but thanks for all the input.

Is there a reason that ACH format is not being added? Seems odd that Softrak would want to limit itself to Canada as far as EFT transactions are concerned.

ACH is much more complex than any Canadian EFT format that we currently have. It is not a project that we are looking at, at this time.

Hi,
We are just completing an ACH processing certification with PrintBoss for integration with Wells Fargo for one of our California clients. Other than the extended testing with Wells Fargo with has tested my patience, we use most of the same fields that are in the EFT processing and it works. And the Wells Fargo team are great to work with.

We enable EFT in the AP company profile. But understand that just because you enable it, you cannot run EFT to select for any vendors that have EFT. Sorry but very short sighted on behalf of Adagio. So we also enable an EFT reporting group so that we can select vendors that we want to run ACH processing on.

We put the US bank account in the EFT banking information for the vendor. Again, too bad that someone thinks than only Canada does Electronic Funds transfer, but the issue is just with the display. If you ignore the CAD bank account display the details will export on to the form as a continuous string.

We put the Routing number in another field on the vendor records, and let PrintBoss format the string details from a generic Check Spec that we simply do not print. And they create the CSV file in the requested bank format.

We use the Adagio AP emailing of the additional forms to email the stub details to the vendor. Because the stub additional forms does not concern itself with a limit on the number of invoices paid on a check form, we can have unlimited payments on the additional forms that match to the AP deposit advice.

Then you're home free with your ACH solution for US domestic payments. It's not so bad. As Doug has suggested, international ACH is a little trickier and we may attempt that after we complete this project. Many of our US clients are requesting ACH processing as a requirement to efficiently deal with Covid-19 processing issues of working in isolation. And if you cannot deal with it, it's almost a show stopper these days.

Best,
Brian

Is everyone ignoring Doug's reply?

"You can do US EFT from a US based bank using PrintBoss"

It's very straightforward, although it's a pain to gather and maintain the bank account info and email address of your vendors. I set this up at a client yesterday with Wellspring Software's help and it took less than an hour.

Steve

Hi Steve, our work with Wellspring is intended to remove that pain point so that the everything from the bank information to the advice emails can be managed in AP.

It also resolves an issue on their end where too many matched documents could produce a 2 page advice that would mess up the process.

Hello Janet,

The Payables 9.3C (2021.07.06) Upgrade released today has a few new formats that handle US$.

There are formats for:
VanCity 1464 USD
CIBC 1464 USD

Royal Bank ACH094
Royal Bank 152 STD format US ACH.