7. Bank Statement Processing Disabled

This article explains how to import bank transactions when Bank Statement Processing is disabled.

📘 Instructions

The Process External Bank Statement menu is not displayed by default – if this is not displayed, go to form settings, and check the flag. To do a reconciliation now users should go to the Reconciliation menu. It is recommended to unflag manual reconciliations.

1. Go to Banking / Bank Statements and External Reconciliations / Process External Bank Statement

2. Enter the GL Account for the corresponding bank account feed / Enter the date range of the desired transitions in the From and To fields / Click Bank Feed

3. A pop-up will appear / Enter the date range again, in the Start Date and End Date fields / click OK

4. The bank statement transactions have been downloaded

You can now proceed to the reconciliation form and complete the bank reconciliation process

Additional Reconciliation Notes

The following information is a summary of native SAP B1 functionality and is independent from the ACSISS add-on, please contact your SAP partner for more information regarding matching rules and reconciliation.

The reconciliation form will attempt to match transactions that are already present in SAP business one against the bank statement transactions that have been downloaded.

There are three possible modes of operation:

Automatic

Select this and SAP Business One will automatically match the transactions in its general ledger against the bank statement, based on your selection of totals or date. Note if the automatic option is selected the user has no opportunity to intervene in the transactions which will be reconciled.

Manual

Select this option and the user will be presented with another screen whereby they will able to match transactions open in SAP business ones books (left hand side) with transactions from the external bank statement (right hand side). Selecting the up and down arrows located in the middle of the screen will reconcile both sides of the transaction.

Semi-automatic

Select this option if you wish to see what SAP business one thinks it can automatically reconcile prior to the automatic reconciliation being executed.

The Bank Statement Reconciliation report is found under Banking / Reports in the main menu. To run the report, enter the General Ledger code required and a crystal report will be produced for that account.

If the reconciliation is incorrect or needs to be adjusted it must first be cancelled, using the manage previous external reconciliation option.

Select the reconciliation that you wish to cancel, and this will undo the reconciliation which will then open the transactions and another reconciliation can be performed.

As each note in each transaction is reconciled the reconciliation number is added to the bank statement reconciliation page and that row becomes closed. Use of the bank statement reconciliation page means that transactions from the bank statement feed will be continuously added to as each bank statement feed is enacted. The previous bank statement feed transactions will still be seen in this screen, the difference being that as they are reconciled, they will no longer be seen as outstanding in the bank reconciliation.