Recalculating Journal Balances

The Recalculate Journal Balances utility recalculates the accumulated debit and credit balances of all transactions for a specific journal and date range. If an imbalance exists, the system generates a new transaction to bring the journal back into balance. This utility does not consider reporting units when determining journal balances. Until posted to the ledger, reporting units are reference only.

Note: 
  • After running this utility, you must run the Journal Transactions utility to complete the transactions that were created to balance the journals.
  • You can recalculate only one journal at a time.
  1. Enter information in these fields:
    • Journal ID: Enter the journal ID you want to recalculate.
    • Starting and Ending Transaction Date: Enter the range of dates for which you want to recalculate transactions.
    • Transaction Date: (Optional) Enter the date you want to use for any transactions that are created by this utility. Note that if you do not enter a date, you will be prompted to enter one when you use the Journal Transactions utility to update the transactions.
  2. To process your selections, click Process.

At most, the system creates one transaction.

If this utility creates a journal entry with an XBAL reference and no account information, this message displays for the transaction: "The Journal Transaction utility must be run to update missing data such as the account number or transaction date." Use the Journal Transaction Utility to update the account information. Upon doing so, you will be able to successfully post the journal.