An ACH registry entry must be created for each GL Account and GL Entity combination for which you will be generating direct deposit paychecks. Your bank will provide details on the necessary account and routing numbers, as well as sending the electronic file. Note that the registry entry provides critical file information for the funds transfer, and should always be pre-noted to verify its correctness.
Testing Your Registry Entries
The system does not verify the validity of registry entries. Be sure to test your registry entries after completing them to verify that they are functioning correctly.
Setting Values are Uppercase-Lowercase Sensitive:
The Setting Value is case-sensitive: be sure that you enter the value exactly as specified in the documentation. If the documentation specifies a value of true, do NOT enter True or TRUE.
See ACH Sample File for an example of the output structure of this file.
Id:
For ACH entries, the key information must be formatted as follows:
sys-eft-glbankaccountid-glentity-branchid-userid
sys-eft-glbankaccountid-glentity-securityid
sys-eft-glbankaccountid-glentity
sys-eft-glbankaccountid-
where glbankaccountid is replaced by the GL Account Id of the bank account for payroll. The GL Entity MUST be specified if you run paychecks by GL Account and Entity. If you generate paychecks for multiple GL Accounts/GL Entities, a registry entry should be created for each.
The first format enables you to specify ACH parameters by branch id and (optionally) user. If this entry is specific to a user, the branch must be specified if a user belongs to a branch. If branches are not implemented, two dashes (not separated by a space) must precede the user id.
The second format enables you to specify ACH parameters by security id.
The third format would apply to all users unless another registry entry was created for their security or branch/user id.
Note that in the fourth format (for all users if entities are NOT used for Paychecks) the trailing hyphen must be retained.
Name: A descriptive name for this ACH entry.
All entries listed below are always required. Entries noted as options may be required by your bank.
Setting Key: fhDestId Setting Value: nnnnnnnnn
where nnnnnnnnnn is replaced by the nine character immediate destination number provided by your bank.
Setting Key: fhOrigId Setting Value: nnnnnnnnn
where nnnnnnnnn is replaced your by the nine character origination number (your bank's 8 digit routing number plus a check digit) specified by your bank.
Setting Key: fhDestName Setting Value: nnnnnnnnnnnnnnnnnnnnnnn
where nnnnnnnnnnnnnnnnnnnnnnn is replaced by the (up to 23 character) destination name provided by your bank or other originator. It specifies the name of your bank or financial institution.
Setting Key: fhOrigName Setting Value: nnnnnnnnnnnnnnnnnnnnnnn
where nnnnnnnnnnnnnnnnnnnnnnn is replaced by your firm's (up to 23 character) name as provided by your bank or other originator.
Setting Key: bhDFIOrigId Setting Value: nnnnnnnn
where nnnnnnnn is replaced by the eight digit originating bank id as specified by your bank.
Setting Key: bhCompName Setting Value: nnnnnnnnnnnnnnnn
where nnnnnnnnnnnnnnnn is replaced by the (up to 16 character) sending company's (your firm's) name.
Setting Key: bcCompId Setting Value: nnnnnnnnnn
where nnnnnnnnnn is replaced by the ten character sending company Id number provided by your bank.
Setting Key: balBankId Setting Value: nnnnnnnnn
where nnnnnnnnn is the Bank Id/routing number provided by your bank or financial institution that specifies the bank/financial institution the payroll funds are debited from for balancing entries. This option is required if balAcctType is set to savings or checking.
Setting Key: balAcctType Setting Value: savings or checking
defines the account type (e.g., checking or saving) for the balancing entries.
Note: Unbalanced Entry Option
The option
Setting Key: balAcctType Setting Value: omit
would be included (instead of balAcctType=checking or savings) if your bank/financial institution explicitly instructs you that a balancing entry is not to be included in the EFT file.
Setting Key: balAcctNo Setting Value: nnnnnnnnnnnnnnnnnn
where nnnnnnnnnnnnnnnnn is your company's (up to 17 character) account number provided by your bank or financial institution for balancing entries. This option is required if balAcctType is set to savings or checking.
Setting Key: eol Setting Value: crlf
this option should be only included if your bank/financial institution requires that a carriage return/line feed code is included at the end of each line.
Setting Key: filename Setting Value: nnnnnnnn
this optional field specifies the name of the electronic file that will be created when the Generate EFT Register function is run. If this parameter is not included, the system will create a file with the filename transmitdate-transmittime.eft.
If your bank/financial institution requires that the first line of the eft file consists of the security code that you specify, you must include this option in the Contents or Additional Contents field as shown below:
Setting Key: securitycode Setting Value: security_code_from_bank
where security_code_from_bank is replaced with the exact code specified by your bank.
Setting Key: uppercase Setting Value: y
This may be included if your bank/financial institution explicitly instructs you that all text must be uppercase.
If your bank/financial institution requires that the batch header Company Entry Description field is included in the EFT file, you must include this option as shown below:
Setting Key: bhDescription Setting Value: dbDescript
where dbDescript is replaced with the 10 character description specified by your bank.
These options enable you to adjust the Entry Detail Description sent to your financial institution and displayed in the Reference column in the printed EFT register. Do not implement more than one of these options:
Setting Key: edDescriptionSourcePR Setting Value: socsecno
This option forces the replacement of the standard Entry Detail Description column (CK#, VdCk#, prenote) with the employee's social security number. Note that hyphens are not included in the social security number. This option should only be implemented if specifically required by your financial institution.
Setting Key: edDescriptionSourcePR Setting Value: Check#6
This option forces the replacement of the standard Entry Detail Description column (CK#, VdCk#, prenote) with the value 'Check#' plus the check number right-justified to 6 places and zero-filled. With this option turned on, check #1234 would appear in the file as 'Check#001234'.
Setting Key: fhFileIdModifier Setting Value: s
This option allows you to set the File Header's FILE ID MODIFIER. s should be replaced by the single character as dictated by the bank.
By default, the electronic file generated by Report EFT is automatically written to the directory containing the Sam Pro executable. This new registry option enables the user to specify a directory path to override the default:
Setting Key: PathName Setting Value: sharepath/eftdirectory
Note that sharepath/eftdirectory must be replaced by a valid directory name.