Sage 100

Does anyone have First Midwest Bank setup for direct deposit or ACH in Sage 100?

No one at the bank has a clue?

The contact person at the bank is clueless. They sent me the nacha format specs which doesn't help much. I need an example with real bank data , and/or the specific values the bank requires. For example: 1.Routing Transit Numbers: Immediate Destination, Immediate Origin, Originating DFI. 2.Do you require a carriage return / line feed after each record? 3.Ctrl +Z at the end of file? 4.Service class code? I have asked for this information but they seem to be having trouble tracking it down. The next step is for me to start calling someone else at the bank. I hope everyone is aware this is all billable. It would be a lot cheaper if someone with a clue would send me the info.

I had the same situation a few years back with a small town bank. She had no clue what I was talking about. I finally just made guesses and tested uploads. Eventually, we got something working. Don't know the relationship the bank has with your customer but have your customer call the bank and request nicely to have someone contact you! Good luck!!

It has been my experience that bank personnel are clueless - and that's why they work in banks. In this case, size does not matter, because Wells Fargo has to be one of the most frustrating.

@JohnHoyt - Totally agree with the WF statement. TG I have a couple Wells Fargo ACH's working so I can just borrow from that. @DougHiggs - What @ThereseLogeais suggested is probably your best bet. Make some guesses and start throwing it at the wall. Something eventually will stick.

How do I send a test (pre-note) of the payroll direct deposit ACH file to the bank? Create a ""test "" payroll to generate the direct deposit file or is there a better way?

Nope. Just set up a couple employees with Direct Deposit and send the prenote. No need to actually start PR.

They changed banks. PR direct deposit has worked well for several years on the previous bank. I want to send a test to the new bank to see if the new bank DD interface is set up like they want it. Will sending an employee pre-note test the setup of the new bank info?

Are they still using the old bank? Since you will probably be setting up a new bank code, sending the pre-note on the new bank will send the new bank settings.

The new bank code is set up and the dd interface is set up for the new bank. I just need to send a test ach file to the new bank. Are you saying to just create a pre-note for one of the employees? Isn't an employee pre-note normally used to test with the employee's bank?

Yes, it is. But you have to get the ACH file accepted by the company bank before it can be sent to the employee bank. And that is why you only change one or two employees back to pre-note status. The KISS method.

Great. Thanks Jeff.