Best Of

Thanks @CherylLindstrom we don't have grant agreement for each grant that goes out each week and that's why I am asking if there is another way to verify account numbers before releasing the grant payment to grantees who receive grant from us only very few times a year. Some grantees who receive grants frequently form us do get back to us as soon as they have new banking information so we can update our system.

Hello. We switched to ACH two years ago. Note, we have two cycles per year, approx 200 payments each cycle that we process all at the same time.

We ask for the authorized banking contact email address on our grant acceptance (agreement) form within GLM. I then run a report on that field once I receive all the agreements back and export as .csv. We utilize DocuSign to obtain banking details (routing, account numbers etc.). I created templates with DocuSign and utilize the batch functioality to send to everyone in a few clicks (each org gets their own envelope).They are encyrpted and easily purged after the process is complete. Once they are all returned, I utilize DocuSigns export function that takes all the banking information and places it in another .csv file on our encrypted cloud server. From there, I import it into our online banking ACH templates in bulk. It sounds like a lot of steps but is rather easy and secure. We are considering bill.com. Two years ago, because there weren't a lot of foundations using it combined with not having customer service readily avaible, I went this route. But I am now reconsidering given the current track record. Happy to provide more details if people are interested. Good luck!

Thanks for this information!!!

@TrinaFrandsen I did just learn that Foundant supports APIs for those with an Advanced license. I don't know quite how these work (yet!), but I believe the capability could be used to export installments, including bill.com PNIs, to Quickbooks, then import payments back into GLM.

Thank you @KaraAdams - I'll have to check out those links!

@TrinaFrandsen & @DeborahMueller - Don't quote me, but I believe this is already an Idea Lab suggestion. Feel free to vote it up there, or add your own specific suggestion. In the meantime, there are a few other discussions here in Compass that might be helpful.

Kara

Community Manager