Next Generation - The new Bank Reconciliation screen

You can access the new Bank Reconciliation either through the Cash Book or directly from the Bank Reconciliation option, in the Financials module.

Access the New Bank Reconciliation directly from the navigation panel

Click Financials then click Bank Reconciliation.
- Note: The Bank Reconciliation screen opens with no Bank Account selected or any transactions listed. You will need to select your nominal code for the bank account you wish to work with by either typing in the nominal code or name.
  - You must know the first few characters of the nominal code or name as this search is what we refer to as a "Begins With" search.
  - You can also select the Show More option which gives you a larger list of records and more advanced filtering.
    To open the filters, hover over the label of the columns until you see 3 small horizontal lines.
    Click on the 3 lines to open the Filtering popup where you can select the relevant filtering option you want to work with.
Click on Confirm Selection.
The Bank Reconciliation screen refreshes and displays all transactions and statement or statements that are relevant for the selected account.

Access the New Bank Reconciliation from Cash Book

Click Financials then click Cash Book.
- Note: All Bank and Petty Cash type nominal accounts are displayed for you. You can narrow down you search using advanced filters. You can also search on the columns directly by pointing the mouse to the name of the column and click on the icon and choose from the available filter list, then click OK.
Select the checkbox in front of the nominal bank account that you wish to work with.
- Note: The Action Panel automatically opens from the right-hand side of the screen.
Click on the Bank Rec tab on the Action Panel.
- When you select a bank type nominal account where you have not set up any import mappings, you will need to select the Import Statement action card and follow our Set up a new mapping for bank statements article.
- When you select a bank type nominal account where you have not set up the bank feeds yet, please refer to our Set up the Bank Feeds for a bank type nominal account article.
For a bank type nominal account where you have set up a mapping, select the Bank Reconciliation action card.
- Note: The Bank Reconciliation screen opens for you with your selected bank account prepopulated in the Bank Account field.

The bank reconciliation screen is made up of the following sections:

Sections	Description
Bank Account	Blank when you open the Bank Reconciliation directly through the Bank Reconciliation option in the Financials module. Pre-populated with a Bank Account when access the Bank Reconciliation screen from Cash Book and the Bank Rec tab. Searchable field by either typing in the first few characters of the nominal code or name, or alternatively you can use the drop-down arrow and select the Show More option to access all bank and or petty cash type nominal accounts with a wider range of search options. You can hover over the Account Code and Account Name column labels to get 3 small horizontal lines displayed. Click on the horizontal lines and on the Filter popup, select the search criteria that best suits your needs and click OK.
Statements	Lists all your statements that you have imported or downloaded for the selected bank account. You can use the drop-down arrow and select the Show More option to access all statements with a wider range of search options. You can hover over all the column names to get 3 small horizontal lines displayed. Click on the horizontal lines and on the Filter popup, select the search criteria that best suits your needs and click OK. You can also remove any unwanted columns by clicking on the Cog on the top left-hand side of the Statements screen and selecting the Configure Columns functionality.
Auto-Match	Can be used on demand where you have a statement imported and you have posted some cash book transactions, you can then use the Auto-Match button to reconcile it with the transactions from your bank statement.
Summary section	Opened as default and can be collapsed by clicking on the line before the Summary label if you wish to have more space to see transactions. Contains the information of the bank account that you have started your journey with or selected manually.
Edit button	Allows you to edit the Statement Opening and Closing balances as well as the Bank Statement Name.
Cancel or Save button	When in Edit mode, it allows you to save your changes or discard them.
Matched Tab	Sortable tab that displays all the matches identified by the Auto Matching system and any manual matches you have created. The bank statement transactions are on the left-hand side of the screen while the cash book ones are on the right linked with a Matched green indicator. Number indicator represents the count of transactions within this tab. You can review these, accept and reconcile them or reject them. The AI matching system will be able to identify groups of bank statement transactions that are to be matched to a single account transactions or visa versa. For more information please refer to our Accept, Reject and undo Reconciliation in the Bank Reconciliation screen article. You can also rearrange your columns by dragging and dropping them to your preferred location using your mouse's left key.
Unmatched Tab	Sortable tab that contains all the unmatched transactions that the Auto Matching system couldn't match between your bank statement and Cash Book transactions as well as any transactions that you have manually rejected on the Matched tab and all your manually unreconciled transactions. Displays the total Statement and total Cash Book transactions selected for matching while the Difference shows the difference between those values. the Difference field must always equal to zero in order to be able to match transactions. Number indicator represents the count of transactions within this tab. For more information please refer to our Accept, Reject and undo Reconciliation in the Bank Reconciliation screen article. You can also rearrange your columns by dragging and dropping them to your preferred location using your mouse's left key. You can also delete any unwanted transactions from the Bank Statement columns when you use Bank Feeds, by hovering over the transactions you wish to delete, right click with your mouse and select Delete Statement Line. For more information on how to delete an unwanted transaction, please refer to our Delete bank statement lines or transactions for Plaid integration article. Note: The Delete Statement Line option is also available when you are using a CSV upload, however you will get a validation error when you try to delete a bank statement line.
Reconciled Tab	All transactions that you have accepted and reconciled will be displayed under this tab. You can also undo any reconciled transactions by selecting the checkbox for any transactions you wish to unreconcile and clicking the Undo Reconciliation button. You can select a specific statement from the Statements drop-down field which opens a list of existing statements of the cash book account you are working with. Number indicator represents the count of transactions within this tab. For more information please refer to our Accept, Reject and undo Reconciliation in the Bank Reconciliation screen article. You can also rearrange your columns by dragging and dropping them to your preferred location using your mouse's left key.
Bank Statement	Displays the bank statement transactions from either the Matched, Unmatched or Reconciled tabs.
Search by Reference	Allows you to search by statement transaction reference. This search is what we refer to as a "Begins" with search which means that you will need to know the first few characters of the reference you are searching on. Note: For a more flexible way of searching where perhaps you don't know the exact reference, you can hover over the column labels of each column on the Bank Statement panel until you see 3 horizontal lines which you then need to click on to get access to the filer popup where you can still use the Contains search type among other filter criteria.
The Cog option	Opens the Configure Columns for the Bank Statement where you can either add or remove columns you wish to work with. For more information on how to use the configure columns option, please refer to our Configure Columns article.
Cash Book	Displays all the transactions from your cash book.
Search by Reference	Allows you to search by cash book transaction reference.
The Cog option	Opens the Configure Columns for the Cash Book where you can either add or remove columns you wish to work with. For more information on how to use the configure columns option, please refer to our Configure Columns article. Export to Excel - All - Exports all the transactions on the purchase ledger for the columns displayed on the screen. If you wish to see all columns available on your export, you have to add all columns in the configure column option. The current limit is set at 500,000 rows to protect the performance. You can run several exports at the same time, even from the same screen and you'll be notified individually as each one is completed. Export to Excel Current View - Exports the currently displayed or loaded transactions and columns, the default is to load 100 transactions. If you wish to see all columns available on your export, you have to add all columns in the configure column option. Once you scroll past the 100th transaction, this loads another 100 transactions. This is done to make sure that you don't come across any performance issues when you have hundreds of thousands of records.

Next Generation - Accept, Reject and undo Reconciliation on the Bank Reconciliation screen

Next Generation - Access the new Bank Reconciliation

Next Generation - Create missing cash book transactions directly from the Bank Reconciliation screen

Next Generation - Download bank statements using the Bank Feeds connection

Next Generation - Work on multiple imported bank statements