Understanding the Bank Tape Reconciliation Process

If your bank provides you with a tape of the transactions that have cleared your bank account, you can use the JD Edwards EnterpriseOne General Accounting system to automatically reconcile the account. Your bank must provide magnetic media.

Before the system can automatically reconcile transactions, you must convert the data from the bank tape into a flat file called F095051. Then you can run the Custom Reformat UBE program (R09501), which converts the data in the F095051 to the F09505 workfile. For the Custom Reformat UBE program to convert the data, the data must be mapped to certain positions in the F095051 workfile. If it is not, you must create a new custom reformat program.

This graphic illustrates the bank tape reconciliation process: