Reconciling Bank Tapes

To track cleared dates and maintain a duplicate set of records for the AZ (cash basis) ledger when reconciling bank tapes:

1. Run the Create Cash Basis Entries program (R11C850) to process cash basis transactions and generate records for the AZ ledger.

2. Convert the data on the tape that you receive from your bank into a flat file called F095051.

   This program converts the data in the F095051 to the F09505 workfile.

   You can run the Custom Reformat UBE program (R09501) to convert the data if the data is mapped to the correct positions. If not, then you must create your own custom program to convert the data.

3. Run the Refresh Reconciliation File program (R09130) to copy the unreconciled transaction detail for all reconcilable accounts from the F0911 table to the F0911R reconciliation workfile.

4. In the Match Tape File to Recon File program (R09510), set the Additional Ledger Type to be updated processing option to update the AZ ledger.

5. Run the Match Tape File to Recon File program to reconcile the transactions that have cleared your bank account.

   The Match Tape File to Recon File program generates four reports that show the results of the comparison and list any errors that occurred during the automatic reconciliation. You use these reports to verify the accuracy of the bank tape reconciliation and, if applicable, to determine the cause of any errors.

See "Running the Match Tape File To Recon File Program" in the JD Edwards EnterpriseOne Applications General Accounting Implementation Guide.