Atrieve Payroll

Banking Constants

Banking Constants are used in the generation of the direct deposit transfer for the chartered bank. The information required is generally available from the local Payroll Services branch of the bank in question.

The information defined under the Banking Constants is used by the bank transfer generation during the running of the Payroll Processing. The program name defined under the Bank File Program Name field, of the User Specific Parameters Profile determines which bank is being used within a payroll.

This record should be set up for all payrolls, whether a direct deposit is to be produced as a means of payment. If cheques only are to be used, 'dummy' information may be entered for the banking information required below.

Not all fields are required by all banks. A list of required fields per bank is included at the end of this module.

Bank Name

  • The name of your bank.

Client #

  • Your client number as supplied by your bank. This field is required by all banks and should not be left blank.

Processing Center

  • Enter the name of the processing center (supplied by the bank) that deals with your transactions.

Bank Number

  • Bank branch you normally deal with. Your bank if required supplies this field.

INST. ID for Returns

  • Bank ID number of the bank to which returns are sent, supplied by your bank.

Acct # for Returns 

  • Supplied by the bank and is the account number for returns.

Transaction Code DEPOSIT

  • Enter the CPA code to be used for bank Credits. Usually 200 Payroll Deposits but should be confirmed with your bank.

Transaction Code Debits

  • Enter the CPA code to be used for bank Debits. The system default is 450 Miscellaneous Payments. This field value is only used if the Pre-Authorized Debit deduction is in use and active for EFT

Transaction Description

  • Enter a short description of the transactions code, limited to 30 characters,

Use Sequence Number

  • This field is required if your bank uses sequence numbers. Currently only used by the Bank of Montreal 1464 format (does not apply to the 80-character format) for generation of an incrementing Item Trace number.

Customer Short Name

  • Enter a short description of the payroll, limited to 15 characters in length.

Customer Long Name 

  • Enter full description (up to 30 characters) of your organization.

ID Number

This ID number is supplied by the bank and required for any site using the Norwest Bank for Montana, USA.

This field is used by CUCBC and is a User ID code of up to a maximum of eight characters. NOTE: Do not use commas or quotation marks as part of the User ID.

This ID Number field can be used by the 1464 HSBC or COCORP format (PRTP0G) as an alternate the bank account number when the bank account for withdrawals is different than the bank number defined under Acct # for Returns. Enter BK-#######, where ####### is your bank account number. This relates to the bank's field #19 Transaction Origination XREF.

The following details which banking constants fields are used by which bank.

All listed fields must be completed. If a field is not listed the information is optional. NOTE: Client # is required for All bank transfers.

Canadian Imperial Bank Of Canada (CIBC 80 format)

The organization name is taken from the Client Name field on the Payroll Master Profile.


Processing Center

Bank Number

INST. ID for Returns

Acct # for Returns

Transaction Code

Transaction Description

Royal Bank of Canada

Standard 152 Format

Client # and bank description only. The organization name is taken from the Client Name field on the Payroll Master Profile.

HSBC 134 CHAR. format

INST. ID for Returns

Acct # for Returns

Customer Short Name

Customer Long Name 

HSBC 1464 format

Processing Center

INST. ID for Returns

Acct # for Returns

Transaction Code

Customer Short Name

Customer Long Name

ID Number (BK-######) OPTIONAL Alternate Account #

Bank Of Montreal

Processing Center

INST. ID for Returns

Acct # for Returns

Use Sequence Number

Customer Short Name

Customer Long Name 

CUCORP (Credit Unions1464 )

Processing Center

INST. ID for Returns (NOTE: Must BE Bank and Transit Number, 9 Long)

Acct # for Returns

Transaction Code

Customer Short Name

Customer Long Name 

Alberta Treasury Branch 96 

Transaction Code

Customer Long Name

National Bank of Canada

Processing Center

INST. ID for Returns

Acct # for Returns  

Transaction Code

Norwest Bank Montana USA

Processing Center

Bank Number

Transaction Code

Transaction Description

Customer Long Name  

ID Number 

First Security Bank Montana USA

No other banking constants fields required

Stockman Bank, Montana USA

Bank Number Transaction Code Transaction Description Customer Long Name ID Number

CUCBC (Credit Union Central Of BC) 

INST. ID for Returns Acct. # for Returns Transaction Code Customer Short Name Customer Long Name ID Number (Dialup Password)

TD Bank 80

Bank Number INST. ID for Returns Acct # for Returns Transaction Code Customer Short Name

GLACIER Bank

Bank Name must be set to 'GLACIER Bank'

Processing Center

Bank Number

INST. ID for Returns – customer routing number

Acct # for Returns – customers account number Transaction Code

Transaction Description

Customer Long Name

ID Number

Bank OF NOVA SCOTIA 80

INST. ID for Returns Acct # for Returns Transaction Code Customer Short Name Customer Long Name

FIRST INTERSTATE Bank 

Bank Name must be set to 'FIRST INTERSTATE Bank'

Processing Center –fed's routing number  - 4 digits

Bank Number                 - Fed's transit number   - 5 digits

INST. ID for Returns – customer routing number

Acct # for Returns – customers account number Transaction Code Transaction Description

destination name  -  frb – Minneapolis

customer short name – used to defined bank's routing + transit number – 9 digits

Customer Long Name ID Number – '1 + customer ein"