Updating transaction bank balances

If you have set the Summarize Ledger Balances flag to Yes on Cash Codes (CB00.2), then you can track summarized transactions. However, you must enter the beginning and ending balances to correspond with historical transactions. See Defining cash codes (bank accounts) for information on setting the Summarize Ledger Balances flag.

Use this procedure to update the beginning and ending bank balances in the Cash Management consolidation file. The balances entered at the company level are consolidated and applied to the balances at the cash code level.

  1. Access Transaction Bank Balance Update (CB99.3).

    Transaction Bank Balance Update (CB99.3) is used to add balance records when first tracking transactions through the Cash Management consolidation file. You can also use it to modify existing bank balances that are incorrect.

  2. Specify the cash code and date that you will edit the beginning and ending balance. Use these guidelines to specify the field values:
    Beginning Bank Balance

    This is the beginning balance amount for the specified date for the cash code.

    Ending Bank Balance

    This is the ending balance amount for the specified date for the cash code.

    Company

    This is the company to which balances are applied.

    Beginning Balance

    The balance of reconciled transactions for the selected company at the beginning of the day.

    Ending Balance

    The current balance of reconciled transactions for the selected company.

  3. Click Add to update your transaction balance.