Skip to main content
Solved

Payroll Bank Rec Issue


I’m not sure if this is a glitch in Acumatica or a setup issue on our end. Bank reconciliation is showing the direct deposit batch total as one line on the bank rec (which is how we have it setup in the bank and what we want) and no individual pay stubs; but once the bank rec is released, the individual pay stubs show in bank transaction details as cleared but not reconciled. In next reconciliation the individual pay checks show up for some reason as ready to be reconciled with the cleared box checked. Users cannot reconcile the individual pay stubs because they have already reconciled the whole direct deposit batch in the previous reconciliation. It is like a flip gets switched once the direct deposit batch is reconciled and released that marks the pay stubs as cleared but not reconciled and then allows individual the pay stubs to then show up in the bank rec. I can’t figure out why the individual pay stubs are 1-not being marked reconciled when the full batch is reconciled, and 2-why do they all of a sudden appear in the next bank rec.

 

  • Using V2020 R2
  • Payroll is all ACH done in one direct deposit batch per pay period
  • Cash account is set to “Match Bank Transactions to Batch Payments”

Best answer by Julia Golomidova

Hi @mattsylvia22 ,

According to the issue description, it can be related to the following known issue that has been fixed in 20.211.0037 build:

AC-189873: When the Match Bank Transactions to Batch Payments check box was selected on the Cash Account (CA202000) form, the payroll direct deposit batches (batch payments) were not shown in one line on the Reconciliation Statements (CA302000) form for this cash account. Also, on the Reconciliation Statements form, the value in the Module column was not set to PR and the value in the Tran. Type column was not set to Direct Deposit Batch.
Also, after releasing the reconciliation statement, these payments were still shown separately in a newly created reconciliation statement.
Workaround: To resolve the issue, you will need to apply the special script. Please contact your Acumatica support provider to receive the script and any assistance with running the script.

Here is a page to the known issues page for 2020R2:

https://sso.acumatica.com/(W(3))/Main?ScreenId=KI2020R2&PageID=5989ee6b-e9a4-44ec-9fbf-fa91bd17102d

View original
Did this topic help you find an answer to your question?

2 replies

Julia Golomidova
Captain II
Forum|alt.badge.img+3

Hi @mattsylvia22 ,

According to the issue description, it can be related to the following known issue that has been fixed in 20.211.0037 build:

AC-189873: When the Match Bank Transactions to Batch Payments check box was selected on the Cash Account (CA202000) form, the payroll direct deposit batches (batch payments) were not shown in one line on the Reconciliation Statements (CA302000) form for this cash account. Also, on the Reconciliation Statements form, the value in the Module column was not set to PR and the value in the Tran. Type column was not set to Direct Deposit Batch.
Also, after releasing the reconciliation statement, these payments were still shown separately in a newly created reconciliation statement.
Workaround: To resolve the issue, you will need to apply the special script. Please contact your Acumatica support provider to receive the script and any assistance with running the script.

Here is a page to the known issues page for 2020R2:

https://sso.acumatica.com/(W(3))/Main?ScreenId=KI2020R2&PageID=5989ee6b-e9a4-44ec-9fbf-fa91bd17102d


  • Author
  • Freshman I
  • 8 replies
  • May 25, 2021

Thank you. I ended up putting in a support ticket and they ran the script for me.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings