Skip Headers
JD Edwards World General Accounting I Guide
Release A9.3.x

E21540-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

33 Work with Bank Tape Reconciliations

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:

33.1 Customizing the Reformat Program

Navigation

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.

33.2 Matching the Bank Tape to the Reconciliation File (P09510)

Navigation

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.

33.2.1 Before You Begin

  • Customize the reformat program for your bank tape

  • Create the reconciliations worktable by running Refresh Reconciliations File

33.3 Verifying the Bank Tape Reconciliation

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.

33.3.1 Bank Tape Reconciliation Reports

Report Description
Reconciliation Report (R09510) This report prints a detail line for every transaction and, if there are errors, prints a message such as:
  • A payment cleared but was not issued.

  • A payment cleared before it was issued.

  • The payment cleared amount is not the same as the payment issued amount.

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:
  • A manual payment number was entered in error.

  • A manual payment was issued but not entered in the system.

  • A MICR (Magnetic Ink Character Recognition) code on a payment was damaged and misrepresented on the bank tape.

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:
  • A date was entered in error.

  • The bank cashed a post-dated payment.

  • The payment was released before it was supposed to be released.

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:
  • An amount was entered in error.

  • A bank error allowed the payment to be cashed for an amount different from the actual amount.