Reconcile Transactions Fields

This page is displayed when you reconcile your bank statement automatically. The page contains two panels:

Bank Statement Lines. Your System Administrator can customize the columns in this panel by editing the BankRecColumns fieldset on the Bank Statement Line Item object. The Date, Reference and Amount columns cannot be removed.

Transactions. Your System Administrator can customize the columns in this panel by editing the BankRecColumns fieldset on the Transaction Line Item object. The Due Date and Bank Account Value columns cannot be removed.

Fields and Controls

Some features are common to both panels.

Field/Control	Description
Filter	The Filter box across the top of each panel allows you to filter that list to show only rows containing a specific string. Only the columns currently displayed in that panel are matched against the string. The string can contain any characters and is not case sensitive.
Sorting	You can sort the rows by clicking on a column heading. An up/down arrow will indicate if sorting is in ascending or descending order.
	Collapses a panel to the right.
	Collapses a panel to the left.
	Indicates that the row is selected for reconciliation. The icon is an empty circle if the row is not selected.
	This icon appears when you hover the cursor over an unreconciled bank statement line. Click it to create a new transaction for the bank statement line. Complete the details on the Create Transaction dialog box to create the new transaction. The new transaction will appear in the Transactions panel and is available for reconciling to the bank statement line.
Subtotal	The subtotal row across the bottom of each panel shows the number of lines selected in that panel, and their total value.

Field/Control

Description

Filter

The Filter box across the top of each panel allows you to filter that list to show only rows containing a specific string. Only the columns currently displayed in that panel are matched against the string. The string can contain any characters and is not case sensitive.

Sorting

You can sort the rows by clicking on a column heading. An up/down arrow will indicate if sorting is in ascending or descending order.

Collapses a panel to the right.

Collapses a panel to the left.

Indicates that the row is selected for reconciliation. The icon is an empty circle if the row is not selected.

This icon appears when you hover the cursor over an unreconciled bank statement line. Click it to create a new transaction for the bank statement line. Complete the details on the Create Transaction dialog box to create the new transaction. The new transaction will appear in the Transactions panel and is available for reconciling to the bank statement line.

Subtotal

The subtotal row across the bottom of each panel shows the number of lines selected in that panel, and their total value.

Buttons

Button	Description
Commit Selected Lines	When the selected bank statement lines and transactions balance to 0.00, click Commit Selected Lines to reconcile them. Committed lines are removed from the display.
Cancel	Closes the Reconcile Transactions page and returns you to the previous screen.
Complete Reconciliation	This button becomes available once all the bank statement line items have been committed. Clicking it completes the bank reconciliation and sets the status of the bank statement and its line items to "Reconciled".
Deselect All	Deselects all the items that have been selected automatically, so that you can manually select only the items you want.

Button

Description

Commit Selected Lines

When the selected bank statement lines and transactions balance to 0.00, click Commit Selected Lines to reconcile them. Committed lines are removed from the display.

Cancel

Closes the Reconcile Transactions page and returns you to the previous screen.

Complete Reconciliation

This button becomes available once all the bank statement line items have been committed. Clicking it completes the bank reconciliation and sets the status of the bank statement and its line items to "Reconciled".

Deselect All

Deselects all the items that have been selected automatically, so that you can manually select only the items you want.

Related Concepts

About Bank Reconciliation

Related Tasks

Starting a Manual Bank Reconciliation

Recording Bank Charges and Interest

Selecting Transactions to Reconcile

Importing Bank Statement Details

Reconciling your Bank Statement Automatically

Managing Bank Reconciliation Details

Deleting a Bank Reconciliation

Reopening a Bank Reconciliation

Reference

Bank Reconciliation Fields

Bank Reconciliation Charge Fields

Bank Statement Fields