Direct Deposit ACH File
Print
Modified on: Thu, 28 Oct, 2021 at 2:03 PM
What This Process Does
- This process creates an ACH file containing employee direct deposit amounts for you to send to your organization's bank. While most customers transfer the direct deposit file from the RDA server to their desktop (using CoreFTP), and then upload to their bank, if your bank website allows access, the file can be uploaded directly from within the process by selecting the Globe icon from the DOS Copy Window screen. Also, if desired, you can copy the file to a diskette from the DOS Copy Window; note that it is not necessary to save the file to a diskette because the file can be re-created at any time for the desired Pay ID.
Direct Deposit ACH File
- HR → Payroll → Finish Tab → Direct Deposit ACH File
- Review the Instructions tab for information about the report.
- For first time setup and/or new bank: Populate all required fields on the Select tab, as described below, with the exception of the Pay Identification and Posting Date (as those change with each Pay ID); save in site defaults. For organizations with multiple payroll bank accounts with the Enterprise version of OpenRDA (or with software bundle S5 Group Defaults) save each different bank account in Group Defaults for easy retrieval each payroll.
- Enter the unique Pay Identification and Posting Date when creating each Pay ID's ACH file.
FIELDS | Opt. | Rec. | Req. | Description |
Pay Identification | — | — | ♦ | Select the Pay ID for which you want to create an ACH file |
Bank ID | — | — | ♦ | Bank from which the direct deposit funds should pull |
Posting Date | — | — | ♦ | Enter the date that you want the direct deposits to post to employees' accounts; must be a future date or today's date in order to engage the select button |
Company Tax ID | — | — | ♦ | Your organization's Federal Employer Identification Number |
Batch Number | ♦ | — | — | Not required unless submitting multiple files to your bank for the same posting date |
Immediate Origin ID | — | — | — | Enter if different from Company Tax ID; check with your bank representative to determine if needed |
Transit/Routing # (Immediate Destination) | — | — | ♦ | Your organization's bank routing number |
Trace Number | — | — | — | Enter if not the Transit/Routing number; check with your bank representative to determine if needed |
Organization Account Number | — | — | ♦ | Your organization's bank account number |
Receiving Point Name | — | — | ♦ | The name of your organization's bank. Also referred to as the Destination Name. |
Header ID Code | — | — | — | Check with your bank representative to determine if needed |
Position 41 in the 52 Record | — | — | — | Check with your bank representative to determine if a different number is needed to precede the Company Tax ID other than the default of 1. |
Position 45 in the 82 Record | — | — | — | Check with your bank representative to determine if a different number is needed to precede the Company Tax ID other than the default of 1 |
Individual Name | — | — | — | Enter if not the Sending Name; check with your bank representative to determine if needed |
Use Offsetting Transactions | — | — | — | May need to be marked True, depending on your bank's file specifications; Troubleshooting tip: mark true if pre-notification file indicates “unable to import unbalanced file” |
Use Carriage Line Return/Line Feeds | — | — | — | May need to be marked True, depending on your bank's file specifications |
Receiving Point is Federal Reserve | — | — | — | Check with your bank representative to determine if needed |
Optional Reference Code | ♦ | — | — | Check with your bank representative to determine if needed |
Optional Batch Header Discretionary Data | ♦ | — | — | Check with your bank representative to determine if needed |
Optional Batch Header 1 | ♦ | — | — | Check with your bank representative to determine if needed |
Optional Batch Header 2 | ♦ | — | — | Check with your bank representative to determine if needed |
Opt. = Optional Rec. = Recommended Req. = Required |
- Range tab should have Range on DD Deduction Type FROM: DIRECT D TO: DIRECT D~
- Click the Select button to create the file.
- Only those employees with a Direct Deposit Deduction and a True ACH flag will be included
- Verify that no employee routing number or account number is missing on the report.
- At the bottom of the Audit Trail, verify that the integer "Block Count" is equal to the "Number of Accounts" divided by 10 (rounded up).
- The Total Credit Amount, and Debit if using offsetting transactions, should equal the total of all Direct Deposit Type deductions including Direct Drafts
- NOTE: A negative direct deposit amount (negative file) cannot be created for voided direct deposits
- After verifying the audit trail, Set Flags/Update, the DOS Copy Window will appear
- The system generated filename is drctdpst
- Select the Globe Icon (URL Internet) to upload directly to your bank's webiste, or, copy to diskette, or, cancel out of the DOS COPY WINDOW and transfer the file to your desktop
- To find the file when uploading directly, go to File System → rda → xpert → select today's file → Upload
Did you find it helpful?
Yes
No
Send feedback Sorry we couldn't be helpful. Help us improve this article with your feedback.