Import Bank Transactions (BAI)

We will be transitioning banks starting in the next month or two, problem we have is the bank upload files. Both have 2 options

1. They provide us will bank transaction files. Problem is that these files contain ACH batch totals only. To resolve this they will provide a separate ACH activity file. So we will have to recon the activity to the batch, delete the batch out of the bank transaction file and cut and paste the ACH detailed activity in. So manual and error-prone.
2. Bankers will provide us with a single BAI file that contains all banking transactions and this has the ACH down to the individual transaction level. BAI’s are the industry standard for the banks, so does Acumatica have a way of uploading these? A BAI file looks something like this - see attached. The extension on these files is either .BAI or .BAI2. Note: a single file contains all activity across all our bank accounts.

We found a utility that can convert the BAI to an excel format but then we need an import scenario that can bring in these details into the Import Bank transaction screen.  Should this be doable? What would you suggest?

Thank you,

Anna