Registry Report AFT Payroll (Canadian PR Direct Deposit)


An AFT 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.


This entry is designed for use with Canadian Payroll. It is referenced by Report AFT Payroll.

Important Fields:






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 MUST be created for each.

The first format enables you to specify 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 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) the trailing hyphen must be retained.

Name: A descriptive name for this entry.

RBC Bank

Setting Key: Format Setting Value: RBC

TD Bank EFT 80 Byte File Format

Setting Key: Format    Setting Value: TD80

Make sure that the edOriginatorName field is a max of 15 characters.

Other Required Entries

All entries listed below are always required. Entries noted as options may be required by your bank.

Setting Key: TestFileHeader Setting Value: $$AAPDCPA1464[TEST[NL$$

The system will use the TestFileHeader setting if the Test box on Report AFT is checked.

Setting Key:  ProdFileHeader Setting Value: $$AAPDCPA1464[PROD[NL$$

The system will use the ProdFileHeader setting if the Test box on Report AFT is clear.

Setting Key: fhOriginatorId Setting Value: nnnnnnnnnn
where nnnnnnnnnn is replaced your by the 10 character origination number specified by your bank.

Setting Key: fhDestinationDataCentre Setting Value: #####
where ##### is replaced by the 5 digit numeric number provided by your bank.

Setting Key: fhCurrencyCode Setting Value: CAD or USD
Specify CAD for Canadian dollars.

Setting Key: edOriginatorName Setting Value: 30 alpha-numeric characters
The Value must consist of the up to 30 character name provided by your firm’s bank or other originator.

Setting Key: edOriginatorDirectClearerId Setting Value: 10 alpha-numeric character
The Value must consist of the ID specified by your firm’s bank or other originator.

Setting Key: edIdReturns Setting Value: 9 digit numeric

Setting Key: edAccountNoReturns Setting Value: 12 alpha-numeric

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 AFT Register function is run. If this parameter is not included, the system will create a file with the filename transmitdate-transmittime.aft.

Setting Key: PathName Setting Value: sharepath/eftdirectory

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:

Note that sharepath/eftdirectory must be replaced by a valid directory name.

Setting Key: PreNoteAmount Setting Value: .01

Setting Key: uppercase Setting Value: y

This may be included if your bank/financial institution explicitly instructs you that all text must be uppercase.