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.

Filter Transactions

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.

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.

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.