--- title: "Bank Reconciliation Dashboard Screen" canonical: "https://kb.myframeworks.com.au/space/FRAM/28380822/Bank%20Reconciliation%20Dashboard%20Screen" format: markdown --- The **Bank Reconciliation Dashboard** provides a central location for managing bank reconciliation activities across all configured bank accounts. This screen allows users to view, create, and access bank statements for reconciliation purposes, with the ability to filter statements by date range, bank account, and reconciliation status. Bank statements can be added to the dashboard in three ways: manually entered, imported via a bank export file, or scheduled for automatic import. > ⚠️ **Important:** To reconcile imported and scheduled bank statements, the feature code **BNK** must be activated. Without this feature code active, users can only perform manual bank reconciliation. ## Screen Access From the **Frameworks Menu, **navigate to **General Ledger > Transaction Processing > Bank Reconciliation**. ## Screen Structure ![image-20260115-040359.png](media://e0651e30-abca-4c23-8c90-22e6aee37b23) The **Bank Reconciliation Dashboard** screen is organised into two main sections: 1. **Search Options** - Filter controls for finding specific bank statements 2. **Results Grid** - List of bank statements matching the search criteria --- ## Search Options ![image-20260115-054442.png](media://99f5478e-022f-43a4-ac5a-8fb0f33843e4) The Search Options section provides filter controls for refining which bank statements are displayed in the results grid. This section includes bank account selection, date range filters, reconciliation status options, and actions for creating new reconciliations. ### Bank The **Bank** field allows you to select which bank account to display reconciliation statements for. The drop-down menu displays all bank accounts configured in Bank Account Maintenance. - The drop-down defaults to **ALL** to display statements across all bank accounts - Select a specific bank account to filter results to only that account - Bank accounts are displayed showing their bank code and name ### Date From The **Date From** field sets the starting date for the date range filter. This field determines the earliest statement date to include in the search results. - Enter the date in DD/MM/YYYY format - Click the calendar icon to select a date from the calendar picker - This field works in conjunction with the **Date To** field to define the search date range ### Date To The **Date To** field sets the ending date for the date range filter. This field determines the latest statement date to include in the search results. - Enter the date in DD/MM/YYYY format - Click the calendar icon to select a date from the calendar picker - This field works in conjunction with the **Date From** field to define the search date range ### Include Reconciled The **Include Reconciled** checkbox controls whether reconciled bank statements are displayed in the search results. When enabled, both unbalanced and reconciled statements appear in the results grid. - When disabled (default), only unbalanced statements are displayed - Enable this option to review previously completed reconciliations - This filter works in combination with the bank account and date range filters ### New Reconciliation The **New Reconciliation** button opens the **New Bank Statement** window to create a new bank statement for reconciliation. The window provides options to manually enter a bank statement or import an electronic bank statement file. - Manual entry allows you to key in the statement details and transactions - Electronic import allows you to upload a bank file in a supported format - The statement will be added to the **Bank Reconciliation Dashboard** once created > ✅ Refer to [https://sterlandsupport.atlassian.net/wiki/spaces/CO/pages/400490517](https://sterlandsupport.atlassian.net/wiki/spaces/CO/pages/400490517) and [https://sterlandsupport.atlassian.net/wiki/spaces/CO/pages/30530970](https://sterlandsupport.atlassian.net/wiki/spaces/CO/pages/30530970) for more information about creating a new reconciliation. ### Find The **Find** button executes the search and updates the results grid based on the selected search criteria. The results grid refreshes to display only bank statements matching the current filters. - The results grid updates immediately when this button is clicked - The search uses all enabled filters (bank account, date range, reconciliation status) - The pagination will reset to page 1 when a new search is executed --- ## Results Grid ![image-20260115-054650.png](media://6025e950-918e-44af-8223-8a7fdc5bad69) The **Results Grid** displays all bank statements matching the current search criteria. Each row represents a single bank statement entry, showing key information about the statement and its reconciliation status. Click the statement reference hyperlink to access the full bank reconciliation screen. ### Statement Reference The **Statement Reference** column displays the unique identifier assigned to the bank statement. This reference uniquely identifies each bank statement within Frameworks. - Click the hyperlink to open the **Bank Statement Reconciliation** screen for this statement - The statement reference is entered when the bank reconciliation is created > ✅ Refer to the [https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28380750](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28380750) and [https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28380810](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28380810) for more information about the Bank Reconciliation screens ### Bank The **Bank** column displays the bank code for the bank account associated with this statement. The bank code is a short identifier configured in Bank Account Maintenance. - Examples include WBC for Westpac, CBA for Commonwealth Bank, NAB for National Australia Bank - The bank code helps identify which account the statement belongs to - This field corresponds to the bank account selected when creating the statement ### Name The **Name** column displays the full bank account name assigned to the bank account via Bank Account Maintenance. This descriptive name provides additional context about the account beyond the bank code. - The name typically includes the bank name and account type or number - Examples include "Operating Account" or "Payroll Account" - This name is defined when setting up the bank account in **Frameworks** > ✅ Refer to [Bank Account Maintenance](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28391814) for more information about configuring bank accounts. ### Period The **Period** column displays the accounting period to which this bank reconciliation will be applied. The period determines which financial period the reconciliation transactions are posted. - The period is displayed in MM/YYYY format (e.g., 01/2026 for January 2026, 12/2025 for December 2025) - The accounting period must be open in **Frameworks** to complete the reconciliation - This period affects the general ledger posting date for reconciliation adjustments > ✅ Refer to [GL Year Maintenance](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28403940) for more information about managing accounting periods. ### Last Statement The **Last Statement** column displays the statement date of the bank statement being reconciled. This is the ending date of the bank statement period as provided by the bank. - The date is displayed in DD/MM/YYYY format - For imported statements, this date is extracted from the bank file - For manual statements, this date is entered by the user - This date represents the balance date for the **Statement Balance** field ### Statement Balance The **Statement Balance** column displays the closing balance of the bank statement as reported by the bank. This is the balance shown on the physical or electronic bank statement for the statement date. - The balance is displayed as a monetary amount with two decimal places - This balance typically matches the reconciled ledger balance when reconciliation is complete ### GL Balance The **GL Balance** column displays the general ledger balance for the bank account at the statement date. This balance represents what Frameworks has recorded for this bank account up to the statement date. - The balance is calculated from general ledger transactions posted to this bank account - The balance is displayed as a monetary amount with two decimal places - Differences between GL Balance and Statement Balance indicate outstanding transactions or errors ### Status The **Status** column displays the current reconciliation status of the bank statement. This indicates whether the statement has been successfully reconciled or still requires completion. Available status values include: - **Unbalanced**: The reconciliation has not been completed or the ledger balance does not match the statement balance - **Reconciled**: The reconciliation has been completed and the ledger balance matches the statement balance ### Assignee The **Assignee** column displays the user ID of the person assigned to complete this bank reconciliation. This allows work allocation and tracking of responsibility for reconciliation tasks. - The assignee is the user responsible for completing the reconciliation - Assignment can be set when creating the statement or updated during the reconciliation process - The user ID displayed matches the operator login ID in **Frameworks** ### Comment The **Comment** column displays any comments or notes that have been added to the reconciliation. This field provides context, explanations, or reminders about the reconciliation. - Comments can explain unusual transactions or adjustments - Notes can document follow-up actions required - Multiple users can add comments during the reconciliation process - Comments are visible to all users accessing this reconciliation --- > ✅ ## Related Information > ✅ > ✅ - [https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28380750](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28380750) and [https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28380810](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28380810) - Detailed information about the reconciliation process and screen functionality > ✅ - [https://sterlandsupport.atlassian.net/wiki/spaces/CO/pages/30529362](https://sterlandsupport.atlassian.net/wiki/spaces/CO/pages/30529362) - Step-by-step procedures for completing the bank reconciliation process > ✅ - [Bank Account Maintenance](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28391814) - Configure bank accounts in Frameworks > ✅ - [Feature Codes](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28401618) - Configure the BNK feature code and other bank reconciliation options > ✅ - [GL Year Maintenance](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28403940) - Manage accounting periods