Reconciling Available Transactions and Batches
After you locate detail or batch transactions that are available for reconciliation, you must mark the specific items you want to reconcile.
To reconcile an available detail transaction:
1. Find the available detail transaction you want to reconcile.
2. Review the transaction information shown on the Available Transactions window:
- Choose Transaction (the default value) from the poplist to see information about the transactions and journal entries shown. You can review:
- Original Currency and Amount
- Bank Account Currency Amount and Amount Cleared
- Choose Exchange from the poplist to see exchange rate information about the transactions.
- Choose Reference from the poplist to see additional descriptive information about the transactions and journal entries.
3. Mark the transaction or journal entry you want to reconcile by checking the box to the left of the item's information.
4. Choose Reconcile to reconcile the selected items against the current statement line.
Note: If you navigated to the Find Available window from the Bank Statement window, and did not select a statement line, choosing Reconcile creates a new, reconciled bank statement line.
Cash Management shows the Amount Reconciled and the Amount Remaining to be reconciled for the current bank statement line.
5. Choose Previous or Next to move to another statement line without returning to the Bank Statement Lines window. Cash Management updates the Amount Reconciled and the Amount Remaining as you change statement lines.
6. When you are finished, navigate to the Bank Statement Lines window to review the bank statement lines with the reconciliation information.
After reconciliation, the amount reconciled for the bank statement line should be the same as the entered amount, and the line Amount Reconciled Status will be Reconciled.
To reconcile an available remittance or payment batch:
1. Find the available remittance or payment batch you want to reconcile.
Note: For remittance batches, Cash Management excludes reversed receipts from the batch total, and these receipts are not reconciled when you reconcile the batch.
2. Review the batch information.
- Choose Transaction from the poplist to see information about the Batch Name, Original Currency and Total, bank Account Currency batch Total and Amount Cleared, and GL Date.
- Choose Exchange from the poplist to see exchange rate information about the batch.
3. Mark the batch you want to reconcile by checking the box to the left of the batch information.
4. Choose Reconcile to reconcile the selected batches against the current statement line.
Note: If you navigated to the Find Available window from the Bank Statement window, and did not select a statement line, choosing Reconcile creates a new, reconciled bank statement line.
Cash Management shows the Amount Reconciled and the Amount Remaining to be reconciled for the current bank statement line.
5. Choose Previous or Next to move to another statement line without returning to the Bank Statement Lines window. Cash Management updates the Amount Reconciled and the Amount Remaining as you change statement lines.
6. When you are finished, navigate to the Bank Statement Lines window to review the bank statement lines with the reconciliation information.
After reconciliation, the amount reconciled for the bank statement line should be the same as the entered amount, and the line Amount Reconciled Status is updated to Reconciled.
Note: Cash Management handles differences in batch amounts as follows:
Receivables: A miscellaneous receipt is created for the batch amount difference and booked using the account defined in the Receivable Activity field of the System Parameters window. You will be prompted to enter a payment method.
Payables: The batch amount difference is included with the first payment in a batch.
See Also
Finding Available Detail and Batch Transactions for Reconciliation
Reconciling Bank Statements Manually
Creating Reconciled Bank Statement Lines
Reviewing Reconciled Transactions
Changing the Reconciliation Status
Using Attachments
Creating Payments and Receipts Transactions
Creating Miscellaneous Transactions
Recording Exceptions
Entering Reversals
Manually Clearing and Unclearing Receipts and Payments