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 |
|---|---|
|
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 icon is an empty square 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/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. |
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". |