Setting Up Reconciliation Codes

As part of the setup for the Bank Account Reconciliation and the Debit/Credit Match methods of account reconciliation, you can change the reconciliation code that the system uses to indicate the reconciliation status of a transaction. The system updates the transactions in the WF - Account Ledger Reconciliation worktable (F0911R) and the Account Ledger table (F0911) with this reconciliation code when you reconcile transactions within your accounts. The Refresh Reconciliation File program (R09130) uses the reconciliation code to determine which transactions have already been reconciled when refreshing the F0911R worktable. The default reconciliation code is R. However, if your organization has a different term for reconciliation and would like to make the code more applicable, you can add a new reconciliation code.

If you want to add a new reconciliation code, you must define the new code in UDC table 09/RC. You can enter any alphanumeric value. The field length is 1. However, if you are using bank statement processing, you cannot use values A or D because they are used by the Bank Statement programs.

Note: The Auto Reconcile Void Payment (R09551) and Auto Reconcile Void Receipt (R09552) programs use the default reconciliation code of R. You cannot change the reconciliation code for these programs.