Subledger Settings

In Treasury, configure subledger settings when you add or edit a bank account so your team can post consistently, reduce manual corrections, and speed up reconciliation. When you select a subledger, settings appear for cash account setup, transaction numbering, and deposit or refund behavior.

Note: Each subledger can have a different general cash account.

Enter Payables Settings

  1. When you add or edit a bank account, under Subledger settings, select Payables.

  2. Under Track in, select whether the cash account uses one fund or multiple funds.

  3. Under GL cash account, enter the general ledger cash account number. The cash account must already exist, regardless of whether it is tracked in one fund or multiple funds.

    Note: To simplify bank reconciliation, assign the same cash account code to all programs that use the bank account, and assign each cash account code to only one bank account.

  4. Under Transaction types, define numbering for payment transaction types. Select a start number for the first type, and then base later types on that number to reduce setup time. You can also enter a maximum amount for each type. Required transaction types are:

    • Computer check

    • Electronic funds transfer

    • Manual check

    • One-time check

    • Bank draft

Enter Receivables Settings

  1. When you add or edit a bank account, under Subledger settings, select Receivables.

  2. Under Track in, select whether the cash account uses one fund or multiple funds.

  3. Under GL cash account, enter the general ledger cash account number. The cash account must already exist, regardless of whether it is tracked in one fund or multiple funds.

    Note: To simplify bank reconciliation, assign the same cash account code to all programs that use the bank account, and assign each cash account code to only one bank account.

  4. Specify whether the account allows accounts receivable deposits and refund checks.

Enter Cash Receipts Settings

  1. When you add or edit a bank account, under Subledger settings, select Cash receipts.

  2. Under Track in, select whether the cash account uses one fund or multiple funds.

  3. Under GL cash account, enter the general ledger cash account number. The cash account must already exist, regardless of whether it is tracked in one fund or multiple funds.

    Note: To simplify bank reconciliation, assign the same cash account code to all programs that use the bank account, and assign each cash account code to only one bank account.

  4. If the account allows deposits, select Allow deposits.

Enter Cash Management Settings

  1. When you add or edit a bank account, under Subledger settings, select Cash management.

  2. Under Track in, select whether the cash account uses one fund or multiple funds.

  3. Under GL cash account, enter the general ledger cash account number. The cash account must already exist, regardless of whether it is tracked in one fund or multiple funds.

    Note: To simplify bank reconciliation, assign the same cash account code to all programs that use the bank account, and assign each cash account code to only one bank account.

  4. Under Transaction types, select the adjustment start number and maximum amount.