How to Set up Payroll Direct Deposit Interface file for Sage 100

Description

How to Set up Payroll Direct Deposit Interface ACH file

Resolution

Complete the Direct Deposit Interface setup based on the file layout specifications from your financial institution.

Open Payroll, Direct Deposit, Direct Deposit Interface Setup.
In the Bank Code field, select Bank Code
Click Main tab, and select Direct Deposit check box.
Complete the following fields:
- Account Type:
  - Select Checking for a checking account.
  - Select Savings for a savings account.
- Pre-Note Approved:
  - Select this check box if a pre-note has been approved for this bank account.
- Immediate Destination:
  - Enter the transit/routing number and description of the ACH (Automated Clearing House) operator, or receiving point to where the file is being sent (as directed by your financial institution).
- Immediate Origin:
  - Enter the routing number and description of the ACH operator, or sending point of the file (as directed by your financial institution).
- Originating DFI:
  - Type the originating DFI (Department of Financial Institutions) routing transit number for this bank. This field defaults to the Immediate Origin Routing Number without the check digit. Accept the default selections unless directed by your financial institution.
Click Primary tab, and complete the following fields:
- Leading Character for Immediate Origin:
  - Enter the leading character before the Immediate Origin Routing Number (if required by your financial institutions).
- Put CR/LF After Each Record:
  - Yes: This option adds a carriage return/line feed combination after records in the ACH file.
  - No: This option adds nothing to the record. This produces record lengths of exactly 94 bytes in the ACH file.
  - CR only: This option adds a carriage return only.
  - LF Only: This option adds a line feed only.
  - LF then CR: This option adds a line feed followed by a carriage return.
- Put Ctrl+Z at End of File:
  - Select this check box to include a Ctrl+Z at the end of the file.
- Date for File Creation: Select the creation date for the File Header record (record type 1):
  - Run date is the calendar date.
  - System date is the module date.
  - Effective date is the check date.
- Service Class Code:
  - Enter the service class code for Batch Header record (record type 5) and the Batch Control record (record type 8) in the ACH file. The default value is 200. This field should remain blank unless directed by your financial institution.
- Space Rather Than Dash in the Word ‘Pre-Note’:
  - Select this check box to add a space instead of a dash (-) in the word Pre Note.
- Include Only Employee Records:
  - Select this check box to produce an ACH file with no file header, file control, batch header, or batch control records. The resulting ACH file contains only Entry Detail (record type 6) records.
- Pad File to Block Size of 10: Select an option below to pad the file to fill the block:
  - Yes to pad the file with 9 records to fill the block. A block is a group of 10 records. If the number of records in the ACH file is not a multiple of 10, the character 9 fills the character positions at the end of the file to make the number of records equal to a multiple of 10.
  - No if no additional records must be added.
  - 9 to pad the file with ten records, and to fill positions 56-94 in the File Control Record with nines. Some financial institutions require that a file be submitted in complete physical blocks of ten records each.
- Valid File ID Modifiers
  - Select the range to character for the first file ID modifier. For each time the check register is printed and the ACH file created, this value increments within the range specified.
- Date for Descriptive Date Select the descriptive date (Batch Header record, record type 5):
  - Run date is the calendar date
  - System date is the module date
  - Effective date is the check date
- Zero Fill Settlement Date:
  - Select this check box to add a 3 character settlement date (Batch Header record, record type 5). By default, the settlement date is 000.
Click Advanced tab, and complete the following fields
- Include Internal Bank ID:
  - Select this check box to include the description required by your financial institution as a record to precede the File Header (record type 1) in the ACH file. Clear this check box to leave the File Header record (record type 1) as the first record in the ACH file.
- Use 80 Byte Text as 1st Record:
  - Select this check box to use 80-byte text as the record to precede the Internal Bank ID record as the first record in the ACH file. Clear this check box if 80-byte text is not required by your financial institution.
- Include Debit Record
  - Select this check box to include a debit record for your company. Your financial institution may use the term ‘Balance File Format’ when a debit record is required. Clear this check box if a debit record is not required. An entry detail record is created in the file after all employee records are processed.
- Transaction Code:
  - Type the transaction code to be used for the debit record as directed by your financial institution. This field is available if the Include Debit Record check box is selected.
- Receiving DFI Identification:
  - Type the transmit/routing number to be used for the debit record as directed by your financial institution. This field is available if the Include Debit Record check box is selected.
- DFI Account Number:
  - Type the bank account number to be used for the debit record as directed by your financial institution. This field is available if the Include Debit Record check box is selected.
- Individual ID Number:
  - Type the individual ID number to be used for the debit record as directed by your financial institution. This field is available if the Include Debit Record check box is selected.
- First Hawaiian Bank
  - Select this check box if using direct deposit with First Hawaiian Bank. An additional record is appended to the file created that meets the First Hawaiian Bank standards.
- Character to Precede Company ID:
  - Type a character to become the first character in Company ID field besides “1” before the Company ID, (Batch Header record, record type 5, Position 41).By default, a “1” is inserted into the ACH file before the Company ID. Leave this field blank to place a blank in front of the company ID.
- Alternate Employer ID Number:
  - Type an ID number to be used in the ACH file. (Batch Header record, record type 5, Position 42-50). Leave this field blank to use the federal ID number assigned in Company Maintenance.
- Alternate Company Name:
  - Type the company name to be used in the ACH file. Leave this field blank to use the company name assigned in Company Maintenance.
- Company Discretionary Data:
  - Type additional company information to be included in the ACH file (Batch Header record, record type 5), if directed by your financial institution.
- Alternate Company Name:
  - Type the company name to be used in the ACH file. Leave this field blank to use the company name assigned in Company Maintenance.
- Company Discretionary Data:
  - Type additional company information to be included in the ACH file (Batch Header record, record type 5), if directed by your financial institution.
- Company Entry Description:
  - Type the text to overwrite the standard Sage 100 Direct Deposit Comment field.
Click Accept button.