AP-R0002 Payment Reconciliation Register Report

Report Name
Payment Reconciliation Register

RMDS Report Group
MM170-1 CK RECONCILIATION

Frequency
When bank accounts are reconciled.

Records/Retention Requirements
ITEM 43049.  Payment Reconciliation Register (AP-R0002).  Material management production activity.

DISPOSITION INSTRUCTIONS:  Destroy in office after 30 days.

Use
Use this report to review complete reconciliation information for each payment.

Content
This report contains a summary for a given bank account and period, the following information:

  • · Payments made, but not cleared
  • · Reconciled payments
  • · Replaced payments

Totals
For each bank account payment (BAP) code, bank account, and bank, the report lists the following totals:

  • · Beginning outstanding balance
  • · Amount paid for current period
  • · Amount cleared for current period
  • · Current outstanding amount
  • · Unreconciled difference
  • · Cancellation for prior period checks
  • · Cleared payments for prior period checks

Column Headings
The following column headings are listed for each bank account number, bank name and bank account code:

  • PAYMENT-REF NUMBER
  • PAYMENT DATE
  • BEGINNING OUTSTANDING
  • PAID CURRENT PERIOD
  • DATE CLEARED
  • PAYMENT DIFFERENCE
  • CURRENT OUTSTANDING
  • REPLACED PYMT REF
  • PYMT TYPE