Accounts Payable Payment Reconcile

Menu Path: Cash Management $Images\bluerarw.gif$ Reconciliation $Images\bluerarw.gif$ Accounts Payable Payment Reconcile

Purpose

Mark accounts payable payments as reconciled.

Overview

Use Accounts Payable Payment Reconcile for bank reconciliation purposes. You can select individual payments, or payments in a range for a specific account and payment method. You can also import payment reconciliations in Accounts Payable Payment Reconcile Import.

Reconciling Payments

To reconcile payments:

Enter a cash account for which you want to perform reconciliation in the Cash Account field. This defaults to the default cash account.
Enter a date for the reconciliation in the Reconciliation Date field. This defaults to the current date.
Click the Lookup button to the right of the Payment Method field, and select a payment method for the payments you want to reconcile.
If you want to reconcile a range of payments, select the Select Payment ID Range check box, and then enter the range of payment ID's in the From and To fields. If you want to select individual payments, select payments in the Available A/P Payment Items grid, enter the bank statement amount and cleared date, and then click the right arrow button. You can use the Cleared Date option and the Update button to set the cleared date for all payments. If you add a payment that is not in your default currency, A/P Payment Reconciliation Exchange Rate appears, and allows you to enter an exchange rate.

Note If you modified the currency exchange rate, a currency exchange gain/loss entry will be generated during the next accounts payable payment posting to the general ledger.

When you have selected all the payments you want to reconcile, click the Reconcile A/P Payments button in the ribbon. The payments are reconciled.

Ribbon Home Tab Buttons

Button	Description
Exit	Click this button to close the Accounts Payable Payment Reconcile window.
Miscellaneous Charge Entry	Click this button to display Service Charge Entry, which allows you to record service charges for a bank account.
Reconcile A/P Payments	Click this button to reconcile the selected accounts payable payments. If you modified the currency exchange rate, a currency exchange gain/loss entry will be generated during the next accounts payable payment posting to the general ledger.

Main Tab Fields and Buttons

Field or Button	Description
Cash Account	Enter the cash account of the payments, or click the Lookup button to select the cash account. This field defaults to the default cash account.
Reconciliation Date	Enter the date against which the reconciliation is being made, or click the drop-down arrow to select a date. This defaults to the current date.
Payment Method	Click the Lookup button to select the payment method for payments to be displayed.
Select Payment ID Range	Select this check box to reconcile a range of payments. This check box is cleared by default.
From	Enter the first payment ID in a range of payment ID's you want to reconcile, or click the Lookup button to select a payment ID. This field is only enabled if you select the Select Payment ID Range check box.
To	Enter the last payment ID in a range of payment ID's you want to reconcile, or click the Lookup button to select a payment ID. This field is only enabled if you select the Select Payment ID Range check box.
Cleared Date	Select one of the following options for changing the cleared dates for payments: Today - Use today's date as the cleared date. Payment Date - Use the payment date as the cleared date. Reconciliation Date - Use the reconciliation date entered in the Reconciliation Date field as the cleared date. Specific Date - Use a specific date entered in the field to the right of this radio button as the cleared date. After you select one of the above options, click the Update button to update the dates in the Cleared Date column in both the Available A/P Payment Items and Selected A/P Payment Items grids.
Update	Click this button to update the dates in the Cleared Date column in both the Available A/P Payment Items and Selected A/P Payment Items grids based on the selected Cleared Date option.
Available A/P Payment Items	This grid displays accounts payable payments to reconcile. This grid is only enabled if you clear the Select Payment ID Range check box. For each payment you are reconciling, enter the bank statement amount and cleared date in the Statement Amount and Cleared Date columns. Note Dates in the Cleared Date column default to the payment dates. To select a payment for reconciliation, double-click it, or select it, and then click the right-arrow button. Note This grid is cached to improve performance. You cannot sort, filter, group, graph, or summarize data in this grid.
Items Selected	This field displays the total number of selected payments.
	Click this button to add the payment selected in the Available A/P Payment Items grid to the Selected A/P Payment Items grid. If you add a payment that is not in your default currency, A/P Payment Reconciliation Exchange Rate appears, and allows you to enter an exchange rate.
	Click this button to remove the selected payment item from the Selected A/P Payment Items grid.
Selected A/P Payment Items	This grid displays payments you have selected for reconciliation.
Items Total	This field displays the total amount of selected payments.