Show TOC

Procedure documentationCreating Adjustments: 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, to reflect transactions that are already in the bank statement but are not yet posted in SAP Business One, you can create a balancing transaction or document: 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.

After you make the required adjustments, the difference between the ending balance in the bank statement and the account balance in the books equals zero, and you can now reconcile the selected transactions.

Procedure

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

  2. In the External Bank Reconciliation - Selection Criteria window, specify the relevant account information and choose OK.

  3. In the Reconciliation Bank Statement window, make the required selections and choose Adjustments.

    The Adjustments window appears.

  4. Select one of the following types of transactions you want to create and choose OK:

    • Journal entry

    • Incoming payment

    • Outgoing payment

    • Check for payment

    • Deposit

    The window of the selected transaction type appears.

  5. Create the required transaction and choose Add.

    As a result, the created transaction is added to the table of the Reconciliation Bank Statement window, and it is also selected. The value in the Difference field is updated accordingly.

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

More Information

the selection criteria and reconciliation windows

Manually Reconciling Bank Statements: AU, BR, CA, CN, CY, GB, IN

Example: Manual Reconciliation of External Bank Statements: AU,

External Bank Reconciliation - Selection Criteria Window: AU, BR

Reconciliation Bank Statement Window: AU, BR, CA, CN, CY, GB, IN