Bank Account Balance (ABAL)

Bank Account Balance (ABAL) contains an entry for each day's bank account balance. This window is keyed by bank account code and the balance date. The date is keyed in reverse order (the most recent date first).

The offline program ABAL is run on a nightly basis. This program takes the previous day's ending book balance and determines the new balance from the day's cash receipt, payroll voucher, check cancellation, and journal voucher documents. The cash balance is computed by taking the ending book balance and adding back outstanding checks/warrants from Warrant Reconciliation (WREC) that have not cleared. ABPG, another offline program, is available to purge entries in this table that are no longer needed.

• One entry must exist in this table for each bank account before the ABAL offline program is run for the first time.

Bank Account Code	Key field. Enter the bank account code assigned to this account.
Balance Date	Key field. Enter the date ( mm dd yy ) when the bank balance was calculated.
Account Name	The name of this account from Bank Account (BANK) is displayed.
Bank Name	The name of bank holding this account, inferred from Bank Account (BANK), is displayed.
Account Number	The account number assigned by the bank, inferred from Bank Account (BANK), is displayed.
Beginning Balance	Default is 0 (zero). Enter the bank account balance at the start of the day.
Debits	Default calculates the total of all debit transactions affecting the account during the balance date.
Credits	Default calculates the total of all credit transactions affecting the account during the balance date.
Ending Book Balance	Default is the bank account balance at the end of the day computed as: Beginning Balance + Debits - Credits
Outstanding Checks/Warrants	Default displays the checks/warrants that have not cleared.
Cash Balance	Default is the cash balance of account computed as: Ending Book Balance + Outstanding Checks/Warrants