Payments Tab of the Bank Reconciliation Form

The Payments tab lists all of the payments written against this bank code that are not designated as cleared for another statement date.

If you display reconciliation information for a prior statement, any payment listed on the Payments tab that has been cleared on a more recent statement is displayed as uncleared, and the date of the future statement on which it was cleared displays in the Statement Date field.

Electronic Payments

To configure how electronic payments display on this tab, use the Bank Reconciliation tab of the Banks form in Settings > Cash Management > Banks:

• If Summarize Electronic Payment Runs in Bank Reconciliation is selected, the electronic payments included in a transmitted file display on the Payments tab as a single summarized payment, and you mark all of them as cleared by selecting Cleared on the summarized payment row. If you void one or more individual payments that are included in a summarized EFT payment, the void appears as a separate line in the grid.

  Hover over a grid entry and click View Details to display the individual payments that were voided.

• If Summarize Electronic Payment Runs in Bank Reconciliation is not selected, the electronic payments included in a transmitted file display individually on the Payments tab, and you mark them as cleared individually.

Contents

Field	Description
<Bank Name and Code> - <Statement Date> (<Statement Number>), Fiscal Period, <Active Company>	These fields display the bank name, bank code, and statement date for the bank reconciliation, followed by the fiscal period in which the bank statement was created. If Vantagepoint is set up for multiple companies, the name of the active company also displays.
Import Transactions	Click this option to import new bank transactions to the bank reconciliation. This option displays if you select the Import Enabled checkbox on the Options tab of the Banks form in Settings > Cash Management > Banks.
Close Statement	This option displays if the current bank reconciliation state is still in progress. When the reconciliation is completed, select this option to mark the reconciliation as closed. Closing a reconciliation removes the statement date from the list of "in progress" statements on the Bank Statement Selection dialog box, to make it easier to select statements in the future. It also disables options on the other tabs on the Bank Reconciliation form. However, you can choose Reopen Statement at any time to reopen the reconciliation.
Reopen Statement	This option displays if the current bank reconciliation record is closed. When the reconciliation is closed, select this option to reopen the reconciliation. Reopening a reconciliation moves the statement back to the "in progress" state, which allows you to make changes and view the reconciliation.
Other Actions/Actions	If you have the Import function enabled, this appears as Other Actions. Otherwise, it displays as Actions. Choose an option from the drop-down list: Create Transaction Entries: Select this option to create bank statement entries for bank fees, interest, and other user-defined bank entries in Settings > Cash Management > Banks. Print: Select this option to generate the Bank Reconciliation report for the currently displayed reconciliation. Post Cash Receipts: Select this option to open the Cash Receipts dialog box and select cash receipts to post. This option appears if you have access rights to post Cash Receipts and if you set the Enable Transaction Center Approvals option to No in Settings > Accounting > Transactions. Match Transactions: This option displays if there are records that were imported through a bank feed. Select this option to automatically match bank transactions with posted records that have the same amount or description. Refresh Bank Transactions: This option displays if you set up bank feed for the bank associated with the bank reconciliation record. Select this option to update the Import Records grid with bank transactions that were posted after the daily import. Errors Report: Select this option to import a report that identifies any errors that were encountered during the last import that you performed for the statement currently open in Bank Reconciliation. Import History: Select this option to open the Import History dialog box and view or undo imported bank transactions. You can undo transactions if you have imported them into the wrong bank statement.

Payments

Field	Description
Clear All	Use this option to clear all listed transactions.
Unclear All	Use this option to unclear all listed transactions.
Other Actions	Click the drop-down arrow on a grid header to complete any of the following actions: To print grid data, click Print. On the Print Preview form, click File > Print to send the grid data to your default printer. To export grid data to an Excel spreadsheet, click Export to Excel. When Microsoft Excel opens, use its features to modify, print, or email the grid data or to save the spreadsheet file locally. To enable grouping for a grid, click Enable Grouping. When a field displays with the instruction to "Drag a column header here to group by that column," you can drag and drop column headers into the field in the sequence that you want them to display. Not all options are available on all grids.
Process Cleared Items	This option only displays when the Enable In-Process Account feature is enabled on the Options tab in Settings > Cash Management > Banks. Click Process Cleared Items to display the Post Cleared Items dialog box, which displays all the payments that have cleared but have not yet posted to the general ledger. Because posting is period-specific, cleared items must be processed in the same period in which the items cleared the bank and from the correct bank statement. The posting process clears out the in-process account (typically a debit) and charges the bank’s G/L account (typically a credit).
Number	This field displays the reference number entered for the payment transaction during transaction entry or processing. If the bank code is set up to summarize all electronic payments in a transmitted file as a single row on the Payments tab, this field contains zeros for those rows.
Date	This field displays the date of the payment as entered during transaction entry or processing.
Amount	This field displays the amount of the payment as entered during transaction entry or processing. For a voided individual payment that is associated with the currently selected statement, this field is blank. For a voided payment that is not yet associated with a statement or is associated with a more recent statement, this field displays the original payment amount. For a voided payment that includes one or more individual payments from a summarized electronic payment and is associated with the currently selected statement, this field displays a negative amount to offset the sum of the original individual payment amounts. For such a voided payment that is not yet associated with a statement or is associated with a more recent statement, this field is blank.
Cleared	Select this checkbox to indicate that the payment was listed as a cleared transaction on the bank statement. For a voided payment that is associated with the currently selected statement, this checkbox is selected and cannot be cleared. For a voided payment that is not yet associated with a statement or is associated with a more recent statement, this checkbox is not selected and cannot be selected.
Payee	This field displays the person or organization to whom the payment was made. If the bank code is set up to summarize all electronic payments in a transmitted file as a single row on the Payments tab, this field contains a description of the electronic payment (for example, Electronic Funds Transfer) for those rows, rather than an individual payee name.
Type	This field displays the transaction type for this payment. Payments have one of the following transaction types: CD: Cash Disbursement CV: AP Disbursement EP: Employee Advance and Expense Processing PP: AP Payment Processing PY: Payroll Processing
Voided	A check mark in this box indicates that the transaction has been voided.
Void Date	If the payment has been voided, this column displays the date that it was voided.
Statement Date	This field displays the date of the statement on which the transaction was listed as cleared. Voided payments are the only payments for which you can change this date. For a voided payment, this field displays the date of the statement with which the void is associated. For a voided payment that is not yet associated with a statement date, this field displays New. If necessary, you can select New or a different open statement date for a voided payment.
View Details	Hover over a grid entry and click this option to display the details of the payment. If the bank code is set up to summarize all electronic payments in a transmitted file as a single row on the Payments tab and you select one of those rows, the Payment Details dialog box displays the individual payments that were included in the transmitted file.
	This icon displays at the end of the row when you click or hover over a grid row. Click the icon to select one of these actions for that row: View Details: Choose this option to display the details of the payment. Match Transaction: Choose this option to match the payment with imported bank transactions.