How to auto reconcile batch level payments (on bank stmts) with Expense report level GL journals ?

Hello Oracle Cloud Community,

We are facing significant challenges in reconciling Expense report payments (moved from Concord to Oracle GL) with our bank statements in cash management. Our current process involves using Concord integrated with a third-party payment processor. Payments are deducted as batch totals (e.g., $1,000 for 10 reports) from our bank, but they hit the GL at the individual expense report level. This creates mismatches between our bank statements and GL, requiring extensive manual reconciliation efforts.

For example - 10 employees submit 10 reports in Concord with a total of 1,000 dollar over a course of 5 days. We have reports moved from Concord to Oracle GL on a daily basis i.e. 10 different GL journal batches each hitting the cash a/c 10 times. Third party payment processor gets the batch info from Concord and deducts the payment from bank as a batch total (1,000 dollars) and distributes it to each employee based on their individual report amount. Now, the bank statement shows one line of 1,000 dollars whereas there are 10 GL journal batches totaling