Automate Bank Closing balances load into ARCS & attach supporting documents

In Current process, All Cash reconciliations are account analysis method and business would manually perform balance explanation and upload attachment that are manually downloaded from bank portal as closing balance evidence which is a SOX requirement.

We're exploring the possibility of connecting to the bank portal/SFTP to retrieve end-of-month statements for automatic loading of closing balances into ARCS, with the ability to upload these statements as attachments for reconciliation purposes along with loading balances.

Alternatively, if direct access to the bank portal is not feasible, we're looking if anyone has implemented loading of closing balances from the Cash Management/Treasury System into ARCS as subsystem balances.