Question

Import bank file (ACH) AR payments

  • 19 February 2020
  • 2 replies
  • 472 views

Userlevel 5
Badge +8

Hello, has anyone imported customer payments using a standard ACH file from the bank (ACH file is a fixed width (94 characters) ASCII file).  It looks like there are standard external file templates in IFS.  Just wondering if anyone has already done this and what is the set-up to do so?  There are several template available, but not sure if we would need to create our own or not.  Thanks!


2 replies

Userlevel 6
Badge +11

Hi,

In the standard solution you can upload file to external payment for AR/AP reconciliation purpose. More generic file templates are available as system defined templates. But, it is possible you to defined your own template based on your file layout.

Could you please specify the bank and clearing channel which you deal with? Is this US NACHA ACH file or other ACH file. If you refer to NACHA ACH file, it is an output from application for vendor payment. So, I am wondering the purpose of importing it back to the system. 

 

 

Userlevel 5
Badge +8

We ended up using a custom created template with very little information needed from the bank to achieve our import to IFS.  See below:

 

 

The purpose was to simply load customer payments from the bank.  The ACH reference might be a little overstated and not the full intent but nevertheless we got everything to work without issues.

Thanks, Mark

Reply