Importing Bank Statements for Bank Account Defined Twice

Summary

Experiencing issues interfacing bank statements due to the same bank account number used for two cash management bank accounts

Content

Our main disbursements bank account is used by Payables to send ACH and Check payments. In order for our bank to send them correctly, we need to send ACH under one routing number and Checks under a different routing number. This forced us to create two bank accounts in Cash Management, both using the same account number, but pointing to two different bank branches (with the different routing numbers attached).

Our issue is that when we attempt to import our bank statements, the process results in error because the import process is trying to create multiple statements for the same account and day. The process only has the statement date and bank account number to go off of.