Bank Statement Import Format

Anyone have a sample csv format they can share for the bank statement import that is working. Our standard from the bank says it is not in the correct format and trying the template format from Epicor does the same.

Using the Interface Erp\EI\StatementImportCSV_Template\StatementImportCSV_Template.cs

Did you ask the Bank to send you their format?

We have 3 formats we can download, one being CSV. Seeems it will need some manipulation of the file or the interface though since it is erroring “Not in correct Format”

Steps are:

  • Get a copy of the CSV from your bank. They should be able to provide a document with the format of the file as well, they do this for EFT and ACH as well. There are supposed to be standards, but these interfaces are a bit like EDI, a standard by name, but that’s about it.

  • Copy the statement importCSV folder and duplicate it

  • Create new Electronic interface pointing to the duplicated interface program

  • Open the project in VSstudio

  • Modify the code to match the format. (it will take a bit of trial and error)

Haven’t had to do one for nearly two years now or so, but that’s the crux of it.

Which reminds me I did promise a particular person I would do a write up and put it in code sharing… I’ll get there at some point. :slight_smile:

Going to refer to this post from the venerable @gpayne

2 Likes