| How to Set up Payroll Direct Deposit Interface 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
- Complete the following fields:
- Click Tab 1. Main tab, and select Direct Deposit check box.
- Account Type
- Select Checking for a checking account.
- Select Savings for a savings account.
Pre-Note Approved. Routing Transit Numbers Originating DFI: Immediate Origin: Immediate Destination
- 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.
- Click Tab 2. Records, and complete the following fields:
- File Header Record
- Immediate Origin Leading Character
- Enter the leading character before the Immediate Origin Routing Number (if required by your financial institutions).
- 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.
- File CreationDate. 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.
- Company/Batch Header and Control Records
- 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.
- 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
- If this field is left blank, the ACH file will be populated from the Direct Deposit Comment field on the Check Register Posting window which defaults from the Pay Cycle period end date. This can be modified or blanked out.
- File Control Record
- Pad File to Block Size
- 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.
- Block Size to 9. Select this option to pad the file with 10 records and to fill positions 56-94 in the File Control record with nines.
- Block Size to 10. 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.
- 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
- 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.
- Remove Dash From Pre-Note
- Select this check box to add a space instead of a dash (-) in the word Pre Note.
- Click Tab 3. Additional, 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.
- Debit Record
- 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. The bank may also refer to this as a "Trace ID". This field is available if the Include Debit Record check box is selected.
- Add 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.
- 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.
- 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.
- Click Accept button.
If you need assistance from Sage Support with setting up your direct deposit interface file, please obtain the Direct Deposit Interface layout or ACH file requirements layout from your financial institution. See attached ACH field specifications for additional information. DocLink: How to Generate or Regenerate Payroll ACH or Direct Deposit Interface File DocLink: How to Process Pre-Notes for Payroll Direct Deposit DocLink: How to setup Direct Deposit for Employees in Payroll Attachment: 347_20230425114737_ACH Field Specifications1.pdf Attachment: 347_20230425114737_ACH Field Specifications2.pdf
|
|