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. 2. Locate Locate the Bank in which you wish to enable ACH payments. Once located, click on the ACH Settings tab.
    3. Using        Image Added

  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)

    destination

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

     

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

    a.

    FieldExampleDescription
     Security:
      $$ADD
    $$ADD ID=DMGYUSF6 BID='NWFACH12345678'
          Customer
                             Customer Checklist, Page 2
    b.
     File Name:
      ACH
      ACH_[bankcode]_[yy][mm][dd]_[batchno]_[filemodifier].
    txt      Implementation
    txt      Implementation Guide, Page
    17c.
    17   Check with your bank to see if they want a specific file name for submittal.
     File Location:
      C
     C:\ACH\
     
    (or the desired location where you wish to save the file)
    d.
    Needs to be accessible by application.  Select ellipsis to ensure file path location is valid.
     File Date:
      Check
     Check Date
    e.

     Descriptive Date: Check
    Date 
    Date                                                                                      (or Run Date depending on desired date on receivers
    bank        statement
    bank statement)  Implementation Guide, Page 16
    f.
     Carriage Returns: Checked Implementation Guide, Page
    17g.
    17 This will put on different lines in file.
     Pad File (10 Blocks) Checked (will 10 block the file, appears optional by Wells Fargo) 
    h.
     Addenda Records: Checked (option to include Invoice details on CCD/CTX payments)
          Implementation
       Implementation Guide, Page 10
    i.
     Balanced File:
      Not Checked 
     Not Checked                                                                                     (will make debits = credits)
          Implementation
      Implementation Guide, Page 12

     

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

...