Verifying the Bank Tape Reconciliation

Use reports to verify the accuracy of the bank tape reconciliation and, if applicable, to determine the cause of any errors. If errors occur, the system does not mark the transactions as reconciled. You must manually reconcile them using the Manual Reconciliation program (P09131).

When you run the Match Tape File To Recon File program, the system generates these four reports:

Report	Description
Reconciliation Report	Prints a detail line for every transaction and, if errors occurred, 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	Summarizes any payments that cleared the bank but do not exist in the F0911 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	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	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 that was different from the actual amount.