Understanding Manual Bank Account Reconciliation

When you reconcile your accounts on the Bank Account Reconciliation form, the system marks the transactions on the form with the default reconciliation code R or the code that you selected. As you reconcile transactions, the system updates the Outstanding Debits and Outstanding Credits fields in the F0911R1 table. The system also updates the Amt to Reconcile field using this formula:

(Bank Balance + Outstanding Debits + Outstanding Credits)–Book Balance = Amount to Reconcile

• Bank Balance = the amount on your bank statement.

• Outstanding Debits and Credits = the records in the F0911 table that have not been marked as reconciled.

• Book Balance = the account balance in the F0902 table. The system includes balance forward amounts for balance sheet accounts.