Updating transaction open balances

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

  1. Access Transaction Open Balance Update (CB99.5).

    Transaction Open Balance Update (CB99.5) is used to add balance records when first tracking transactions through the Cash Management consolidation file. You can also use it to modify existing open 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 cash code on the specified date.

    Ending Bank Balance

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

    Company

    This is the company to which balances are applied.

    Tran Code

    This is the transaction code to which balances are applied.

    Beginning Balance

    The balance of transactions for the selected company that are in an open status at the beginning of the day.

    Ending Balance

    The current balance of transactions that are in an open status (Open Beginning Balance + current day (issues - reconciled - voided - stop paid - escheated).

  3. Click Add to update your transaction balance.