Bank Statement Processing - Cannot select Payroll ACH for matching

Kinetic ERP
1

Bank Statement Processing - Cannot select Payroll ACH for matching

When we we’re doing paper checks, each check was matched against our bank statement and we were able to balance. Now that we are doing ACH, there is only $0 entry for each employee check and no Total ACH. Our bank statement has a total ACH line for our payroll.
We have called Epicor but the two solutions they offered do not seem like clean ways to handle this.

KB0115941

  1. Update the opening balance of the bank statement to reflect the difference to which those payroll checks have cleared.
  2. Do a bank adjustment as needed but note, you will want to Debit & Credit the same GL Account when you do this adjustment so you do not affect General Ledger which has already been updated.

With #1 - this solved the issue but creates a red flag for our auditing as our opening balance will be wrong by the total payroll ACH month, and then wrong when comparing month to month.

With #2 We did an adjustment which is net 0 - the adjustment shows up to match, but the opposite adjustment will linger in the system for eternity in Bank Statement Processing.

Our ACH is a Deduction and processed through Check Entry, Nacha file is created and processed by the bank.
Deduction is GL Control to our bank account.

2

Possible solution:

In Bank Adjustment - Created Bank Fee for Nacha that uses our checking GL acct.
Created a negative adjustment using the total ACH amount and checking GL acct.
Edit list has the adjustment go full circle, and only creates 1 journal entry. (Net Zero for credit and debit)

This single adjustment now shows up in Bank Statement Processing to be matched.