EFT Options Setup Field List

From the drop-down list, select the file format required by the bank. Note the following:

• CPA Standard 005 is the format that was implemented on June 4, 2001. Use this format if your bank requires the CPA Standard format that was implemented after June 4, 2000.
• CPA Standard 005 with Offset Record is the same format as CPA Standard 005 but also includes the offset records if reversals were made.
• CPA Standard – Existing was implemented prior to June 5, 2000.
• HSBC Bank Canada – Existing is for existing HSBC Bank Canada clients.
• HSBC Bank Canada – New ASCII is for new HSBC Bank Canada clients.
• HSBC Bank Canada with Offset Record is used if you have multiple accounts with HSBC Bank Canada. Contact your bank if you have any questions about which format to use.
• National Bank - 96 Byte Format is supported.
• National Bank - CPA Format - was called National Bank in prior releases of Sage HRMS Payroll.
• Royal Bank – Existing is for Royal Bank clients before December 1997.
• Royal Bank – New is for Royal Bank clients after December 1997.
• IAT Transfers is required for any payment transaction involving a financial institution outside the territorial jurisdiction of Canada.

Enter the originator (organization) number, 10 digits maximum (this number is supplied to you by your banking institution).

This field already contains the company name from the company setup.

You can enter an abbreviated version (up to 15 characters) of your company name. You should fill out this field.

(Optional) This number is issued to you by your bank (some banks may not require it). Refer to your bank guideline book or contact your local branch to determine the information required for this field. Each bank will use different formats with up to 5 characters.

The Item Trace Number field (next to the Data Center Number field) is only available if you chose the bank format "HSBC Bank Canada with Offset Record." This field will determine what is added to the Item Trace Number field in the output file. The selections available to you are:

• Zero Fill - The field will be populated with zeros. This is the default value.
• Blank Fill - The field will be populated with blanks.

The institution number (up to 9 digits), given to you by your bank, consists of the following:

• First digit is usually a zero (0).
• The next 3 digits are your bank’s number.
• The next 5 digits are the branch’s transit number.

This number is given to you by your bank (up to 12 numbers). If funds cannot be transferred to an employee’s account (because an employee has changed accounts), then the funds will be returned to the account indicated here.

(Optional) This user-defined field (up to 15 characters) is used by some banks to record employer and employee payroll records.

(Maintained by the system) At this time, the Caisse Desjardins is the only bank that requires this field (up to 11 characters). For the Alberta Treasury Branch, this field must be zero-filled.

(Maintained by the system) At this time, the Caisse Desjardins is the only bank that uses this field (two characters).

The default value for this field is 200.

Used by some banks to indicate the end of individual records in the file. See the guideline book from your banking institution prior to selecting this option. Most banks will require that you indicate the record’s end.

Enter the name and extension for the deposit file; this is the name and extension of the file to be transferred to the bank (using a standard DOS file format, the default being CPDIRECT.TXT.) The file name you specify must be a minimum of 4 characters, it cannot contain invalid file name characters (such as \ / : ? " < > |), and it cannot begin with spaces.

Some banks may require specific information to be placed at the beginning (header) or end (footer) of the file. Check with your company’s bank. Depending on the bank format that you chose, the program may automatically enter the required header and footer information.

As you generate direct deposits, the system will automatically update this field with the generation date.

As you generate direct deposits, the system will automatically update this field with a sequential number.

This field is only available if you chose the bank format "IAT Transfer" on the General tab. The selections available to you are:

• Fixed to Fixed - The entry originates and is received as a fixed amount in the same currency denomination. This is the default value.
• Fixed to Variable - The entry originates as a fixed value but is received as a variable amount.

This field defines the reason for the payment. The Transaction Type field is only available if you chose the bank format "IAT Transfer" on the General tab.

This field determines the contents of this field in the EFT file. The default value is "Space Filled." The Foreign Reference Indicator field is only available if you chose the bank format "IAT Transfer" on the General tab.

This field contains the foreign exchange rate or reference number to execute the change. A blank field is the default value. The Foreign Exchange Reference field is only available if you chose the bank format "IAT Transfer" on the General tab.

The routing number provided by the company bank. The Immediate Destination field is only available if you chose the bank format "IAT Transfer" on the General tab.

The name of the bank where the file is being sent. This field is only available if you chose the bank format "IAT Transfer" on the General tab.

The ACH identification number provided by the company’s bank. This field is only available if you chose the bank format "IAT Transfer" on the General tab.

The company name. This field is only available if you chose the bank format "IAT Transfer" on the General tab.

The person originating the batch. This field is only available if you chose the bank format "IAT Transfer" on the General tab.

The ISO code used to identify the country in which the branch of the originating bank entry is located. This is a mandatory field and the default value is “CAN”. This field is only available if you chose the bank format "IAT Transfer" on the General tab.

A description for the purpose of the entry. The length of this field has a limit of 10 characters. The Company Entry Description field is only available if you chose the bank format "IAT Transfer" on the General tab.