Deltek Vantagepoint Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

NACHA File Format Tab of Banks Settings Form

If you use the ACH network to make electronic funds transfer (EFT) payments through your bank, use the NACHA File Format tab to specify the file format information.

This tab displays only if you have the Accounting, Expense, or Payroll application installed.

The file format information that you enter on this tab is used to create a file for your bank when you process:

  • Payroll direct deposits
  • Employee expense direct deposits
  • Accounts payable EFT payments to vendors

The formatting that you enter on this tab does not apply to Export to Text files that are created in Accounts Payable and Employee Expenses Payment Processing.

Contents

Field Description
Immediate Origin Number Enter your company identification number, provided by the bank that is associated with this bank code. This number contains the routing number of the ACH Operator or sending point. The 10-character field begins with a blank in the first position, followed by the four-digit Federal Reserve Routing Symbol, the four-digit ABA Institution Identifier, and the Check Digit (bTTTTAAAAC).

This field may also be mutually defined between the originating depository financial institution (ODFI) and originator. For example, the ODFI may ask its originator to put its tax identification number in this field; however, the field must contain the routing number of the sending point when the file is delivered to the ACH operator.

The bank to which the file is submitted, and from which the direct deposit payments is withdrawn, tells the enterprise (originator) what they expect to find in this field. Usually this is the routing number of the enterprise's bank.

Immediate Destination Number Enter the identification number of the bank to which the direct deposit file will be sent. This is the identification number of the bank that is associated with this bank code.
Immediate Origin Name Enter the name of your enterprise.
Immediate Destination Name Enter the name of the bank to which the direct deposit file will be sent. This is the name of the bank associated with this bank code.
Routing Number Enter the eight-digit routing transit number that is assigned to your company by the bank that is associated with this bank code. If this routing number has nine digits, enter the first eight digits only. Vantagepoint calculates the ninth digit.
Company ID The Company ID is an alphanumeric code that is used to identify the originator (the enterprise that submits the file). Enter your nine-digit IRS Employee Identification Number (EIN). Or, enter a number based on the Data Universal Numbering System (DUNS) or a user-assigned value.

When you enter a DUNS or user-assigned number, you must modify the qualifier in the Identification Code Designator (ICD) field on this form.

The bank to which the file is submitted and from which the direct deposit payments are withdrawn tells you what number to enter in this field. In most cases, it is your Employee Identification Number.

Company Name Enter the name of your enterprise as you want it to display on statements.
AP Payment Entry Description Enter a description or purpose for the Accounts Payable EFT payment entry.
Expense Entry Description Enter a description for the employee expense payments direct deposit entry.
Payroll Entry Description Enter a description for the employee payroll direct deposit entry.
AP Payment File Name Enter the file name for the Accounts Payable EFT payment file. The default file name that prefills in this field is DIRDEP.TXT, which is located in the current default directory. If you are unable to locate this file, contact your system administrator.
Expense File Name Enter the file name for the employee expense payments direct deposit file. The default file name that prefills in this field is DIRDEP.TXT, which is located in the current default directory. If you are unable to locate this file, contact your system administrator.
Payroll File Name Enter the file name for the direct deposit file, such as DIRDEP.TXT.
File Format From the drop-down list, select one of the following options to determine the accounting entries to include in each direct deposit processing run:
  • Credits Only: The run includes only credit entries (individual employee entries).
  • Credits and Debit: The run includes credit entries and the debit entry to the company account for the total amount.
Account Number This option is enabled when you select Credits and Debit in the File Format field. Enter the bank account number of the bank from which payment for the total amount of the direct deposit will be made. This is the bank account number that is associated with this bank code.
Separate Batches for Credits and Debits This option is enabled when you select Credits and Debit in the File Format field.

Set this option to Yes to place the debit entry to the company account in a separate batch from the credit entries. If you set this option to No, the debit entry to the company account is placed at the end of the batch that contains the credit entries.

Account Type This option is enabled when you select Credits and Debit in the File Format field.

From the drop-down list, select Checking or Savings as the type of account associated with this bank code.

Identification Code Designator (ICD) Select an item from the drop-down list or enter any value that will be used to qualify the entry in the Company ID field. The ICD value is placed in byte 41 of the company batch header record and in byte 45 of the company batch control record, each of which precedes the Company ID value.

The options are:

  • 1: IRS Employer Identification Number (EIN)
  • 3: Data Universal Numbering Systems (DUNS)
  • 9: User Assigned Number
Include ICD in Immediate Origin Number Set this option to Yes if you want the bank’s Identification Code Designer (ICD) number to be placed in position 14 of record type "1" (line 1) in the generated ACH file.
File Header Byte 4 Character Enter a value in this field to be placed in byte 4 of the file header record. This is the first character in the space reserved for the value entered in the Immediate Destination Number field.
File Padding Set this option to Yes to add dummy records (all 9s) after the file control record in the direct deposit processing file to force the total record count to be a multiple of 10 (if it is not a multiple of 10 at the end of processing).