This report shows all transactions available for reconciliation for a specific bank account. It lists detailed transaction information for your Available Receipts, Available Payments, and Available Journal Entries for reconciliation. Detailed information includes the Customer, Supplier, Transaction Date, Payment Method, Transaction Number, Currency, and Amount. It also lists detailed information for statement lines that are available for reconciliation against other statement lines.
Note: Statement lines that cannot be reconciled are not shown. To view these lines, you should run the Bank Statement Detail Report.
This report only lists void payments if the Show Void Payments option on the Systems Parameters window is checked. It does not list receipts reversed due to user error nor does it list the associated original receipts that were not reconciled. This report groups transactions by status so that void or reversed transactions are separate from regular transactions.
The Net Available Amount is calculated as Total Available Receipts minus Total Reversed Receipts minus Total Available Payments plus Total Voided Payments.
Additional Information: If you want to view batches available for reconciliation, submit the Batches Available for Reconciliation Report.
You submit this report from the Submit Request window. See: Submitting Requests.
Transaction Type Indicate the types of transactions, such as payments, that you want to include on 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.
Bank Account Number: Enter the bank account number.
Order By:Choose to sort the report by amount or date.
Available Receipts:
Customer Name: The customer associated with the transaction.
Remit Date: The receipt transaction date.
Maturity Date: The receipt maturity/due date.
Currency: The code for the currency of the receipt.
Amount: The amount of the receipt.
Account Amount: The receipt amount in the currency of the bank account.
Available Payments:
Supplier Name: The supplier associated with the transaction.
Payment Date: The check or payment date.
Maturity Date: The maturity date of the payment.
Currency: The code for the currency of the payment.
Amount: The amount of the payment.
Account Amount: The payment amount in the currency of the bank account.
Journal Entry Lines:
Effective Date: The date the journal entry line affects balances in the general ledger.
Maturity Date: The maturity date of the journal entry line.
Journal Entry Description: Matching is performed against the journal entry description.
Currency: The code for the currency of the journal entry line.
Amount: The amount of the journal entry line.
Account Amount: The amount of the journal entry line in the currency of the bank account.
Reversed Receipts:
Customer Name: The customer associated with the transaction.
Remit Date: The receipt transaction date.
Maturity Date: The maturity date or due date of the transaction.
Payment Method: The user-defined Receivables choices for how customer's invoices can be paid for customer receipts.
Receipt Number: The receipt number.
Currency: The code for the currency of the receipt.
Amount: The amount of the receipt.
Account Amount: The receipt amount in the currency of the bank account.
Unreconciled Statement Lines:
Statement Number: The number of the bank statement.
Transaction Date: The transaction date.
Maturity Date: The transaction maturity/due date.
Line Type: Indicates the types of transactions, such as payments.
Transaction Number: The transaction number.
Currency: The code for the currency of the statement line.
Amount: The amount of the statement line.
Account Amount: The amount in the currency of the bank account.