Direct Deposit Interface Setup- Fields

 

Direct Deposit Interface Setup

Expand/Collapse all Show/Hide All

Bank Code

Enter the bank code for the bank account to add or maintain, or click the Lookup button to list all bank codes. The bank code must be a letter or a number; do not enter a special character (!, @, #, $, %, ^, & , *, ( ), { }, [ ])  at this field.

Note Bank code A is the default bank code and is permanently assigned to your main bank account by the system; it cannot be deleted. Complete the information for this account before entering bank codes for other accounts.  

During Accounts Payable and Accounts Receivable system startup, enter the bank code defined as the default bank code in Accounts Payable Options and Accounts Receivable Options.

Note Bank code Z is used during the clearing process. Do not use bank code Z if you plan on using the A/P from A/R Clearing feature. If you do not plan on using the A/P from A/R Clearing feature, you can use bank code Z for day-to-day entries.

 

Description

This field displays the name of the bank or a description of the bank account entered in Bank Code Maintenance. Make any changes to the description in Bank Code Maintenance. This field can only be viewed.

 

1. Main

 

Cash Account Number

This field displays the general ledger cash account number corresponding to this checking account entered in Bank Code Maintenance. Make any changes to the cash account number in Bank Code Maintenance. This field can only be viewed.

If the account number is longer than the field, use the left and right arrow keys to view the entire account number.

 

Bank Account Number

This field displays the bank account number for this bank account entered in Bank Code Maintenance. Make any changes to the bank account number in Bank Code Maintenance. This number can be found on your monthly bank statement and on the bottom of your checks. This field can only be viewed.

 

Account Type

Select Checking for a checking-type account, or select Savings for a savings-type account. This field is available only if the Direct Deposit check box is selected.

 

Next Check Number

This field displays the next check number to use for this bank account entered in Bank Code Maintenance. This number increments automatically each time a check is issued for this bank code. This field is updated automatically when checks are updated and can only be viewed.

While checks are being processed for this account, this number cannot be changed. After the checks are updated, the next check number can be reset, if necessary.

This field is available only if the Accounts Payable module is installed, and if you accessed Bank Code Maintenance from Common Information, Accounts Payable, Payroll, or Bank Reconciliation.

 

Direct Deposit

Select this check box to use this bank account for direct deposit. Clear this check box if you do not want to use this bank account for direct deposit.

Note If you are using the Sage 100 Direct Deposit service, only one bank account can be set up for direct deposit. If you need to change which bank account is used, you must contact Sage Direct Deposit Support. Selecting a different account in this task will not update your record in Sage 100 Direct Deposit.

 

Pre-Note Approved

Select this check box if a pre-note has been approved for this bank account. Clear this check box if a pre-note has not been approved. This field is available only if Manually Send ACH File is selected in the Direct Deposit Interface field in Payroll Options and the Direct Deposit check box is selected.

 

Immediate Destination

Type the transit/routing number and description of the Automated Clearing House (ACH) operator or receiving point to where the file is being sent. The 9-character field begins with the 4-digit transfer number followed by the 4-digit American Bankers Association (ABA) number and check digit. This field is available only if the Direct Deposit check box is selected.

If directed by your financial institution, you can also enter a different transit/routing number than the one from the ACH operator. A message appears that allows you to save the alternate number.

 

Immediate Origin

Type the routing number and description of the ACH operator or sending point of the file. The 9-character field begins with the 4-digit transfer number followed by the 4-digit ABA number and check digit. This field is available only if the Direct Deposit check box is selected.

If directed by your financial institution, you can also enter a different transit/routing number than the one from the ACH operator. A message appears that allows you to save the alternate number.

 

Originating DFI

Type the originating Department of Financial Institutions (DFI) routing transit number for this bank. This field defaults to the Immediate Origin Routing Number without the check digit. Accept the default unless directed by your financial institution. This field is available only if the Direct Deposit check box is selected.

 

Alternate Employer ID Number

Type an ID number to be used in the ACH file. Leave this field blank to use the federal ID number assigned in Company Maintenance. This field is available only if the Direct Deposit check box is selected on the Main tab.

 

Alternate Company Name

Type the company name to use in the ACH file. Leave this field blank to use the company name assigned in Company Maintenance. This field is available only if the Direct Deposit check box is selected on the Main tab.

 

Fee Expense Account Number

Enter the general ledger account number to use for ancillary fees related to the Sage 100 Direct Deposit service, such as an NSF charge or a fee for reversing a transaction. If you incur a fee, a transaction journal entry is created the next time that you synchronize data using the Process Employee Pre-Note and Direct Deposit Transactions window. The fee must be reviewed and updated to the general ledger.

This field is available only if Sage 100 Direct Deposit Service is selected in the Direct Deposit Interface field in Payroll Options.

 

Alternate Billing Bank Code

Enter the bank code for the bank account that you selected as the billing bank account when signing up for the Sage 100 Direct Deposit service. If you incur a fee, a transaction journal entry is created the next time that you synchronize data using the Process Employee Pre-Note and Direct Deposit Transactions window. The fee must be reviewed and updated to the general ledger.

 This field is available only if Sage 100 Direct Deposit Service is selected in the Direct Deposit Interface field in Payroll Options.

 

2. Primary

 

Note This tab is available only if Manually Send ACH File is selected in the Direct Deposit Interface field in Payroll Options.

Leading Character for Immediate Origin

Type the leading character before the Immediate Origin Routing Number. The leading character is only required by some financial institutions. This field is available only if the Direct Deposit check box is selected on the Main tab.

 

Put CR/LF After Each Record

Select the option to add a return after each record. This field is available only if the Direct Deposit check box is selected on the Main tab.

Option

Action

Yes

Adds a carriage return/line feed combination after record in the ACH file.

No

Adds nothing to the record. This produces record lengths of exactly 94 bytes in the ACH file.

CR only

Includes a carriage return only.

LR only

Includes a line return only.

LF then CR

Adds a line feed, then 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 as directed by your financial institution. Clear this check box to not include a CTRL+Z at the end of the file. This field is available only if the Direct Deposit check box is selected on the Main tab.

 

Date for File Creation

Select whether the file creation date for the File Header record (record type 1) in the ACH file is the run date, system date, or effective date. The run date is the calendar date, the system date is the module date, and the effective date is the check date. This field is available only if the Direct Deposit check box is selected on the Main tab.

 

Service Class Code

Type the service class code for the Batch Header record (record type 5) and the Batch Control record (record type 8) in the ACH file. Leave this field blank unless directed by your financial institution. This field is available only if the Direct Deposit check box is selected on the Main tab.

 

Space Rather Than Dash in the Word 'Pre-Note'

Select this check box to put in a space instead of a dash (-) in the word Pre-Note. Clear this check box to leave a dash in the word Pre-Note. This field is available only if the Direct Deposit check box is selected on the Main tab.

 

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 will contain only Entry Detail (record type 6) records. This field is available only if the Direct Deposit check box is selected on the Main tab.

 

Pad File to Block Size of 10

Select the option to pad the file to fill the block.

Note Select Yes or 9 only if you are instructed to do so by your financial institution.

 

Valid File ID Modifiers

Select the range of characters for the first file ID modifier. Each time the ACH file is created, this value increments within the range specified. This field is available only if the Direct Deposit check box is selected on the Main tab.

Note Select the range only if you are instructed to do so by your financial institution.

 

Date for Descriptive Date

Select whether the descriptive date (Batch Header record, record type 5) is the run date, system date, or effective date. The run date is the calendar date, the system date is the module date, and the effective date is the check date. This field is available only if the Direct Deposit check box is selected on the Main tab.

 

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. Clear this check box to leave the statement field blank. This field is available only if the Direct Deposit check box is selected on the Main tab.

3. Advanced

 

Note This tab is available only if Manually Send ACH File is selected in the Direct Deposit Interface field in Payroll Options.

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.

This field is available only if the Direct Deposit check box is selected on the Main tab.

Note Select this check box only if you are instructed to do so by your financial institution.

 

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. This field is available only if the Direct Deposit check box is selected on the Main tab.

Note Select this check box only if you are instructed to do so 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 have been processed. This field is available only if the Direct Deposit check box is selected on the Main tab.

Note Select this check box only if you are instructed to do so by your financial institution.

 

Transaction Code

Type the transaction code to be used this debit record as directed by your financial institution. This field is available only 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 only if the Include Debit Record check box is selected.

 

DFI Account Number

Type the bank account number to use for the debit record as directed by your financial institution. This field is available only if the Include Debit Record check box is selected.

 

Individual ID Number

Type the individual ID number to use for the debit record as directed by your financial institution. This field is available only if the Include Debit Record check box is selected.

 

First Hawaiian Bank

Select this check box if you are using direct deposit with First Hawaiian Bank. An additional record is appended to the file created that meets the First Hawaiian Bank standards. This field is available only if the Direct Deposit check box is selected on the Main tab.

Expand or collapse item First Hawaiian Bank Record Layout

Data Element

Position

Length

Remark

Record Description

1-8

8

'?TRAILER'

File ID Number

9-14

6

'EFF230'

Immediate Origin

15-25

11

From File Header Record, position 14B23

Total Record Count

26-30

5

((Block Count * 10) + 2) Block Count from File Control Record, position 8B13

Total Debit + Credit

31-40

10

From File Control Record, position 46B55

Filler

41-94

54

Blank

 

Character to Precede Company ID

Type a character to become the first character in Company ID field besides 1 before the Company ID. 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. This field is available only if the Direct Deposit check box is selected on the Main tab.

 

Company Discretionary Data

Type additional company information to be placed in the ACH file (Batch Header record, record type 5) if directed by your financial institution. This field is available only if the Direct Deposit check box is selected on the Main tab.

 

Company Entry Description

Type text to overwrite the standard Sage 100 Direct Deposit comment field. This field is available only if the Direct Deposit check box is selected on the Main tab.

© Sage Group plc 2019. Privacy Policy | Copyright/Trademarks