Each location in STORIS contains a bank number. The system references this bank number when posting cash through Accounts Receivable and Sales Order Entry.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
Support Files: Company, Vendor, Warehouse Location.
Tabs: General, Reconciliation, Third Party Processing
This file is used by the financial modules for the processing of
accounts receivable,
vendor receivables,
financing, and
other accounting information.
We recommend you create a record for each bank you use to hold company funds.
Each location in STORIS contains a bank number. The system references this bank number when posting cash through Accounts Receivable and Sales Order Entry.
Bank CodeEnter an alpha or numeric code of up to 4 characters that will be used to represent this bank.
NameEnter the name of the bank. This is a required field for the NACHA EFT file format.
Address Line 1Enter the first line of the bank's address.
Address Line 2Enter the second line of the bank's address. This line may be used for P.O. Box, Dept., etc.
Zip Code/Postal CodeEnter the bank's zip code/postal code.
City/TownThis field will automatically default to the city/town listed in the zip code record for this bank's zip code. If the default is not the city/town where the bank is located, the default may be overridden.
State/ProvinceThe bank's State/Province will automatically be written to this field based upon the information found in the Zip Code record.
ContactIf desired, you may enter the name of the person most frequently contacted at the bank.
TelephoneEnter the bank's telephone number.
AR Cash AccountEnter the number of the GL account you want to use for AR processing for this bank. The system posts to this GL account when issuing payable checks from this bank and receiving cash or checks from sales orders and/or exchanges. If you click on the Action button, the GL Account Entry Screen appears, from which you choose an account.
Credit Card AccountEnter the number of the GL account (if any) to which you want to direct credit card receivables. The system references this account in the event no GL account has been specified in the Credit Card Payment Settings for the credit card in question.
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.
Company NumberEnter the number of the company you want to associate with this bank. If using Multi-Company Processing, you can click the Search button to select from a list of valid company number codes. If not using Multi-Company Processing, only the default company (specified in the General System Control Settings) is available for selection.
Next Check NumberEnter the number (if any) you want to apply to the next pre-numbered check you print for this bank. You can enter a number up to nine digits. If you enter a number here, the system automatically increments the check number each time you print a check.
Note that for EFT payments, the system uses the number specified at the Next EFT Payment Number field.
Print Check NumberTo print the above check number on AP checks for this bank, check the box. Otherwise, leave the box blank.
Use this tab to set up your system for the Bank Reconciliation feature. If TPA is active on your system, this tab is inactive.
Reconcile TransactionsTo activate the Bank Reconciliation feature for this bank, check this box. Otherwise, leave the box blank.
Automated Bank DownloadTo base reconciliation on data received and/or downloaded from the bank (automatic reconciliation), check the box. To use the manual reconciliation process for this bank, leave the box blank.
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.
As OfThe as-of date displays for the Beginning Balance field. The Report Reconciliation Transactions routine uses this date as the starting date if a date is not present at the Starting Date field. This date updates along with the beginning balance when you run the Purge Reconciled Transactions program.
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 tab to enter information required for electronic funds transfer (EFT) files as well as positive pay information. Note that if TPA is active on your system, this tab is inactive.
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.
Alternate Account NumberUse this field to enter an alternate account number for the selected bank, using up to 20 alphanumeric characters. This is not a required field. If not using EFT or positive pay, you can use this field as a reference field, or leave it blank. The positive pay export process will use this value, if defined, in place of the standard Account Number.
Note that this is an encrypted field. To view this field, you have access via the View Encrypted AP Account Numbers field in the User file. 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.
Routing NumberEnter the bank's routing number. Your entry must be a numeric, 9-digit response. The number you enter appears on printed checks. This is a required field for the NACHA EFT file format.
The Laser Check Print feature references this field. If not using the Laser Check Print feature, you can use this field as a reference field, or leave it blank.
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.
Transit NumberEnter the transit number, using up to 5 numeric digits. Use this field with the Electronic Funds Transfers (EFT) feature. 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)
Positive Pay File Format(STORIS-LOCKED FIELD! No Access available!) The positive pay file format for this bank is indicated in this field. This field is used to identify the export subroutine responsible for formatting the bank check file for the selected bank.
Positive Pay Bank IdentifierThe field is active if a value has been entered in the File Format field. Use this field to indicate the unique bank ID, as supplied by the bank. If an ID is entered here, it is used in the header record of the positive pay file. If no bank ID is entered here, the Bank Code is used.
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.