Reconciling Bank Account Transactions Manually

Access the Bank Account Reconciliation form.

1. Enter the account number for which you ran the Refresh Reconciliation File program (R09130).

2. To view both unreconciled and reconciled items, do not select the Unreconciled Only option.

   You can review both unreconciled and reconciled items if you entered 1 for the Reconciled Status processing option of the Refresh Reconciliation File program.

3. To limit the transactions that you view for the account, enter a general ledger date in the From Date field.

   You must enter a date that is within the date range that you entered in the processing options for the Refresh Reconciliation File program. To view transactions from a date prior to the beginning date in the processing option, you must run the Refresh Reconciliation File program again with different dates.

4. Enter the balance that appears on your bank statement in the Bank Balance field and click Find.

5. To mark a transaction as reconciled, select the row that corresponds to the transaction and then select Reconcile Toggle from the Row menu.

6. To mark more than one transaction (or all transactions) as reconciled, select the rows for the transactions and then select Reconcile Toggle from the Row menu.

   When you mark transactions as reconciled:

   • If the Reconciliation Reference processing option for the Manual Reconciliation program is set to 1, the Bank Account Reconciliation form appears and displays the next available number from next numbers. The system displays this form each time you reconcile a transaction so that you can enter a new number for each transaction.

   • If the Cleared Date processing option is set to display the Cleared Date field, enter the date that the bank cleared the transaction. If you do not enter a date, the system uses the system date.

   • The system enters R (or the reconciliation code that you selected) in the Rec Code field on the Bank Account Reconciliation form.

   • Update the GLR3 field in the F0911R table with the reconciliation reference number for all reconciled transactions.

   • Update the GLRCND field in the F0911 table with the Rec Code R in the F0911R table for all reconciled transactions.

     Note: The system updates the F0911 table for ledger type AA and an additional ledger type, if you specified an additional ledger type in the processing options.

   • Update the GLR3 and GLRCND fields in the F0911 and F0911R tables if the Bank Account Reconciliation Reference processing options for the Manual Reconciliation program is set to 1.

7. To print a report, select Reconciliation Print (R09132P) from the Report menu.