Show TOC

Procedure documentationRecording Transactions from External Statements Locate this document in the navigation structure

 

To record transactions from external bank or business partner statements, you can enter information manually or automatically. Later, to reconcile these transactions with the transactions recorded in the books, use the reconciliation function.

Note Note

If you use the localized function for manually performing external reconciliations (see Manually Reconciling Bank Statements: AU, BR, CA, CN, CY, GB, IN) to avoid creating duplicate reconciliations, do not simultaneously use this function to record transactions from external bank statements. For the same bank account, always use the same function for recording transactions from external bank statements: either this function or the localized function.

End of the note.

Note Note

For Israel and Panama localizations, you can import an external bank statement from electronic files provided by the bank. For more information, see Importing External Bank Statements: Israel and Panama.

End of the note.

Procedure

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

    Note Note

    The function for processing external bank statements is invisible by default in the SAP Business One Main Menu for the following localizations: Australia, Brazil, Canada, China, Cyprus, India, Japan, Korea, New Zealand, Singapore, South Africa, United Kingdom, and United States. To display this feature in the SAP Business One Main Menu, click Form Settings.

    End of the note.

    The Process External Bank Statement window appears.

  2. From the G/L Account dropdown list, select G/L Account if you want to record transactions from your bank statements, or select BP if you want to record transactions from your business partner’s statements. Specify the code of the G/L account or business partner for which you want to record the transactions.

    The Page Currency field automatically displays the currency defined for the G/L account or the business partner you specified. This is the currency in which the amounts posted to this page are calculated.

    Note Note

    If All Currencies is defined for the specified G/L account or the business partner, the currency displayed is the local currency; reconciliations and transactions of All Currencies entities are performed and calculated in the local currency.

    End of the note.
  3. Move the cursor to the first empty row and specify the information as it appears in the statement you received from the bank or the business partner.

  4. If you record transactions from your bank statements, to create an automatic incoming payment linked to an existing invoice, in the table area select the Create Payment checkbox and specify the customer code and the existing invoice number. For more information, see Automatically Creating Incoming Payments to Reconcile Bank State.

  5. To save the information, choose Update.

Result

SAP Business One updates the list of external transactions and the expected current balance of the G/L account or the business partner according to the statement. You can later reconcile those transactions.