Skip to main content
Solved

Process Bank Transactions - How to match multiple bank transactions to single payment


We have a vendor for whom we paid multiple invoices in one payment batch. Therefore, there is only one payment reflected in ACU. However, the payment amounts for each invoice withdrew from the cash account individually, so there are now multiple bank transactions that match to a single payment. 

Acumatica allows you to select multiple payments to match to a single bank transaction, but it does not appear to work the other way around. Does anyone know a way to get this to work that I may be missing, or a handy workaround? I would like to avoid voiding and recreating the payments if I can, but let me know if that is the only way.

Best answer by jhenggeler

For anyone searching this topic: the only solution I have found so far is the workaround to verify items agree outside the Process Bank Transaction window, then mark larger ACU transaction as cleared & reconciled in the Reconciliation Statements window and hide all the smaller bank transactions in the Process Bank Transaction window. 

View original

6 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3132 replies
  • November 2, 2023

Hello @jhenggeler ,

I notice your idea has been suggested in the Ideas section of Acumatica Community. If you didn’t already do so, please vote for it here:

https://community.acumatica.com/ideas/process-bank-transactions-match-multiple-transactions-to-the-same-invoice-16117

 

Laura

 


  • Author
  • Freshman II
  • 3 replies
  • November 3, 2023

Thanks for the reply, @Laura02! If I am reading that idea accurately, I don’t think it is exactly the same scenario. To me, that one sounds like they have one bank transaction on the left side of the screen that they wish to connect to multiple invoices on the right side of the screen; am I understanding correctly?

In my scenario, I have multiple bank transactions on the left side of the Process Bank Transactions screen that all match to a single payment on the right side of the screen. 

Going forward, we may be able to change procedures to individualize the payments on the right side of the screen to 1:1 match the left, but I have 3-4 months of activity I need to figure out how to match.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2751 replies
  • December 13, 2023

Hi @jhenggeler were you able to find a solution? Thank you!


  • Author
  • Freshman II
  • 3 replies
  • Answer
  • January 22, 2024

For anyone searching this topic: the only solution I have found so far is the workaround to verify items agree outside the Process Bank Transaction window, then mark larger ACU transaction as cleared & reconciled in the Reconciliation Statements window and hide all the smaller bank transactions in the Process Bank Transaction window. 


Forum|alt.badge.img
  • Jr Varsity II
  • 30 replies
  • November 13, 2024

Yet another process that Acumatica has developed about 80% of the way. The complex matching and system itself would be impressive if it was finished. Much faster to do this manually.

 

They should’ve skipped the matching and developed basic functions needed for a Bank Rec.

 

Its like an autonomous vehicle that can’t turn by itself.

 


  • Freshman I
  • 8 replies
  • December 1, 2024

Our system converts and closes the SO to an open invoice. I found by closing the invoices is the way! I can now match a single payment to multiple invoices. The only thing I am struggling with now is matching a single PO or journal entry to multiple bank transactions in the feed.

 

Help anyone?


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