Show TOC

Procedure documentationManually Reconciling Bank Statements: AU, BR, CA, CN, CY, GB, IN, JP, KO, NZ, SG, US, and ZA Locate this document in the navigation structure

 

For the following localizations, you can verify the transactions recorded in SAP Business One against the balance received from the bank and create adjustments if required: Australia, Brazil, Canada, China, Cyprus, India, Japan, Korea, New Zealand, Singapore, South Africa, United Kingdom, and United States.

Recommendation Recommendation

When you use this localized function for manually reconciling bank statements, to avoid creating duplicate reconciliations, do not simultaneously use the external bank statement processing function (see Recording Transactions from External Statements) and the standard function for manually performing an external reconciliation (see Manually Performing External Reconciliations) for the same bank account. In addition, we recommend that you use exclusively either this function or the standard function for manually reconciling bank statements.

End of the recommendation.

Note Note

If bank statement processing is activated in SAP Business One, you must perform external reconciliations directly within the bank statement processing functionality. Do not use this function to reconcile transactions from your bank statements. For more information, see the online help for SAP Business One and How to Use Bank Statement Processing in Release 2007 in the documentation area of SAP Business One Customer Portal at http://service.sap.com/smb/sbocustomer/documentation.

End of the note.

Procedure

  1. From the SAP Business One Main Menu, choose   Banking   Bank Statements and External Reconciliations   Manual Reconciliation  .

    The External Bank Reconciliation – Selection Criteria window appears.

  2. In the Account Code field, select an account code.

    As a result, Account Name and Currency are displayed automatically in the respective fields. If the account currency is defined as All Currencies, the local currency is displayed and is the reconciliation currency. You cannot edit the Currency and the Last Balance fields. In addition, the Last Balance field automatically displays the updated balance from the previous reconciliation.

    In the Ending Balance field, specify the current balance received from the bank; in the End Date field specify the date to which the current balance is updated.

  3. Choose OK.

    The Reconciliation Bank Statement window appears.

    SAP Business One displays all the open deposits and payments in which the selected account is involved. View and specify the information displayed.

  4. Select the transactions to be cleared.

    When you select a transaction, SAP Business One recalculates the value in the Difference field. Reconciliation is performed only if the difference equals zero.

  5. If the value in the Difference field is not zero, do one of the following:

    • Create an adjustment.

      For more information, see Creating Adjustments: AU, BR, CA, CN, CY, GB, IN, JP, KO, NZ, SG.

    • Save your selection for future processing.

      Choose the Save button. The next time you choose the same account in the External Bank Reconciliation – Selection Criteria window, the Reconciliation Bank Statement window displays the saved selection.

  6. To perform the reconciliation, choose the Reconcile button.

    Note Note

    You cannot re-create reconciliations created in the Reconciliation Bank Statement window.

    End of the note.

Result

SAP Business One reconciles the selected transactions and sets the reconciliation type for this reconciliation to Manual.