How I fixed an ACH file rejected because of the effective entry date

I dealt with this recently in a banking operations process that generated ACH payroll files from an internal system. The visible problem was the ACH file was rejected because the effective entry date landed on a non-processing day. The easy explanation was a bank portal upload glitch, but it appeared when payroll was approved late on a Friday before a holiday weekend. That mattered because operat…