Bank Settings

• Accounting > Receivables > Receivables Settings > Bank Settings

• Accounting > Financing > Financing Settings > Bank Settings

• Accounting > Vendor Receivables > Vendor Receivables Settings > Bank Settings

• Accounting > Settings > Payables Settings > Bank Settings

• Accounting > Settings > Financing Settings > Bank Settings

• Accounting > Settings > Vendor Receivables Settings > Bank Settings

• Accounting > General Ledger > General Ledger Settings > Bank Settings

• Accounting > Payables > Payables Settings > Bank Settings

• Accounting > Third Party Accounting > General Ledger > General Ledger Settings > Bank Settings

• Accounting > Settings > General Ledger Settings > Bank Settings

• Accounting > Payables > Reconcile Bank Transactions > Settings > Bank Settings

• System Administration > Get Started - Enter Your Information > Get Started Step 1 - Tax and Banking > Bank Settings

• System Administration > System Settings > Accounting System Settings > Accounts Receivables System Settings > Bank Settings

• System Administration > System Settings > Accounting System Settings > Financing System Settings > Bank Settings

• System Administration > System Settings > Accounting System Settings > Vendor Receivables Systems Settings > Bank Settings

• System Administration > System Settings > Accounting System Settings > General Ledger System Settings > Bank Settings

Enter the GL account you want to use for check processing for the selected bank.  If you click on the Action button, the GL Account Entry Screen appears from which you can select an account.

You cannot use wildcards for AP accounts.

Enter the beginning bank balance (if any) you want to use with the reconciliation process. This amount reflects on the Report Reconciliation Transactions routine, and updates each time you run the Purge Reconciled Transactions.

To edit this field, you must have security clearance via the Create a User/Group Actions - Payables Security.  You can use the Track Settings Activity routine to audit any manual changes made to this field.

Use the following fields to specify default reconciliation deposit type codes (if any) for each payment class.  If you click on the Arrow, a list of deposit types appears from which you can choose.  If you leave this field blank, the payment class does not reconcile unless an override exists (see below).

If you click on the Action button, the Payment Type Override Settings appears.  Use this screen to override the default deposit type (if any) for a payment class by specifying default deposit types for individual payment types within a payment class.

  You cannot assign a deposit type code to the Gift Certificate payment class.  To assign a deposit type code to the Financing payment class, use the Finance Provider Settings.

Use this field to enter an account number for the selected bank, using up to 20 alphanumeric characters. This is a required field for the CPA005 EFT and CIBC EFT file formats.  

This is an encrypted field.  To view this field, you must have access via the View Encrypted AP Account Numbers field in Payables Security. However, the account number prints un-encrypted on AP checks printed via the Forms Designer.  Note that once the checks print, the system removes the numbers from the computer on which the checks were printed.

Use this field with the Electronic Funds Transfers (EFT) feature to enter the payer number, using up to 12 alphanumeric characters. This information is provided by the payer's bank. The CPA005 EFT file format requires this field to be populated with the Originator ID. The NACHA EFT file format requires this field to be populated with the Immediate Origin. This field is required for the CIBC EFT file format.

Use this field to specify the institution number of the payer's bank.  You can enter up to three digits.   This is a required field for the CPA005 EFT and CIBC EFT file formats.

Use this field to specify the short name of the payer's company, using up to 15 alphanumeric characters.  It may appear on the payee's bank statement for an EFT payment.   This is a required field for the CPA005, CIBC, and NACHA EFT file formats.

Use this field to specify the long name of the payer's company, using up to 30 alphanumeric characters.  It may appear on the payee's bank statement for an EFT payment.   This is a required field for the CPA005 EFT and CIBC EFT file formats.

Use this field to enter the 5 digit number provided by the Bank of Montreal in Canada (BMO) or Canadian Imperial Bank of Commerce (CIBC).   This is a required field for the CPA005 EFT and CIBC EFT file formats.

(STORIS - LOCKED FIELD! No Access available) When creating a new bank code, this field defaults to a starting value of 100 for the next EFT payment.  Contact STORIS to change the value in this field. This field accepts up to 9 numeric digits.  The system automatically increments the number each time you generate an EFT batch.  The system uses this number for EFT payments instead of the Next Check Number.   This is a required field for the CPA005, CIBC, and NACHA EFT file formats.

In order to activate this bank for EFT processing, you must specify an EFT file format at this field. Specify the EFT file format (if any) to use for this bank. If you click on the Arrow, a list of formats displays from which you can choose. The system supports the following formats:

• Scotia Bank (SCPI5)

• Bank of Montreal (CPA005)

• BMO Harris (NACHA)

• Canadian Imperial Bank of Commerce (CIBC)

 This is a required field for the CPA005, CIBC, and NACHA EFT file formats.

The Canadian Payments Association uses the CPA005 file format with a standard 1464 byte file format used by most financial institutions in Canada.

The Automated Clearing House (ACH) network (United States) uses the NACHA EFT file format.

The Canadian Imperial Bank of Commerce (CIBC) uses the CIBC 1464 byte format.

Specify the General Ledger account (if any) you want to credit for individual EFT payments within an EFT batch. If you click on the Action button, the GL Account Entry Screen appears via which you can specify an account. The GL posting for the total EFT batch debits the EFT GL Account and credits the AP Cash Account.  

When searching for an EFT GL account, the posting process references the following hierarchy and uses the first account it finds:

• EFT GL Account field in the Bank Settings for the GL account

• EFT Payment GL Account field on the Accounts Payable tab in the General Ledger Assigned Account Settings

• GL Account Number Default ($$$$$^NN)

Check this box to indicate that the checks generated for this bank should be exported to an XML file instead of being printed.  Otherwise, leave the box blank.

This setting cannot be changed if an open check run (e.g. pending or exported status) exists for the bank.