Skip to main content

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

 

Anna,

Did you ever find a solution for this issue?  We are implementing Acumatica and our bank only offers the BAI2 format.  We will be addressing this issue soon.

@brockinl nope, not yet :(

I have a client with the same situation, they want to implement this BAI system. @aborisova37 could you share the name of the utility that you found to convert the BAI?

From my research, the BAI2 file (PDF spec here) is a comma delimited file that you can import directly using an import scenario. 

The BAI2 file contains several different record types. The account number, transaction date, and details are all in different records. So if your bank provides a different file for each account and each date, then the import is quite easy. If you get a single file with multiple accounts and dates then the import gets more complex unless you do some pre-processing of the file.

We are gathering feedback on the ideas portal here.

Reply


Terms & ConditionsCookie settings