This report shows transactions that were cleared or reconciled both manually and automatically.

The cleared receipts section shows the customer name, remittance date, maturity date, payment method, receipt number, currency, amount, account amount, cleared date, and cleared amount.

The cleared payments section shows the supplier name, payment date, payroll payments, maturity date, payment method, payment number, currency, amount, account amount, cleared date, and cleared amount

You can submit the report for Oracle Payables payments only, receipts only, payroll payments, or all.

Report Submission

You submit this report from the Submit Request window. See: Submitting Requests.

Selected Report Parameters

• Bank Branch: Bank branch for which you want to submit the report.

• Bank Account Number: If you want to submit the report for a particular bank account, enter the bank account number.

• Transaction/Batch: Select the level at which you want to run the report:

  • Batch

  • Transaction

• Transaction Type Transaction type for which you want to run the report.

  • All

  • Payments

  • Receipts

  • AP Payments and AR Receipts

  • Payroll Payments

  • Open Interface Transactions

  • Cash Management Transactions

  • Journal Entry Lines

  • Bank Statement Lines

  • Treasury Open Interface Transactions

• Treasury Legal Entity: This field is enabled if Treasury Open Interface is selected in the Transaction Type parameter field. If a legal entity is entered, only Treasury transactions that belong to this legal entity are included on the report.

• Payroll Business Group: This field is only enabled if Payroll Payments is selected in the Transaction Type field. If a business group is entered, only payroll payments that belong to this business group are displayed on the report.

• AP/AR Operating Unit: This field is enabled if either AP Payments or AR Receipts is selected in the Transaction Type parameter field. If an operating unit is entered, only AP payments or AR receipts that belong to this operating unit are included on the report.

• Cleared Date From/To: Enter a value in one or both fields if you want to limit the report to transactions with cleared dates during a particular time period.

• Order By: Order in which report output will be displayed.

  • Amount

  • Date

Selected Report Headings

• Remittance Date: The receipt transaction date.

• Maturity Date: Date the issuing bank dispersed funds.

• Amount: Amount of payment in the currency it was issued.

• Account Amount: Payment amount in the currency of the bank account.

• Cleared Date: Date the payment or receipt cleared in Cash Management.

• Payment Date: Date payment is issued.

• Cleared Amount: Amount cleared in Cash Management.