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

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:

Laura

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.

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

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.

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?

Hi - I’m commenting on this older post because we, too, have run into the same issue where we need to match multiple bank transactions on the Left side of the reconciliation with a single transaction on the right side of the screen.  The suggested ‘upvote’ topic doesn’t cover this issue, as we need to match multiple on the Left with a single on the right.

We have been handling it with the same work around ​@jhenggeler suggested, however, that method still leaves the ACU payment on the right side unchecked for future bank transaction processing, so it will never be removed from the list (it does however mark them cleared inside each payment).

Hello!

I have the same concern where the supplier payment (Salary for Internal employees or external supplier payments for multiple Bills) made as a single entry in Acumatica is recorded with multiple lines in Bank Statement as the payment is going for different accounts (Salary for internal employees) or for different invoices (External Supplier Payments). 

Currently, I am unable to reconcile the Bank Statement transaction line with multiple payment lines of Acumatica due to the reason bank statement line is not fully matched with Acumatica payment. 

Is there any way that I can handle with this or a workaround that adjusting the Bank Statement manually and importing it to the “Import Bank Transactions” screen?

Thank You!

Hello ​@apallawala21,

The best workaround my team has found to date is to use what I’d label as a “Hide in Processing, Clear in Reconciliation” approach. It is open to errors, so it must be done carefully, but it works. Here is an example:

Say you have a vendor payment that is a single entry of $1,000 in Acumatica. However, it pays two supplier invoices: one for $250 and one for $750. For whatever reason, the payments for the invoices come out individually on your bank account, so you are left with one Acumatica transaction to two bank transactions, which you cannot clear in the Process Bank Transactions window because of the limitation we are discussing.

The workaround for us is this in such a scenario: it requires simultaneously finishing the Process Bank Transactions while also starting the Reconciliation Statements for that same account. When we encounter something like this, we manually confirm the single Acumatica item belongs with the two bank statement items. Next, in the Process Bank Transactions window, we select the two bank transactions and click “Hide Transaction”. Next, we switch over to the Reconciliation Statements window (usually open at the same time on another tab for this reason) and find the single Acumatica transaction that belongs with the two hidden ones. We mark “Reconcile” for that transaction (which automatically marks “Cleared”) and then save.

Not perfect, but it works and does not require backing out and re-creating transactions, or manually modifying the bank transactions for import (which would require pre-reconciling before import).