AP-F0012 Accounts Payable Reconciliation Update Report

Report Name
Accounts Payable Reconciliation Update

RMDS Report Group
MM170-1 CK RECONCILIATION

Frequency
When transactions are reconciled off-line.

Records/Retention Requirements
ITEM 43048.  Accounts Payable Reconciliation Update (AP-F0012).  Material management production activity.

DISPOSITION INSTRUCTIONS:  Destroy in office after 30 days.

Use
Use this report to view all off-line reconciliation transactions.

Content
This report lists all transactions added to the Reconciliation File (APFM200) off-line. The status for each line indicates whether payments are cleared, added or deleted off-line.

Asterisks on the report indicate one of the following has occurred:

• A break in payment reference numbers when adding reconciliation transactions.
• A payment cleared at an amount different from the payment amount.
• Totals of ranges do not agree with the system calculated totals.
• Totals of bank account ranges do not agree with the system calculated totals.

Totals
The report gives bank account totals for:

• Pymt/void added
• Pymt amount cleared
• Bank amount cleared
• Pymt/void delete

Report totals for:

• Pymt/void added
• Pymt amount cleared
• Bank amount cleared
• Pymt/void delete

Column Headings
The following column headings are listed for each bank account and BAP code:

• PAYMENT REF NUMBER
• VENDOR NAME
• PYMT TYPE
• PAYMENT DATE
• PAYMENT AMOUNT
• CLEARANCE DATE
• CLEARANCE AMOUNT
• RECON STATUS