Automation is required in capturing balance explanation in GL accounts (ARCS module)

As part of our ARCS implementation, we have a requirement for reconciling GL accounts under the Account Analysis method. Currently, users need to manually provide Balance Explanations for each account, and with over 200+ accounts requiring reconciliation, this process is highly manual and time-consuming.

We would like to explore if there is a way to automate this process and directly load Balance Explanations from EBS into ARCS. However, there is an additional challenge—each reconciliation account has a different explanation template format and pulls transactional data from different sources. Users currently fetch this data manually for reconciliation, but they are looking for an automated solution within ARCS to eliminate this manual effort.