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.
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
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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. Records
Note This tab is available only if Manually Send ACH File is selected in the Direct Deposit Interface field in Payroll Options.
Immediate Origin Leading Character
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.
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're instructed to do so by your financial institution.
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.
Enter the reference code for the File Header record lines (record type 1, field 87–94) when the ACH file is created.
Note Enter the reference code only if you're instructed to do so by your financial institution.
This field is available only if the Direct Deposit check box is selected on the Main tab.
Select this check box if your bank requires that ACH files be generated as complete blocks of 10 records each. If you select this check box, select the padding option required by your bank, either Block Size to 9 or Block Size to 10.
Clear this check box if your bank does not require that ACH files be generated as complete blocks of 10 records.
This field is available only if the Direct Deposit check box is selected on the Main tab.
Select this option to pad the file with 10 records and to fill positions 56-94 in the File Control record with nines.
This field is available only if the Pad File to Block Size check box is selected.
Select this option to pad the file with 9 records to fill the block. If the number of records in the ACH file is not a multiple of 10, the character 9 will fill the character positions in the end of the file to make the number of records equal to a multiple of 10.
This field is available only if the Pad File to Block Size check box is selected.
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.
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.
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.
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.
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.
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.
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.
3. Additional
Note This tab is available only if Manually Send ACH File is selected in the Direct Deposit Interface field in Payroll Options.
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 First 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.
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.
Type the transaction code 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.
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.
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.
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.
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. |
|
Carriage Return only |
Includes a carriage return only. |
|
Line Feed only |
Includes a line return only. |
|
LF then CR |
Adds a line feed, then a carriage return. |
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.
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.
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.
|
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 |
