CR Bank Setup field descriptions

Fields are presented in alphabetic order within each section.

Bank Information

Address

Three lines of address are allowed but not required. If only one line is needed, specify it on the first line.

City, State, ZIP

Specify the city, state, and postal code. The Zip Code field can accommodate ten characters. Specify the postal code without using delimiters (-). If the last four digits of the extended postal code are not used, leave the spaces blank.

Name

Specify the name of the bank. If multiple bank accounts exist in the same bank, use the Name field to differentiate them. For example, United Bank - Petty Cash, United Bank - Business, United Bank - Savings.

Phone

Specify the bank's telephone number, including the area code. The last four characters are designated for an extension.

The cursor is initially positioned on the first parenthesis, but as you type the first number, it automatically places the number in the first available position within the parentheses. This is true for typing the remainder of the telephone number as well. Do not worry about typing over the parentheses or hyphens, the numbers are placed in the correct positions. The phone number field uses the format you set up at the company level in SA Administration Options-System-Options. The default for the setting enables U.S. and Canadian companies to use the existing default format.

Balances

Bank Balance

Specify the current balance of the bank account as indicated by the bank when you set up this CR Bank Setup record for the first time. Thereafter, this amount is updated by the CR Entry Balance Bank Accounts Report. It should reflect the correct balance of the bank account as of the last bank statement.

Current Balance

The Current Balance field represents an accumulative total. It is updated each time a transaction entry function posts transactions to this bank number.

When the CR Trial Balance Report is printed, the Current Balance value should match the General Ledger account code YTD Balance.

If the bank record is set up in the middle of your fiscal year, all outstanding transactions as of the last bank statement must be specified through CR Trial Balance Report. This includes outstanding checks, deposits, charges, interest, and adjustments. If the system interfaces with General Ledger, Customer, or Sales Order, this balance is adjusted daily via entries from the other modules.

Last Balance

This date is updated each time the CR Entry Bank Accounts Report is run. The Balance Date requested on the report parameter screen updates this field.

Last Bank Balance #

This field indicates the last CR Entry Bank Accounts Report sequence number. This field also helps maintain an accurate audit trail when balancing your bank account.

Last Check

This date reflects the last time a check transaction type was posted through any of the interfacing entry functions [GL, AR, AP, PR, OE or CR]. This date reflects the actual posting date.

Last Trial Balance

This field indicates the last sequence number of the CR Trial Balance Report. This field helps maintain an accurate audit trail when balancing your bank account.

Last Verified Balance

The Last Verified Balance amount is updated each time CR Entry Balance Bank Accounts Report is performed and reflects the last time the bank account was in balance.

This amount takes into consideration the bank balance and any outstanding checks, deposits, and so on. The CR Trial Balance Report uses this value as a starting point when calculating the adjusted bank balance associated with each transaction. The Bank Balance and Last Verified Balance amounts are equal after the CR Entry Balance Bank Accounts Report has been completed.

Account Information

Active

Select this option if this bank record is active. If a bank is inactive, you can no longer post transactions to it or update the current balance. This is useful if a bank account is closed but it is necessary to keep the history and balance information on file.

BACS Format

To enable BACS processing, you must define your BACS format. The BACS format is an agreed standard that enables your data to be processed by your bank. There are two formats, BACSTEL and LloydsLink. Your bank should specify which format you should use. Select one of these formats for BACS transactions that use BOD-based electronic AP payment remittance.

Bank Account

This user-defined field can contain the actual bank account number or any other description.

Currency

This is a user-defined field and is beneficial if your company maintains an account that deals with foreign currency. SA Currency Table Setup provides you with the necessary information for setting up your foreign currency fields.

If your company's bank deals with domestic currency only, leave this field blank.

Division #

Choose a division number if you are setting up this bank to handle all bank transactions for one particular division. If you are utilizing full Divisionalized Accounting (your SA Company Setup option is selected), this field is required.

When you enter any journal transactions that affect cash, the system checks this Division # field. This controls the receipt and disbursement of cash for this division.

GL Account

The General Ledger account code set up here is the first code that is updated when posting transactions to a cash GL account. If an account code is specified, its description is displayed beneath the number. You can also leave this field blank.

The actual General Ledger YTD balance in this account should match the Current Balance on the CR Trial Balance Report. If they do not match, each record should be checked for errors. This can be done by running the GL Transaction Activity Report and CR Transaction Activity Report for the same period, then comparing the transactions in the two reports.

Note:  Matching the balances only works if one General Ledger account code is dedicated to one bank record. If one account code is used for multiple bank numbers, the two balances will not be equal.

Transit Routing #

Specify the transit routing number for the bank.

Last Numbers Used

Adjustment #

This field is automatically increased by 1 when transaction entry functions update Check Reconciliation.

This number should not be manually changed. You can set the security level in SA Operator Setup to prevent an operator from changing this number, as well as the balances, by restricting the operator to Level 1 or 2 security for this section.

Charge

This field is automatically increased by 1 when transaction entry functions update Check Reconciliation.

This number should not be manually changed. You can set the security level in SA Operator Setup to prevent an operator from changing this number, as well as the balances, by restricting the operator to Level 1 or 2 security for this section.

Check #

The Check # field reflects the last check number posted. If the number on a reprinted check is less than the number that shows in this field, then the larger check number is displayed.

This number should not be manually changed. You can set the security level in SA Operator Setup to prevent an operator from changing this number, as well as the balances, by restricting the operator to Level 1 or 2 security for this section.

Check Open Init

This is a display-only field that shows the operator initials of the operator who created a check record that is still open.

Deposit #

This field is automatically increased by 1 when transaction entry functions update Check Reconciliation.

This number should not be manually changed. You can set the security level in SA Operator Setup to prevent an operator from changing this number, as well as the balances, by restricting the operator to Level 1 or 2 security for this section.

Interest #

This field is automatically increased by 1 when transaction entry functions update Check Reconciliation.

This number should not be manually changed. You can set the security level in SA Operator Setup to prevent an operator from changing this number, as well as the balances, by restricting the operator to Level 1 or 2 security for this section.

Transfer In #

This field is automatically increased by 1 when transaction entry functions update Check Reconciliation.

This number should not be manually changed. You can set the security level in SA Operator Setup to prevent an operator from changing this number, as well as the balances, by restricting the operator to Level 1 or 2 security for this section.

Transfer Out #

This field is automatically increased by 1 when transaction entry functions update Check Reconciliation.

This number should not be manually changed. You can set the security level in SA Operator Setup to prevent an operator from changing this number, as well as the balances, by restricting the operator to Level 1 or 2 security for this section.

CenPOS Processing

This section is only updated if you are integrated to the CenPOS credit card processor.

Merchant ID

This ID is the default merchant ID assigned and provided by CenPOS. Contact your CenPOS representative.

Merchant ID is an ID assigned to the distributor by CenPOS. When used with the Credit Card Interface or electronic AP payment remittance, the Merchant ID is used by CenPOS to identify the bank account where the distributor's payment will be withdrawn. The ID is specified as the Processor Vendor ID in SA Credit Card Processor Setup-Required-Processor, and for the Merchant ID in CR Bank Setup-Credit ACH. The default is the Processor Vendor ID. The default is overridden by any value specified in Merchant ID in CR Bank Setup-Credit ACH. You would use the override if you wanted to pay a vendor from one bank, and pay a different vendor from another bank. You would need to a different Merchant ID for each bank.

When used for Positive Pay, if your Positive Pay Output Method is set to CenPOS, the Merchant ID is required and used by CenPOS to associate a specific bank account with the check data you are sending for various payments. When used for Positive Pay, you do not specify this Merchant ID in SA Credit Card Processor Setup. Because the CenPOS Positive Pay functionality is accessed through a specific web service, a processor record is not required. The connection information is stored in the Positive Pay Processing URL field of the CR Bank Setup record.

Merchant User ID

Specify the user ID provided by CenPOS for this association. This information enables CenPOS to be able to pass the full credentials when creating a Credit ACH payment request transaction.

When used for Positive Pay, if your Positive Pay Output Method is set to CenPOS, the Merchant ID is required and used by CenPOS to establish a connection to the CenPOS web service.

Merchant User PW

Specify the user password provided by CenPOS for this association. This information enables CenPOS to pass the full credentials when creating a Credit ACH payment request transaction.

When used for Positive Pay, if your Positive Pay Output Method is set to CenPOS, the Merchant ID is required and used by CenPOS to establish a connection to the CenPOS web service.

Credit ACH

Use this section only if you have implemented the electronic AP payment remittance feature, and intend to send payments to a vendor electronically through CenPOS from this bank.

Last Credit ACH Date

This date reflects the last time a Credit ACH payment request is made from this bank.

Last Credit ACH Number

By default, this numbering starts at 1. The number in this field increments by one each time a new Credit ACH payment or ION payment request is made from this bank. Although this field is editable, we recommend you do not change the value in this field after initial setup. For BACS transactions that use BOD-based electronic AP payment remittance, ION transactions are counted as Credit ACH transactions.

Payment Type

This list is populated only with values from SA Table Code Value Setup-Payment Type records that have the option, Payment Type is Credit ACH, selected. You must select the Credit ACH payment type for this bank. Specifying this payment type links the bank to the processor associated with the Payment Type in SA Table Code Value Setup.

Positive Pay

Set up one CR Bank Setup record for each bank account you will implement a Positive Pay system for.

Positive Pay Output Method

Three methods are available:

• Retain the default No Positive Pay if you are not implementing a Positive Pay system for this bank account.
• Select CenPOS if you have retained the CenPOS company to be responsible for managing the different bank formats and ensuring that the check data is delivered to the bank in the format appropriate to their program.
• Select ION if you are making check data available through the SXPositivePay custom BOD. To use this method, you must have pre-arranged with the bank that the bank can consume the check data from this BOD.

Positive Pay Processing URL

If your Positive Pay Output Method is set to CenPOS, this field is available. Specify the URL provided by CenPOS. The URL is used to access the web service for positive pay processing. Contact your CenPOS representative.

Positive Pay Void Processing

You have the option to include or exclude check data from voided checks in the output for your Positive Pay system. Select Include to include voided check data in the output. Select Exclude to exclude voided check data from the output.