Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This article documents how to configure your bank accounts to allow ACH transactions.

Pre-requisites

  1. Bank Accounts

Step-by-Step Guide

  1. Navigate to the Bank Account Master (Master Table -> Miscellaneous -> Bank Accounts).

  2. Locate the Bank in which you wish to enable ACH payments. Once located, click on the ACH Settings tab.
           

  3. Using the information obtained from your Bank, populate the necessary File Header & Batch Header fields.  (This is a sample used by Wells Fargo for demonstration purposes)

    FieldExampleDescription
    Destination #: 091000019 (preceded with a space)   Implementation Guide, Page
    20
    20    This is usually Banks Routing number
     Destination Name: WELLS FARGO    Implementation Guide, Page 20
     Origin Number: 1Tax ID # (also known as the File ID, 1 followed by your Tax ID)   Implementation Guide, Page 11, 20
     Origin Name: CULTURA EGGS       (account name as registered with the Bank)  Implementation Guide, Page 20
     Company Name: CULTURA EGGS        (or, the text you wish to appear on the receivers bank statement)  Implementation Guide, Page 12 & 16
     Entry Description: AP PAYMENT            (or, additional description of the ACH transaction reason)  Implementation Guide, Page 16
     Alternate ID:
     
     
     (Company Discretionary Data, optional / used to assist in identifying your company.  Implementation Guide, Page 21

     

  4. Using the information obtained from your Bank, populate the necessary File Settings:

    FieldExampleDescription
                               
  5. Security:                    
  6.  Security:$$ADD ID=DMGYUSF6 BID='NWFACH12345678'
  7.                         Customer
  8.                          Customer Checklist, Page 2
  9. File
  10.  File Name:
  11.                   ACH
  12.   ACH_[bankcode]_[yy][mm][dd]_[batchno]_[filemodifier].
  13. txt            
  14. txt      Implementation Guide, Page
  15. 17File Location:              C
  16. 17   Check with your bank to see if they want a specific file name for submittal.
     File Location: C:\ACH\
  17.                                                                                            
  18. (or the desired location where you wish to save the file)
  19. File Date:                    Check Date
  20. Descriptive Date:        Check Date                                                                                      
  21. Needs to be accessible by application.  Select ellipsis to ensure file path location is valid.
     File Date: Check Date
     Descriptive Date: Check Date                                                                                      (or Run Date depending on desired date on receivers bank statement)  Implementation Guide, Page 16
  22. Carriage
  23.  Carriage Returns:
  24.        Checked Implementation
  25.  Checked Implementation Guide, Page
  26. 17Pad
  27. 17 This will put on different lines in file.
     Pad File (10 Blocks)
  28.    Checked                                                                                           
  29.  Checked (will 10 block the file, appears optional by Wells Fargo) 
  30. Addenda
  31.  Addenda Records:
  32.       Checked                                                                                            
  33.  Checked (option to include Invoice details on CCD/CTX payments)   Implementation Guide, Page 10
  34. Balanced
  35.  Balanced File:
  36.            
  37.  Not
  38. Checked                                                                                     
  39. Checked                                                                                     (will make debits = credits)  Implementation Guide, Page 12

     

  40. Click the Save button to commit the changes to the database.

...