Reconcile Transactions Fields

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

Bank Statement Lines. Your 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.

Field/Control	Description
	Displays in the column heading. Enables you to select, or deselect, all lines in the list.
	Collapses a panel to the right.
	Collapses a panel to the left.
	Indicates that the line is selected for reconciliation. The checkbox is blank if the line 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.
Balance	Displays the balance of the selected bank statement lines and transactions.
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 or down arrow will indicate if sorting is in ascending or descending order.
Subtotal	The subtotal row across the bottom of each panel shows the number of lines selected in that panel, and their total value.

The following buttons are displayed on the Reconcile Transactions page.

Button	Description
Auto-Match Settings	Displays the Auto-Match Settings options: Exact Auto Match Suggested Auto Match Click one of these to display the Auto-Match Settings page. For details of the fields displayed see Auto-Match Settings.
Cancel	Closes the page without reconciling any selected transactions.
Finish	Closes the page. This button only displays if there are no bank statement lines and transactions to reconcile.
Reconcile and Continue	Reconciles the selected transaction lines and removes them from the grid. This button is hidden if there are no bank statement lines and transactions to reconcile.
Reconcile and Finish	Reconciles the selected transactions and closes the page. The reconciliation status is updated to "In Progress".

Auto-Match Settings

The name of this page depends on the Auto Match option selected:

The following fields are displayed on the Auto-Match Settings page.

Key: S- Displayed for Suggested Auto Match Only.

Field		Description
		Deletes a line.
Add New Fields		Adds a new line, so that you can select additional bank statement and transaction line fields for matching.
Bank Statement Line Field		The bank statement field that you want to match transaction line items to.
Operator	S	The matching method that you want to use. You can select one of the following. Contains Equals Greater than or equal to Less than or equal to Range
Priority	S	The priority for this field. You must assign a unique priority to each matching rule.
Set as Default		Sets the selected Auto-Match Settings as the default auto matching methods.
Transaction Line Field		The transaction line item field that you want to use for matching.
Value	S	The values of the bank statement field that you want to match to.

The following buttons and controls are displayed on the Auto-Match Settings page.

Button	Description
Apply	Applies the selected matching criteria to the transaction line items. Matching transaction line items are displayed at the top of the grid. If you have selected Suggested Auto-Match, the suggested matching transactions are highlighted and in priority order.
Cancel	Closes the Auto-Match Settings page.

Button

Description

Apply

Applies the selected matching criteria to the transaction line items. Matching transaction line items are displayed at the top of the grid.

If you have selected Suggested Auto-Match, the suggested matching transactions are highlighted and in priority order.

Cancel

Closes the Auto-Match Settings page.

The following fields and controls are displayed on thr Filters panel.

Field	Description
From Due Date	The due date from which you want to filter transactions.
To Due Date	The due date to which you want to filter transactions.
Account	The bank account name you want to filter transactions by. If you have encryption enabled in your org, you must be as specific as possible when typing the account name to ensure that the account is found. See Shield Platform Encryption for more information.
Bank Account Value	The value you want to filter transactions by.

Button	Description
Retrieve	Retrieves transaction line data that meets your filter criteria.
Cancel	Abandons the search. This button is only available when it is possible to abandon the current search. For example, if the search results are not displayed promptly because a large amount of data is being retrieved.

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".