How to set up bank statement import for US Bank

Thanks, @MNlesta. I just spoke to someone in our bank’s treasury department, and their standard file is a BAI file that is pushed to us periodically (daily or monthly). Here’s an example I found on google, that includes the breakdown of type codes as well as an example file: https://www.tdcommercialbanking.com/document/PDF/bai.pdf

@josecgomez - You mentioned setting up a BAI file import in the ‘Innovations’ topic - We’re just looking to import the bank statement to speed up reconciling with automatic matching, not do cash receipt lockbox, etc. From what I gather, we need to set up bank statement transaction codes (to match BAI), create a BAI template, Bank Statement Parsing Parameters, and then import the statement into Bank Statement Processing? Or do you do it a different way?

image

image

Getting there slowly (although not as slow as our bank, who said it’ll take 4-6 weeks to get a BAI file set up on our account). That’s slower than uploading a database to EpiCare!