This chapter contains these topics:
You can automatically reconcile items that have cleared your bank account if you arrange to have your bank provide a bank tape. To automatically reconcile your accounts, you use the same reconciliation processes and steps as manual reconciliation, with the following exceptions, you MUST:
Customize a program that reads the bank tape and loads information into the JD Edwards World system
Run the Match Tape File to Reconciliation File program (P09510) after running the Refresh Reconciliations File program (P09130).
See Also:
From General Accounting (G09), choose Account Reconciliation
From Account Reconciliation (G0921), choose Customize the Reformat Program
To automatically reconcile items that have cleared your bank account, your system administrator must customize the reformat program that is used for reconciling bank tapes. This program:
Reads the information on the tape supplied to you by your bank
Transfers the information to the Bank Cleared Payments worktable (F09505)
There are two sample programs that you can use as models when customizing the reformat program:
CLP J09501
You add the code that transfers the tape or diskette to disk.
RPG P09501
You enter the correct format of the tape that will be copied to the Bank Cleared Payments worktable.
These model programs:
Omit all unused records, such as header records, from the tape
Convert information for the payment number, payment amount, and payment cleared date to the worktable
To customize the reformat program for your company, your system administrator must typically:
Write the payment amount to the F09505 as a negative amount.
Write the cleared date as a six-position Julian date. The first position represents the century, the next two positions represent the year, and the last three positions represent the day of the year (up to 366).
For example, February 28, 1998, would appear as 098059, where:
0 = the 20th century
98 = the year 1998
059 = the 59th day of the year (February 28)
After this program is customized, your system administrator will run it only if the bank tape format changes.
From General Accounting (G09), choose Account Reconciliation
From Account Reconciliation (G0921), choose Match Tape File to Recon File
After the reformat program is customized, you can reconcile payments and receipts that have cleared your bank. The Match Bank Tape File to Reconciliation File program (P09510) reads the Bank File of Cleared Payments file (F09505) and compares it to the Account Ledger File for Reconciliation file (F0911R) built by the Refresh Reconciliation File program (P09130). The system then automatically reconciles the payments in the F0911R and the Account Ledger file (F0911).
The system compares the information on your bank tape to the information in the reconciliations worktable. This program:
Compares the following:
Cleared payments from the bank tape in the Bank Cleared Payments worktable (F09505)
Unreconciled payments in the Account Ledger Reconciliations worktable (F0911R)
Marks as reconciled all transactions that have matching document numbers, matching amounts, and cleared dates greater than the document date in the Account Ledger Reconciliations worktable and the Account Ledger table (F0911) with an R.
Updates unreconciled transactions from the F0911 and the F0911R.
Prints four reports listing all transactions
Prints three reports listing any errors that occurred during the automatic reconciliation
Note:
You must correct the errors and manually reconcile those transactions.When you match your bank tape to the reconciliations worktable, the system produces four reports. Use these reports to verify the accuracy of your bank tape reconciliation and, if applicable, to determine the cause of any errors. If there are errors, the system does not mark the transactions as reconciled. You must manually reconcile them using the Bank Account Reconciliation program.
| Report | Description |
|---|---|
| Reconciliation Report (R09510) | This report prints a detail line for every transaction and, if there are errors, prints a message such as:
|
| Cleared Not Issued Report (R09511) | This report summarizes any payments that cleared the bank but do not exist in the Account Ledger table. Payments appear on this report if:
|
| Cleared Before Issued Report (R09512) | This report summarizes payments that have a cleared date prior to the payment date. Payments appear on this report if:
|
| Amounts Not Equal Report (R09513) | This report summarizes payments that have cleared the bank, but the cleared amount is not the same as the actual payment amount. Payments appear on this report if:
|