Defining company - cash code relationships

You must define a relationship between an Accounts Receivable and/or Accounts Payable company and a cash code in order for the company to process transactions for a specific bank account. This procedure describes the process for defining company - cash code relationships.

  1. Access Company-Cash Codes (CB00.3).

    Use these guidelines to specify the field values:

    Company / Cash Code

    Select the company and cash code that you will define a relationship.

    Cash Account

    Select the general ledger cash account you will use for posting accounts payable payments and accounts receivable deposits.

    Transfer Clearing Account

    Select the general ledger bank transfer clearing account for bank transfers to or from the cash code for the company.

    Payment Clearing Account

    Select a valid general ledger payment clearing accounting unit used for processing Cash Management payments.

    EFT/CC Extract Clearing Account

    Select a valid general ledger EFT/credit card extract clearing accounting unit used for processing Cash Management EFT and credit card extracts.

    Over Tolerance / Under Tolerance

    If you do not want to manually reconcile differences between issued amounts and cleared amounts for a transaction, then specify a range that indicates the variance you are willing to tolerate.

    Variance Account

    If you defined reconciliation tolerances, then select the variance account for posting variance amounts within the defined tolerances.

    Reconcile Entry

    If you select Yes, then a general ledger entry is created from the Cash Account to the Reconcile Account when the company reconciles a transaction for the cash code. The difference between the reconciled amount and the issued amount, within the tolerances you define, posts to the Variance Account.

    Account

    If you selected Yes in the Reconcile Entry field, then select a valid reconciliation account for posting reconciled transactions.

    Journal Book

    If the company uses journal books, then specify the name of the journal book associated with transactions created as a result of the bank statement reconciliation process. See Defining a cash code journal book.

    Default Pay Codes

    Select default pay codes that represent types of bank transactions. You can select from these pay codes:

    Pay code Description
    Customer A customer pay code represents banking transactions that debit or credit your bank accounts in the Accounts Receivable application. You can use this pay code to update customer account balances on Application Closing (AR190). See the Accounts Receivable User Guide.
    Vendor A vendor pay code represents cash payments and payment tapes that are used in the Accounts Payable application. You can use this pay code to close a payment cycle on Payment Closing (AP170). See the Accounts Payable User Guide.
    G/L A G/L pay code represents banking transactions that debit or credit your bank accounts in the Cash Management application. You can use this pay code to post transaction entries to the general ledger through the Post Thru Date that you define for the cash code on Bank Transaction Posting (CB175). See Posting bank transactions.
    Reconciliation A reconciliation pay code represents a cash payment, BOE payment, or bank service. If the Reconcile Entry field is set to Yes, then you must use this pay code to post reconciliation adjustments to the general ledger through the Post Thru Date that you define for the cash code on Bank Transaction Posting (CB175). See Posting bank transactions.
    Note: You must define the pay codes on Bank Transaction Definition (CB00.4).

    See Defining bank transaction codes.

  2. Optionally, to process bills of exchange in the Accounts Receivable application, select BOE Accounts to select general ledger accounts. Use these guidelines to specify the field values on BOE Accounts (CB00.6):
    Discounted Remittance

    (Optional) Select a valid discounted remittance account for bills of exchange processing.

    Encashed Remittance

    (Optional) Select a valid encashed remittance account for bills of exchange processing.

    Bank Risk

    (Optional) Select a valid bank risk account for bills of exchange processing.

    Bank Expense

    (Optional) Select a valid bank expense account for bills of exchange processing.

    Administration Expense

    (Optional) Select a valid administration expense account for bills of exchange processing.

  3. Optionally, if you use attribute matrix, then click Attributes to access Attributes (CB01.4). See Using Attribute Matrix attributes.
  4. Optionally, if the company uses journal books to group general ledger transactions, then click Journal Book to access Cash Code Journal Book (CB05.1). See Defining a cash code journal book.
  5. Optionally, if the company uses stale date accounts, then click Stale Date Accounts to access Stale Dating Accounts (CB07.1). See Defining stale dating and escheatment accounts.