Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Payroll ACH Files
Microsoft Dynamics GP (Archived)

Payroll ACH Files

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Is anyone else having trouble getting their bank to accept an ACH file output for Payroll?  My bank recently switched Web providers and ever since I have had trouble getting it to accept the ACH file output from GP!  I had to add balancing totals and change other settings, it looks like everything is correct then when I upload the file, error after error.  They are using FiServ platform now and it is like I am the ONLY one having issues.  Please, is anyone else having problems?

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Payroll ACH Files

    Yes, despite what Microsoft thinks they are NOT creating a correct file in GP!!  I ran into the same problem.  Since Microsoft, in all their infinite wisdom, has decided that it is not an issue, and it was a user error, I had to edit each ACH file that was created.  Here are the 2 errors in the file.  First line, after the 101 there needs to be a space, then after the Fed routing number there currently is a space between it and your bank's Routing Number, remove that space, the line should align itself after that.  Second error, is in the 627 line (or 637 if using a Savings account to pay from), there is a blank space, if you notice that is because the system clipped off the end of your Routing number and last digit needs to be added, highlight the blank space and type in the correct digit.  Save the file and resend it.  I did my edits in Notepad, that program doesn't change anything else about the file and so you should be able to edit and try to upload it again, with these corrections it works out with Fiserv.  Our bank switched over to them a couple of years ago and I had the same issues.  I hope this helps.

  • Trisha Tretter Profile Picture
    Trisha Tretter on at
    RE: Payroll ACH Files

    Terry,

    We are getting a Entry Hash error, our bank just changed our ACH files to enhanced.  This is only happening on our large companies, not the small ones.  Any ideas where or how I fix this Entry Hash issue?  We also have the Fiserv platform with our bank. 

    Trish

  • Suggested answer
    Terry R Heley Profile Picture
    Terry R Heley Microsoft Employee on at
    RE: Payroll ACH Files

    Hello, our payroll direct deposit file is NACHA formatted, this is what all banks accept.  I have not heard of a bank yet, that would not take our file.  At times you may need to change it to add ASL auto settle line, the balance line as you did, depending if the bank wants it, but otherwise it should work.  I would have the bank tell you what is wrong on the ACH file you sent to see if it can be changed, but I have not heard of a bank that does not accept our file as it is NACHA regulated.

    Thanks

    Terry Heley

    Microsoft.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans